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

MySQL schemaÃüÃû¹æÔò

/*****************by
garcon1986************************************************************/
ͨÓùæÔò£º
Õû
¸öÊý¾Ý¿âÀïµÄÃû×Ö¶¼¾¡Á¿Ê¹ÓÃСд¡£ÕâÑùÄÜÏû³ýÓÉÓÚ´óСд£¨
case-sensitivity
£©´øÀ´
µÄ´íÎó¡£
Mysql
ĬÈÏÇø·Ö´óСд¡£
ʹ
ÓÃÏ»®Ïß¶Ï¿ªÃû×Ö£¬Ãû×ÖÖв»ÄÜ
ʹÓÿոñ¡£
Ãû×ÖÖо¡Á¿²»Òª
ʹ
ÓÃÊý×Ö¡£
Ãû×ÖÖо¡Á¿²»Òª
ʹÓÃ"
.",
Õâ
ÑùÄܱÜÃâÔÚ²éѯʱ³ö´í
¡£
Ãû×ÖÖв»ÄÜʹÓñ£Áô×Ö¡£
¾¡
Á¿Ê¹Ãû×Ö¼òµ¥¡£
 
Êý¾Ý¿âÃû£º
Ò»
°ãÇé¿öÏ£¬Ê¹ÓÃÏîÄ¿Ãû³Æ×÷ΪÊý¾Ý¿âµÄÃû×Ö¡£
Êý¾Ý¿âÃû×Öǰ¼ÓËùÓÐÕßµÄÃû×Ö×÷Ϊǰ׺¡£
 
±íÃû£º
¿É
ÒÔʹÓÃËõÂÔ´Ê×÷Ϊǰ׺
È磺"
hr_”, "mkt_”£¬·Ç±ð´ú±íÁËhuman
resource, marketing²¿ÃÅ¡£
²»ÒªÊ¹ÓÃͨÓõÄǰ׺
È磺"
tbl_”,
"db_”£¬ÕâÑù
ûÓÐʵ¼ÊÒâÒ壬·´¶ø¿´ÆðÀ´¸üÂé·³¡£
±íÃû¾¡Á¿¼ò¶Ì£¬×¼È·¡£
¹Ø
ÓÚ±íÃûµÄµ¥¸´Êý£¬¸ù¾Ý¸öÈËϰ¹ß¾ö¶¨£¬Ã»ÓжԴí
¡£
 
ÁÐÃû£º
Ö÷
¼üÒ»°ã
ÊÇ"
±íÃû
_id”¡£
Íâ
¼üµÄÁÐÃûºÍÁíÒ»¸ö±íµÄÖ÷¼üÃûÒ»ÖÂ
¡£
È磺
create table manager
(manager_id int(11) primary key );
create table employee(
employee_id int(11) primary key,
manager_id int(11),
FOREIGN KEY (manager_id) REFERENCES
manager(manager_id) ON DELETE CASCADE)
ÁÐ
ÃûÒÔ
3
¸ö×ÖĸµÄ±í¸ñËõдΪǰ׺
ÈÕ
ÆÚÁÐÒÔ"
date_”
Ϊǰ׺
Boolean
Àà
ÐÍÁÐÒÔ"
is_”
Ϊǰ׺
ÒýÓãº
MySQL database identifiers that can
be named include databases, tables, and columns. The MySQL documentation
contains extensive information about naming conventions. Here are some
of the naming conventions that you must use:
·        
All identifier names must be from 1 to 64
characters long, except for aliases, which can be 255 characters long.
·        
Database names must be unique. For each user
within a database, names of database objects must be unique across all
users (for example, if a database contains a department table created by
user A, no other user can create a department t


Ïà¹ØÎĵµ£º

Íü¼ÇmysqlÃÜÂëºó£¬ÖØÐ°²×°mysqlÈ«¹¥ÂÔ

 
1. ¿ªÊ¼->¿ØÖÆÃæ°å->Ìí¼Ó»òɾ³ý³ÌÐò->Ð¶ÔØmysql
2. ¼ÙÉè֮ǰmysqlµÄ°²×°Ä¿Â¼ÊÇC:\Program Files\MySQL\MySQL Server 5.1/, ÄÇôÕâ¸öÏÂÃæ»¹±£ÁôÁËһЩ¶«Î÷£¬´ò¿ªmy.ini
3. ÕÒµ½#Path to the database root£¬ È»ºó°´ÕÕÕâ¸öPathÕÒµ½mysql,ɾµô
4. °ÑC:\Program Files\MySQLҲɾµô
5. ¿ªÊ¼->ÔËÐÐ ÊäÈër ......

MYSQL Ë«»úÈȱ¸ÅäÖÃÊÖ²á()


[Ô­´´] MYSQL Ë«»úÈȱ¸ÅäÖÃÊÖ²á[Ô­´´]
http://www.chinaunix.net ×÷Õß:squall1  ·¢±íÓÚ£º2007-07-23 19:01:43
¡¾·¢±íÆÀÂÛ¡¿¡¾²é¿´Ô­ÎÄ¡¿¡¾´æ´¢±¸·ÝÖ®¼ÒÌÖÂÛÇø¡¿¡¾¹Ø±Õ¡¿
×÷ÕߣºCU-squall   
·¢±íÓÚ£º2005Äê4ÔÂ18ÈÕ 8:21  ¿ÉÒÔ²»¾­×÷ÕßͬÒâ×ÔÓÉ´«²¥£¬Çë×¢Ã÷×÷Õß³ö´¦¡£
ʹ ......

Nginx+PHP+MySQLË«»ú»¥±¸¡¢È«×Ô¶¯Çл»·½°¸[ת]

ÔÚÉú²úÓ¦ÓÃÖУ¬Ä³Ì¨“Nginx+PHP+MySQL”½Ó¿ÚÊý¾Ý·þÎñÆ÷£¬°çÑݵĽÇɫʮ·ÖÖØÒª£¬Èç¹û·þÎñÆ÷Ó²¼þ»òNginx¡¢MySQL·¢Éú¹ÊÕÏ£¬¶ø¶Ìʱ¼äÄÚÎÞ·¨»Ö¸´£¬ºó¹û½«·Ç³£ÑÏÖØ¡£ÎªÁ˱ÜÃâµ¥µã¹ÊÕÏ£¬ÎÒÉè¼ÆÁË´ËÌ×·½°¸£¬±àдÁËfailover.sh½Å±¾£¬ÊµÏÖÁËË«»ú»¥±¸¡¢È«×Ô¶¯Çл»£¬¹ÊÕÏ×ªÒÆÊ±¼äÖ»Ð輸ʮÃë¡£
¡¡¡¡Ò»¡¢Ë«»ú»¥±¸¡¢È«×Ô¶¯Çл»·½ ......

MySQL¼à¿Ø

Ô­ÎÄÍøÖ·£ºhttp://knowhow.innovatedigital.com/mysql-monitoring.html
MySQLÊÇ×îÁ÷ÐеĿª·ÅÔ´´úÂë¹ØÏµÊý¾Ý¿âϵͳ¡£ÆäÐÔÄܺÍÒ×ÓÃÐÔ£¬Ê¹Æä³ÉΪLAMP¼Ü¹¹µÄÖÐÐÄÖ§ÖùÖ®Ò»¡£
       MySQL¼à¿ØÒ»Ö±ÊǹØ×¢MySQLÊý¾Ý¿âÐÔÄܺÍMySQLÊý¾Ý¿âÔËά¹ÜÀí¼¼ÊõÈËÔ±µÄ·Ç³£¸ÐÐËȤ»°Ìâ¡£ÈçºÎÈÃÄúµÄMySQLÊý¾Ý¿â° ......

ÐÞ¸ÄmysqlÊý¾Ý¿âµÄĬÈϱàÂ뷽ʽ


< type="text/javascript">
document.body.oncopy = function() {
if (window.clipboardData) {
setTimeout(function() {
var text = clipboardData.getData("text");
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ