CREATE DATABASE mgcherry_od;
DROP TABLE IF EXISTS 'od_user');
USE mgcherry_od;
CREATE TABLE IF NOT EXISTS `od_user`(
`od_id` INT UNSIGNED AUTO_INCREMENT,
`od_username` VARCHAR(100) NOT NULL,
`od_password` VARCHAR(40) NOT NULL,
`od_phone` VARCHAR(22) NOT NULL,
PRIMARY KEY ( `od_id` )
)ENGINE=InnoDB DEFAULT CHARSET=utf8;
# 向·od_user表插入初始数据·
INSERT INTO `od_user`(od_id,od_username,od_password,od_phone)VALUES('1',"mg1234","123456","1845260951");
INSERT INTO `od_user`(od_id,od_username,od_password,od_phone)VALUES('2',"mg2580","123456","1845260952");
SELECT * FROM `od_user`;