mysql 初学总结

mysql -h localhost -u root -p //启用mysql

lmy1234;

 

show databases; //查看已存在的数据库

use (databses); //使用某个数据库

 

create table pet( //创建一个数据表

name   varchar(20),

owner   varchar(20),

species   varchar(20),

sex    char(1),

birth    date,

death    date

);

 

show  tables; //查看数据表

describle pet; //查看数据表结构

 

INSERT INTO pet VALUES('Fluffy','Harold','cat','f','1999-03-30','2009-10-09'); //插入数据

INSERT INTO pet VALUES('Hally','Jim','dog','m','2001-03-30','2011-11-11');

INSERT INTO pet VALUES('Woddy','Jack','bird','f','2003-03-30',null);

 

 

select * from pet where name = 'Fluffy'; //按条件查找

 

select * from pet where name = 'Woddy' and sex = 'm'; //多条件和查找

 

select * from pet where name = 'Woddy' or sex = 'm'; //多条件或查找

 

select name,birth from pet where birth >='2000-1-1'; //特定的条件查找

 

select name,birth,species from pet where sex = 'm' order by birth; //按此顺序查找

 

select name,(TO_DAYS(NOW())-TO_DAYS(BIRTH))/365 as age from pet; //按年龄查找

 

select count(*) from pet ; //查询记录数

 

select count(*) from pet where sex = 'm'; //按性别查询记录数

 

 

在学习中遇到mysql 版本不匹配的问题，mysql_front不能打开.sql的文件/