MySQL学习笔记

MySQL学习笔记1

 -- 创建数据库create database mydate;show databases;-- 删除数据库drop database mydate;-- 打开数据库use mysqltest;-- 创建表create table if not exists user1(    id int(4),    user_name varchar(20),    sex smallint(1),    age int(2))engine=innodb charset=utf8;-- 查看表结构desc user1;-- 创建表create table studet(--  主键设置    id int (4)auto_increment primary key,    user_name varchar(10) not null,    pwd varchar(20) not null,    age int(4))engine=innodb charset=utf8;describe student;--添加数据INSERT INTO `mysqltest`.`studet` (`id`, `user_name`, `pwd`, `age`) VALUES ('1', '212', '1212121', '11');INSERT INTO `mysqltest`.`studet` (`id`, `user_name`, `pwd`, `age`) VALUES ('21', 'tqom', 'sf', '22');-- 查询整个表SELECT * FROM mysqltest.studet;