debianÏÂmysql¶ÔÖÐÎĵÄÖ§³ÖÎÊÌâ
ÐÞ¸Ä /etc/mysql/my.cnf Îļþ£¬
ÔÚ £Ûclient£Ý ϼÓÈë default-character-set=utf8,
ÔÚ [mysqld] ϼÓÈë default-character-set=utf8,
ÔòÔÚviÀï¿ÉÒÔÕýÈ·µÄÏÔʾÖÐÎÄÁË£¨Ç°ÌáÊÇviҲʹÓÃutf8£©¡£
²»¹ýÔÚ²éѯµÄʱºò£¬½á¹ûÀïµÄÖÐÎÄÈ´»áÏÔʾ³É "?"£¬Õâ¸öÎÊÌâ±È½Ï¼òµ¥µÄ·½·¨Óм¸ÖÖ£¬·Ö±ðÊÇ£º
1.ÔÚ´´½¨Êý¾Ý¿âʱ¼´Ö¸¶¨Êý¾Ý¿â×Ö·û¼¯(»¹¿ÉÒÔ˳´øÖ¸¶¨Ð£¶Ô¹æÔò)£º
mysql> CREATE DATABASE
db_name
mysql> DEFAULT CHARACTER SET utf8 £Û
COLLATE utf8
£Ý;
2.ÔÚ´´½¨±íµÄʱºòÖ¸¶¨±í×Ö·û¼¯£º
mysql> CREATE TABLE
tbl_name
(
column_list
)
mysql> DEFAULT CHARACTER SET
charset_name
COLLATE
collation_name
3.Ö¸¶¨ÁÐ×Ö·û¼¯(ÿһ¸ö“×Ö·û
”ÁУ¨¼´£¬CHAR
¡¢VARCHAR
»òTEXT
ÀàÐ͵ÄÁУ©ÓÐÒ»¸öÁÐ×Ö·û¼¯ºÍÒ»¸öÁÐ
У¶Ô¹æÔò£¬Ëü²»ÄÜΪ
¿Õ¡£Áж¨ÒåÓï·¨ÓÐÒ»¸ö¿ÉÑ¡×Ó¾äÀ´Ö¸¶¨ÁÐ×Ö·û¼¯ºÍУ¶Ô¹æÔò)£º
mysql> CREATE TABLE Table1
mysql> (
mysql> column1 VARCHAR(5)
CHARACTER SET latin1 COLLATE latin1_german1_ci
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×¢È룬Ҳʵ¼Ê²Ù×÷ÁËһϣ¬È·Êµ·¢ÏÖÁËËûµÄÍþÁ¦¡£
Ò»¸ö×¢È멶´¿ÉÒÔÈÃÈËÖ±½ÓÄõ½·þÎñÆ÷ȨÏÞ¡£
×ܽáһϣº
1£¬Ä¿Â¼µÄȨÏÞ²»ÄÜÌ«¸ß£¬²»È»±ðÈËÄÜÍùÀïдÎļþ£¬ÒÔÇ°ÓÃ0777ÕæÊÇÌ«ÓÞ´ÀÁË¡£
2£¬Ñϸñ¹ýÂËÊý¾Ý£¬ÕûÐÎÒ»ÂÉתint»òÓÃmysql_escape_string
3£¬ÉèÖúÏÀíµÄÊý¾Ý¿âȨÏÞ£¬²»ÒªÓÃROOT,²»È»»áËÀµÃºÜ²Ò¡£
4 ......
MSSQL ÈçºÎʵÏÖ MySQL µÄ limit ²éѯ·½Ê½
²»ÖªÎªºÎ£¬MSSQL ÖÐûÓÐ limit Õâ¸ö¼«ÎªÖØÒªµÄ²éѯ·½Ê½£¬ÊìϤ MySQL µÄÅóÓѶ¼ÖªµÀ£¬MySQL µÄ limit ¶ÔÓÚʵÏÖ·ÖÒ³ºÍһЩÏÞÖƽá¹û¼¯µÄÓ¦ÓÃÖзdz£·½±ã¡£Ã»Óв»Òª½ô£¬ÎÒÃÇ¿ÉÒÔÓÃÆäËû·½·¨´ïµ½Í¬ÑùµÄÄ¿µÄ£¬×Ô¼º¶¯ÊÖ£¬·áÒÂ×ãʳ£¡
Óï·¨£º
Code:
SELECT * from
(
......
´Ó±¾Æª²©ÎÄ¿ªÊ¼£¬ÎÒÃǾÍÒªÉîÈëµ½PHPµÄÓ¦Óõ±ÖÐÈ¥ÁË¡£PHPµÄÊý¾Ý¿âÓ¦ÓÃÊÇÖØÖÐÖ®ÖØ£¬±ØÐëÕÆÎÕ¡£Ñ¡ÔñʲôÑùµÄÊý¾Ý¿âÄØ£¬µ±È»ÊÇÎÒÃǵÄMySQLÀ²£¬Ã»ÓÐÈË»áȥʹÓÃÄÇЩÅÓ´ó¡¢µÍЧ¶øÓÖ°º¹óµÄÉÌÒµÊý¾Ý¿âÀ´¹¹½¨PHPÓ¦Óðɡ£
1 MySQLÊý¾Ý¿âµÄ°²×°
¹ýÈ¥£¬°²×°Ò»¸öMySQLÊý¾Ý¿â²¢ÇÒÒªÆô¶¯ÆðÀ´ºÜ·ÑÊ£¬ÌرðÊÇÔÚLinuxÕâÑùµÄ¿ª·¢»·¾³Ï£¬ÐèÒª¸ ......
http://www.3d308.cn/article.asp?id=37
shell> mysql -u root mysql
mysql> Update user SET Password=PASSWORD('new_password')
Where user='root';
mysql> FLUSH PRIVILEGES;
......