Windows Ï mysql ±¸·Ý»Ö¸´ÃüÁî
¼ÙÉèmysql °²×°ÔÚc:ÅÌ£¬mysqlÊý¾Ý¿âµÄÓû§ÃûÊÇroot£¬ÃÜÂëÊÇ123456£¬Êý¾Ý¿âÃûÊÇtestdb£¬ÔÚd:Å̸ùĿ¼ÏÂÃæ´æ·Å±¸·ÝÊý¾Ý¿â£¬±¸·ÝÊý¾Ý¿âÃû×ÖΪbackup20070713.sql(20070713.sqlΪ±¸·ÝÈÕÆÚ)
±¸·ÝÊý¾Ý¿â£º
mysqldump -uroot -p123456 testdb>d:/backup20070713.sql
»Ö¸´Êý¾Ý¿â£º
ɾ³ýÔÓÐÊý¾Ý¿â£¬½¨Á¢Êý¾Ý¿â£¬°Ñ±¸·ÝÊý¾Ý¿âµ¼Èë¡£
mysqladmin -uroot -p123456 drop testdb
mysqladmin -uroot -p123456 create testdb
mysql -uroot -p123456 testdb<d:/backup20070713.sql
ÔÚµ¼È뱸·ÝÊý¾Ý¿âÇ°£¬testdbÈç¹ûûÓУ¬ÊÇÐèÒª´´½¨µÄ£»¶øÇÒÓëbackup20070713.sqlÖÐÊý¾Ý¿âÃûÊÇÒ»ÑùµÄ²ÅÄܵ¼Èë¡£
Ïà¹ØÎĵµ£º
MySQL 5.1 ÊÇ MySQL Êý¾Ý¿âÄ¿Ç°·¢²¼µÄ×îеÄÎȶ¨°æ±¾£¨5.5ÊÇbeta״̬£¬6.0ÊÇalpha״̬£©¡£
¸Ã°æ±¾Ôö¼ÓÁ˶ÔÏÂÃ漸¸öƽ̨µÄÖ§³Ö£º
Mac OS X 10.6 x86/x64
HP-UX 11.31 IA64
SLES 11 x86/x64
InnoDB ²å¼þÉý¼¶µ½ 1.0.6 °æ±¾£¬ÁíÍâͨ¹ý¶Ô²éѯ»º´æµÄËéƬÓÅ»¯ÌáÉýÁËÐÔÄÜ£¬¸ü¶àÏêϸµÄÄÚÈÝÇë¿´ÕâÀï¡£
ÏÂÔصØÖ·£ºhttp://dev. ......
mysql ´´½¨±í£º
mysql> create table user(
-> userid int(4) primary key not null auto_increment,
-> username varchar(16) not null,
-> userpassword varchar(32) not null
-> );
create table log(
logid int(4) ......
1¡¢Ìá½»±íµ¥JavascriptÑéÖ¤
<form action="" method="post" name="myform" onsubmit="return CheckPost();">
SCRIPT language=javascript>
function CheckPost()
{
if (myform.user.value=="")
{
alert("ÇëÌîдÓû§");
myform.user.focus();
return f ......
Ò»¹²ÓÐÈý¸öÀࣺWriteFile ; ReadFile ; InsertDB ;
//WriteFile.java
//ÓÃÓÚ½«ÐÅϢдÈëÎı¾Îļþ
package org.mb.insertfromfile;
import java.io.*;
public class WriteFile{
private int count = 0 ;
public int getCount() {
return count;
}
public void setCount(int count) {
this.cou ......
ÔÚÉè¼Æ¹ØϵÊý¾Ý¿âʱÊÇÒª×ñÊØÒ»¶¨µÄ¹æÔòµÄ¡£ÓÈÆäÊÇÊý¾Ý¿âÉè¼Æ·¶Ê½ÏÖ¼òµ¥½éÉÜ1NF£¨µÚÒ»·¶Ê½£©£¬2NF£¨µÚ¶þ·¶Ê½£©£¬3NF£¨µÚÈý·¶Ê½£©ºÍBCNF£¬ÁíÓеÚËÄ·¶Ê½ºÍµÚÎ巶ʽÁôµ½ÒÔºóÔÙ½éÉÜ¡£ÔÚÄãÉè¼ÆÊý¾Ý¿â֮ʱ£¬ÈôÄÜ·ûºÏÕ⼸¸ö·¶Ê½£¬Äã¾ÍÊÇÊý¾Ý¿âÉè¼ÆµÄ¸ßÊÖ¡£
µÚÒ»·¶Ê½£¨1NF£©£ºÔÚ¹ØϵģʽRÖеÄÿһ¸ö¾ßÌå¹ØϵrÖУ¬Èç¹ûÿ¸öÊôÐÔÖµ¶¼Ê ......