Logo F2FInterview

MySql Interview Questions

Q   |   QA

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

mysql> SELECT * FROM tablename WHERE name like “sonia%” AND phone_number = ’9876543210′ limit 1,5;

mysql> SELECT * FROM tablename WHERE rec RLIKE “^r”;

mysql> SELECT DISTINCT columnname FROM tablename;

mysql> SELECT col1,col2 FROM tablename ORDER BY col2 DESC;
mysql> SELECT col1,col2 FROM tablename ORDER BY col2 ASC;

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: