mysqlÍâ¼üµÄʹÓÃ
ÏñMySQLÕâÑùµÄ¹ØϵÐÍÊý¾Ý¿â¹ÜÀíϵͳ£¬ËüÃǵĻù´¡ÊÇÔÚÊý¾Ý¿âµÄ±íÖ®¼ä´´½¨¹ØϵµÄÄÜÁ¦¡£Í¨¹ý·½±ãµØÔÚ²»Í¬±íÖн¨Á¢¼Ç¼µ½¼Ç¼µÄÁªÏµ£¬RDBMS¿ÉÒÔÀûÓò»Í¬µÄ·½·¨·ÖÎöÊý¾Ý£¬Í¬Ê±±£³ÖÊý¾Ý¿âÒÔϵͳµÄ·½Ê½¡¢×îСµÄÈßÓà½øÐÐ×éÖ¯¡£
¼òµ¥ÃèÊö£º
ÕâЩ¹Øϵ»ù±¾ÉÏÒÀ¿¿Íâ¼ü½øÐйÜÀí£¬ÔÚ¹ØϵÖÐËùÓбíÖоßÓÐÏàͬº¬ÒåµÄ×Ö¶Î×÷Ϊ¹«¹²²¿·ÖÀ´Á¬½Ó²»Í¬±íÖеļǼ¡£Íâ¼ü¿ÉÒÔÊÇÒ»¶ÔÒ»µÄ£¬Ò»¸ö±íµÄ¼Ç¼ֻÄÜÓëÁíÒ»¸ö±íµÄÒ»Ìõ¼Ç¼Á¬½Ó£¬»òÕßÊÇÒ»¶Ô¶àµÄ£¬Ò»¸ö±íµÄ¼Ç¼ÓëÁíÒ»¸ö±íµÄ¶àÌõ¼Ç¼Á¬½Ó¡£
MySQLÖГ¼ü”ºÍ“Ë÷Òý”µÄ¶¨ÒåÏàͬ£¬ ËùÒÔÍâ¼üºÍÖ÷¼üÒ»ÑùÒ²ÊÇË÷ÒýµÄÒ»ÖÖ¡£²»Í¬µÄÊÇMySQL»á×Ô¶¯ÎªËùÓбíµÄÖ÷¼ü½øÐÐË÷Òý£¬µ«ÊÇÍâ¼ü×ֶαØÐëÓÉÓû§½øÐÐÃ÷È·µÄË÷Òý¡£ÕâºÍһЩ·â½¨Ë¼Ïë±È½Ï³ÁÖصļÒÍ¥ÊÇÒ»ÑùµÄ£¬ÍâÀ´µÄº¢×Ó(¶ùϱ¸¾£¬µ¹²åÃÅÅ®Ðö)Ò»°ã¶¼ÊDz»ÊÜÖØÊӵġ£
µÍË×ʾÀý£º
±í¼äÒ»¶ÔÒ»¹ØϵʾÀý£º
ÓÐÁ½ÕÅ±í£¬µÚÒ»ÕűíÊǼǼ¹«Ë¾ÓжàÉÙÈË£¬¶¼ÓÐË£¬Ò²¾ÍÊÇÔ±¹¤±àºÅ¼°Ô±¹¤ÐÕÃûÕâЩ»ù±¾±í¡£ÁíÒ»Õűí¼Ç¼ÿ¸öÔ·¢¸øÓû§¶àÉÙ¹¤×Ê£¬Ëùν¹¤×ʱíÊÇÒ²¡£
µ«Êǹ¤×ʱíÀïÃæ²»ÄÜÒÔÔ±¹¤ÐÕÃûΪÖ÷¼ü£¬Í¬ÑùҪͨ¹ýÔ±¹¤id£¬ÒòΪԱ¹¤µÄÐÕÃûÊÇ¿ÉÄÜÖظ´µÄ°¡¡£²¿ÃžÀí½ÐÕÅÈý£¬Ð¡µÜÒ²½ÐÕÅÈý£¬ÄÇÕâÁ©ÕÅÈýµÄ¹¤×ÊÄÜÒ»ÑùÂ𣿲¢ÇÒÔ±¹¤±íÀïÃæµÄÿ¸öÈ˶¼Óй¤×Ê£¬·ñÔòËÒ²²»¸øÄã¸É»î£¬ÇÒÒ»¸öÈËÖ»ÄÜÓÐÒ»·Ý¹¤×Ê£¬·ñÔòÀÏ°åÒ²²»Í¬ÒâÁË¡£ËùÒÔÔ±¹¤±íºÍ¹¤×ʱíÊÇͨ¹ýÔ±¹¤id½øÐйØÁªµÄÒ»¶ÔÒ»¹Øϵ¡£
²»¹ýÎÒÃÇÒªÓÐÒ»¸öºÃµÄ¼ÛÖµ¹Û£¬ÎÒÃÇÉϰ಻ÄÜΪÁËÇ®£¬ÎÒÃÇÊÇΪÁËѧ֪ʶ£¬Ñ§ÎÄ»¯£¬ÎªÔçÈÕʵÏÖËĸöÏÖ´ú»¯(±ðÎÊÎÒÊÇɶ£¬Ò²±ðÎÊÎÒµ½µ×ʵÏÖûÓÐ)¶øŬÁ¦·Ü¶·¡£ËùÒÔÔÚ¹¤×ʱíÀïÈç¹ûûÓÐÄãÒ²²»ÒªÂÒº°¡£àÅ¡£
/*
½¨Á¢Ô±¹¤±í
*/
create table employees (
id int(5) not null auto_increment ,
name varchar(8) not null,
primary key (id)
)
type£½innodb;
/*
½¨Á¢¹¤×ʱí
*/
create table payroll(
id int(5) not null,
emp_id int(5) not null,
name varchar(8) not null,
payroll float(4,2) not null,
primary key(id),
index emp_id (emp_id),
foreign key (emp_id) references employees (id)
)
type = innodb;
±í¼äÒ»¶Ô¶à¹ØϵʾÀý£º
ÓÐÁ½¸ö±í£¬Ò»¸öÊÇÌ°¹Ù±í£¬ÓÐÌ°¹ÙµÄidºÍÃû×Ö¡£ÁíÓÐÒ»ÕÅÌ°¹ÙÇ鸾±í£¬×¢ÒâÒ»¸öÌ°¹Ù²»Ò»¶¨Ö»ÓÐÒ»¸öÇ鸾£¬ÆäÓиö¶þÈýËÄÎåÄÌÊǺÜÕý³£µÄ£¬ËùÒÔÔÚÌ°¹Ù±íÀïÃæµÄÒ»ÌõÊý¾Ý£¬¶ÔÓ¦Ç鸾±íÀï¿ÉÄܾÍÓжàÌõ¼Ç¼£¬ÕâÊÇͨ¹ýÌ°¹Ùid½øÐйØÁªµÄÒ»¶Ô¶à¹Øϵ¡£
²ÎÕÕÍêÕûÐÔ
Ïà¹ØÎĵµ£º
°³½ñÌìÕâô¼¤¶¯ÓÖÏëдÎÄÕµÄÔÒòÊÇMySQL5.1µÄ·¢²¼´øÀ´ÁËÉè¼Æ³¬Ç¿¶¯Á¦Êý¾Ý¿âµÄÇ¿ÓÐÁ¦µÄÎäÆ÷£¬ÈκÎMySQLµÄDBA¶¼Ó¦¸Ã¾¡¿ìѧϰ²¢Ê¹ÓÃËü¡£°³¾õµÃÈç¹ûÄܺܺõÎʹÓÃÕâ¸ö5.1°æ´øÀ´µÄÐÂÌØÐÔ£¬DBA¿ÉÒÔʹ×Ô¼º¹ÜÀíµÄVLDB£¨²»ÖªµÀʲôÊÇVLDB£¿¸æËßÄ㣬ÊǺôóºÃ´óµÄÊý¾Ý¿âµÄÒâ˼£¬Very Large DB£©»òÊý¾Ý²Ö¿âÆæ¼£°ãµÄ»ñµÃ¾Þ´óµÄÐÔÄÜÌáÉý¡£ ......
MySQL´Ó4.1¿ªÊ¼Ö§³ÖSQLµÄ×Ó²éѯ¡£Õâ¸ö¼¼Êõ¿ÉÒÔʹÓÃSELECTÓï¾äÀ´´´½¨Ò»¸öµ¥ÁеIJéѯ½á¹û£¬È»ºó°ÑÕâ¸ö½á¹û×÷Ϊ¹ýÂËÌõ¼þÓÃÔÚÁíÒ»¸ö²éѯÖС£ÀýÈ磬ÎÒÃÇÒª½«¿Í»§»ù±¾ÐÅÏ¢±íÖÐûÓÐÈκζ©µ¥µÄ¿Í»§É¾³ýµô£¬¾Í¿ÉÒÔÀûÓÃ×Ó²éѯÏÈ´ÓÏúÊÛÐÅÏ¢±íÖн«ËùÓз¢³ö¶©µ¥µÄ¿Í»§IDÈ¡³öÀ´£¬È»ºó½«½á¹û´«µÝ¸øÖ÷²éѯ£¬ÈçÏÂËùʾ£º
DELETE from ......
<!--#include file="zheboconn.asp"-->
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=GB2312" />
<title>aspºÍmysql·ÖÒ³´úÂë</title>
<style type="text/css">
<!--
.STYLE3 {
fon ......
ÓÉÓÚ×î½üÒ»Ö±ÔÚÁ˽âmysql¡£¸÷ÖÖ±íÀàÐ͵ÄÊý¾Ý´æ´¢ÒÔ¼°Ïà¹ØÏÞÖƾÍÊDZØÐëÁ˽âµÄ·½ÃæÁË¡£
×Ô¼ºµÄ·þÎñÆ÷»·¾³£ºOS Cent OS ext3£¬memory 4G£¬ disk 2T block size 4K¡£
¾µ÷²é£¬linuxÏÂÎļþ×î´óÊÇ´æÔÚÏÞÖƵġ£È¥googleÉÏËÑÁËËÑ£¬´ó¼Ò˵·¨²»Ò»£¬×îÖÕ×Ô¼º»¹ÊÇÕÒµ½±È½Ï¹Ù·½µÄ˵¡£Ïê¼ûhttp://en.wikipedia.org/wiki/Ext3 ËùÒÔ× ......
Mysql³£ÓÃÃüÁî½Å±¾
µÚÒ»ÕС¢mysql·þÎñµÄÆô¶¯ºÍÍ£Ö¹
net stop mysql
net start mysql
µÚ¶þÕС¢µÇ½mysql
Óï·¨ÊÇ mysql -hÖ÷»ú -uÓû§Ãû -pÃØÃÜ
Àý×ÓÊÇ mysql -hlocalhost -uroot -p123456
Ҫȷ¶¨mysql°²×°Ê±ºò¹´Ñ¡ÁË¿ÉÒÔÔ¶³ÌÁ´½Ó¡£Èç¹ûµÇ½±¾µØ¼ÆËã»ú£¬-h¿ÉÒÔÊ¡ÂÔ£¬¼üÈëÃüÁîmysql -uroot -p£¬ »Ø³µºóÌáʾÄãÊäÈëÃÜÂ룬 ......