/*!40101 SET NAMES utf8 */;/*!40101 SET SQL_MODE=''*/;create database if not exists `buy`;USE `buy`;/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' *//*Table structure for table `uadd` */DROP TABLE IF EXISTS `uadd`;CREATE TABLE `add` (
`ADDID` int(11) NOT NULL,
`TYPE` varchar(20) default NULL,
`COIN` int(11) default NULL,
`DATETIME` datetime default NULL,
`USERID` int(11) default NULL,
PRIMARY KEY (`ADDID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
GO
IF EXISTS(
SELECT * FROM sysobjects
WHERE xtype='U'
AND name='uadd'
)
DROP TABLE uadd;
GOCREATE TABLE add (
ADDID int NOT NULL PRIMARY KEY,
TYPE varchar(20) default NULL,
COIN int default NULL,
DATETIME datetime default NULL,
USERID int default NULL
) ;
?
add用[]就行了use ..
goif object_id('表','u') is not null--判斷存在刪除
drop table 表create table --再建