Logo F2FInterview

MySql Interview Questions

Q   |   QA

mysql> SELECT * FROM tablename;

mysql> show columns from tablename;

mysql> SELECT * FROM tablename WHERE fieldname = “pcds”;

mysql> SELECT * FROM tablename WHERE name = “sonia” AND phone_number = ’9876543210′;

mysql> SELECT * FROM tablename WHERE name != “sonia” AND phone_number = ’9876543210′ order by phone_number;

In order to link this F2FInterview's page as Reference on your website or Blog, click on below text area and pres (CTRL-C) to copy the code in clipboard or right click then copy the following lines after that paste into your website or Blog.

Get Reference Link To This Page: (copy below code by (CTRL-C) and paste into your website or Blog)
HTML Rendering of above code: