Shulou(Shulou.com)06/01 Report--

Create a datasheet:

Mysql > use simonwang

Database changed

Mysql > show tables

Empty set (0.00 sec)

Mysql > create table T1 (`id` int (4), `name` char (40))

Query OK, 0 rows affected (0.01 sec)

Insert data:

Mysql > insert into studytable values (1)

Query OK, 1 row affected (0.00 sec)

Mysql > select * from studytable

+-+ +

| | id | name |

+-+ +

| | 1 | test |

+-+ +

1 row in set (0.00 sec)

Modify the data:

Mysql > update studytable set name='updatetest' where id='1'

Query OK, 1 row affected (0.00 sec)

Rows matched: 1 Changed: 1 Warnings: 0

Mysql > select * from studytable

+-+ +

| | id | name |

+-+ +

| | 1 | updatetest |

+-+ +

1 row in set (0.00 sec)

Empty the datasheet:

Mysql > truncate table studytable

Query OK, 0 rows affected (0.00 sec)

Mysql > select * from studytable

Empty set (0.00 sec)

Delete the datasheet:

Mysql > drop table studytable

Query OK, 0 rows affected (0.00 sec)

Delete the database:

Mysql > drop database simonwang

Query OK, 0 rows affected (0.01 sec)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.