Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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½øÐйØÁªµÄÒ»¶Ô¶à¹Øϵ¡£
²ÎÕÕÍêÕûÐÔ


Ïà¹ØÎĵµ£º

mysqlÐÔÄÜÓÅ»¯2

 MySQL´Ó4.1¿ªÊ¼Ö§³ÖSQLµÄ×Ó²éѯ¡£Õâ¸ö¼¼Êõ¿ÉÒÔʹÓÃSELECTÓï¾äÀ´´´½¨Ò»¸öµ¥ÁеIJéѯ½á¹û£¬È»ºó°ÑÕâ¸ö½á¹û×÷Ϊ¹ýÂËÌõ¼þÓÃÔÚÁíÒ»¸ö²éѯÖС£ÀýÈ磬ÎÒÃÇÒª½«¿Í»§»ù±¾ÐÅÏ¢±íÖÐûÓÐÈκζ©µ¥µÄ¿Í»§É¾³ýµô£¬¾Í¿ÉÒÔÀûÓÃ×Ó²éѯÏÈ´ÓÏúÊÛÐÅÏ¢±íÖн«ËùÓз¢³ö¶©µ¥µÄ¿Í»§IDÈ¡³öÀ´£¬È»ºó½«½á¹û´«µÝ¸øÖ÷²éѯ£¬ÈçÏÂËùʾ£º
DELETE from ......

aspºÍmysql·ÖÒ³´úÂë

 <!--#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¡¢Apache¡¢PhpµÄжÔØ (Linux)

 Ð¶ÔØMysql
[root@localhost ~]# rpm -qa | grep mysql
mysql-3.23.58-9
php-mysql-4.3.4-11
mod_auth_mysql-20030510-4.1
mysql-server-3.23.58-9
˵Ã÷£ºrpm –qa | grep mysql ÃüÁîÊÇΪÁË°ÑmysqlÏà¹ØµÄ°ü¶¼ÁгöÀ´£¬Ð¶Ôض¼´Ó×îÏÂÃæµÄÒ»¸ö°ü¿ªÊ¼£¬Ö±µ½Ð¶ÔصôµÚÒ»¸öΪֹ¡£Ö´ÐÐrpm -q php£¬Èç¹û·µ»Øphp°æ±¾£¬ ......

MySQL ÃüÁîÐÐ

 MySQL ÃüÁîÐÐ
µÚÒ»ÕС¢mysql·þÎñµÄÆô¶¯ºÍÍ£Ö¹
net stop mysql
net start mysql
µÚ¶þÕС¢µÇ½mysql
Óï·¨ÈçÏ£º mysql -uÓû§Ãû -pÓû§ÃÜÂë
¼üÈëÃüÁîmysql -uroot -p£¬ »Ø³µºóÌáʾÄãÊäÈëÃÜÂ룬ÊäÈë12345£¬È»ºó»Ø³µ¼´¿É½øÈëµ½mysqlÖÐÁË£¬mysqlµÄÌáʾ·ûÊÇ£º
mysql>
×¢Ò⣬Èç¹ûÊÇÁ¬½Óµ½ÁíÍâµÄ»úÆ÷ÉÏ£¬ÔòÐèÒª¼ÓÈ ......

mysqlÓÃjdbcÁ¬½Ó

Ê×ÏÈ·ÅÖúÃjdbcÇý¶¯³ÌÐò£¬ÔÚ java\jre6\lib\ext\Ï£¬java\jdk1.6\jre\libµÈµØ·½¶¼·ÅÆðÀ´£¬ÒòΪ²»È·¶¨ÔÚÄÄÀïÓÐÓ÷··
Class.forName("com.mysql.jdbc.Driver").newInstance();
 String url = "jdbc:mysql://localhost/DATABASENAME?user=USERNAME&password=PASSWORD&useUnicode=tru ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ