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

ÓÉMYSQL×¢Èë×ܽá³öÀ´µÄ¡£

×î½üÁ˽âÁËÒ»ÏÂMYSQL×¢È룬Ҳʵ¼Ê²Ù×÷ÁËһϣ¬È·Êµ·¢ÏÖÁËËûµÄÍþÁ¦¡£
Ò»¸ö×¢È멶´¿ÉÒÔÈÃÈËÖ±½ÓÄõ½·þÎñÆ÷ȨÏÞ¡£
×ܽáһϣº
1£¬Ä¿Â¼µÄȨÏÞ²»ÄÜÌ«¸ß£¬²»È»±ðÈËÄÜÍùÀïдÎļþ£¬ÒÔÇ°ÓÃ0777ÕæÊÇÌ«ÓÞ´ÀÁË¡£
2£¬Ñϸñ¹ýÂËÊý¾Ý£¬ÕûÐÎÒ»ÂÉתint»òÓÃmysql_escape_string
3£¬ÉèÖúÏÀíµÄÊý¾Ý¿âȨÏÞ£¬²»ÒªÓÃROOT,²»È»»áËÀµÃºÜ²Ò¡£
4£¬½ûÖ¹·þÎñÆ÷´íÎóÊä³ö£¬´íÎóÊä³ö»á±¬Â·¾¶£¬±»±¬Â·¾¶ÅäºÏ×¢È룬¹À¼Æ·þÎñÆ÷¾ÍÍêµ°ÁË¡£


Ïà¹ØÎĵµ£º

¹ØÓÚmysql archive´æ´¢ÒýÇæ

Õþ¸®»¹ÓÐÒ»¸öÈÃÊý¾Ý¿âר¼Ò̯Éϸü¶àÊÂÇéµÄÖ°ÄÜ£¬¾ÍÊÇ°²È«¿ØÖƺÍÊý¾ÝÉó¼Æ¡£ÄÇЩ¹ÜÀíן£Á¿Êý¾Ý²Ö¿âµÄÆóÒµ¹ÙÔ±³£³£µÃ»Ø´ðÖîÈ瓺ÎÈ˺ÎʱÐÞ¸ÄÁËʲô”»òÕß“ºÎÈ˺Îʱ²é¿´ÁËʲô”ÕâÑùµÄÌáÎÊ¡£ÄÇЩӵÓÐÊýÒÔǧ¼ÆµÄÔ±¹¤£¬¿ªÕ¹×Ų»¼ÆÆäÊýµÄÒµÎñµÄÆóÒµ£¬Ã¿Ì춼»á²úÉú³ö´óÁ¿µÄÈÕÖ¾¼Ç¼Êý¾Ý£¬¶øÇÒ±ØÐ뽫ÆäºÃºÃ±£´æ ......

HibernateµÄÓ³ÉäÀàÐÍ hibernate mysqlÓ³ÉäÀàÐÍ

1¡¢HibernateµÄÓ³ÉäÀàÐÍ hibernate mysqlÓ³ÉäÀàÐÍ
Hibernate Ó³ÉäÀàÐÍ
Java ÀàÐÍ
±ê×¼ SQL ÀàÐÍ
´óСºÍÈ¡Öµ·¶Î§
integer »òÕß int
int »òÕß java.lang.Integer
INTEGER
4 ×Ö½Ú
long
long  Long
BIGINT
8 ×Ö½Ú
short
short  Short
SMALLINT
2 ×Ö½Ú
byte
byte  Byte
TINYINT
1 ×Ö½Ú
floa ......

Mysql³£ÓÃÃüÁîÐдóÈ«

µÚÒ»ÕС¢mysql·þÎñµÄÆô¶¯ºÍÍ£Ö¹
net stop mysql
net start mysql
µÚ¶þÕС¢µÇ½mysql
Óï·¨ÈçÏ£º mysql -uÓû§Ãû -pÓû§ÃÜÂë
¼üÈëÃüÁîmysql -uroot -p£¬ »Ø³µºóÌáʾÄãÊäÈëÃÜÂ룬ÊäÈë12345£¬È»ºó»Ø³µ¼´¿É½øÈëµ½mysqlÖÐÁË£¬mysqlµÄÌáʾ·ûÊÇ£º
mysql>
×¢Ò⣬Èç¹ûÊÇÁ¬½Óµ½ÁíÍâµÄ»úÆ÷ÉÏ£¬ÔòÐèÒª¼ÓÈëÒ»¸ö²ÎÊý-h»úÆ÷IP
µ ......

mysql º¯Êý

***function(/*³£Óú¯Êý*/)***
----ͳ¼Æº¯Êý----
AVG    --Çóƽ¾ùÖµ
COUNT   --ͳ¼ÆÊýÄ¿
MAX    --Çó×î´óÖµ
MIN    --Çó×îСֵ
SUM    --ÇóºÍ
--AVG
use pangu
select avg(e_wage) as dept_avgWage
from employee
group by dept_id
--M ......

ÈçºÎÐÞ¸Ämysql rootÃÜÂ룿

1¡¢±à¼­MySQLÅäÖÃÎļþ£º
 windows»·¾³ÖУº%MySQL_installdir%\my.ini¡¡//Ò»°ãÔÚMySQL°²×°Ä¿Â¼ÏÂÓÐmy.ini¼´MySQLµÄÅäÖÃÎļþ¡£
linux»·¾³ÖУº/etc/my.cnf
ÔÚ[MySQLd]ÅäÖöÎÌí¼ÓÈçÏÂÒ»ÐУº
skip-grant-tables
±£´æÍ˳ö±à¼­¡£
2¡¢È»ºóÖØÆôMySQL·þÎñ
windows»·¾³ÖУº
net stop MySQL
net start MySQL
linux»·¾³ÖÐ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ