Trying to automate database table creating

[dt_gry]

Hi guys,

 

I am trying to automate database table creation using database.sql (executing in puTTY) and I am getting

the following error

 

./database.sql: line 1: syntax error near unexpected token `('

./database.sql: line 1: `CREATE TABLE 'users' ('

 

Here is my code:

 

CREATE TABLE 'users' (
  'id' int(11) NOT NULL auto_increment,
  'username' varchar(30) NOT NULL default '',
  'password' varchar(40) NOT NULL default '',
  'email' varchar(140) NOT NULL default '',
  'regdate' int(10) NOT NULL default '0',
  'ip' varchar(15) NOT NULL default '',
  'lastdate' int(10) NOT NULL default '0',
  PRIMARY KEY  ('id')
);

CREATE TABLE 'forgot' (
  'username' varchar(30) NOT NULL default '',
  'password' varchar(40) NOT NULL default '',
  'email' varchar(140) NOT NULL default '',
  'regdate' int(10) NOT NULL default '0',
  'ip' varchar(15) NOT NULL default ''
);

 

Any ideas?

 

Thanks

dt_gry

[lonewolf217]

I dont think you need the single quotes around 'users'

[F1Fan]

Yes, I believe that when you're referring to table and column names, you use "double quotes" and when referring to data, you use 'single quotes.'

[Stooney]

I don't believe you need any of the single quotes.  You can however use backdrops (`) where needed.

[dt_gry]

That didn't work.

 

New CODE

CREATE TABLE "users" (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(30) NOT NULL default ``,
  `password` varchar(40) NOT NULL default ``,
  `email` varchar(140) NOT NULL default ``,
  `regdate` int(10) NOT NULL default `0`,
  `ip` varchar(15) NOT NULL default ``,
  `lastdate` int(10) NOT NULL default `0`,
  PRIMARY KEY  (`id`)
);

CREATE TABLE "forgot" (
  `username` varchar(30) NOT NULL default ``,
  `password` varchar(40) NOT NULL default ``,
  `email` varchar(140) NOT NULL default ``,
  `regdate` int(10) NOT NULL default `0`,
  `ip` varchar(15) NOT NULL default ``
);

 

 

Thanks

dt_gry

[Stooney]

You're problem lies with default.  You need to specify a value like this:

regdate int(10) NOT NULL default '0'

 

So here's working code, without defaults

CREATE TABLE users (
  id int(11) NOT NULL AUTO_INCREMENT,
  username varchar(30) NOT NULL,
  password varchar(40) NOT NULL,
  email varchar(140) NOT NULL,
  regdate int(10) NOT NULL,
  ip varchar(15) NOT NULL,
  lastdate int(10) NOT NULL,
  PRIMARY KEY  (id)
);

CREATE TABLE forgot (
  username varchar(30) NOT NULL,
  password varchar(40) NOT NULL,
  email varchar(140) NOT NULL,
  regdate int(10) NOT NULL,
  ip varchar(15) NOT NULL  
);

[dt_gry]

Thanks chrisdburns, but I got the same error with the code you gave me. Any more ideas.

 

Thanks

dt_gry

[F1Fan]

What happens when you try this:

 

CREATE TABLE "users" (
  "id" int(11) NOT NULL AUTO_INCREMENT,
  "username" varchar(30) NOT NULL,
  "password" varchar(40) NOT NULL,
  "email" varchar(140) NOT NULL,
  "regdate" int(10) NOT NULL,
  "ip" varchar(15) NOT NULL,
  "lastdate" int(10) NOT NULL,
  PRIMARY KEY  ("id")
);

CREATE TABLE "forgot" (
  "username" varchar(30) NOT NULL,
  "password" varchar(40) NOT NULL,
  "email" varchar(140) NOT NULL,
  "regdate" int(10) NOT NULL,
  "ip" varchar(15) NOT NULL  
);

[dt_gry]

./database.sql: line 1: syntax error near unexpected token `('

./database.sql: line 1: `CREATE TABLE "users" ('

 

[Stooney]

The code I posted ran fine in phpMyAdmin.

[F1Fan]

Yeah, it looks perfectly fine. Copy exactly what you're running and paste it here so we can see it. Maybe you're missing one little character that you're not seeing, but we will.

[dt_gry]

I am going into putty and doing this

 

I login

I go to the directory where database.sql is located

lastly I type ./database.sql

 

I thought I might be executing it wrong but wasn't sure.

 

Thanks Guys,

dt_gry