创建数据库及数据表
create database user;
CREATE TABLE IF NOT EXISTS `user_tbl`(
`user_id` INT UNSIGNED AUTO_INCREMENT,
`user_Name` VARCHAR(100) NOT NULL,
`user_Phone` VARCHAR(100) NOT NULL,
`create_date` DATE,
PRIMARY KEY ( `user_id` )
)ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO user_tbl ( user_id, user_Name,user_Phone,create_date ) VALUES ( 1, "ella","13172890999",now());
INSERT INTO user_tbl ( user_id, user_Name,user_Phone,create_date ) VALUES ( 2, "ella2","13172890991",now());
INSERT INTO user_tbl ( user_id, user_Name,user_Phone,create_date ) VALUES ( 3, "ella3","13172890992",now());
INSERT INTO user_tbl ( user_id, user_Name,user_Phone,create_date ) VALUES ( 4, "ella4","13172890993",now());