我的python学习--第六天
MariaDB [(none)]> create database reboot;Query OK, 1 row affected (0.00 sec)
MariaDB [(none)]> use reboot;
Database changed
MariaDB > create table users(
-> id int AUTO_INCREMENT primary key
-> ,name varchar(20) not null
-> ,name_cn varchar(50) not null
-> ,password varchar(50) not null
-> ,email varchar(50)
-> ,mobile varchar(11)
-> ,role varchar(10) not null
-> ,status varchar(10)
-> ,create_time timestamp default current_timestamp
-> ,last_time timestamp default current_timestamp
-> ,unique keyname (name) ) engine=innodb;
Query OK, 0 rows affected (0.01 sec)
MariaDB > show tables;
+------------------+
| Tables_in_reboot |
+------------------+
| users |
+------------------+
1 row in set (0.00 sec)
MariaDB > desc users;
+-------------+-------------+------+-----+-------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+-------------+------+-----+-------------------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| name | varchar(20) | NO | UNI | NULL | |
| name_cn | varchar(50) | NO | | NULL | |
| password | varchar(50) | NO | | NULL | |
| email | varchar(50) | YES| | NULL | |
| mobile | varchar(11) | YES| | NULL | |
| role | varchar(10) | NO | | NULL | |
| status | varchar(10) | YES| | NULL | |
| create_time | timestamp | NO | | CURRENT_TIMESTAMP | |
| last_time | timestamp | NO | | CURRENT_TIMESTAMP | |
+-------------+-------------+------+-----+-------------------+----------------+
10 rows in set (0.00 sec)
页:
[1]