Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

mysql »ù±¾²Ù×÷º¯Êý

Ò» . °²×°ÓëÅäÖÃMYSQL
¶þ . ³£ÓÃmysqlÃüÁîÐÐÃüÁî
1 .mysqlµÄÆô¶¯ÓëÍ£Ö¹
Æô¶¯MYSQL·þÎñ net start mysql
Í£Ö¹MYSQL·þÎñ net stop mysql
2 . netstat –na | findstr 3306 ²é¿´±»¼àÌýµÄ¶Ë¿Ú , findstrÓÃÓÚ²éÕÒºóÃæµÄ¶Ë¿ÚÊÇ·ñ´æÔÚ
3 . ÔÚÃüÁîÐÐÖеǽMYSQL¿ØÖÆÌ¨ , ¼´Ê¹Óà MYSQL COMMEND LINE TOOL
     Óï·¨¸ñʽ mysql –user=root –password=123456 db_name
       »ò mysql –uroot –p123456 db_name
4 . ½øÈëMYSQLÃüÁîÐй¤¾ßºó , ʹÓÃstatus; »ò\s ²é¿´ÔËÐл·¾³ÐÅÏ¢
5 . Çл»Á¬½ÓÊý¾Ý¿âµÄÓï·¨ : use new_dbname;

6 . ÏÔʾËùÓÐÊý¾Ý¿â : show databases;
7 . ÏÔʾÊý¾Ý¿âÖеÄËùÓбí : show tables;
8 . ÏÔʾij¸ö±í´´½¨Ê±µÄÈ«²¿ÐÅÏ¢ : show create table table_name;
9 . ²é¿´±íµÄ¾ßÌåÊôÐÔÐÅÏ¢¼°±íÖи÷×ֶεÄÃèÊö
   Describe table_name; ËõдÐÎʽ : desc table_name;
Èý ¡£ MySqlÖеÄSQLÓï¾ä
1 . Êý¾Ý¿â´´½¨ : Create database db_name;
Êý¾Ý¿âɾ³ý : Drop database db_name; ɾ³ýʱ¿ÉÏÈÅжÏÊÇ·ñ´æÔÚ£¬Ð´³É : drop database if exits db_name

2 . ½¨±í : ´´½¨Êý¾Ý±íµÄÓï·¨ : create table table_name (×Ö¶Î1 Êý¾ÝÀàÐÍ , ×Ö¶Î2 Êý¾ÝÀàÐÍ);
   Àý : create table mytable (id int , username char(20));
   ɾ±í : drop table table_name; Àý : drop table mytable;
8 . Ìí¼ÓÊý¾Ý : Insert into ±íÃû [(×Ö¶Î1 , ×Ö¶Î2 , ….)] values (Öµ1 , Öµ2 , …..);
Èç¹ûÏò±íÖеÄÿ¸ö×ֶζ¼²åÈëÒ»¸öÖµ,ÄÇÃ´Ç°Ãæ [ ] À¨ºÅÄÚ×Ö¶ÎÃû¿ÉдҲ¿É²»Ð´
   Àý : insert into mytable (id,username) values (1,’zhangsan’);
9 . ²éѯ : ²éѯËùÓÐÊý¾Ý : select * from table_name;
²éѯָ¶¨×ֶεÄÊý¾Ý : select ×Ö¶Î1 , ×Ö¶Î2 from table_name;
Àý : select id,username from mytable where id=1 order by desc;¶à±í²éѯÓï¾ä------------²ÎÕÕµÚ17ÌõʵÀý
10 . ¸üÐÂÖ¸¶¨Êý¾Ý , ¸üÐÂijһ¸ö×ֶεÄÊý¾Ý£¨×¢Ò⣬²»ÊǸüÐÂ×ֶεÄÃû×Ö£©
Update table_name set ×Ö¶ÎÃû=’ÐÂÖµ’ [, ×Ö¶Î2 =’ÐÂÖµ’ , …..][where id=id_num] [order by ×ֶΠ˳Ðò]
Àý : update mytable set username=’lisi’ where id=1;
OrderÓï¾ä


Ïà¹ØÎĵµ£º

mysql ¸´ÖƼǼ

¸´ÖƼǼ,²ÉÓÃ×Ô²éѯ·½Ê½
sql
INSERT INTO `table` ('id','aa','bb','cc') SELECT 'id','aa','bb','cc' from `table` (WHERE .....) 
Tips:
/**
* ¸´ÖÆÐ¼Í¼µÄʱºò,¿ÉÄÜÒª¸üÐÂid»òÕßÊDz¿·ÖÊý¾Ý(¼ÙÉèid×ÔÔö¼ÓµÄÇé¿ö)
*
* text_aa Ϊ¹Ì¶¨Öµ ,¿ÉÔڽű¾µ÷ÓÃÖи³±äÁ¿Öµ Èç($aa)
* ×¢Òâ'text_aa' Óë `cc` µÄÇø±ð ......

mysql µ¼Êý¾Ý¿âÃüÁî

mysql µ¼Êý¾Ý¿âÃüÁî
mysqlÃüÁîµ¼Êý¾Ý¿â½Å±¾¡£
mysql>create database databaseName
mysql>use yourDatabase
mysql>source d:yourSql.sql
=========================
1.mysql -u root -p Javascript:tagshow(event, '%CA%FD%BE%DD%BF%E2');" href="http://www.xland.com.cn/article/74/76/0704/Javascript:;" ......

mysql Ö÷´ÓÐĵÃ


grant replication slave on *.* to 'guest'@'192.168.1.%' identified by '123456'
change master to master_host='192.168.1.190',master_user='guest',master_password='123456',master_port=3306
mysql> change master to master_host='192.168.1.190',master_user='guest',master_password='123456',master_log ......

MySQLÎå¸ö²éѯÓÅ»¯·½·¨


MySQLÎå¸ö²éѯÓÅ»¯·½·¨

ÊìϤSQLµÄÈ˶¼ÖªµÀ£¬Íê³Éͬһ¸öÈÎÎñ£¬SQL¿ÉÄÜÓжàÖÖд·¨£¬µ«²»Í¬Ð´·¨µÄ²éѯ
ÐÔÄÜ¿ÉÄÜ»áÓÐÌìÈÀÖ®±ð£¬±¾ÎÄÁоٳöÎå¸ö²éѯÓÅ»¯µÄ·½·¨
£¬µ±È»£¬ÓÅ»¯µÄ·½·¨»¹Óкܶࡣ¡¡¡¡
1¡¢ÓÅ»¯Êý¾ÝÀàÐÍ
MySQL
ÖÐÊý¾ÝÀàÐÍÓжàÖÖ£¬Èç¹ûÄãÊÇÒ»ÃûDBA£¬ÕýÔÚ°´ÕÕÓÅ»¯µÄÔ­Ôò¶ÔÊý¾ÝÀàÐͽøÐÐÑϸñµÄ¼ì²é£¬µ«¿ª·¢
ÈËÔ ......

mysqlº¯Êý


ÓÃÔÚSELECTºÍWHERE×Ó¾äµÄº¯Êý
--------------------------------------------------------------
1 ·Ö×麯Êý
( ... ) À¨ºÅ¡£Ê¹ÓÃËüÃÇÀ´Ç¿ÖÆÔÚÒ»¸ö±í´ïʽµÄ¼ÆËã˳Ðò¡£
--------------------------------------------------------------
2 ³£ÓõÄËãÊõÔËËã
£¨+ - * /£©
Ò»°ãµÄË ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ