MySQL创建数据库、表、插入数据、查询数据

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`;