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

mysql һЩ¼òµ¥²Ù×÷ Rubicon

Á˽âÁËһЩ×î»ù±¾µÄ²Ù×÷ÃüÁîºó£¬ÎÒÃÇÔÙÀ´Ñ§Ï°ÈçºÎ´´½¨Ò»¸öÊý¾Ý¿âºÍÊý¾Ý¿â±í¡£
¡¡¡¡1¡¢Ê¹ÓÃSHOWÓï¾äÕÒ³öÔÚ·þÎñÆ÷Éϵ±Ç°´æÔÚʲôÊý¾Ý¿â£º
mysql> SHOW DATABASES; +----------+
| Database | +----------+ | mysql |
| test | +----------+ 3 rows in set (0.00 sec)
¡¡¡¡2¡¢´´½¨Ò»¸öÊý¾Ý¿âabccs
¡¡¡¡mysql> CREATE DATABASE abccs;
¡¡¡¡×¢Òⲻͬ²Ù×÷ϵͳ¶Ô´óСдµÄÃô¸Ð¡£
¡¡¡¡3¡¢Ñ¡ÔñÄãËù´´½¨µÄÊý¾Ý¿â
¡¡¡¡mysql> USE abccs
¡¡¡¡Database changed
¡¡¡¡´ËʱÄãÒѾ­½øÈëÄã¸Õ²ÅËù½¨Á¢µÄÊý¾Ý¿âabccs.
¡¡¡¡4¡¢ ´´½¨Ò»¸öÊý¾Ý¿â±í
¡¡¡¡Ê×ÏÈ¿´ÏÖÔÚÄãµÄÊý¾Ý¿âÖдæÔÚʲô±í£º
¡¡¡¡mysql> SHOW TABLES;
¡¡¡¡Empty set (0.00 sec)
¡¡¡¡ËµÃ÷¸Õ²Å½¨Á¢µÄÊý¾Ý¿âÖл¹Ã»ÓÐÊý¾Ý¿â±í¡£ÏÂÃæÀ´´´½¨Ò»¸öÊý¾Ý¿â±ímytable:
¡¡¡¡ÎÒÃÇÒª½¨Á¢Ò»¸öÄ㹫˾Ա¹¤µÄÉúÈÕ±í£¬±íµÄÄÚÈݰüº¬Ô±¹¤ÐÕÃû¡¢ÐԱ𡢳öÉúÈÕÆÚ¡¢³öÉú³ÇÊС£
mysql> CREATE TABLE mytable (name VARCHAR(20), sex CHAR(1),
-> birth DATE, birthaddr VARCHAR(20));
Query OK, 0 rows affected (0.00 sec)
¡¡¡¡ÓÉÓÚname¡¢birthaddµÄÁÐÖµÊDZ仯µÄ£¬Òò´ËÑ¡ÔñVARCHAR£¬Æä³¤¶È²»Ò»¶¨ÊÇ20¡£¿ÉÒÔÑ¡Ôñ´Ó1µ½255µÄÈκγ¤¶È£¬Èç¹ûÒÔºóÐèÒª¸Ä±äËüµÄ×Ö³¤£¬¿ÉÒÔʹÓÃALTER TABLEÓï¾ä¡££©;ÐÔ±ðÖ»ÐèÒ»¸ö×Ö·û¾Í¿ÉÒÔ±íʾ£º"m"»ò"f"£¬Òò´ËÑ¡ÓÃCHAR(1);birthÁÐÔòʹÓÃDATEÊý¾ÝÀàÐÍ¡£
¡¡¡¡´´½¨ÁËÒ»¸ö±íºó£¬ÎÒÃÇ¿ÉÒÔ¿´¿´¸Õ²Å×öµÄ½á¹û£¬ÓÃSHOW TABLESÏÔʾÊý¾Ý¿âÖÐÓÐÄÄЩ±í£º
mysql> SHOW TABLES; +---------------------+
| Tables in menagerie | +---------------------+ | mytables
| +---------------------+
¡¡¡¡5¡¢ÏÔʾ±íµÄ½á¹¹£º
mysql> DESCRIBE mytable;
+-------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+-------------+------+-----+---------+-------+
| name | varchar(20) | YES | | NULL | | | sex | char(1)
| YES | | NULL | | | birth | date | YES | | NULL | |
| deathaddr | varchar(20) | YES | | NULL |
| +-------------+-------------+------+-----+---------+-------+
4 rows in set (0.00 sec)
¡¡¡¡6¡¢ Íù±íÖмÓÈë¼Ç¼
¡¡¡¡ÎÒÃÇÏÈÓÃSELECTÃüÁîÀ´²é¿´±íÖеÄÊý¾Ý£º
¡¡¡¡mysql> select * from mytable;
¡¡¡¡Empty set (0.00 sec)
¡¡¡


Ïà¹ØÎĵµ£º

2010.01.14 (mysql: data too long for column)

netbeans6.7ÖÐÏòmysql5ÖвåÈëÖÐÎÄÊý¾ÝʱÏÔʾ”data too long for column“µÄÎÊÌâ¡£
    ÎÒµÄmysqlÖÐ×Ö·ûµÄÉèÖÃʱutf-8£¬²¢ÇÒÔÚ¿ØÖÆÌ¨ÖпÉÒÔ²åÈëÖÐÎÄÊý¾Ý²¢ÏÔʾ£¬µ«ÔÚnetbeansÖвåÈëÊý¾Ýʱȴ×ÜÊÇÏÔʾ”data too long for column“¡£»ù±¾¿ÉÒÔÅжÏÊÇÓÉÓÚnetbeansºÍmysqlÖ®¼äµÄÊý¾Ý½»»»³öÁ ......

ʹÓÃÓαêʵÏÖ mysql ´æ´¢¹ý³ÌÖеÄÑ­»·

create   procedure   all_joiner_message(   in   captions   varchar(255),  in contents text,   in objectid int, in types int  ,  out count int)
begin
 declare   userids   int;
 DECLARE _done IN ......

MySQL´æ´¢ÒýÇæ Ó¦ÓÃ


MySQL·þÎñÆ÷²ÉÓÃÁËÄ£¿é»¯·ç¸ñ£¬¸÷²¿·ÖÖ®¼ä±£³ÖÏà¶Ô¶ÀÁ¢£¬ÓÈÆäÌåÏÖÔÚ´æ´¢¼Ü¹¹ÉÏ¡£´æ´¢ÒýÇæ¸ºÔð
¹ÜÀíÊý¾Ý´æ´¢£¬ÒÔ¼°MySQLµÄË÷Òý¹ÜÀí¡£Í¨¹ý¶¨ÒåµÄAPI£¬MySQL·þÎñÆ÷Äܹ»Óë´æ´¢ÒýÇæ½øÐÐͨÐÅ¡£Ä¿Ç°Ê¹ÓÃ×î¶àµÄÊÇMyISAMºÍInnoDB¡£
InnoDB±»OracleÊÕ¹ººó£¬MySQL×ÔÐпª·¢µÄд洢ÒýÇæFalcon½«ÔÚMySQL6.0°æ±¾Òý½ø¡£
MyISAMÒýÇæÊÇÒ ......

mysqlÖÐÎÄÂÒÂë½â¾ö

ÓÉÓÚÄÜÖ±½ÓÔÚMYSQLÊý¾Ý¿âÀïÌí¼ÓÖÐÎÄÊý¾Ý,²¢ÇÒÄÜÕý³£ÏÔʾ,˵Ã÷ÎÒµÄ±í¶¼Ê¹ÓÃÁËÕýÈ·µÄ×Ö·û±àÂë,¾­¹ý²é¿´ºó,È·ÈÏÁË,ÎÒÈ«²¿µÄ±íÒÔ¼°×ֶζ¼Ê¹ÓÃÁËUTF-8µÄ±àÂë,µ«ÊÇΪʲô³ÌÐòÌí¼ÓµÄÖÐÎÄÊý¾Ý¾Í²»ÐÐÄØ?
Æäʵ,Ô­ÒòÔÚÓÚMYSQL·þÎñÆ÷ʹÓõÄĬÈϱàÂë,ÒÔ¼°Êý¾Ý¿âµÄĬÈϱàÂë,ºÜ¶àÈËÒѾ­ºÜСÐĵÄÔÚ½¨Á¢±íʱ¹Ø×¢±íµÄ×Ö·û±àÂë,È´ºöÂÔÁËÊý¾Ý¿â ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ