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

MySQLѧϰ

»ù±¾µÄMySQLÓï¾äºÜ¼òµ¥£¬ÕâÀïÖ÷Ҫ̸̸һЩÈÝÒ×ÒÅÍüµÄ¡£
1.ÈçºÎÉèÖÃ×ֶεÝÔö
create table tb_User(Id int auto_increment
not null primary key,UserName varchar(50),Password varchar(20));
2.²é¿´±í½á¹¹
desc tb_User;
3.ÈçºÎÐ޸ıí½á
ÖØÃüÃû±í£ºalter table tb_User rename
tb_UserInfo;
Ìí¼ÓÒ»ÁУºalter table tb_User add
(Date datetime);
ɾ³ýÒ»ÁУºalter table tb_User drop
column Date;
ÐÞ¸ÄÒ»ÁÐÊôÐÔ£ºalter table tb_User change
UserName UserName varchar(50) not null;£¨Óô˷½·¨¿ÉÒÔÖØÃüÃûÒ»ÁУ©
Ìí¼ÓÖ÷¼ü£ºalter table tb_User add primary key(Ö÷¼ü×Ö¶Î);
Ìí¼ÓË÷Òý£ºalter table tb-User add index(×Ö¶ÎÃû);
4.ÈçºÎ±¸·ÝºÍµ¼ÈëÊý¾Ý¿â
Õâ¸öÎÊÌâÓм¸ÖÖ·½·¨£¬µ«ÊÇÎÒ¸öÈ˸üϲ»¶mysqldump£¬¾Ù¸öÀý×ÓÎÒÏÖÔÚÓÐÒ»¸öÊý¾Ý¿âdb_cmj
ÏÖÔÚÒªÏ뽫Õâ¸öÊý¾Ý¿â¸½¼Óµ½Áíһ̨µçÄÔÉÏ£¬Èç¹ûÁ½Ì¨µçÄÔÍøÂçͨµÄ»°¿ÉÒÔͨ¹ýmysqldumpÃüÁîÖ±½ÓÒ»²¿Íê³É£¬µ«ÊÇÕâÖÖÇé¿öҪעÒâmysql°æ±¾ÎÊÌâ¡£ÎÒÕâÀïÌṩһÖÖͨÓõķ½·¨£¬Ò²ÊǸüÈÝÒ×Àí½âµÄ£ºÊÔÏëÒ»ÏÂÈç¹ûÄãÄܹ»½«ÏÖÔÚÎÒÕą̂µçÄÔÉϵÄdb_cmjÖÐËùÓеÄÐÅÏ¢¶¼±ä³ÉsqlÓï¾ä£¬²¢±£´æµ½Ò»¸öÎļþÖУ¬È»ºóÄÃ×ÅÕâ¸öÎļþµ½Áíһ̨»úÆ÷ÉÏÖ´ÐÐÒÔϲ»¾Í¿ÉÒÔÁËÂð¡£
¾ßÌåÔõô×öÄØ£¿
ÃüÁîÐÐÖÐÊäÈ룺mysqldump -uroot -p db_cmj > db_cmj.sql [»Ø³µ]
ÊäÈëÃÜÂë
¾Í»áÉú³ÉÒ»¸ödb_cmj.sqlÎļþ£¬ÀïÃæ°üº¬ËùÓÐÄãµÄÊý¾Ý¿âÐÅÏ¢£¬Õâ¸öÎļþºÃÏñÔÚC:\Documents and Settings\AdministratorÏÂ
È»ºóÄõ½Õâ¸öÎļþµ½Áíһ̨»úÆ÷ÉÏ£¬ÀýÈç·Åµ½ÄÇ̨»úÆ÷µÄcÅ̸ùĿ¼£¬´ÓÃüÁîÐнøÈëmysqlºóÖ´ÐÐdb_cmj.sqlÖÐsqlÓï¾ä£¬ÕâÀïÎÒÃÇÓÃÅú´¦Àí
Ö´ÐУºsource C:\db_cmj.sql[»Ø³µ]
¾Í»á·¢ÏÖÄãÒѾ­³É¹¦½«Êý¾Ý¿â¿½±´µ½Õą̂»úÆ÷ÉÏÁË£¬¼È·½±ãÓÖÖ±¹Û£¬×îÖ÷ÒªÊÇ¿ÉÒԵõ½sqlÓï¾ä£¬Õâ²ÅÊDZ¾ÖÊ¡£
×¢Ò⣺Õâ¸ö¹ý³Ì×î³£¼ûµÄÒ»¸öÎÊÌâ¾ÍÊÇ£¬±àÂë²»ÕýÈ·£¬ÎÒÃÇÏëÏóµÄÊǿ϶¨ÓõÄÊÇĬÈϱàÂëutf-8,ËùÒÔÔÚÓÃmysqldumpʱ¾Í²»ÓÃÖ¸¶¨±àÂ뷽ʽ£¬¶øÊÂʵÉÏÎÒÃÇÒªÖ¸¶¨£¬¶øÇÒÒªÖÆ¶¨³Élatin1£¬Ò²¾ÍÊÇÃüÁî¸ÄΪ£ºmysqldump -uroot -p db_cmj > db_cmj.sql --default-character-set=latin1¡£Õâ¸öÎÊÌâÍøÉÏÓкܶ࣬µ«ÊÇ´ó¶àÊýûÓиø³öºÜºÃµÄ½âÊÍ¡£
³£¼ûÎÊÌ⣺
1.ÈçºÎ²åÈ뵱ǰÈÕÆÚ
insert into tb_User(UserName ,Password,Date) vlaues('cmj','123',Now());
2.×Ö¶ÎΨһÐÔ
×Ö¶ÎΨһÐÔÓõÄÊÇunique¡£
ÍØÕ¹£º
1.ÈçºÎÀûÓÃMySQLʵÏÖ·ÖÒ³
(¼ÙÉèÒ³ÓÐÎåÌõ¼Ç¼£¬ÏÖÔÚÏÔʾ


Ïà¹ØÎĵµ£º

MySQL³£ÓòÙ×÷»ù±¾²Ù×÷


¹Ø¼ü×Ö: mysql³£ÓòÙ×÷»ù±¾²Ù×÷
MySQL³£ÓòÙ×÷»ù±¾²Ù×÷£¬ÒÔ϶¼ÊÇMySQL5.0ϲâÊÔͨ¹ýÊ×ÏÈ˵Ã÷Ï£¬¼ÇסÔÚÿ¸öÃüÁî½áÊøÊ±¼ÓÉÏ£»£¨·ÖºÅ£©
1.µ¼³öÕû¸öÊý¾Ý¿â
mysqldump -u Óû§Ãû -p --default-character-set=latin1 Êý¾Ý¿âÃû > µ¼³öµÄÎļþÃû(Êý¾Ý¿âĬÈϱàÂëÊÇlatin1)
mysqldump -u wcnc -p smgp_apps_wcnc > wcnc. ......

MySQLÊý¾Ý¿â±¸·ÝºÍ»¹Ô­µÄ³£ÓÃÃüÁî


±¸·ÝMySQLÊý¾Ý¿âµÄÃüÁî
mysqldump -hhostname -uusername -ppassword databasename > backupfile.sql
±¸·ÝMySQLÊý¾Ý¿âΪ´øÉ¾³ý±íµÄ¸ñʽ
±¸·ÝMySQLÊý¾Ý¿âΪ´øÉ¾³ý±íµÄ¸ñʽ£¬Äܹ»Èøñ¸·Ý¸²¸ÇÒÑÓÐÊý¾Ý¿â¶ø²»ÐèÒªÊÖ¶¯É¾³ýÔ­ÓÐÊý¾Ý¿â¡£
mysqldump -–add-drop-table -uusername -ppassword databasename > bac ......

¼Ç¼µã¶«Î÷£¬MSSQL£¬MySQL£¬.NETµÄMD5¼ÓÃÜ

 MSSQL:select Right(sys.fn_VarBinToHexStr(hashbytes('MD5', '123456')),32)
 MSSQL16λ:select Right(sys.fn_VarBinToHexStr(hashbytes('MD5', '123456')),16)
 MySQL:select md5('123456')
 .NET:string ½á¹û×Ö·û´®=System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFil ......

linuxÏÂmysqlµÄʹÓÃ


Æô¶¯mysql:  /etc/rc.d/init.d/mysql start
ÐÞ¸ÄÃÜÂë: ¸ñʽ£ºmysqladmin -uÓû§Ãû -p¾ÉÃÜÂë password ÐÂÃÜÂë
ʹÓÃÃÜÂëµÇ¼:  mysql -u root -p
ÏÔʾÊý¾Ý¿â:  show databases;
Ñ¡ÔñÊý¾Ý¿â:  use Êý¾Ý¿âÃû;
ÏÔʾ±í:  show tables;
ÏÔʾ±í½á¹¹:  descibe ±íÃû;
Ô¶³ÌµÇ¼mysqlÐèÒª¿ªÆôÈ ......

Javaµ÷Óô洢¹ý³Ì(MySqlÊý¾Ý¿â)

Ò»¡¢½¨±í
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `ID` int(11) NOT NULL auto_increment,
  `NAME` varchar(16) NOT NULL default '',
  `REMARK` varchar(16) NOT NULL default '',
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;
&nb ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ