mysql...
ÔÚMySQLµÄÖ¸Áî´°ÀïÃæÊäÍêÃÜÂëºó È»ºóÉÁÒ»ÏÂÖ¸Áî´°¾ÍûÁË
ʲôÔÒò°¡£¿
ÐÂÊÖ°¡ Íü¸÷λǰ±²Ö¸µ¼Ó´¡£¡£¡£
ÎÊ´íµØ·½ÁË£¬È¥MYSQL°æ£¡
ÔÚÔËÐÐÖÐÊäÈëcmdºó,ÔÚÓÃnet start mysql
Ŷ лÀ²¡£¡£
Ïà¹ØÎÊ´ð£º
MySqlÖвåÈ뵱ǰʱ¼äµÄ¸ÃÔõôд°¡£¿
now()
SQL code:
sqlÀïÊÇ£º
getdate()
ÒýÓÃ
now()
ѧϰ
SQL code:
select now();
SQL code:
TODAY()
?
SQL code:
select now();
/* ......
ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£ºError 1305.Error reading from file C:DOCUME~1\LOCALS~1\Temp\mysql_server.msi.Verify that the file exists and that you can access it.
¿ ......
MySQLÈëÃÅ
¿ÉÒÔÏÈ¿´Ê²Ã´Êé¼®°¡£¿
ÏȶÁÈý±é¡¶Êý¾Ý¿âϵͳ¸ÅÂÛ¡·,ÕÆÎÕÊý¾Ý¿âµÄ»ù´¡ÀíÂÛ¡£
È»ºóÔÙ´Ö¿´Ò»±éMYSQLµÄ¹Ù·½Îĵµ¡£ MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc/refman/5.1/zh/index.html
¾ÍÕÒÒ»±¾ºÜ»ù´ ......
SQL code:
SET NAMES 'gb2312'
drop table if exists t_course;
create table t_course(
id int(11) not null auto_increment,
name varchar(50) default null,
primary key(id)
)ENGINE=InnoDB AUTO_INCR ......