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

ÓйØmysql·þÎñ×Ô¶¯¹Ø±ÕµÄÎÊÌâ

ÎÒÓõÄÊÇMySQL Server5.0ÂÌÉ«°æµÄ£¬ÎÒ¸øËü¿ªÁË3506¶Ë¿Ú

ÔÚÓÐЩ¼ÆËã»úÉÏ£¬¹ýû¶à¾ÃËü¾Í»á×Ô¶¯¹Ø±Õ£¬µ«ÓÐЩ¼ÆËã»úÉÏÓÖ²»»á

Õâ¸öÎÊÌâ¸ÃÔõô´¦Àí°¡£¿
cmd --> F:\MySql\MySqlServer5.1\bin\mysqld --install ¼ÓÈë·þÎñ

Õâ¸ö°¡£¿
ÄÇôÉÙÐÅÏ¢±È½ÏÄÑÅжÏ
ÕâÑù°É
ÄãÈ¥¿´¿´dataµÄĿ¼ÏÂerrºó׺µÄÎļþÀïÃæÊÇ·ñÓÐʲô´íÎóÐÅϢûÓУ¿
»òÈ¥¿´¿´²Ù×÷ϵͳµÄÈÕÖ¾£¬¿´¿´ÊÇ·ñÓÐʲôÒì³£´íÎóÐÅϢûÓÐ


È·ÈÏÏÂÊÇ·ñ´æÔÚsocket¶Ë¿Ú³åÍ»µÄÎÊÌâûÓÐ

091030 10:58:14  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
091030 10:58:14  InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 6242273.
InnoDB: Doing recovery: scanned up to log sequence number 0 6242273
091030 10:58:14  InnoDB: Started; log sequence number 0 6242273
091030 10:58:15 [Note] d:\Program Files\HIGHSUM_SOFT\ºÏÖÇÈËʹ¤×ʹÜÀíÈí¼þ(ÍøÂç°æ)\MySQL Server 5.0\bin\mysqld-nt.exe: ready for connections.
Version: '5.0.45-community-nt'  socket: ''  port: 3506  MySQL Community Edition (GPL)
091030 11:09:30 [Note] d:\Program Files\HIGHSUM_SOFT\ºÏÖÇÈËʹ¤×ʹÜÀíÈí¼þ(ÍøÂç°æ)\MySQL Server 5.0\bin\mysqld-nt.exe: Normal shutdown

091030 11:09:30  I


Ïà¹ØÎÊ´ð£º

c,c++Á¬½Ómysql ÕÒ²»µ½Í·²¿Îļþ£¨ÐÂÊÖ£©

±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......

MySqlÎÊÌâ

MySqlÖвåÈ뵱ǰʱ¼äµÄ¸ÃÔõôд°¡£¿
now()

SQL code:

sqlÀïÊÇ£º
getdate()

ÒýÓÃ
now()


ѧϰ

SQL code:
select now();

SQL code:
TODAY()
?

SQL code:
select now();
/* ......

mysqlµÄÇý¶¯³ÌÐò

ÎÒÓÐÒ»¸öjava»·¾³ÏµijÌÐò£¬ÔÚ±¾»úÔËÐÐÕý³££¬µ«·¢²¼µ½ÍøµÄÐéÄâÖ÷»úʱ²»ÄÜÁ¬½ÓÊý¾Ý¿âÁ¬½Ó³Ø
jdk 1.6 tomcat6.0.18 mysql5 mysqljdbc5.1.5
ÐéÄâÖ÷»úµÄ¼¼ÊõÈËԱ˵£¬Ö»ÄÜÅäÖþÖÓòµÄÊý¾Ý¿âÁ¬½Ó³Ø£¬Ò²¾ÍÊÇÔÚM ......

Çë½Ìmysql innodbÊý¾ÝÎļþ´óС³¬¹ýϵͳÏÞÖÆµÄÎÊÌâ

ÓÉÓÚÒÔǰûÓÐinnodbµÄÓ¦Óþ­Ñ飬ÔÚÅäÖÃinnodbµÄinnodb_data_file_pathÑ¡ÏîʱÓõÄÊÇĬÈÏÅäÖã¨ibdata1:10M:autoexte
nd£© ,½ñÌì·¢ÏÖ´ËÊý¾Ý¿âÔÚͬ²½Ö÷Êý¾Ý¿âÊý¾Ýʱ£¨´ËinnodbÊÇ×÷Ϊһ̨myisam dbµÄÀ䱸»úÆ÷£©£¬ibda ......

ÓÃPHPÅÅÐòmysqlÎÊÌâ

²»ÖªµÀÊDz»ÊÇÎÒµÄxamppÓÐÎÊÌ⣬mysqlÊÇͼÐλ¯µÄ£¡
Ò»¸öID×éÔÚÎÒµÄmysqlµÄ±íÀïÃæ 2£¬5£¬8£¬7
µãÁËÅÅÐò£¬È»ºóÓÃPHPÎļþÁ¬½ÓÕâ¸ö±íÏÔʾ±íµÄÐÅϢʱ£¬IDµÄ˳Ðò»¹ÊDz»±ä£¡Ó¦¸ÃÊÇ2£¬5£¬7£¬8µÄ°ÉÉýÐòÅÅÐòºó£¡
ÔÚPHPÎļþÀï ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ