当前位置:Gxlcms > 数据库问题 > mysql创建数据库、表、写数据

mysql创建数据库、表、写数据

时间:2021-07-01 10:21:17 帮助过:4人阅读

mysql> create database ceshi;
Query OK, 1 row affected (0.01 sec)

mysql> use ceshi;
Database changed

mysql> create table if not exists test ( id int(10) PRIMARY KEY AUTO_INCREMENT, name varchar(50) NOT NULL);
Query OK, 0 rows affected (0.04 sec)

mysql> insert into test values(1,‘dahuju‘);
Query OK, 1 row affected (0.00 sec)

mysql> insert into test values(2,‘yunjisuan‘);
Query OK, 1 row affected (0.00 sec)

mysql> select * from test;
+----+-----------+
| id | name |
+----+-----------+
| 1 | yunjisuan |
| 2 | dashuju |
+----+-----------+
2 rows in set (0.00 sec)

mysql创建数据库、表、写数据

标签:prim   ima   ash   table   incr   das   not   auto   ble   

人气教程排行