MySQL·þÎñÆ÷Æô¶¯¡¢Í£Ö¹¼°Á¬½ÓÃüÁî
MySQL·þÎñÆ÷Æô¶¯ÃüÁîÈçÏ£ºnet start mysql
MySQL·þÎñÆ÷Í£Ö¹ÃüÁîÈçÏ£ºnet stop mysql
MySQL·þÎñÆ÷µÄÁ¬½ÓÃüÁîÈçÏ£º
·½Ê½Ò»£ºmysql -h Ö÷»úÃû -u Óû§Ãû -p Óû§ÃÜÂë
·½Ê½¶þ£ºmysql --host=Ö÷»úÃû --user=Óû§Ãû --password=Óû§ÃÜÂë
ĬÈϵÄÖ÷»úÊÇ£ºlocalhost
Ïà¹ØÎĵµ£º
drop table student;
create table student
(sno int not null unique,
sname varchar(8) not null,
ssex char(2) not null,
sage int ,
sdept varchar(20));
select * from student;
alter table student drop uniq ......
conn.php
<?php
/*
* Created on 2010-1-6
* Author:CHAUVET
* Function:Á¬½Ó×Ö·û´®
*/
$conn=@mysql_connect("localhost","root","")or die("Á¬½ÓÊý¾Ý¿â³ö´í£¡");
mysql_select_db("newdb",$conn);
mysql_query("set names 'gb2312'");
function ReplaceSom ......
MySQLÊÇÒ»¸öÕæÕýµÄ¶àÓû§¡¢¶àÏß³ÌSQLÊý¾Ý¿â·þÎñÆ÷¡£MySQLÊÇÒÔÒ»¸ö¿Í»§»ú/·þÎñÆ÷½á¹¹µÄʵÏÖ£¬ËüÓÉÒ»
¸ö·þÎñÆ÷ÊØ»¤³ÌÐòmysqldºÍºÜ¶à²»Í¬µÄ¿Í»§³ÌÐòºÍ¿â×é³É¡£ÓÉÓÚÆäÔ´ÂëµÄ¿ª·ÅÐÔ¼°Îȶ¨ÐÔ£¬ÇÒÓëÍøÕ¾Á÷Ðбà徎ÓïÑÔPHPµÄÍêÃÀ½áºÏ£¬ÏÖÔںܶàÕ¾µã¶¼ÀûÓÃÆä
µ±×÷ºó¶ËÊý¾Ý¿â£¬Ê¹Æä»ñµÃÁ˹㷺ӦÓᣴ¦ÓÚ°²È«·½ÃæµÄ¿¼ÂÇ£¬ÐèҪΪà ......
mysqlµÄ´æ´¢ÒýÇæÓм¸ÖÖ£¬µ«ÊÇ´Ó5.0¿ªÊ±´ó²¿·ÖÊÇĬÈϲÉÓà innodb´æ´¢ÒýÇæ¡£innodb´æ´¢ÒýÇæÖ§³Ö ÊÂÎñ£¬Íâ¼ü£¬ÐÐÊý¾ÝËø¶¨£¨µ±È»ÊÇÏà¶ÔmyisamµÄ±íËø¶¨£©¡£magento°²×°µÄʱºòÓмì²é mysqlÊÇ·ñÖ§³Öinnodb´æ´¢ÒýÇæ£¬Èç¹û²»Ö§³ÖÔò²»ÄܼÌÐø°²×°¶øÌáʾÈçÏ´íÎ󣬾¡¹Üinnodb´æ´¢²¢Ã»Óб»ÁÐΪ°²×°magentoµÄǰÌáÌõ¼þÖ®Ò»¡£
Database&nbs ......