mysql数据库创建表年龄怎么写_mysql创建数据库、表、写数据

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)

原文：https://www.cnblogs.com/effortsing/p/10011301.html