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)