ÓÉMYSQL×¢Èë×ܽá³öÀ´µÄ¡£
×î½üÁ˽âÁËÒ»ÏÂMYSQL×¢È룬Ҳʵ¼Ê²Ù×÷ÁËһϣ¬È·Êµ·¢ÏÖÁËËûµÄÍþÁ¦¡£
Ò»¸ö×¢È멶´¿ÉÒÔÈÃÈËÖ±½ÓÄõ½·þÎñÆ÷ȨÏÞ¡£
×ܽáһϣº
1£¬Ä¿Â¼µÄȨÏÞ²»ÄÜÌ«¸ß£¬²»È»±ðÈËÄÜÍùÀïдÎļþ£¬ÒÔÇ°ÓÃ0777ÕæÊÇÌ«ÓÞ´ÀÁË¡£
2£¬Ñϸñ¹ýÂËÊý¾Ý£¬ÕûÐÎÒ»ÂÉתint»òÓÃmysql_escape_string
3£¬ÉèÖúÏÀíµÄÊý¾Ý¿âȨÏÞ£¬²»ÒªÓÃROOT,²»È»»áËÀµÃºÜ²Ò¡£
4£¬½ûÖ¹·þÎñÆ÷´íÎóÊä³ö£¬´íÎóÊä³ö»á±¬Â·¾¶£¬±»±¬Â·¾¶ÅäºÏ×¢È룬¹À¼Æ·þÎñÆ÷¾ÍÍêµ°ÁË¡£
Ïà¹ØÎĵµ£º
Õþ¸®»¹ÓÐÒ»¸öÈÃÊý¾Ý¿âר¼Ò̯Éϸü¶àÊÂÇéµÄÖ°ÄÜ£¬¾ÍÊÇ°²È«¿ØÖƺÍÊý¾ÝÉó¼Æ¡£ÄÇЩ¹ÜÀíן£Á¿Êý¾Ý²Ö¿âµÄÆóÒµ¹ÙÔ±³£³£µÃ»Ø´ðÖîÈ瓺ÎÈ˺ÎʱÐÞ¸ÄÁËʲô”»òÕß“ºÎÈ˺Îʱ²é¿´ÁËʲô”ÕâÑùµÄÌáÎÊ¡£ÄÇЩӵÓÐÊýÒÔǧ¼ÆµÄÔ±¹¤£¬¿ªÕ¹×Ų»¼ÆÆäÊýµÄÒµÎñµÄÆóÒµ£¬Ã¿Ì춼»á²úÉú³ö´óÁ¿µÄÈÕÖ¾¼Ç¼Êý¾Ý£¬¶øÇÒ±ØÐ뽫ÆäºÃºÃ±£´æ ......
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·þÎñµÄÆô¶¯ºÍÍ£Ö¹
net stop mysql
net start mysql
µÚ¶þÕС¢µÇ½mysql
Óï·¨ÈçÏ£º mysql -uÓû§Ãû -pÓû§ÃÜÂë
¼üÈëÃüÁîmysql -uroot -p£¬ »Ø³µºóÌáʾÄãÊäÈëÃÜÂ룬ÊäÈë12345£¬È»ºó»Ø³µ¼´¿É½øÈëµ½mysqlÖÐÁË£¬mysqlµÄÌáʾ·ûÊÇ£º
mysql>
×¢Ò⣬Èç¹ûÊÇÁ¬½Óµ½ÁíÍâµÄ»úÆ÷ÉÏ£¬ÔòÐèÒª¼ÓÈëÒ»¸ö²ÎÊý-h»úÆ÷IP
µ ......
***function(/*³£Óú¯Êý*/)***
----ͳ¼Æº¯Êý----
AVG --Çóƽ¾ùÖµ
COUNT --ͳ¼ÆÊýÄ¿
MAX --Çó×î´óÖµ
MIN --Çó×îСֵ
SUM --ÇóºÍ
--AVG
use pangu
select avg(e_wage) as dept_avgWage
from employee
group by dept_id
--M ......
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»·¾³ÖÐ ......