在mac终端,进入mysql,创建数据库,和表
mysql> CREATE TABLE users(id INT(11) AUTO_INCREMENT PRIMARY KEY,name VARCHAR(100),email VARCHAR(100),username VARCHAR(30),password VARCHAR(100),register_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP);
mysql> show tables;
+----------------------+
| Tables_in_myflaskapp |
+----------------------+
| users |
+----------------------+
1 row in set (0.00 sec)
mysql> describe users;
+---------------+--------------+------+-----+-------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------+--------------+------+-----+-------------------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| name | varchar(100) | YES | | NULL | |
| email | varchar(100) | YES | | NULL | |
| username | varchar(30) | YES | | NULL | |
| password | varchar(100) | YES | | NULL | |
| register_date | timestamp | NO | | CURRENT_TIMESTAMP | |
+---------------+--------------+------+-----+-------------------+----------------+
6 rows in set (0.01 sec)