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

Mysql ѧϰ±Ê¼Ç

 ÏÔʾËùÓÐÊý¾Ý¿â show databases;
 ´´½¨Êý¾Ý¿â create dababase stu;
 É¾³ýÊý¾Ý¿âdrop database stu;
 Çл»µ½Êý¾Ý¿âuse stu;
 È¡µÃµ±Ç°µÄÊý¾Ý¿â,´ø£¨£©±íʾº¯Êý:select database();
´´½¨±í£¨ÒªÇл»µ½Êý¾Ý¿âÖУ©
mysql> create table stu_info(
   
-> stu_id int(8),
   
-> stu_name varchar(48),
   
-> stu_sex char(2),
   
-> stu_age int(8));
²é¿´±íµÄ½á¹¹
mysql> desc stu_info;
+----------+-------------+------+-----+---------+-------+
| Field    |
Type       
| Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+-------+
| stu_id   |
int(8)     
| YES 
|    
| NULL   
|      
|
| stu_name | varchar(48) | YES 
|    
| NULL   
|      
|
| stu_sex  |
char(2)    
| YES 
|    
| NULL   
|      
|
| stu_age  |
int(8)     
| YES 
|    
| NULL   
|      
|
+----------+-------------+------+-----+---------+-------+
4 rows in set (0.00 sec)
ɾ³ý±í
drop table stu_info;
²é¿´Êý¾Ý¿âÖÐËùÓеıíshow tables;
Ö÷¼ü primary key
Ôö¼Ó×Ö¶Î alert table stu_info add column stu_card varchar(20);
 É¾³ý×Ö¶Îalter table stu_info drop column stu_card
;
ÐÞ¸Ä×Ö¶Î alter table stu_info modify column stu_id int(20);
delete from stu_info where []
insert into stu_info() values ()
select * from stu_info where []
mysql ·ÖÒµ¼¼Êõ  Ñ¡Ôñ´ÓµÚ1Ìõ¿ªÊ¼µÄ3ÌõÊý¾Ý
select * from stu_info limit 0,3 ;
Ñ¡Ôñ´ÓµÚ1Ìõ¿ªÊ¼µÄ3ÌõÊý¾Ý
select * from stu_info limit 5,3 ;
Ö±½Ó´ÓÎļþÖжÁÈ¡sqlÓï¾äÈ»ºóÔÚmysqlÖÐÖ´ÐÐ
 \. d:\\che\\mysql1\\


Ïà¹ØÎĵµ£º

MySQL Ñϸñģʽ sql_mode

ËäȻ˵ÎÒÃǾ¡Á¿ÔÚд³ÌÐòµÄʱºò¿ØÖƲåÈëµ½Êý¾Ý¿âµÄÊý¾Ý£¬¶ø²»ÒªÓÃÊý¾Ý¿âÈ¥ÅжÏÊý¾ÝµÄ¶Ô´í£¬µ«ÊÇÓÐʱºòΪÁË·½±ã»¹ÊÇÐèÒªÊý¾Ý¿â×ÔÉíµÄÈÝ´íÄÜÁ¦À´°ïÖúÎÒÃǴﵽĿµÄµÄ¡£¾ÙÀý˵Ã÷£º
´´½¨ÈçÏÂÊý¾Ý±í
CREATE TABLE `book` (
  `id` int(11) default NULL,
  `num` int(11) unsigned default NULL
) ENGINE=InnoDB DE ......

MYSQLÊý¾Ý¿âÉè¼Æ×¢ÒâÊÂÏî Êý¾Ý¿âÓÅ»¯

ÏÖÔÚ´ó¸ÅÁгöÈçÏÂ:
1.Êý¾Ý¿âµÄÉè¼Æ
¾¡Á¿°ÑÊý¾Ý¿âÉè¼ÆµÄ¸üСµÄÕ¼´ÅÅ̿ռä.
1).¾¡¿ÉÄÜʹÓøüСµÄÕûÊýÀàÐÍ.(mediumint¾Í±Èint¸üºÏÊÊ).
2).¾¡¿ÉÄ͍ܵÒå×Ö¶ÎΪnot null,³ý·ÇÕâ¸ö×Ö¶ÎÐèÒªnull.
3).Èç¹ûûÓÐÓõ½±ä³¤×ֶεϰ±ÈÈçvarchar,ÄǾͲÉÓù̶¨´óСµÄ¼Í¼¸ñʽ±ÈÈçchar.
4).±íµÄÖ÷Ë÷ÒýÓ¦¸Ã¾¡¿ÉÄܵĶÌ.ÕâÑùµÄ»°Ã¿Ìõ¼Í¼ ......

mysqlÄÚ´æ±íheapʹÓÃ×ܽá


ÄÚ´æ±íʹÓùþϣɢÁÐË÷Òý°ÑÊý¾Ý±£´æÔÚÄÚ´æÖУ¬Òò´Ë¾ßÓм«¿ìµÄËÙ¶È£¬Êʺϻº´æÖÐСÐÍÊý¾Ý¿â£¬µ«ÊÇʹÓÃÉÏÊܵ½Ò»Ð©ÏÞÖÆ£¬ÒÔÏÂÊÇÀ¶²ÝʹÓõÄһЩ¸ÐÊÜ¡£
1¡¢heap¶ÔËùÓÐÓû§µÄÁ¬½ÓÊǿɼûµÄ£¬ÕâʹµÃËü·Ç³£ÊʺÏ×ö»º´æ¡£
2¡¢½öÊʺÏʹÓõij¡ºÏ¡£heap²»ÔÊÐíʹÓÃxxxTEXTºÍxxxBLOBÊý¾ÝÀàÐÍ£»Ö»ÔÊÐíʹÓÃ=ºÍ<=>²Ù×÷·ûÀ´ËÑË÷¼Ç¼£¨²» ......

ÓÅ»¯MYSQLÊý¾Ý¿âµÄ·½·¨

1¡¢Ñ¡È¡×îÊÊÓõÄ×Ö¶ÎÊôÐÔ
¡¡¡¡MySQL¿ÉÒԺܺõÄÖ§³Ö´óÊý¾ÝÁ¿µÄ´æÈ¡£¬µ«ÊÇÒ»°ã˵À´£¬Êý¾Ý¿âÖеıíԽС£¬ÔÚËüÉÏÃæÖ´ÐеIJéѯҲ¾Í»áÔ½¿ì¡£Òò´Ë£¬ÔÚ´´½¨±íµÄʱºò£¬ÎªÁË»ñµÃ¸üºÃµÄÐÔÄÜ£¬ÎÒÃÇ¿ÉÒÔ½«±íÖÐ×ֶεĿí¶ÈÉèµÃ¾¡¿ÉÄÜС¡£ÀýÈ磬ÔÚ¶¨ÒåÓÊÕþ±àÂëÕâ¸ö×Ö¶Îʱ£¬Èç¹û½«ÆäÉèÖÃΪCHAR(255),ÏÔÈ»¸øÊý¾Ý¿âÔö¼ÓÁ˲»±ØÒªµÄ¿Õ¼ä£¬ÉõÖÁʹ ......

[ÔÓ¼Ç] ÐÂÄêÎïÓï&¹ØÓÚMysqlÒýÇæÐÔÄܲâÊÔ

æµµÄ2009ÖÕÓÚ¹ýÈ¥£¬Ò²ÖÕÓÚ°ÑÈËÉú´óÊÂæÍêÁË£¬»Øµ½Õý³£µÄ¹¤×÷Éú»îÖÐÀ´¡£2010¶ÔÎÒÀ´ËµÓ¦¸ÃÊdzäÂúÐÂÆÚÍûµÄÒ»Ä꣬ÐÂµÄÆõ»ú¾ÍÔÚÑÛǰ£¬¼ÓÓÍŬÁ¦°É~
ÁíÍâ×¼±¸12¸öÔÂÖ®ºóÔÙÀ´×ܽáһϽñÄêµÄÖØ´óʼǣ¬ºÇºÇ~
˳±ã¿´µ½Ò»¸öMysqlµÄ²âÊÔÎÄÕ£¬¸Ð¾õ»¹ÂúÓвο¼¼ÛÖµµÄ£¬ÓÚÊǼǼÏÂÀ´ÒÔ±ã²Î¿¼¡£
ÒÔÏÂÊÇÒ»¸öMySQLÖÐMyISAMÒýÇæÓëInnoDBÒ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ