mysql记录1.docVIP

mysql记录1 #连接与断开服务器?C:\Documents?and?Settings\Administratormysql?-u?root?-p?Enter?password:?****??mysql?quit?Bye??#---------------------------?mysql?-u?root?-p?Enter?password:?****??#----------------------------------------------?#输入查询?#mysql的版本号和当前日期?SELECT?VERSION(),?CURRENT_DATE;??#将mysql用作一个简单的计算器?SELECT?SIN(PI()/4),?(4+1)*5;??#一行上输入多条语句?SELECT?VERSION();?SELECT?NOW();??#多行语句的例子?SELECT?USER()?,?CURRENT_DATE;??#输入\c取消已输入的不想执行的命令?SELECT?USER()?\c??#-------------------------------------------?#创建并使用数据库?#显示数据库?SHOW?DATABASES;??#使用数据库?USE?test??#创建并选择数据库?CREATE?DATABASE?menagerie;?USE?menagerie;??#设置每次启动mysql会话使用menagerie数据库?mysql?-u?root?-p?menagerie??#创建表?SHOW?TABLES;?CREATE?TABLE?pet?(name?VARCHAR(20),?owner?VARCHAR(20),?species?VARCHAR(20),?sex?CHAR(1),?birth?DATE,?death?DATE);?SHOW?TABLES;?DESCRIBE?pet;???#将数据装入表中?LOAD?DATA?LOCAL?INFILE?/path/pet.txt?INTO?TABLE?pet;?LOAD?DATA?LOCAL?INFILE?/path/pet.txt?INTO?TABLE?pet?LINES?TERMINATED?BY?\r\n;??#pet.txt?Fluffy????Harold????cat????f????1993-02-04?Claws????Gwen????cat????m????1994-03-17?Buffy????Harold????dog????f????1989-05-13?Fang????Benny????dog????m????1990-08-27?Bowser????Diane????dog????m????1979-08-31????1995-07-29?Chirpy????Gwen????bird????f????1998-09-11?Whistler????Gwen????bird????f????1997-12-09?Slim????Benny????snake????m????1996-04-29??INSERT?INTO?pet?VALUES?(Puffball,Diane,hamster,f,1999-03-30,NULL);?INSERT?INTO?pet?VALUES?(Bowser,Diane,dog,m,1979-08-31,1995-07-29);?INSERT?INTO?pet?VALUES?(Chirpy,Gwen,bird,f,1998-09-11,NULL);???#从表检索信息?select?*?from?pet;?UPDATE?pet?SET?birth?=?1989-08-30?WHERE?name?=?Bowser;??#选择特殊行?SELECT?*?FROM?pet?WHERE?name?=?Bowser;?SELECT?*?FROM?pet?WHERE?birth??1998-1-1;?SELECT?*?FROM?pet?WHERE?species?=?dog?AND?sex?=?f;??#选择特殊列?SELECT?name,?birth?FROM?pet;?SELECT?owner?FROM?pet;?SELECT?DISTINCT?owner?FROM?pet;??SELECT?name,?species,?birth?FROM?pet?WHERE?species?=?dog?OR?species?=?cat;??