MySQLÔõôÈÃÁÐĬÈÏֵΪϵͳµ±Ç°Ê±¼ä
ÈçÌ⣬±¾ÈËÊÇMySQLÐÂÊÖ¡£¡£¡£¡£¡£
SQL code: mysql> create table ivykid2002(id int,d1 TIMESTAMP default CURRENT_TIMESTAMP()); Query OK, 0 rows affected (0.08 sec) mysql> insert into ivykid2002 (id) values (1); Query OK, 1 row affected (0.06 sec) mysql> select * from ivykid2002; +------+---------------------+ | id | d1 | +------+---------------------+ | 1 | 2010-01-07 21:10:06 | +------+---------------------+ 1 row in set (0.00 sec) mysql>ÒýÓà MySQL¹Ù·½Îĵµhttp://dev.mysql.com/doc/refman/5.1/zh/index.html Ê®·Ö¸Ðл°æÖ÷£¬½áÌùÁË
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃmysql×Ô´øµÄC API if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0)) { AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£ ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É л ......
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡ лл¸÷λÁË ¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î ±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡ ллÁË ¼Æ»®ÈÎÎñ...php....sql...truncate....OK Äã¾ÍÕâ½ÓÔÚҳà ......
Ҫת³ÉÒ»ÑùµÄЧ¹û£¬ÓÃpowerdesignerÔõôת£¿ÄÜתÂ𣿠create table publishers ( publisherID int identity, publisherName varchar (30) NOT NULL, constraint pk_publishers primary key (publisherID) )& ......
CREATE DATABASE ADDRESSLIST; USE ADDRESSLIST; DROP TABLE IF EXISTS FRIEND; CREATE TABLE FRIEND (FRIEND_ID INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY , FRIEND_NAME VARCHAR(20) NOT N ......