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

ÔÚÒ»µçÄÔÉÏ°²×°¶àmysqlʵÀý

ÎҵĻ·¾³£º
Ô­ÓÐÒ»mysql5.0ʵÀý£¬ÏÖа²×°Ò»mysql5.1£¬²¢½«ÐµÄ5.1ʵÀýµÄÊý¾Ý·¾¶·ÅÔÚÁíһĿ¼¡£
mysql5.1µÄmy.iniÈçÏÂ
£¨ÅäÖÃmy.iniµÄ²Î¿¼×ÊÁÏ£º
http://dev.mysql.com/doc/refman/5.1/en/option-files.html
http://downloads.mysql.com/docs/mysql-windows-excerpt-5.1-en.pdf
http://dev.mysql.com/doc/refman/5.0/en/multiple-windows-servers.html
¹Ø¼üÊǼ¸¸öÊôÐÔ£º
client×é¡¢mysqld×éµÄportÒª²»Í¬£»
mysqld×éµÄbasedirָʾmysqlµÄ°²×°Ä¿Â¼£»
mysqld×éµÄdatadir¡¢innodb_data_home_dirÇ°ÕßÊÇÊý¾ÝµÄĿ¼£¬ºóÕßÊÇinnodbµÄÊý¾ÝĿ¼£¬Á½Õß±ØÐëÏàͬ£¬·ñÔò»á±¨´íÈçÏ£º
InnoDB: No valid checkpoint found.
InnoDB: If this error appears when you are creating an InnoDB database,
InnoDB: the problem may be that during an earlier attempt you managed
InnoDB: to create the InnoDB data files, but log file creation failed.
InnoDB: If that is the case, please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/error-creating-innodb.html
100515 20:50:51 [ERROR] Plugin 'InnoDB' init function returned error.
100515 20:50:51 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
100515 20:50:52 [ERROR] Unknown/unsupported table type: INNODB
100515 20:50:52 [ERROR] Aborting£»
£©
#------------------------------------------------------------------------------------------------------------
# MySQL Server Instance Configuration File
# ----------------------------------------------------------------------
# Generated by the MySQL Server Instance Configuration Wizard
#
#
# Installation Instructions
# ----------------------------------------------------------------------
#
# On Linux you can copy this file to /etc/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options
# (@localstatedir@ for this installation) or to
# ~/.my.cnf to set user-specific options.
#
# On Windows you should keep this file in the installation directory
# of your server (e.g. C:\Program Files\MySQL\MySQL Server X.Y). To
# make sure the server reads the config file use the startup o


Ïà¹ØÎĵµ£º

.NETÁ¬½ÓMySqlÊý¾Ý¿âµÄ·½·¨¼°Ê¾Àý

·½·¨Ò»£º
ʹÓÃMySQLÍƳöµÄMySQL Connector/Net×é¼þ£¬ ¸Ã×é¼þÊÇMySQLΪADO.NET·ÃÎÊMySQLÊý¾Ý¿âÉè¼ÆµÄ.NETרÓ÷ÃÎÊ×é¼þ¡£Íê³É¸Ã×é¼þºó£¬ÐèÒªÔÚÏîÄ¿ÖÐÒýÓÃÕâ¸ö×é¼þ£¬Ò²¿ÉÒÔÖ±½ÓÔÚÅäÖÃÎļþµÄ<assemblies>½ÚµãÄÚÌí¼ÓÏÂÃæµÄ½Úµã£º
<add assembly="MySql.Data, Version=5.1.5.0, Culture=neutral, PublicKeyToken=C5687 ......

mysqlÎĵµÑ§Ï°3.6

Ô¶³ÌµÇ¼ -h IPµØÖ·
ctrl + d Í˳ö »ò \q »ò quit
select version(); µ±Ç°°æ±¾
current_dateµ±Ç°ÈÕÆÚ »òcurdate() »ò current_date()
SELECT name, birth, curdate(),(year(curdate())-year(birth)) - (right(curdate(),5)<right(birth,5)) as age from ±í ORDER BY name;
year ÌáÈ¡Ä겿·Ö right(curdate(),5)ÌáÈ¡Ó ......

mysql ·Ç°²×°°æµÄÒ»¸ö×Ô¶¯°²×°½Å±¾

¸öÈËÀͶ¯£¬»¹Çë×ðÖØ£¬ÈçÈôתÔØÇë×¢Ã÷³ö´¦¡£iihero@CSDN
¿´µ½ÓÐЩÅóÓÑÀÏÎÊÕâ¸ö·Ç°²×°°æÓë°²×°°æÓÐʲôÇø±ð£¨µ±È»ÊÇwindowsƽ̨)
¸É´àдÁËÒ»¸ö½Å±¾×Ô¶¯ÎªÆä´´½¨mysql5·þÎñ¡£
½Å±¾ÈçÏ£¬½«Æä·Åµ½½âѹÒÔºóµÄĿ¼Àï±ßÖ´Ðм´¿É¡£
@echo off
echo "This is a demo script for auto installation of noninstall version o ......

MYSQLºÍjavaÖеÄÊýÖµ·¶Î§ 91KGE

mysqlÊýÖµ·¶Î§
tinyint  -128~127   0~255
smallint  -32768~32767  0~65535
mediumint -8388608~8388607  0~16777215
int -2147483648~2147483647 0~4294967295
bigint  -9223372036854775808~9223372036854775807   0~18446744073709551615
javaÖÐ
byte   ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ