MySql¼òÒױʼÇ
MySql¼òÒױʼÇ
1£º°²×°http://download.mysql.cn/src/2006/0710/5543.html£»
2£º´ò¿ªmysqlµÄCMD
3£º´´½¨Ò»¸öÊý¾Ý¿â¼°±í£º
mysql> CREATE DATABASE bbs;
mysql> CREATE TABLE pet (name VARCHAR(20), owner VARCHAR(20),
-> species VARCHAR(20), sex CHAR(1), birth DATE, death DATE);
4£º²é¿´£º
show databases;
show tabales;
describe pet;
5:µ¼³ö³É*.sqlÎļþ
ÔÚϵͳcmdÏÂʹÓÃÃüÁmysqljump -u root –p test > c:\test.sql
»ù±¾¹¦ÄܾʹËOK£¡
Ïà¹ØÎĵµ£º
Mysql
sudo netstat -tap | grep mysql
µ±ÄúÔËÐиÃÃüÁîʱ£¬Äú¿ÉÒÔ¿´µ½ÀàËÆÏÂÃæµÄÐУº
linuxidc@linuxidc-laptop:~$">linuxidc@linuxidc-laptop:~$ sudo netstat -tap | grep mysql
[sudo] password for linuxidc:
tcp &n ......
²éѯ¼°É¾³ýÖØ¸´¼Ç¼µÄ·½·¨
(Ò»)
1¡¢²éÕÒ±íÖжàÓàµÄÖØ¸´¼Ç¼£¬Öظ´¼Ç¼ÊǸù¾Ýµ¥¸ö×ֶΣ¨peopleId£©À´ÅжÏ
select * from people
where peopleId in (select peopleId from people group by peopleId having count(peopleId) > 1)
2¡¢É¾³ý±íÖжàÓàµÄÖØ¸´¼Ç¼£ ......
Ò»¡¢Á¬½ÓMYSQL
¸ñʽ£º mysql -hÖ÷»úµØÖ· -uÓû§Ãû £pÓû§ÃÜÂë
1¡¢Àý1£ºÁ¬½Óµ½±¾»úÉϵÄMYSQL¡£
Ê×ÏÈÔÚ´ò¿ªDOS´°¿Ú£¬È»ºó½øÈëĿ¼ mysqlbin£¬ÔÙ¼üÈëÃüÁîmysql -uroot -p£¬»Ø³µºóÌáʾÄãÊäÃÜÂ룬Èç¹û¸Õ°²×°ºÃMYSQL£¬³¬¼¶Óû§rootÊÇûÓÐÃÜÂëµÄ£¬¹ÊÖ±½Ó»Ø³µ¼´¿É½øÈëµ½MYSQLÖÐÁË£¬MYSQLµÄÌáʾ·ûÊÇ£ºmysql>
2¡¢Àý2£ºÁ¬½Óµ½Ô ......
»ù±¾²éѯ
SELECTÓï¾äÓÃÓÚ²éѯÊý¾Ý¿âºÍSQLÖеÄËùÓÐÊä³ö²Ù×÷¡£
SELECTc_u_name, emailfromcooya_users;
Êä³öcooya_users±íÖÐËùÓÐÐУ¨»ò¼Ç¼£©µÄÊôÐÔc_u_nameºÍemailµÄÖµ¡£
Èç¹ûÐèÒªËùÓÐÊôÐÔ£¬¿ÉÒÔʹÓÃÐǺţ¨*£©µÄ¿ì½Ý·½Ê½¡£
SELECT* from cooya_users;
SELECTÓï¾ä»¹¿ÉÒÔÊä³ö²»ÊÇÊý¾Ý¿âÖеÄÊý¾Ý¼°¿ÉÒÔÓÃ×÷¼òµ¥µÄ¼ÆËã·û ......