MySQL³£ÓõÄÃüÁî
MYSQLÖг£ÓõÄÃüÁî´óÈ«
Ò»¡¢ Êý¾Ý¿â²Ù×÷µÄÃüÁî
1. ´´½¨Êý¾Ý¿â
Ø create database Name;
2. Ñ¡ÔñÊý¾Ý¿â
Ø use DatabaseName;
3. Ö±½Óɾ³ýÊý¾Ý¿â£¬²»ÌáÐÑ
Ø drop database Name;
4. ɾ³ýÊý¾Ý¿âÇ°£¬ÓÐÌáʾ¡£
Ø drop database Name;
5. ÏÔʾËùÓÐÊý¾Ý¿â
Ø show databases;
6. Ë¢ÐÂÊý¾Ý¿â
Ø flush privileges ;
7. ±¸·ÝÊý¾Ý¿â
Ø mysqldump -h host -u root -p dbname >dbname_backup.sql;
8. »Ö¸´Êý¾Ý¿â
Ø mysqladmin -h myhost -u root -p create dbname;
Ø mysqldump -h host -u root -p dbname < dbname_backup.sql;
¶þ¡¢ ±í²Ù×÷µÄÃüÁî
1. ´´½¨±í
Ø create table Name;
2. ÏÔʾ±í
Ø show tables;
3. ÏÔʾ±í½á¹¹
Ø describe TableName;
4. Çå¿Õ±í
Ø delete from TableName;
5. ɾ³ý±í
Ø drop table TableName;
Èý¡¢ Ð޸ıí½á¹¹µÄÃüÁî
1. ÖØÃüÃû±í
Ø alter table t1 rename t2;
2. ±ípositionÔö¼ÓÁÐtest
Ø alter table position add(test char(10));
3. ±ípositionÐÞ¸ÄÁÐtest
Ø alter table position modify test char(20) not null;
4. ±ípositionÐÞ¸ÄÁÐtestĬÈÏÖµ
Ø alter table position alter test set default 'system';
5. ±ípositionÈ¥µôtestĬÈÏÖµ
Ø alter table position alter test drop default;
6. ±ípositionÈ¥µôÁÐtest
Ø alter table position drop column test;
7. ±ídepart_posɾ³ýÖ÷¼ü
Ø alter table depart_pos drop primary key;
8. ±ídepart_posÔö¼ÓÖ÷¼ü
Ø alter table depart_pos add primary key PK_depart_pos (department_id,position_id);
ËÄ¡¢ ÏÔʾÃüÁî
1. ÏÔʾµ±Ç°mysql°æ±¾ºÍµ±Ç°ÈÕÆÚ
Ø select version(),current_date;
Ïà¹ØÎĵµ£º
Author: Ivan@mysqlab.net/Ì·¿¡Çà תÔØÇë×¢Ã÷À´Ô´URIÁ´½Ó:
http://www.mysqlab.net/blog/2009/04/mysql-54µÄÐÂÌØÐÔ½âÎö/
MySQL 5.4 Ö®ËùÒÔÃüÃûΪ5.4£¬¶ø²»ÊÇ5.2 ÊÇÒòΪ֮ǰµÄ5.2°æ±¾±»ÃüÃûΪ6.0ÁË£¨Õâ¸öÓ¦¸ÃÊÇÉÌÒµÉϵÄÔÒò£¬¾ÍÏñjava1.6±»ÃüÃûΪ6.0£©¡£ÏÖÔÚµÄ5.4 preview release ÊÇÔÚµ±Ç°MySQL5.1µÄ»ù´¡ÉÏ£¬¶Ô Innodb ½ø ......
³£³£Óöµ½´óÊý¾ÝÁ¿Æµ·±¶ÁдÊƱػᵼÖ·þÎñÆ÷µÄÐÔÄÜϽµ¡£ÏÂÃæ¼Ç¼һ϶ÔmysqlµÄÓÅ»¯ÅäÖÃ
1.Ê×ÏȹرÕauto commit¡£
2.¶ÔÓÚÊý¾Ý±íʹÓÃInnoDB¡£
3.¹Ø±ÕÍâ¼üÔ¼Êø¡£
4.²ÉÓöàÖµ²åÈë“INSERT INTO ±íÃû VALUES (1,2), (5,5), ...;” Èç¹ûÓдóÁ¿²¢·¢¿ÉÒÔÓøü¸ÄINSERT INTOΪ INSERT DELAYED INTO¿ÉÒÔÔڳ̶ÈÉϽ⾠......
1¡¢mysql Êý¾Ý¿âûÓÐÔöÁ¿±¸·ÝµÄ»úÖÆ£¬µ±Êý¾ÝÁ¿Ì«´óµÄʱºò±¸·ÝÊÇÒ»¸öºÜ´óµÄÎÊÌâ¡£»¹ºÃ mysql Êý¾Ý¿âÌṩÁËÒ»ÖÖÖ÷´Ó±¸·ÝµÄ»úÖÆ£¬Æäʵ¾ÍÊÇ°ÑÖ÷Êý¾Ý¿âµÄËùÓеÄÊý¾Ýͬʱдµ½±¸·ÝÊý¾Ý¿âÖС£ÊµÏÖ mysql Êý¾Ý¿âµÄÈȱ¸·Ý¡£
¡¡¡¡2¡¢ÒªÏëʵÏÖË«»úµÄÈȱ¸Ê×ÏÈÒªÁ˽âÖ÷´ÓÊý¾Ý¿â·þÎñÆ÷µÄ°æ±¾µÄÐèÇó¡£ÒªÊµÏ ......
1.Ê×ÏȵöÔmysql ÀïÃæµÄ²ÎÊý½øÐнéÉÜÏÂ:
procedure--in:ÊäÈë²ÎÊý,outÊä³ö²ÎÊý,inoutÕâ¸ö¾Í²»ÓÃ˵ÁË,´ó¸ÅÒ²²Âµ½ÁË
declare:ÉùÃ÷±äÁ¿.¼ÇÖ÷, ......