Check code - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Check code

Author

Topic

Jeff00323
Starting Member

1 Post

Posted - 2014-03-25 : 14:08:51

I keep getting errors.

CREATE TABLE admin_price (
price1 float default NULL,
price2 float default NULL,
price3 float default NULL,
price4 float default NULL
) TYPE=MyISAM;

INSERT INTO admin_price VALUES (2,3,5,0);

CREATE TABLE tmp (
TID int(11) NOT NULL auto_increment,
sessid mediumblob,
reg timestamp(14) NOT NULL,
payed int(11) default '0',
ref int(11) default '0',
PRIMARY KEY (TID)
) TYPE=MyISAM;

CREATE TABLE total (
visits int(11) default NULL
) TYPE=MyISAM;

INSERT INTO total VALUES (1);

CREATE TABLE user (
UID int(11) NOT NULL auto_increment,
parent1 int(11) default NULL,
parent2 int(11) default NULL,
email mediumblob,
ip varchar(16) default NULL,
reg_time timestamp(14) NOT NULL,
shows int(11) default '0',
refs int(11) default '0',
PRIMARY KEY (UID)
) TYPE=MyISAM;

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-03-25 : 14:12:19

What dbms are you using? auto_increment? In SQL Server-land, you would use IDENTITY.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources