ºìÁªLinuxÃÅ»§
Linux°ïÖú

MySQLÏ´´½¨Êý¾Ý¿âµÈ²Ù×÷

·¢²¼Ê±¼ä:2008-07-19 00:03:55À´Ô´:ºìÁª×÷Õß:isosdw
1¡¢Èç¹ûÏë´Ódos´°¿Ú½øÈëµÄ»°ÄÇôÐèÒªÄúÅäÖû·¾³±äÁ¿£¬ÔÚϵͳ»·¾³±äÁ¿ÀïÃæÇëÅäÖÃC:\Program Files\MySQL\MySQL Server 5.0\bin

2¡¢µ±È»ÄúÈç¹ûÓпÉÊÓ»¯¹¤¾ßµÄ»°ÄÇôÄú¾ÍûÓбØÒªÄÇôÂé·³£»Ö±½Ó½øÈë¿ÉÊÓ»¯¹¤¾ßÔËÓü´¿É

3¡¢µ±È»°²×°ºó¿ÉÒÔ´Ó°²×°³ÌÐòÀïÃæÖ±½Ó½øÈëdos¿ØÖÆ´°¿Ú

½øÈëMySQL²Ù×÷½çÃæ²¢½øÈë
mysql>create database db_lirbary; //±ØÓзֺŠ´´½¨Êý¾Ý¿â
mysql>use db_lirbary //×¢Òâ´ËÃüÁîÏÂûÓзֺŠuseºÍquitÃüÁî¿É²»Ó÷ֺÅ
´ËʱÏÔʾ Database changed
mysql>create table tb_manager(id int unsigned primary key auto_increment,name varchar(30),pwd varchar(30)); //´´½¨±í¸ñ
show tables; //ÏÔʾ±í¸ñ
drop table tb_manager; //ɾ³ý±í¸ñ
drop database db_library; //ɾ³ýÊý¾Ý¿â
show databases; //ÏÔʾËùÓÐÊý¾Ý¿â
select*form db; //ÏÔʾ±í£¨db£©µÄÄÚÈÝ

¶àÐÐÊäÈë³ö´íÓÖÎÞ·¨¸Ä£¬Ö»ÐèÒªÔÚ·ÖºÅ֮ǰ¾Í¿ÉÒÔÓÃcÀ´È¡ÏûÃüÁî

mysql>select
->user()
->c

ÓÃÎı¾·½Ê½½«Êý¾Ý×°ÈëÒ»¸öÊý¾Ý¿â±í

load data local infile "d:\\manager.txt" into table tb_manager;
ÎÄÕÂÆÀÂÛ

¹²ÓÐ 0 ÌõÆÀÂÛ