10 things you might not know about MySQL
View more presentations from Jorge Bernal.
PHP & MySQL + Advanced Concepts
mysql> SELECT * FROM INFO;
+------+-------------+------+------------+------+
| ID | NAME | AGE | DEPT | EXP |
+------+-------------+------+------------+------+
| 1 | KARTHIKEYAN | 23 | TECHNOLOGY | NULL |
| 2 | ARUN | 23 | INFY | 1 |
+------+-------------+------+------------+------+
2 rows in set (0.00 sec)
mysql> UPDATE INFO SET EXP="1" WHERE ID=1;
Query OK, 1 row affected (0.03 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> SELECT * FROM INFO;
+------+-------------+------+------------+------+
| ID | NAME | AGE | DEPT | EXP |
+------+-------------+------+------------+------+
| 1 | KARTHIKEYAN | 23 | TECHNOLOGY | 1 |
| 2 | ARUN | 23 | INFY | 1 |
+------+-------------+------+------------+------+
2 rows in set (0.00 sec)
mysql> SHOW DATABASES;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
+--------------------+
2 rows in set (0.00 sec)
mysql> CREATE DATABASE KARTHIK;
Query OK, 1 row affected (0.00 sec)
mysql> USE KARTHIK;
Database changed
mysql> CREATE TABLE INFO(ID INT, NAME VARCHAR(30), AGE INT, DEPT VARCHAR(30));
Query OK, 0 rows affected (0.20 sec)
mysql> INSERT INTO INFO VALUES(1,"KARTHIKEYAN",23,"INTERNET");
Query OK, 1 row affected (0.03 sec)
mysql> SELECT * FROM INFO;
+------+-------------+------+----------+
| ID | NAME | AGE | DEPT |
+------+-------------+------+----------+
| 1 | KARTHIKEYAN | 23 | INTERNET |
+------+-------------+------+----------+
1 row in set (0.03 sec)
mysql> UPDATE INFO SET DEPT="TECHNOLOGY" WHERE ID=1;
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0
mysql> SELECT * FROM INFO;
+------+-------------+------+------------+
| ID | NAME | AGE | DEPT |
+------+-------------+------+------------+
| 1 | KARTHIKEYAN | 23 | TECHNOLOGY |
+------+-------------+------+------------+
1 row in set (0.00 sec)
mysql> ALTER TABLE INFO ADD EXP INT;
Query OK, 1 row affected (0.19 sec)
Records: 1 Duplicates: 0 Warnings: 0
mysql> SELECT * FROM INFO;
+------+-------------+------+------------+------+
| ID | NAME | AGE | DEPT | EXP |
+------+-------------+------+------------+------+
| 1 | KARTHIKEYAN | 23 | TECHNOLOGY | NULL |
+------+-------------+------+------------+------+
1 row in set (0.00 sec)