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

MYSQLÏÔʾÃüÁî

 1¡¢ÏÔʾÊý¾Ý¿âÁÐ±í¡£
show databases;
¸Õ¿ªÊ¼Ê±²ÅÁ½¸öÊý¾Ý¿â£ºmysqlºÍtest¡£mysql¿âºÜÖØÒªËüÀïÃæÓÐMYSQLµÄϵͳÐÅÏ¢£¬ÎÒÃǸÄÃÜÂëºÍÐÂÔöÓû§£¬Êµ¼ÊÉϾÍÊÇÓÃÕâ¸ö¿â½øÐкÃ×÷¡£
2¡¢ÏÔʾ¿âÖеÄÊý¾Ý±í£º
use mysql£» £¯£¯´ò¿ª¿â£¬Ñ§¹ýFOXBASEµÄÒ»¶¨²»»áİÉú°É
show tables;
3¡¢ÏÔʾÊý¾Ý±íµÄ½á¹¹£º
describe ±íÃû;
4¡¢½¨¿â£º
create database ¿âÃû;
5¡¢½¨±í£º
use ¿âÃû£»
create table ±íÃû (×Ö¶ÎÉ趨Áбí)£»
6¡¢É¾¿âºÍɾ±í:
drop database ¿âÃû;
drop table ±íÃû£»
7¡¢½«±íÖмǼÇå¿Õ£º
delete from ±íÃû;
8¡¢ÏÔʾ±íÖеļǼ£º
select * from ±íÃû;


Ïà¹ØÎĵµ£º

MYSQLÖÐInnoDBÊÇʲô?

 
Ò»ÖÖ±íÇý¶¯,³ýÁËinnodb»¹ÓÐÆäËüµÄ,ÀýÈçisam,myisamµÈ.
innodbµÄÌØÉ«ÔÚÓÚÖ§³Ö²¢·¢Óë±í¼äÒýÓÃ
MySQLÖ§³Ö¶àÖÖ´æ´¢ÒýÇæ£¬Óû§¿ÉÒÔ·½±ãµÄÑ¡Óò»Í¬µÄ´æ´¢ÒýÇæÀ´Ö§³Ö×Ô¼ºµÄÓ¦Óã¬Ã¿ÖÖ²»Í¬µÄ´æ´¢ÒýÇæ¶¼ÓÐÆä×Ô¼ºµÄÌØÐÔ
InnodbÊÇÆäÖеÄÒ»ÖÖ´æ´¢ÒýÇæ£¬ËüµÄÌØÐÔÊÇÖ§³ÖÊÂÎñ£¬²¢ÇÒ²ÉÓÃ¶à°æ±¾²¢·¢¿ØÖƵķ½Ê½À´Ìá¸ß²¢·¢¶È
Ö÷Òª ......

Mysql½¨±í

½¨Á¢Ò»¸öÖ÷Íâ¼ü¹ØÏµ
create table t_dept(
id int(4) not null, name varchar(50) not null,
primary key(id))type=innodb;
create table t_emp (
id int(6) not null,
name char(255) not null,fk_id int(4) not null,
primary key(id),
foreign key (fk_id) references t_dept (id)) type=innodb; ......

¿ÉÁ¯µÄSun¹«Ë¾£¬ÒòΪÊÕ¹ºÁËMySQL£¬ÏëÂô×Ô¼º¶¼Âô²»ÁËÁË

write by ¾ÅÌìÑãôá(JTianLing) -- blog.csdn.net/vagrxie ÌÖÂÛÐÂÎÅ×é¼°Îļþ ½ñÌì¿´µ½CSDNÉϵÄÒ»ÔòÐÂÎÅ¡¶Å·ÃËÕýʽ·ñ¾ö¼×¹ÇÎÄÊÕ¹ºSun ¼×¹ÇÎľÝÀíÁ¦Õù¡·ºóÕæÊǸÐ̾°¡¡£¡£¡£¡£ SunÒ²ËãÊÇÊ¢¼«Ò»Ê±µÄ´ó¹«Ë¾ÁË£¬ÒòΪJAVAÓïÑÔ¶øÎÅÃûÓÚÊÀ£¬ºóÀ´¹ÉƱ´úÂë¶¼¸Ä³ÉJAVAÁË£¬ËäÈ»JAVAʵ¼ÊÉÏûÓÐΪÆä´øÀ´Ì«¶àµÄÀûÈ󣬵«ÊÇSunÒ²ËãÊÇÄܹ»×Ô¼ ......

linuxÏÂapache£¬php,mysqlÕûºÏtomcat

1.Ç°ÃæÒ»ÆªÎÄÕÂÏêϸ½éÉÜÁËÈçºÎÔÚWindowsÏÂÕûºÏapache+mysql+php+tomcat,ºÜ¼òµ¥£¬µ«ÊÇÔÚLinuxϾÍûÕâôÈÝÒ×ÁË£¬ÐèÒªÊÖ¹¤µÄȥдÅäÖÃÎļþ£¬ÍøÉϵÄ×ÊÁÏÓкܶ࣬µ«ÊÇÎÒ¸ù¾ÝËûÃǵÄд·¨£¬Ò»²½Ò»²½µÄÅäÖû¹ÊÇûÄÜsuccess!£¨¿ÉÄÜÊÇÎÒ¸öÈ˵ÄÔ­Òò£¬²»¹ý£¬ÎÞÂÛÔÚGoogle»¹ÊÇbaiduËѵ½µÄÎÄÕ¾ÍÄÇô¼¸Æª£¬Õâ¸öתһÏ£¬ÄǸöתһÏ£¬×îºó¶¼² ......

LinuxÏÂMysql°²×°ºÍÅäÖÃ2

 LinuxÏÂmysqlµÄ°²×°²½Ö裨·Çrpm°²×°£©
1 ÏÂÔØmysql-standard-5.0.27-linux-i686-glibc23.tar.gz °ü
2 ½âѹµ½°²×°Ä¿Â¼£º tar -zxvf /edass/db/mysql-standard-5.0.27-linux-i686-glibc23.tar.gz
3 ½«  mysql-standard-5.0.27-linux-i686-glibc23Á´½Óµ½mysql : ln –s mysql-standard-5.0.27-linux-i686 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ