Mega Code Archive
Create Simple Tables
<![CDATA[
/*
mysql> DROP TABLE Employee;
mysql> CREATE TABLE Employee (
-> Name VARCHAR(50),
-> Phone VARCHAR(15)
-> );
Query OK, 0 rows affected (0.21 sec)
mysql> Show tables;
+-------------+
| Tables_in_t |
+-------------+
| employee |
| enrollment |
| student |
| studentexam |
+-------------+
4 rows in set (0.07 sec)
mysql> Describe Employee;
+-------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| Name | varchar(50) | YES | | NULL | |
| Phone | varchar(15) | YES | | NULL | |
+-------+-------------+------+-----+---------+-------+
2 rows in set (0.03 sec)
mysql> INSERT INTO Employee (Name, Phone) VALUES ('Joe Wang', '666 2323');
Query OK, 1 row affected (0.04 sec)
mysql> INSERT INTO Employee (Name) VALUES ('John Doe');
Query OK, 1 row affected (0.02 sec)
mysql> INSERT INTO Employee (Name, Phone) VALUES ('John Doe', NULL);
Query OK, 1 row affected (0.01 sec)
mysql> Select * from Employee;
+----------+----------+
| Name | Phone |
+----------+----------+
| Joe Wang | 666 2323 |
| John Doe | NULL |
| John Doe | NULL |
+----------+----------+
3 rows in set (0.08 sec)
*/
DROP TABLE Employee;
CREATE TABLE Employee (
Name VARCHAR(50),
Phone VARCHAR(15)
);
Show tables;
Describe Employee;
INSERT INTO Employee (Name, Phone) VALUES ('Joe Wang', '666 2323');
INSERT INTO Employee (Name) VALUES ('John Doe');
INSERT INTO Employee (Name, Phone) VALUES ('John Doe', NULL);
Select * from Employee;
]]>