mysql on suse linux ϵͳÃüÁî±Ê¼Ç
SLES 11
ÉèÖÃmysql·þÎñ×Ô¶¯Æô¶¯×´Ì¬
chkconfig mysql on
(chkconfig mysql off)
Ìí¼Ó/ɾ³ýmysql·þÎñ
/sbin/chkconfig --del mysql
/sbin/chkconfig --add mysql
²é¿´mysql°æ±¾
mysql -V
mysqld -V
ÆôÍ£ mysql
service mysql start
service mysql stop
service mysql restart
Ïà¹ØÎĵµ£º
Mysql Explain Ïê½â
ת×ÔITPUBhttp://www.itpub.net/viewthread.php?tid=1034410&extra=page%3D1%26amp%3Bfilter%3Ddigest&page=1
Ò».Óï·¨
explain < table_name >
ÀýÈç: explain select * from t3 where id=3952602;
¶þ.explainÊä³ö½âÊÍ
+----+-------------+-------+-------+-------------------+--- ......
ÔÀ´ÓÉÓÚѧϰ¹¤×÷µÄÐèÒª£¬ÔÚXPÏÂ×°ÁËLINUXϵͳ£¬°²×°XP/LINUX˫ϵͳÂé·³£¬Ã»Ïëµ½Ð¶ÔØÒ²Âé·³¡£¸Õ¿ªÊ¼ÒÔΪ°Ñ×°LINUXϵͳµÄÄǸöÅ̸ñʽ»¯¾ÍOKÁË£¬½á¹ûÖØÆôºóÈÔÈ»³öÏÖÄǸö¿ÉºÞµÄgrubÒýµ¼½çÃæ¡£Ò»ÆøÖ®Ï£¬ÖØ×°CÅÌ£¬grub½çÃæÃ»ÁË£¬¿ÉÈ´½ø²»ÁËϵͳ¡£ÍøÉ϶෽²éÕÒ£¬×îºó½â¾ö°ì·¨£ºÏÂÔØmbrfixÎļþµ½uÅÌ£¬ÓÃϵͳÅ̽øÈëµ½WINPE£¬½«mbrfi ......
Ò»¡¢Á¬½ÓMYSQL¡£
¸ñʽ£º mysql -hÖ÷»úµØÖ· -uÓû§Ãû £pÓû§ÃÜÂë
1¡¢Á¬½Óµ½±¾»úÉϵÄMYSQL¡£Ê×ÏÈ´ò¿ªDOS´°¿Ú£¬È»ºó½øÈëĿ¼mysql\bin£¬ÔÙ¼üÈëÃüÁîmysql -u root -p£¬»Ø³µºóÌáʾÄãÊäÃÜÂë.×¢ÒâÓû§Ãûǰ¿ÉÒÔÓпոñÒ²¿ÉÒÔûÓпոñ£¬µ«ÊÇÃÜÂëǰ±ØÐëûÓпոñ£¬·ñÔòÈÃÄãÖØÐÂÊäÈëÃÜÂë. Èç¹û¸Õ°²×°ºÃMYSQL£¬³¬¼¶Óû§rootÊÇûÓÐÃÜÂëµ ......
/*
* linux/fs/fcntl.c
*
* (C) 1991 Linus Torvalds
*/
#include <string.h>
#include <errno.h>
#include <linux/sched.h>
#include <linux/kernel.h>
#include <asm/segment.h>
#include <fcntl.h>
#include <sys/stat. ......
Á½ÖÖ·½Ê½£º
Ò»ÖÖÊÇͨ¹ýÖÕ¶ËÊÖ¶¯¹ÒÔØ¼ÓÉϲÎÊý: -o iocharset=utf8
È磺# mount /dev/sdb1 -t vfat /mnt/usb/ -o iocharset=utf8
µÚ¶þÖÖÊÇͨ¹ý¼ÓÈëÄÚºËÖ§³ÖÔÚFile systems ---> DOS/FAT/NT Filesystems --->ÖÐÓÐÁ½ÏîÐÞ¸ÄΪ£ ......