version() 版本号
PI()
SIN()
database();
user(); --察看当前的使用mysql数据库的用户是select user();
current_date;
curdate()
year();
month();
day();
right(); 取yyyy-mm-dd后面的5个字符
max();
min();
as : select col1 as newcolname ;
where子句可以做模式匹配 %, ^begin, end%, ^...$
mysql> SELECT p1.name, p1.sex, p2.name, p2.sex, p1.species
-> FROM pet AS p1, pet AS p2
-> WHERE p1.species = p2.species AND p1.sex = 'f' AND p2.sex = 'm';
PI()
SIN()
database();
user(); --察看当前的使用mysql数据库的用户是select user();
current_date;
curdate()
year();
month();
day();
right(); 取yyyy-mm-dd后面的5个字符
max();
min();
as : select col1 as newcolname ;
where子句可以做模式匹配 %, ^begin, end%, ^...$
mysql> SELECT p1.name, p1.sex, p2.name, p2.sex, p1.species
-> FROM pet AS p1, pet AS p2
-> WHERE p1.species = p2.species AND p1.sex = 'f' AND p2.sex = 'm';