linux下mysql数据库编程练习_MySQL

mysql> use company;
Database changed
mysql> create table worker (nid INT UNIQUE,name VARCHAR(20), address VARCHAR(200), salary float, level int);
Query OK, 0 rows affected (0.18 sec)


mysql> insert worker values (100, 'tom','beijing',2000.0,0);
Query OK, 1 row affected (0.14 sec)


mysql> insert worker values (101, 'jim','shanghai',2000.0,1);
Query OK, 1 row affected (0.01 sec)


mysql> insert worker values (102, 'mali','shanghai',3000.0,2);
Query OK, 1 row affected (0.00 sec)


mysql> select * from worker;
+------+------+----------+--------+-------+
| nid | name | address | salary | level |
+------+------+----------+--------+-------+
| 100 | tom | beijing | 2000 | 0 |
| 101 | jim | shanghai | 2000 | 1 |
| 102 | mali | shanghai | 3000 | 2 |
+------+------+----------+--------+-------+
3 rows in set (0.00 sec)


mysql> delete from woker where nid = 100;
ERROR 1146 (42S02): Table 'company.woker' doesn't exist
mysql> delete from worker where nid = 100;
Query OK, 1 row affected (0.07 sec)


mysql> select * from worker;
+------+------+----------+--------+-------+
| nid | name | address | salary | level |
+------+------+----------+--------+-------+
| 101 | jim | shanghai | 2000 | 1 |
| 102 | mali | shanghai | 3000 | 2 |
+------+------+----------+--------+-------+
2 rows in set (0.00 sec)


mysql> update worker set level = 2, salary=3000.0 where nid=101;
Query OK, 1 row affected (0.12 sec)
Rows matched: 1 Changed: 1 Warnings: 0


mysql> select * from worker;
+------+------+----------+--------+-------+
| nid | name | address | salary | level |
+------+------+----------+--------+-------+
| 101 | jim | shanghai | 3000 | 2 |
| 102 | mali | shanghai | 3000 | 2 |
+------+------+----------+--------+-------+
2 rows in set (0.00 sec)