All Basic Function and Key Word Related to the SQL(Structured Query Language) on this Blogs
Enter password: ****
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.32 MySQL Community Server - GPL
Copyright (c) 2000, 2023, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> SHOW DATEBASES;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DATEBASES' at line 1
mysql> SHOW DATABASES;
+--------------------+
| Database |
+--------------------+
| borrow |
| deposit |
| information_schema |
| mysql |
| own |
| performance_schema |
| practice |
| sb101 |
| sys |
| tester |
+--------------------+
10 rows in set (0.15 sec)
mysql> USE sb101;
Database changed
mysql: Character set ';' is not a compiled character set and is not specified in the 'C:\Program Files\MySQL\MySQL Server 8.0\share\charsets\Index.xml' file
Charset is not found
mysql> \C
ERROR:
Usage: \C charset_name | charset charset_name
mysql> C\;
ERROR:
Unknown command '\;'.
-> \c;
ERROR:
No query specified
mysql> \C
ERROR:
Usage: \C charset_name | charset charset_name
mysql> \c
mysql> USE sb101;
Database changed
mysql> SHOW TABLES;
+-----------------+
| Tables_in_sb101 |
+-----------------+
| st |
+-----------------+
1 row in set (0.05 sec)
mysql> USE ST;
ERROR 1049 (42000): Unknown database 'st'
mysql> DESC ST;
+---------+-------------+------+-----+---------+-------------------+
| Field | Type | Null | Key | Default | Extra |
+---------+-------------+------+-----+---------+-------------------+
| rollNo | int | NO | PRI | NULL | |
| name | varchar(20) | NO | | NULL | |
| email | varchar(20) | YES | UNI | NULL | |
| x_per | double(5,2) | YES | | 33.0 | DEFAULT_GENERATED |
| state | varchar(25) | YES | | NULL | |
| distick | varchar(20) | YES | | NULL | |
| village | varchar(20) | YES | | NULL | |
+---------+-------------+------+-----+---------+-------------------+
7 rows in set (0.04 sec)
mysql> SELECT * FROM st;
+--------+------+------------+-------+----------------+---------+---------+
| rollNo | name | email | x_per | state | distick | village |
+--------+------+------------+-------+----------------+---------+---------+
| 1001 | abc | abc@ms.com | 85.42 | Tamilnadu | NULL | NULL |
| 1002 | def | def@ms.com | 90.20 | Karnataka | NULL | NULL |
| 1003 | ghi | ghi@ms.com | 78.60 | Maharashtra | NULL | NULL |
| 1004 | jkl | jkl@ms.com | 92.50 | Kerala | NULL | NULL |
| 1005 | mno | mno@ms.com | 80.30 | Andhra Pradesh | NULL | NULL |
| 1006 | pqr | pqr@ms.com | 89.10 | Telangana | NULL | NULL |
| 1007 | stu | stu@ms.com | 76.80 | Gujarat | NULL | NULL |
| 1008 | vwx | vwx@ms.com | 95.20 | Uttar Pradesh | NULL | NULL |
| 1009 | yza | yza@ms.com | 87.40 | Bihar | NULL | NULL |
| 1010 | bcd | bcd@ms.com | 81.60 | Tamilnadu | NULL | NULL |
| 1011 | efg | efg@ms.com | 79.20 | Karnataka | NULL | NULL |
| 1012 | hij | hij@ms.com | 88.50 | Maharashtra | NULL | NULL |
| 1013 | klm | klm@ms.com | 72.30 | Kerala | NULL | NULL |
| 1014 | nop | nop@ms.com | 94.10 | Andhra Pradesh | NULL | NULL |
| 1015 | qrs | qrs@ms.com | 82.70 | Telangana | NULL | NULL |
| 1016 | tuv | tuv@ms.com | 70.40 | Gujarat | NULL | NULL |
| 1017 | wxy | wxy@ms.com | 91.80 | Uttar Pradesh | NULL | NULL |
| 1018 | zab | zab@ms.com | 84.50 | Bihar | NULL | NULL |
| 1019 | cde | cde@ms.com | 77.90 | Tamilnadu | NULL | NULL |
| 1020 | fgh | fgh@ms.com | 89.60 | Karnataka | NULL | NULL |
+--------+------+------------+-------+----------------+---------+---------+
20 rows in set (0.06 sec)
mysql> select destinct(x_per) from st;
ERROR 1305 (42000): FUNCTION sb101.destinct does not exist
mysql> select distinct(x_per) from st;
+-------+
| x_per |
+-------+
| 85.42 |
| 90.20 |
| 78.60 |
| 92.50 |
| 80.30 |
| 89.10 |
| 76.80 |
| 95.20 |
| 87.40 |
| 81.60 |
| 79.20 |
| 88.50 |
| 72.30 |
| 94.10 |
| 82.70 |
| 70.40 |
| 91.80 |
| 84.50 |
| 77.90 |
| 89.60 |
+-------+
20 rows in set (0.03 sec)
mysql> select distinct(rollno) from st;
+--------+
| rollno |
+--------+
| 1001 |
| 1010 |
| 1019 |
| 1002 |
| 1011 |
| 1020 |
| 1003 |
| 1012 |
| 1004 |
| 1013 |
| 1005 |
| 1014 |
| 1006 |
| 1015 |
| 1007 |
| 1016 |
| 1008 |
| 1017 |
| 1009 |
| 1018 |
+--------+
20 rows in set (0.03 sec)
mysql> select distinct(name) from st;
+------+
| name |
+------+
| abc |
| def |
| ghi |
| jkl |
| mno |
| pqr |
| stu |
| vwx |
| yza |
| bcd |
| efg |
| hij |
| klm |
| nop |
| qrs |
| tuv |
| wxy |
| zab |
| cde |
| fgh |
+------+
20 rows in set (0.00 sec)
mysql> select rollno as "Roll Number",name as "Student Name",x_per as "otal Pesrcentage" from st;
+-------------+--------------+------------------+
| Roll Number | Student Name | otal Pesrcentage |
+-------------+--------------+------------------+
| 1001 | abc | 85.42 |
| 1002 | def | 90.20 |
| 1003 | ghi | 78.60 |
| 1004 | jkl | 92.50 |
| 1005 | mno | 80.30 |
| 1006 | pqr | 89.10 |
| 1007 | stu | 76.80 |
| 1008 | vwx | 95.20 |
| 1009 | yza | 87.40 |
| 1010 | bcd | 81.60 |
| 1011 | efg | 79.20 |
| 1012 | hij | 88.50 |
| 1013 | klm | 72.30 |
| 1014 | nop | 94.10 |
| 1015 | qrs | 82.70 |
| 1016 | tuv | 70.40 |
| 1017 | wxy | 91.80 |
| 1018 | zab | 84.50 |
| 1019 | cde | 77.90 |
| 1020 | fgh | 89.60 |
+-------------+--------------+------------------+
20 rows in set (0.00 sec)
mysql> select rollno as "Roll Number",name as "Student Name",x_per as "Total Pesrcentage" from st;
+-------------+--------------+-------------------+
| Roll Number | Student Name | Total Pesrcentage |
+-------------+--------------+-------------------+
| 1001 | abc | 85.42 |
| 1002 | def | 90.20 |
| 1003 | ghi | 78.60 |
| 1004 | jkl | 92.50 |
| 1005 | mno | 80.30 |
| 1006 | pqr | 89.10 |
| 1007 | stu | 76.80 |
| 1008 | vwx | 95.20 |
| 1009 | yza | 87.40 |
| 1010 | bcd | 81.60 |
| 1011 | efg | 79.20 |
| 1012 | hij | 88.50 |
| 1013 | klm | 72.30 |
| 1014 | nop | 94.10 |
| 1015 | qrs | 82.70 |
| 1016 | tuv | 70.40 |
| 1017 | wxy | 91.80 |
| 1018 | zab | 84.50 |
| 1019 | cde | 77.90 |
| 1020 | fgh | 89.60 |
+-------------+--------------+-------------------+
20 rows in set (0.00 sec)
mysql> select rollno as "Roll Number",name as "Student Name",x_per as "Total Pesrcentage", rollno as "Key" from st;
+-------------+--------------+-------------------+------+
| Roll Number | Student Name | Total Pesrcentage | Key |
+-------------+--------------+-------------------+------+
| 1001 | abc | 85.42 | 1001 |
| 1002 | def | 90.20 | 1002 |
| 1003 | ghi | 78.60 | 1003 |
| 1004 | jkl | 92.50 | 1004 |
| 1005 | mno | 80.30 | 1005 |
| 1006 | pqr | 89.10 | 1006 |
| 1007 | stu | 76.80 | 1007 |
| 1008 | vwx | 95.20 | 1008 |
| 1009 | yza | 87.40 | 1009 |
| 1010 | bcd | 81.60 | 1010 |
| 1011 | efg | 79.20 | 1011 |
| 1012 | hij | 88.50 | 1012 |
| 1013 | klm | 72.30 | 1013 |
| 1014 | nop | 94.10 | 1014 |
| 1015 | qrs | 82.70 | 1015 |
| 1016 | tuv | 70.40 | 1016 |
| 1017 | wxy | 91.80 | 1017 |
| 1018 | zab | 84.50 | 1018 |
| 1019 | cde | 77.90 | 1019 |
| 1020 | fgh | 89.60 | 1020 |
+-------------+--------------+-------------------+------+
20 rows in set (0.00 sec)
mysql> select rollno as "Roll Number",name as "Student Name",x_per as "Total Pesrcentage", rollno as "Key","Roll Number",name as "Student Name",x_per as "Total Pesrcentage", from st;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from st' at line 1
mysql> select rollno as "Roll Number",name as "Student Name",x_per as "Total Pesrcentage", rollno as "Key","Roll Number",name as "Student Name",x_per as "Total Pesrcentage" from st;
+-------------+--------------+-------------------+------+-------------+--------------+-------------------+
| Roll Number | Student Name | Total Pesrcentage | Key | Roll Number | Student Name | Total Pesrcentage |
+-------------+--------------+-------------------+------+-------------+--------------+-------------------+
| 1001 | abc | 85.42 | 1001 | Roll Number | abc | 85.42 |
| 1002 | def | 90.20 | 1002 | Roll Number | def | 90.20 |
| 1003 | ghi | 78.60 | 1003 | Roll Number | ghi | 78.60 |
| 1004 | jkl | 92.50 | 1004 | Roll Number | jkl | 92.50 |
| 1005 | mno | 80.30 | 1005 | Roll Number | mno | 80.30 |
| 1006 | pqr | 89.10 | 1006 | Roll Number | pqr | 89.10 |
| 1007 | stu | 76.80 | 1007 | Roll Number | stu | 76.80 |
| 1008 | vwx | 95.20 | 1008 | Roll Number | vwx | 95.20 |
| 1009 | yza | 87.40 | 1009 | Roll Number | yza | 87.40 |
| 1010 | bcd | 81.60 | 1010 | Roll Number | bcd | 81.60 |
| 1011 | efg | 79.20 | 1011 | Roll Number | efg | 79.20 |
| 1012 | hij | 88.50 | 1012 | Roll Number | hij | 88.50 |
| 1013 | klm | 72.30 | 1013 | Roll Number | klm | 72.30 |
| 1014 | nop | 94.10 | 1014 | Roll Number | nop | 94.10 |
| 1015 | qrs | 82.70 | 1015 | Roll Number | qrs | 82.70 |
| 1016 | tuv | 70.40 | 1016 | Roll Number | tuv | 70.40 |
| 1017 | wxy | 91.80 | 1017 | Roll Number | wxy | 91.80 |
| 1018 | zab | 84.50 | 1018 | Roll Number | zab | 84.50 |
| 1019 | cde | 77.90 | 1019 | Roll Number | cde | 77.90 |
| 1020 | fgh | 89.60 | 1020 | Roll Number | fgh | 89.60 |
+-------------+--------------+-------------------+------+-------------+--------------+-------------------+
20 rows in set (0.00 sec)
mysql> SELECT rollNo "Roll Number", name "Student Name", x_per "Inter Exam Percentage" FROM st;
+-------------+--------------+-----------------------+
| Roll Number | Student Name | Inter Exam Percentage |
+-------------+--------------+-----------------------+
| 1001 | abc | 85.42 |
| 1002 | def | 90.20 |
| 1003 | ghi | 78.60 |
| 1004 | jkl | 92.50 |
| 1005 | mno | 80.30 |
| 1006 | pqr | 89.10 |
| 1007 | stu | 76.80 |
| 1008 | vwx | 95.20 |
| 1009 | yza | 87.40 |
| 1010 | bcd | 81.60 |
| 1011 | efg | 79.20 |
| 1012 | hij | 88.50 |
| 1013 | klm | 72.30 |
| 1014 | nop | 94.10 |
| 1015 | qrs | 82.70 |
| 1016 | tuv | 70.40 |
| 1017 | wxy | 91.80 |
| 1018 | zab | 84.50 |
| 1019 | cde | 77.90 |
| 1020 | fgh | 89.60 |
+-------------+--------------+-----------------------+
20 rows in set (0.00 sec)
mysql> SELECT rollNo RN, name SName, x_per 10_Per FROM st;
+------+-------+--------+
| RN | SName | 10_Per |
+------+-------+--------+
| 1001 | abc | 85.42 |
| 1002 | def | 90.20 |
| 1003 | ghi | 78.60 |
| 1004 | jkl | 92.50 |
| 1005 | mno | 80.30 |
| 1006 | pqr | 89.10 |
| 1007 | stu | 76.80 |
| 1008 | vwx | 95.20 |
| 1009 | yza | 87.40 |
| 1010 | bcd | 81.60 |
| 1011 | efg | 79.20 |
| 1012 | hij | 88.50 |
| 1013 | klm | 72.30 |
| 1014 | nop | 94.10 |
| 1015 | qrs | 82.70 |
| 1016 | tuv | 70.40 |
| 1017 | wxy | 91.80 |
| 1018 | zab | 84.50 |
| 1019 | cde | 77.90 |
| 1020 | fgh | 89.60 |
+------+-------+--------+
20 rows in set (0.00 sec)
mysql> select rollno as idm name as key ,x_per as value from st;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'name as key ,x_per as value from st' at line 1
mysql> select rollno as idm, name as key ,x_per as value from st;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'key ,x_per as value from st' at line 1
mysql> select rollno as id, name as key ,x_per as value from st;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'key ,x_per as value from st' at line 1
mysql> SELECT rollNo as RN, name as SName, x_per as 10_Per FROM st;
+------+-------+--------+
| RN | SName | 10_Per |
+------+-------+--------+
| 1001 | abc | 85.42 |
| 1002 | def | 90.20 |
| 1003 | ghi | 78.60 |
| 1004 | jkl | 92.50 |
| 1005 | mno | 80.30 |
| 1006 | pqr | 89.10 |
| 1007 | stu | 76.80 |
| 1008 | vwx | 95.20 |
| 1009 | yza | 87.40 |
| 1010 | bcd | 81.60 |
| 1011 | efg | 79.20 |
| 1012 | hij | 88.50 |
| 1013 | klm | 72.30 |
| 1014 | nop | 94.10 |
| 1015 | qrs | 82.70 |
| 1016 | tuv | 70.40 |
| 1017 | wxy | 91.80 |
| 1018 | zab | 84.50 |
| 1019 | cde | 77.90 |
| 1020 | fgh | 89.60 |
+------+-------+--------+
20 rows in set (0.00 sec)
mysql> select (x_per+10) as new_per from st;
+---------+
| new_per |
+---------+
| 95.42 |
| 100.20 |
| 88.60 |
| 102.50 |
| 90.30 |
| 99.10 |
| 86.80 |
| 105.20 |
| 97.40 |
| 91.60 |
| 89.20 |
| 98.50 |
| 82.30 |
| 104.10 |
| 92.70 |
| 80.40 |
| 101.80 |
| 94.50 |
| 87.90 |
| 99.60 |
+---------+
20 rows in set (0.03 sec)
mysql> select (x_per*1010) as new_per from st;
+----------+
| new_per |
+----------+
| 86274.20 |
| 91102.00 |
| 79386.00 |
| 93425.00 |
| 81103.00 |
| 89991.00 |
| 77568.00 |
| 96152.00 |
| 88274.00 |
| 82416.00 |
| 79992.00 |
| 89385.00 |
| 73023.00 |
| 95041.00 |
| 83527.00 |
| 71104.00 |
| 92718.00 |
| 85345.00 |
| 78679.00 |
| 90496.00 |
+----------+
20 rows in set (0.00 sec)
mysql> select (x_per*1000000000000000000010) as new_per from st;
+----------------------------+
| new_per |
+----------------------------+
| 85420000000000000000000.00 |
| 90200000000000010000000.00 |
| 78600000000000000000000.00 |
| 92500000000000000000000.00 |
| 80300000000000000000000.00 |
| 89099999999999990000000.00 |
| 76800000000000000000000.00 |
| 95200000000000000000000.00 |
| 87400000000000000000000.00 |
| 81600000000000000000000.00 |
| 79200000000000000000000.00 |
| 88500000000000000000000.00 |
| 72300000000000000000000.00 |
| 94099999999999990000000.00 |
| 82700000000000000000000.00 |
| 70400000000000010000000.00 |
| 91800000000000000000000.00 |
| 84500000000000000000000.00 |
| 77900000000000000000000.00 |
| 89600000000000000000000.00 |
+----------------------------+
20 rows in set (0.00 sec)
mysql> select (x_per*10000000000000000000145435034859043854903583049583450934853409580) as new_per from st;
+-----------------------------------------------------------------------+
| new_per
|
+-----------------------------------------------------------------------+
| 854200000000000000000000000000000000000000000000000000000000000000.00 |
| 902000000000000000000000000000000000000000000000000000000000000000.00 |
| 786000000000000000000000000000000000000000000000000000000000000000.00 |
| 925000000000000000000000000000000000000000000000000000000000000000.00 |
| 803000000000000000000000000000000000000000000000000000000000000000.00 |
| 890999999999999900000000000000000000000000000000000000000000000000.00 |
| 768000000000000000000000000000000000000000000000000000000000000000.00 |
| 952000000000000000000000000000000000000000000000000000000000000000.00 |
| 874000000000000000000000000000000000000000000000000000000000000000.00 |
| 815999999999999900000000000000000000000000000000000000000000000000.00 |
| 792000000000000000000000000000000000000000000000000000000000000000.00 |
| 885000000000000000000000000000000000000000000000000000000000000000.00 |
| 723000000000000000000000000000000000000000000000000000000000000000.00 |
| 941000000000000000000000000000000000000000000000000000000000000000.00 |
| 827000000000000100000000000000000000000000000000000000000000000000.00 |
| 704000000000000100000000000000000000000000000000000000000000000000.00 |
| 918000000000000000000000000000000000000000000000000000000000000000.00 |
| 845000000000000000000000000000000000000000000000000000000000000000.00 |
| 779000000000000000000000000000000000000000000000000000000000000000.00 |
| 895999999999999900000000000000000000000000000000000000000000000000.00 |
+-----------------------------------------------------------------------+
20 rows in set (0.00 sec)
mysql> select (x_per*1000000000000000000014543503485904385490358304958345093485340958045843258390458439085340958234095834025934258234095) as new_per from st;
+------------------------------------------------------------------------+
| new_per |
+------------------------------------------------------------------------+
| 8542000000000000000000000000000000000000000000000000000000000000000.00 |
| 9020000000000000000000000000000000000000000000000000000000000000000.00 |
| 7860000000000000000000000000000000000000000000000000000000000000000.00 |
| 9250000000000000000000000000000000000000000000000000000000000000000.00 |
| 8030000000000000000000000000000000000000000000000000000000000000000.00 |
| 8909999999999999000000000000000000000000000000000000000000000000000.00 |
| 7679999999999999000000000000000000000000000000000000000000000000000.00 |
| 9520000000000000000000000000000000000000000000000000000000000000000.00 |
| 8740000000000001000000000000000000000000000000000000000000000000000.00 |
| 8160000000000000000000000000000000000000000000000000000000000000000.00 |
| 7920000000000001000000000000000000000000000000000000000000000000000.00 |
| 8850000000000000000000000000000000000000000000000000000000000000000.00 |
| 7229999999999999000000000000000000000000000000000000000000000000000.00 |
| 9410000000000000000000000000000000000000000000000000000000000000000.00 |
| 8270000000000001000000000000000000000000000000000000000000000000000.00 |
| 7040000000000001000000000000000000000000000000000000000000000000000.00 |
| 9180000000000000000000000000000000000000000000000000000000000000000.00 |
| 8450000000000000000000000000000000000000000000000000000000000000000.00 |
| 7790000000000000000000000000000000000000000000000000000000000000000.00 |
| 8960000000000000000000000000000000000000000000000000000000000000000.00 |
+------------------------------------------------------------------------+
20 rows in set, 1 warning (0.03 sec)
mysql> select *from st where x_per>75;
+--------+------+------------+-------+----------------+---------+---------+
| rollNo | name | email | x_per | state | distick | village |
+--------+------+------------+-------+----------------+---------+---------+
| 1001 | abc | abc@ms.com | 85.42 | Tamilnadu | NULL | NULL |
| 1002 | def | def@ms.com | 90.20 | Karnataka | NULL | NULL |
| 1003 | ghi | ghi@ms.com | 78.60 | Maharashtra | NULL | NULL |
| 1004 | jkl | jkl@ms.com | 92.50 | Kerala | NULL | NULL |
| 1005 | mno | mno@ms.com | 80.30 | Andhra Pradesh | NULL | NULL |
| 1006 | pqr | pqr@ms.com | 89.10 | Telangana | NULL | NULL |
| 1007 | stu | stu@ms.com | 76.80 | Gujarat | NULL | NULL |
| 1008 | vwx | vwx@ms.com | 95.20 | Uttar Pradesh | NULL | NULL |
| 1009 | yza | yza@ms.com | 87.40 | Bihar | NULL | NULL |
| 1010 | bcd | bcd@ms.com | 81.60 | Tamilnadu | NULL | NULL |
| 1011 | efg | efg@ms.com | 79.20 | Karnataka | NULL | NULL |
| 1012 | hij | hij@ms.com | 88.50 | Maharashtra | NULL | NULL |
| 1014 | nop | nop@ms.com | 94.10 | Andhra Pradesh | NULL | NULL |
| 1015 | qrs | qrs@ms.com | 82.70 | Telangana | NULL | NULL |
| 1017 | wxy | wxy@ms.com | 91.80 | Uttar Pradesh | NULL | NULL |
| 1018 | zab | zab@ms.com | 84.50 | Bihar | NULL | NULL |
| 1019 | cde | cde@ms.com | 77.90 | Tamilnadu | NULL | NULL |
| 1020 | fgh | fgh@ms.com | 89.60 | Karnataka | NULL | NULL |
+--------+------+------------+-------+----------------+---------+---------+
18 rows in set (0.03 sec)
mysql> select *from st where x_per>=75;
+--------+------+------------+-------+----------------+---------+---------+
| rollNo | name | email | x_per | state | distick | village |
+--------+------+------------+-------+----------------+---------+---------+
| 1001 | abc | abc@ms.com | 85.42 | Tamilnadu | NULL | NULL |
| 1002 | def | def@ms.com | 90.20 | Karnataka | NULL | NULL |
| 1003 | ghi | ghi@ms.com | 78.60 | Maharashtra | NULL | NULL |
| 1004 | jkl | jkl@ms.com | 92.50 | Kerala | NULL | NULL |
| 1005 | mno | mno@ms.com | 80.30 | Andhra Pradesh | NULL | NULL |
| 1006 | pqr | pqr@ms.com | 89.10 | Telangana | NULL | NULL |
| 1007 | stu | stu@ms.com | 76.80 | Gujarat | NULL | NULL |
| 1008 | vwx | vwx@ms.com | 95.20 | Uttar Pradesh | NULL | NULL |
| 1009 | yza | yza@ms.com | 87.40 | Bihar | NULL | NULL |
| 1010 | bcd | bcd@ms.com | 81.60 | Tamilnadu | NULL | NULL |
| 1011 | efg | efg@ms.com | 79.20 | Karnataka | NULL | NULL |
| 1012 | hij | hij@ms.com | 88.50 | Maharashtra | NULL | NULL |
| 1014 | nop | nop@ms.com | 94.10 | Andhra Pradesh | NULL | NULL |
| 1015 | qrs | qrs@ms.com | 82.70 | Telangana | NULL | NULL |
| 1017 | wxy | wxy@ms.com | 91.80 | Uttar Pradesh | NULL | NULL |
| 1018 | zab | zab@ms.com | 84.50 | Bihar | NULL | NULL |
| 1019 | cde | cde@ms.com | 77.90 | Tamilnadu | NULL | NULL |
| 1020 | fgh | fgh@ms.com | 89.60 | Karnataka | NULL | NULL |
+--------+------+------------+-------+----------------+---------+---------+
18 rows in set (0.00 sec)
mysql> select *from st where x_per<=75;
+--------+------+------------+-------+---------+---------+---------+
| rollNo | name | email | x_per | state | distick | village |
+--------+------+------------+-------+---------+---------+---------+
| 1013 | klm | klm@ms.com | 72.30 | Kerala | NULL | NULL |
| 1016 | tuv | tuv@ms.com | 70.40 | Gujarat | NULL | NULL |
+--------+------+------------+-------+---------+---------+---------+
2 rows in set (0.00 sec)
mysql> select rollno as newroll , name as tempName ,xx_per as newPercentatage from st where x_per<=75;
ERROR 1054 (42S22): Unknown column 'xx_per' in 'field list'
mysql> select rollno as newroll , name as tempName ,x_per as newPercentatage from st where x_per<=75;
+---------+----------+-----------------+
| newroll | tempName | newPercentatage |
+---------+----------+-----------------+
| 1013 | klm | 72.30 |
| 1016 | tuv | 70.40 |
+---------+----------+-----------------+
2 rows in set (0.00 sec)
mysql> select * from where x_per between 33.00 and 90.00;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where x_per between 33.00 and 90.00' at line 1
mysql> select * from where x_per between 33 and 90;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where x_per between 33 and 90' at line 1
mysql> select * from st where x_per between 33 and 90;
+--------+------+------------+-------+----------------+---------+---------+
| rollNo | name | email | x_per | state | distick | village |
+--------+------+------------+-------+----------------+---------+---------+
| 1001 | abc | abc@ms.com | 85.42 | Tamilnadu | NULL | NULL |
| 1003 | ghi | ghi@ms.com | 78.60 | Maharashtra | NULL | NULL |
| 1005 | mno | mno@ms.com | 80.30 | Andhra Pradesh | NULL | NULL |
| 1006 | pqr | pqr@ms.com | 89.10 | Telangana | NULL | NULL |
| 1007 | stu | stu@ms.com | 76.80 | Gujarat | NULL | NULL |
| 1009 | yza | yza@ms.com | 87.40 | Bihar | NULL | NULL |
| 1010 | bcd | bcd@ms.com | 81.60 | Tamilnadu | NULL | NULL |
| 1011 | efg | efg@ms.com | 79.20 | Karnataka | NULL | NULL |
| 1012 | hij | hij@ms.com | 88.50 | Maharashtra | NULL | NULL |
| 1013 | klm | klm@ms.com | 72.30 | Kerala | NULL | NULL |
| 1015 | qrs | qrs@ms.com | 82.70 | Telangana | NULL | NULL |
| 1016 | tuv | tuv@ms.com | 70.40 | Gujarat | NULL | NULL |
| 1018 | zab | zab@ms.com | 84.50 | Bihar | NULL | NULL |
| 1019 | cde | cde@ms.com | 77.90 | Tamilnadu | NULL | NULL |
| 1020 | fgh | fgh@ms.com | 89.60 | Karnataka | NULL | NULL |
+--------+------+------------+-------+----------------+---------+---------+
15 rows in set (0.00 sec)
mysql> select * from st where x_per=80.42;
Empty set (0.00 sec)
mysql> select * from st where x_per=80.10;
Empty set (0.00 sec)
mysql> select * from st where x_per=80.30;
+--------+------+------------+-------+----------------+---------+---------+
| rollNo | name | email | x_per | state | distick | village |
+--------+------+------------+-------+----------------+---------+---------+
| 1005 | mno | mno@ms.com | 80.30 | Andhra Pradesh | NULL | NULL |
+--------+------+------------+-------+----------------+---------+---------+
1 row in set (0.00 sec)
mysql> select * from st where state=karnataka;
ERROR 1054 (42S22): Unknown column 'karnataka' in 'where clause'
mysql> select * from st where state='karnataka';
+--------+------+------------+-------+-----------+---------+---------+
| rollNo | name | email | x_per | state | distick | village |
+--------+------+------------+-------+-----------+---------+---------+
| 1002 | def | def@ms.com | 90.20 | Karnataka | NULL | NULL |
| 1011 | efg | efg@ms.com | 79.20 | Karnataka | NULL | NULL |
| 1020 | fgh | fgh@ms.com | 89.60 | Karnataka | NULL | NULL |
+--------+------+------------+-------+-----------+---------+---------+
3 rows in set (0.03 sec)
mysql> select * from st where x_per>=72 or state="karnataka";
+--------+------+------------+-------+----------------+---------+---------+
| rollNo | name | email | x_per | state | distick | village |
+--------+------+------------+-------+----------------+---------+---------+
| 1001 | abc | abc@ms.com | 85.42 | Tamilnadu | NULL | NULL |
| 1002 | def | def@ms.com | 90.20 | Karnataka | NULL | NULL |
| 1003 | ghi | ghi@ms.com | 78.60 | Maharashtra | NULL | NULL |
| 1004 | jkl | jkl@ms.com | 92.50 | Kerala | NULL | NULL |
| 1005 | mno | mno@ms.com | 80.30 | Andhra Pradesh | NULL | NULL |
| 1006 | pqr | pqr@ms.com | 89.10 | Telangana | NULL | NULL |
| 1007 | stu | stu@ms.com | 76.80 | Gujarat | NULL | NULL |
| 1008 | vwx | vwx@ms.com | 95.20 | Uttar Pradesh | NULL | NULL |
| 1009 | yza | yza@ms.com | 87.40 | Bihar | NULL | NULL |
| 1010 | bcd | bcd@ms.com | 81.60 | Tamilnadu | NULL | NULL |
| 1011 | efg | efg@ms.com | 79.20 | Karnataka | NULL | NULL |
| 1012 | hij | hij@ms.com | 88.50 | Maharashtra | NULL | NULL |
| 1013 | klm | klm@ms.com | 72.30 | Kerala | NULL | NULL |
| 1014 | nop | nop@ms.com | 94.10 | Andhra Pradesh | NULL | NULL |
| 1015 | qrs | qrs@ms.com | 82.70 | Telangana | NULL | NULL |
| 1017 | wxy | wxy@ms.com | 91.80 | Uttar Pradesh | NULL | NULL |
| 1018 | zab | zab@ms.com | 84.50 | Bihar | NULL | NULL |
| 1019 | cde | cde@ms.com | 77.90 | Tamilnadu | NULL | NULL |
| 1020 | fgh | fgh@ms.com | 89.60 | Karnataka | NULL | NULL |
+--------+------+------------+-------+----------------+---------+---------+
19 rows in set (0.00 sec)
mysql> SELECT * FROM st WHERE x_per >= 60.00 || state = 'Karnataka';
+--------+------+------------+-------+----------------+---------+---------+
| rollNo | name | email | x_per | state | distick | village |
+--------+------+------------+-------+----------------+---------+---------+
| 1001 | abc | abc@ms.com | 85.42 | Tamilnadu | NULL | NULL |
| 1002 | def | def@ms.com | 90.20 | Karnataka | NULL | NULL |
| 1003 | ghi | ghi@ms.com | 78.60 | Maharashtra | NULL | NULL |
| 1004 | jkl | jkl@ms.com | 92.50 | Kerala | NULL | NULL |
| 1005 | mno | mno@ms.com | 80.30 | Andhra Pradesh | NULL | NULL |
| 1006 | pqr | pqr@ms.com | 89.10 | Telangana | NULL | NULL |
| 1007 | stu | stu@ms.com | 76.80 | Gujarat | NULL | NULL |
| 1008 | vwx | vwx@ms.com | 95.20 | Uttar Pradesh | NULL | NULL |
| 1009 | yza | yza@ms.com | 87.40 | Bihar | NULL | NULL |
| 1010 | bcd | bcd@ms.com | 81.60 | Tamilnadu | NULL | NULL |
| 1011 | efg | efg@ms.com | 79.20 | Karnataka | NULL | NULL |
| 1012 | hij | hij@ms.com | 88.50 | Maharashtra | NULL | NULL |
| 1013 | klm | klm@ms.com | 72.30 | Kerala | NULL | NULL |
| 1014 | nop | nop@ms.com | 94.10 | Andhra Pradesh | NULL | NULL |
| 1015 | qrs | qrs@ms.com | 82.70 | Telangana | NULL | NULL |
| 1016 | tuv | tuv@ms.com | 70.40 | Gujarat | NULL | NULL |
| 1017 | wxy | wxy@ms.com | 91.80 | Uttar Pradesh | NULL | NULL |
| 1018 | zab | zab@ms.com | 84.50 | Bihar | NULL | NULL |
| 1019 | cde | cde@ms.com | 77.90 | Tamilnadu | NULL | NULL |
| 1020 | fgh | fgh@ms.com | 89.60 | Karnataka | NULL | NULL |
+--------+------+------------+-------+----------------+---------+---------+
20 rows in set, 1 warning (0.00 sec)
mysql> SELECT * FROM st WHERE (x_per >= 60.00 and rollno==1020) || state = 'Karnataka';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '==1020) || state = 'Karnataka'' at line 1
mysql> SELECT * FROM st WHERE (x_per >= 60.00 and rollno=1020) || state = 'Karnataka';
+--------+------+------------+-------+-----------+---------+---------+
| rollNo | name | email | x_per | state | distick | village |
+--------+------+------------+-------+-----------+---------+---------+
| 1002 | def | def@ms.com | 90.20 | Karnataka | NULL | NULL |
| 1011 | efg | efg@ms.com | 79.20 | Karnataka | NULL | NULL |
| 1020 | fgh | fgh@ms.com | 89.60 | Karnataka | NULL | NULL |
+--------+------+------------+-------+-----------+---------+---------+
3 rows in set, 1 warning (0.00 sec)
mysql> select * from st whrer state in('karnataka' , 'punjab','rajasthan');
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'state in('karnataka' , 'punjab','rajasthan')' at line 1
mysql> select * from st whrere state in('karnataka' , 'punjab','rajasthan');
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'state in('karnataka' , 'punjab','rajasthan')' at line 1
mysql> select * from st where state in('karnataka' , 'punjab','rajasthan');
+--------+------+------------+-------+-----------+---------+---------+
| rollNo | name | email | x_per | state | distick | village |
+--------+------+------------+-------+-----------+---------+---------+
| 1002 | def | def@ms.com | 90.20 | Karnataka | NULL | NULL |
| 1011 | efg | efg@ms.com | 79.20 | Karnataka | NULL | NULL |
| 1020 | fgh | fgh@ms.com | 89.60 | Karnataka | NULL | NULL |
+--------+------+------------+-------+-----------+---------+---------+
3 rows in set (0.04 sec)
mysql> SELECT * FROM st WHERE email IS NULL;
Empty set (0.03 sec)
mysql> SELECT * FROM st WHERE distick IS NULL;
+--------+------+------------+-------+----------------+---------+---------+
| rollNo | name | email | x_per | state | distick | village |
+--------+------+------------+-------+----------------+---------+---------+
| 1001 | abc | abc@ms.com | 85.42 | Tamilnadu | NULL | NULL |
| 1002 | def | def@ms.com | 90.20 | Karnataka | NULL | NULL |
| 1003 | ghi | ghi@ms.com | 78.60 | Maharashtra | NULL | NULL |
| 1004 | jkl | jkl@ms.com | 92.50 | Kerala | NULL | NULL |
| 1005 | mno | mno@ms.com | 80.30 | Andhra Pradesh | NULL | NULL |
| 1006 | pqr | pqr@ms.com | 89.10 | Telangana | NULL | NULL |
| 1007 | stu | stu@ms.com | 76.80 | Gujarat | NULL | NULL |
| 1008 | vwx | vwx@ms.com | 95.20 | Uttar Pradesh | NULL | NULL |
| 1009 | yza | yza@ms.com | 87.40 | Bihar | NULL | NULL |
| 1010 | bcd | bcd@ms.com | 81.60 | Tamilnadu | NULL | NULL |
| 1011 | efg | efg@ms.com | 79.20 | Karnataka | NULL | NULL |
| 1012 | hij | hij@ms.com | 88.50 | Maharashtra | NULL | NULL |
| 1013 | klm | klm@ms.com | 72.30 | Kerala | NULL | NULL |
| 1014 | nop | nop@ms.com | 94.10 | Andhra Pradesh | NULL | NULL |
| 1015 | qrs | qrs@ms.com | 82.70 | Telangana | NULL | NULL |
| 1016 | tuv | tuv@ms.com | 70.40 | Gujarat | NULL | NULL |
| 1017 | wxy | wxy@ms.com | 91.80 | Uttar Pradesh | NULL | NULL |
| 1018 | zab | zab@ms.com | 84.50 | Bihar | NULL | NULL |
| 1019 | cde | cde@ms.com | 77.90 | Tamilnadu | NULL | NULL |
| 1020 | fgh | fgh@ms.com | 89.60 | Karnataka | NULL | NULL |
+--------+------+------------+-------+----------------+---------+---------+
20 rows in set (0.00 sec)
mysql> ELECT * FROM st WHERE email IS NOT NULL;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ELECT * FROM st WHERE email IS NOT NULL' at line 1
mysql> SELECT * FROM st WHERE email IS NOT NULL;
+--------+------+------------+-------+----------------+---------+---------+
| rollNo | name | email | x_per | state | distick | village |
+--------+------+------------+-------+----------------+---------+---------+
| 1001 | abc | abc@ms.com | 85.42 | Tamilnadu | NULL | NULL |
| 1002 | def | def@ms.com | 90.20 | Karnataka | NULL | NULL |
| 1003 | ghi | ghi@ms.com | 78.60 | Maharashtra | NULL | NULL |
| 1004 | jkl | jkl@ms.com | 92.50 | Kerala | NULL | NULL |
| 1005 | mno | mno@ms.com | 80.30 | Andhra Pradesh | NULL | NULL |
| 1006 | pqr | pqr@ms.com | 89.10 | Telangana | NULL | NULL |
| 1007 | stu | stu@ms.com | 76.80 | Gujarat | NULL | NULL |
| 1008 | vwx | vwx@ms.com | 95.20 | Uttar Pradesh | NULL | NULL |
| 1009 | yza | yza@ms.com | 87.40 | Bihar | NULL | NULL |
| 1010 | bcd | bcd@ms.com | 81.60 | Tamilnadu | NULL | NULL |
| 1011 | efg | efg@ms.com | 79.20 | Karnataka | NULL | NULL |
| 1012 | hij | hij@ms.com | 88.50 | Maharashtra | NULL | NULL |
| 1013 | klm | klm@ms.com | 72.30 | Kerala | NULL | NULL |
| 1014 | nop | nop@ms.com | 94.10 | Andhra Pradesh | NULL | NULL |
| 1015 | qrs | qrs@ms.com | 82.70 | Telangana | NULL | NULL |
| 1016 | tuv | tuv@ms.com | 70.40 | Gujarat | NULL | NULL |
| 1017 | wxy | wxy@ms.com | 91.80 | Uttar Pradesh | NULL | NULL |
| 1018 | zab | zab@ms.com | 84.50 | Bihar | NULL | NULL |
| 1019 | cde | cde@ms.com | 77.90 | Tamilnadu | NULL | NULL |
| 1020 | fgh | fgh@ms.com | 89.60 | Karnataka | NULL | NULL |
+--------+------+------------+-------+----------------+---------+---------+
20 rows in set (0.00 sec)
mysql> select * from st where name like 'a%';
+--------+------+------------+-------+-----------+---------+---------+
| rollNo | name | email | x_per | state | distick | village |
+--------+------+------------+-------+-----------+---------+---------+
| 1001 | abc | abc@ms.com | 85.42 | Tamilnadu | NULL | NULL |
+--------+------+------------+-------+-----------+---------+---------+
1 row in set (0.03 sec)
mysql> select * from st where name like '%a%';
+--------+------+------------+-------+-----------+---------+---------+
| rollNo | name | email | x_per | state | distick | village |
+--------+------+------------+-------+-----------+---------+---------+
| 1001 | abc | abc@ms.com | 85.42 | Tamilnadu | NULL | NULL |
| 1009 | yza | yza@ms.com | 87.40 | Bihar | NULL | NULL |
| 1018 | zab | zab@ms.com | 84.50 | Bihar | NULL | NULL |
+--------+------+------------+-------+-----------+---------+---------+
3 rows in set (0.00 sec)
mysql> select * from st where name like '_a%';
+--------+------+------------+-------+-------+---------+---------+
| rollNo | name | email | x_per | state | distick | village |
+--------+------+------------+-------+-------+---------+---------+
| 1018 | zab | zab@ms.com | 84.50 | Bihar | NULL | NULL |
+--------+------+------------+-------+-------+---------+---------+
1 row in set (0.00 sec)
mysql> select * from st where name like '%a';
+--------+------+------------+-------+-------+---------+---------+
| rollNo | name | email | x_per | state | distick | village |
+--------+------+------------+-------+-------+---------+---------+
| 1009 | yza | yza@ms.com | 87.40 | Bihar | NULL | NULL |
+--------+------+------------+-------+-------+---------+---------+
1 row in set (0.00 sec)
mysql> select * from st where name like '_a_';
+--------+------+------------+-------+-------+---------+---------+
| rollNo | name | email | x_per | state | distick | village |
+--------+------+------------+-------+-------+---------+---------+
| 1018 | zab | zab@ms.com | 84.50 | Bihar | NULL | NULL |
+--------+------+------------+-------+-------+---------+---------+
1 row in set (0.00 sec)
mysql> select * from st Order by x_per ASC;
+--------+------+------------+-------+----------------+---------+---------+
| rollNo | name | email | x_per | state | distick | village |
+--------+------+------------+-------+----------------+---------+---------+
| 1016 | tuv | tuv@ms.com | 70.40 | Gujarat | NULL | NULL |
| 1013 | klm | klm@ms.com | 72.30 | Kerala | NULL | NULL |
| 1007 | stu | stu@ms.com | 76.80 | Gujarat | NULL | NULL |
| 1019 | cde | cde@ms.com | 77.90 | Tamilnadu | NULL | NULL |
| 1003 | ghi | ghi@ms.com | 78.60 | Maharashtra | NULL | NULL |
| 1011 | efg | efg@ms.com | 79.20 | Karnataka | NULL | NULL |
| 1005 | mno | mno@ms.com | 80.30 | Andhra Pradesh | NULL | NULL |
| 1010 | bcd | bcd@ms.com | 81.60 | Tamilnadu | NULL | NULL |
| 1015 | qrs | qrs@ms.com | 82.70 | Telangana | NULL | NULL |
| 1018 | zab | zab@ms.com | 84.50 | Bihar | NULL | NULL |
| 1001 | abc | abc@ms.com | 85.42 | Tamilnadu | NULL | NULL |
| 1009 | yza | yza@ms.com | 87.40 | Bihar | NULL | NULL |
| 1012 | hij | hij@ms.com | 88.50 | Maharashtra | NULL | NULL |
| 1006 | pqr | pqr@ms.com | 89.10 | Telangana | NULL | NULL |
| 1020 | fgh | fgh@ms.com | 89.60 | Karnataka | NULL | NULL |
| 1002 | def | def@ms.com | 90.20 | Karnataka | NULL | NULL |
| 1017 | wxy | wxy@ms.com | 91.80 | Uttar Pradesh | NULL | NULL |
| 1004 | jkl | jkl@ms.com | 92.50 | Kerala | NULL | NULL |
| 1014 | nop | nop@ms.com | 94.10 | Andhra Pradesh | NULL | NULL |
| 1008 | vwx | vwx@ms.com | 95.20 | Uttar Pradesh | NULL | NULL |
+--------+------+------------+-------+----------------+---------+---------+
20 rows in set (0.03 sec)
mysql> select * from st Order by x_per DESC;
+--------+------+------------+-------+----------------+---------+---------+
| rollNo | name | email | x_per | state | distick | village |
+--------+------+------------+-------+----------------+---------+---------+
| 1008 | vwx | vwx@ms.com | 95.20 | Uttar Pradesh | NULL | NULL |
| 1014 | nop | nop@ms.com | 94.10 | Andhra Pradesh | NULL | NULL |
| 1004 | jkl | jkl@ms.com | 92.50 | Kerala | NULL | NULL |
| 1017 | wxy | wxy@ms.com | 91.80 | Uttar Pradesh | NULL | NULL |
| 1002 | def | def@ms.com | 90.20 | Karnataka | NULL | NULL |
| 1020 | fgh | fgh@ms.com | 89.60 | Karnataka | NULL | NULL |
| 1006 | pqr | pqr@ms.com | 89.10 | Telangana | NULL | NULL |
| 1012 | hij | hij@ms.com | 88.50 | Maharashtra | NULL | NULL |
| 1009 | yza | yza@ms.com | 87.40 | Bihar | NULL | NULL |
| 1001 | abc | abc@ms.com | 85.42 | Tamilnadu | NULL | NULL |
| 1018 | zab | zab@ms.com | 84.50 | Bihar | NULL | NULL |
| 1015 | qrs | qrs@ms.com | 82.70 | Telangana | NULL | NULL |
| 1010 | bcd | bcd@ms.com | 81.60 | Tamilnadu | NULL | NULL |
| 1005 | mno | mno@ms.com | 80.30 | Andhra Pradesh | NULL | NULL |
| 1011 | efg | efg@ms.com | 79.20 | Karnataka | NULL | NULL |
| 1003 | ghi | ghi@ms.com | 78.60 | Maharashtra | NULL | NULL |
| 1019 | cde | cde@ms.com | 77.90 | Tamilnadu | NULL | NULL |
| 1007 | stu | stu@ms.com | 76.80 | Gujarat | NULL | NULL |
| 1013 | klm | klm@ms.com | 72.30 | Kerala | NULL | NULL |
| 1016 | tuv | tuv@ms.com | 70.40 | Gujarat | NULL | NULL |
+--------+------+------------+-------+----------------+---------+---------+
20 rows in set (0.00 sec)
mysql> select * from st Order by rollno DESC;
+--------+------+------------+-------+----------------+---------+---------+
| rollNo | name | email | x_per | state | distick | village |
+--------+------+------------+-------+----------------+---------+---------+
| 1020 | fgh | fgh@ms.com | 89.60 | Karnataka | NULL | NULL |
| 1019 | cde | cde@ms.com | 77.90 | Tamilnadu | NULL | NULL |
| 1018 | zab | zab@ms.com | 84.50 | Bihar | NULL | NULL |
| 1017 | wxy | wxy@ms.com | 91.80 | Uttar Pradesh | NULL | NULL |
| 1016 | tuv | tuv@ms.com | 70.40 | Gujarat | NULL | NULL |
| 1015 | qrs | qrs@ms.com | 82.70 | Telangana | NULL | NULL |
| 1014 | nop | nop@ms.com | 94.10 | Andhra Pradesh | NULL | NULL |
| 1013 | klm | klm@ms.com | 72.30 | Kerala | NULL | NULL |
| 1012 | hij | hij@ms.com | 88.50 | Maharashtra | NULL | NULL |
| 1011 | efg | efg@ms.com | 79.20 | Karnataka | NULL | NULL |
| 1010 | bcd | bcd@ms.com | 81.60 | Tamilnadu | NULL | NULL |
| 1009 | yza | yza@ms.com | 87.40 | Bihar | NULL | NULL |
| 1008 | vwx | vwx@ms.com | 95.20 | Uttar Pradesh | NULL | NULL |
| 1007 | stu | stu@ms.com | 76.80 | Gujarat | NULL | NULL |
| 1006 | pqr | pqr@ms.com | 89.10 | Telangana | NULL | NULL |
| 1005 | mno | mno@ms.com | 80.30 | Andhra Pradesh | NULL | NULL |
| 1004 | jkl | jkl@ms.com | 92.50 | Kerala | NULL | NULL |
| 1003 | ghi | ghi@ms.com | 78.60 | Maharashtra | NULL | NULL |
| 1002 | def | def@ms.com | 90.20 | Karnataka | NULL | NULL |
| 1001 | abc | abc@ms.com | 85.42 | Tamilnadu | NULL | NULL |
+--------+------+------------+-------+----------------+---------+---------+
20 rows in set (0.00 sec)
mysql> select * from st Order by name ASC;
+--------+------+------------+-------+----------------+---------+---------+
| rollNo | name | email | x_per | state | distick | village |
+--------+------+------------+-------+----------------+---------+---------+
| 1001 | abc | abc@ms.com | 85.42 | Tamilnadu | NULL | NULL |
| 1010 | bcd | bcd@ms.com | 81.60 | Tamilnadu | NULL | NULL |
| 1019 | cde | cde@ms.com | 77.90 | Tamilnadu | NULL | NULL |
| 1002 | def | def@ms.com | 90.20 | Karnataka | NULL | NULL |
| 1011 | efg | efg@ms.com | 79.20 | Karnataka | NULL | NULL |
| 1020 | fgh | fgh@ms.com | 89.60 | Karnataka | NULL | NULL |
| 1003 | ghi | ghi@ms.com | 78.60 | Maharashtra | NULL | NULL |
| 1012 | hij | hij@ms.com | 88.50 | Maharashtra | NULL | NULL |
| 1004 | jkl | jkl@ms.com | 92.50 | Kerala | NULL | NULL |
| 1013 | klm | klm@ms.com | 72.30 | Kerala | NULL | NULL |
| 1005 | mno | mno@ms.com | 80.30 | Andhra Pradesh | NULL | NULL |
| 1014 | nop | nop@ms.com | 94.10 | Andhra Pradesh | NULL | NULL |
| 1006 | pqr | pqr@ms.com | 89.10 | Telangana | NULL | NULL |
| 1015 | qrs | qrs@ms.com | 82.70 | Telangana | NULL | NULL |
| 1007 | stu | stu@ms.com | 76.80 | Gujarat | NULL | NULL |
| 1016 | tuv | tuv@ms.com | 70.40 | Gujarat | NULL | NULL |
| 1008 | vwx | vwx@ms.com | 95.20 | Uttar Pradesh | NULL | NULL |
| 1017 | wxy | wxy@ms.com | 91.80 | Uttar Pradesh | NULL | NULL |
| 1009 | yza | yza@ms.com | 87.40 | Bihar | NULL | NULL |
| 1018 | zab | zab@ms.com | 84.50 | Bihar | NULL | NULL |
+--------+------+------------+-------+----------------+---------+---------+
20 rows in set (0.03 sec)
mysql> select name, email,x_per from st order by name DESC;
+------+------------+-------+
| name | email | x_per |
+------+------------+-------+
| zab | zab@ms.com | 84.50 |
| yza | yza@ms.com | 87.40 |
| wxy | wxy@ms.com | 91.80 |
| vwx | vwx@ms.com | 95.20 |
| tuv | tuv@ms.com | 70.40 |
| stu | stu@ms.com | 76.80 |
| qrs | qrs@ms.com | 82.70 |
| pqr | pqr@ms.com | 89.10 |
| nop | nop@ms.com | 94.10 |
| mno | mno@ms.com | 80.30 |
| klm | klm@ms.com | 72.30 |
| jkl | jkl@ms.com | 92.50 |
| hij | hij@ms.com | 88.50 |
| ghi | ghi@ms.com | 78.60 |
| fgh | fgh@ms.com | 89.60 |
| efg | efg@ms.com | 79.20 |
| def | def@ms.com | 90.20 |
| cde | cde@ms.com | 77.90 |
| bcd | bcd@ms.com | 81.60 |
| abc | abc@ms.com | 85.42 |
+------+------------+-------+
20 rows in set (0.00 sec)
mysql> select name, email,x_per from st order by name DESC LIMIT 5;
+------+------------+-------+
| name | email | x_per |
+------+------------+-------+
| zab | zab@ms.com | 84.50 |
| yza | yza@ms.com | 87.40 |
| wxy | wxy@ms.com | 91.80 |
| vwx | vwx@ms.com | 95.20 |
| tuv | tuv@ms.com | 70.40 |
+------+------------+-------+
5 rows in set (0.00 sec)
mysql> select name, email,x_per from st order by name aESC LIMIT 5;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'aESC LIMIT 5' at line 1
mysql> select name, email,x_per from st order by name aSC LIMIT 5;
+------+------------+-------+
| name | email | x_per |
+------+------------+-------+
| abc | abc@ms.com | 85.42 |
| bcd | bcd@ms.com | 81.60 |
| cde | cde@ms.com | 77.90 |
| def | def@ms.com | 90.20 |
| efg | efg@ms.com | 79.20 |
+------+------------+-------+
5 rows in set (0.00 sec)
mysql> select mod(45,10);
+------------+
| mod(45,10) |
+------------+
| 5 |
+------------+
1 row in set (0.03 sec)
mysql> select mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),
-> select mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'select mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,' at line 2
mysql> select mod(50,10);
+------------+
| mod(50,10) |
+------------+
| 0 |
+------------+
1 row in set (0.00 sec)
mysql> select mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10),mod(50,10);
+------------+------------+------------+------------+------------+------------+------------+------------+------------+------------+------------+------------+------------+
| mod(50,10) | mod(50,10) | mod(50,10) | mod(50,10) | mod(50,10) | mod(50,10) | mod(50,10) | mod(50,10) | mod(50,10) | mod(50,10) | mod(50,10) | mod(50,10) | mod(50,10) |
+------------+------------+------------+------------+------------+------------+------------+------------+------------+------------+------------+------------+------------+
| 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
+------------+------------+------------+------------+------------+------------+------------+------------+------------+------------+------------+------------+------------+
1 row in set (0.00 sec)
Comments