mysql 基本操作语句

net start mysql

net stop mysql

mysql  -u root -p

show databases

create database lxk

show tables

 create table text(
    -> id int auto_increment primary key,
    -> reading int,
    -> writing int,
    -> waiting int);

insert into text values(2, 3,5, 6);

mysql> select * from text;
+----+---------+---------+---------+
| id | reading | writing | waiting |
+----+---------+---------+---------+
|  2 |       3 |       5 |       6 |
+----+---------+---------+---------+

insert into text(reading, waiting) values(8,9);

mysql> select * from text;
+----+---------+---------+---------+
| id | reading | writing | waiting |
+----+---------+---------+---------+
|  2 |       3 |       5 |       6 |
|  3 |       8 |    NULL |       9 |
+----+---------+---------+---------+