Results 1 to 2 of 2
Related
-
create table in mysql from php forms Forum: PHP Forum
Replies: 2 -
To create table in photoshop Forum: CSS Forum
Replies: 3 -
Table width in myspace changing the wrong bit?!! Forum: Myspace Forum
Replies: 0 -
create a table along the width of the sheet Forum: General Discussion
Replies: 1 -
This is about a create database table? Forum: PHP Forum
Replies: 1
-
10-04-2011, 03:50 AM #1
Is there anything wrong with my create table statement?
Hi guys,
I have an sql query which mysql is giving error:
Code:CREATE TABLE '42011-10-04 08:10:37'(`id` INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(`id`),`url_string` VARCHAR(100),`loadtime` float(10),`comment` VARCHAR(160),`urlflag` INT NOT NULL DEFAULT '0')
Code:ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' 42011-10-04 08:10:37'(`id` INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(`id`),`url_' at line 1
Regards,
Ramki
-
10-04-2011, 11:03 AM #2
Re: Is there anything wrong with my create table statement?
Please use this:
PHP Code:CREATE TABLE `42011-10-04 08:10:37` (`id` INT(10) NOT NULL AUTO_INCREMENT,
`url_string` VARCHAR(100),
`loadtime` float(10),
`comment` VARCHAR(160),
`urlflag` INT NOT NULL DEFAULT '0',
PRIMARY KEY(`id`), KEY `id` (`id`));
Checkout my porfolio.
Please click thebutton when a member helped you.
Take time to use Forum's Search function.
Cloudjiffy- PaaS for Developers
10-05-2020, 12:30 AM in Web Hosting Forum