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£©»òÊý¾Ý²Ö¿âÆæ¼£°ãµÄ»ñµÃ¾Þ´óµÄÐÔÄÜÌáÉý¡£ ......
1.Ç°ÃæÒ»ÆªÎÄÕÂÏêϸ½éÉÜÁËÈçºÎÔÚWindowsÏÂÕûºÏapache+mysql+php+tomcat,ºÜ¼òµ¥£¬µ«ÊÇÔÚLinuxϾÍûÕâôÈÝÒ×ÁË£¬ÐèÒªÊÖ¹¤µÄȥдÅäÖÃÎļþ£¬ÍøÉϵÄ×ÊÁÏÓкܶ࣬µ«ÊÇÎÒ¸ù¾ÝËûÃǵÄд·¨£¬Ò»²½Ò»²½µÄÅäÖû¹ÊÇûÄÜsuccess!£¨¿ÉÄÜÊÇÎÒ¸öÈ˵ÄÔÒò£¬²»¹ý£¬ÎÞÂÛÔÚGoogle»¹ÊÇbaiduËѵ½µÄÎÄÕ¾ÍÄÇô¼¸Æª£¬Õâ¸öתһÏ£¬ÄǸöתһÏ£¬×îºó¶¼² ......
·µ»ØÒ»¸ö½á¹ûÈ«ÊÀ½ç¶¼ÖªµÀÔõô´¦Àí£¬¹Ø¼üÊÇ·µ»Ø¶à¸ö½á¹û¼¯¾Í²»ºÃ°ìÁË£¬ÏÂÃæÓÐÒ»½â¾ö°ì·¨
´æ´¢¹ý³Ì´úÂë
DELIMITER $$;
DROP PROCEDURE IF EXISTS `test`.`sp_test`$$
CREATE PROCEDURE `test`.`sp_test` ()
BEGIN
select * from `user`.`user` limit 0, 50;
select coun ......
1¡¢ÏÔʾÊý¾Ý¿âÁÐ±í¡£
show databases;
¸Õ¿ªÊ¼Ê±²ÅÁ½¸öÊý¾Ý¿â£ºmysqlºÍtest¡£mysql¿âºÜÖØÒªËüÀïÃæÓÐMYSQLµÄϵͳÐÅÏ¢£¬ÎÒÃǸÄÃÜÂëºÍÐÂÔöÓû§£¬Êµ¼ÊÉϾÍÊÇÓÃÕâ¸ö¿â½øÐкÃ×÷¡£
2¡¢ÏÔʾ¿âÖеÄÊý¾Ý±í£º
use mysql£» £¯£¯´ò¿ª¿â£¬Ñ§¹ýFOXBASEµÄÒ»¶¨²»»áİÉú°É
show tables;
3¡¢ÏÔʾÊý¾Ý±íµÄ½á¹¹£º
describe ±í ......
mysqlÎļþµ¼ÈëÂÒÂëÎÊÌâµÄ½â¾ö£º
1 ÃüÁî²ì¿´×Ö·ûÉèÖá£
mysql> show variables like "%char%";
2 ½«²»ÊÇutf-8µÄ¶¼¸Ä³Éutf8¡£Ö»ÓÐfilesystem²»±ä;
| Variable_name | Value
&nb ......