MySQLÊý¾Ý¿âµÄ¼òµ¥²Ù×÷
MySQLÊý¾Ý¿âµÄ¼òµ¥²Ù×÷
Ò».´´½¨Êý¾Ý¿â ͨ¹ýshow databases;ÃüÁîÏÔʾËùÓÐÒÑ´´½¨µÄÊý¾Ý¿âµÄÃû³Æ¡£
ͨ¹ýcreate database XXX;´´½¨Êý¾Ý¿âÃûΪXXXµÄÊý¾Ý¿â¡£ ÀýÈ磺mysql>create database test; ¶þ.´´½¨±íµ¥ ͨ¹ýcreate table XXX();´´½¨ ÀýÈç: È»ºó¿ÉÒÔͨ¹ýdescÃüÁî²é¿´±íµ¥: ÀýÈç: Èý.²åÈëÊý¾Ý ͨ¹ýinsert into XXX values( , );À´Íê³É²åÈë¹ý³Ì¡£È»ºóͨ¹ýselectÃüÁî²é¿´±íµ¥µÄ¾ßÌåÐÅÏ¢¡£ ÀýÈç: ËÄ.¸üÐÂÊý¾Ý ͨ¹ýupdate XXX set XX=XX where XX=XX;À´Íê³É±íµ¥µÄ¸üС£ ÀýÈç: Îå.ɾ³ýÊý¾Ý ͨ¹ýdelete from XXX where XX=XX;ÃüÁîÀ´É¾³ýÊý¾Ý¡£ ÀýÈç: Áù.ɾ³ýÊý¾Ý¿â ͨ¹ýdrop database XXX;À´É¾³ýÊý¾Ý¿â¡£ ÀýÈç:
Ïà¹ØÎĵµ£º
use mysql
update user set Password=password('newpassword') where User='root';
flush privileges;
1.ͨ¹ýÐÞ¸ÄMYSQLÊý¾Ý¿âÖÐMYSQL¿âµÄUSER±í
¾ÍÓÃÆÕͨµÄUPDATE¡¢INSERTÓï¾ä¾Í¿ÉÒÔ
2.ÔÚÃüÁîÐÐÖÐʹÓÃÈçÏÂÃüÁî
MYSQLADMIN -u root -p PASSWORD mypasswd
3.¿ÉÒÔÐÞ¸ÄMYSQLÎļþ¼ÐÖеÄMY.INIÎļþ
4.ʹÓÃSET PASSWORDÓï¾ ......
1. -static 13%
--with-client-ldflags=-all-static
--with-mysqld-ldflags=-all-static
¾²Ì¬Á´½ÓÌá¸ß13%ÐÔÄÜ
2. -pgcc 1%
CFLAGS="-O3 -mpentiumpro -mstack-align-double" CXX=gcc \
CXXFLAGS="-O3 -mpentiumpro -mstack-alig ......
°²×°Ê±µÄÓÅ»¯
(ÒÔϲâÊÔÊý¾Ý¶¼À´×ÔÓÚmysqlµÄ¹Ù·½ÍøÕ¾)
²»ÒªÓÃrpm»òÆäËû¶þ½øÖÆ·½Ê½°²×°
ÒªÓÃÔ´´úÂë×Ô¼º±àÒë
Èç¹ûÊDZ¼ÌÚϵͳ£¬ÍƼöÓÃpgcc±àÒëÆ÷
ÇÒʹÓÃ-O6µÄ±àÒë²ÎÊý
ÕâÑù±à³öÀ´µÄmysql±ÈÓÃgcc2.95µÄÒª¿ì1%
½öÓÃÓõÃ×ŵÄ×Ö·û¼¯±àÒëMySql
mysqlĿǰ֧³Ö¶à´ï34ÖÖ²»Í¬µÄ×Ö·û¼¯(mysql4.1.11)
µ«ÎÒÃdz£ÓõÄÒ²Î޷ǾÍÊÇlati ......
ÔÚʹÓÃJDBC²Ù×÷Êý¾Ý¿â ÔÚÏòÊý¾Ý¿âÖвåÈëͼƬʱ£¬³ÌÐòÀÏÊÇÅ×Òì³£
ÔÀ´µÄMYSQL×Ö·û¼¯ÊÇGBK µ«ÊÇÕâÖÖ×Ö·û¼¯ËäȻ֧³ÖÖÐÎÄ µ«Êǵ±²åÈëͼƬµÈ¶þ½øÖÆÊý¾Ýʱ »á³öÏÖ´íÎó
½â¾ö·½·¨£º
½«Êý¾Ý¿â×Ö·û¼¯¸ü¸ÄΪgb2312»òutf-8
1.ÔÚMYSQL DOS½çÃæÖÐÊäÈë show variables like "%char%";
+---- ......