Programming Forums - View Single Post

Intimidat0r · Jul 31st, 2005, 7:44 PM

if i have a file like hello.sql and this code in it:

CREATE TABLE hello (
     somevar int(10) NOT NULL,
     somevar2 varchar(11) NOT NULL,
     valid_until datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
     somevar3 varchar(11) NOT NULL,
     somevar4 int(10) NOT NULL
);

then what's up with the valid_until datetime line? im tryting to manually do everything instructed here using phpMyAdmin because my commercial server im using doesn't let you execute query files like this so how would i do that line in phpMyAdmin? (or at least, what the hell does it mean)

Jul 31st, 2005, 7:44 PM	#1
Intimidat0r Hobbyist Programmer Join Date: May 2005 Location: Don't know, but the padded walls are a nice touch. Posts: 126 Rep Power: 0	mySQL query file if i have a file like hello.sql and this code in it: (Toggle Plain Text) CREATE TABLE hello ( somevar int(10) NOT NULL, somevar2 varchar(11) NOT NULL, valid_until datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, somevar3 varchar(11) NOT NULL, somevar4 int(10) NOT NULL ); CREATE TABLE hello ( somevar int(10) NOT NULL, somevar2 varchar(11) NOT NULL, valid_until datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, somevar3 varchar(11) NOT NULL, somevar4 int(10) NOT NULL ); then what's up with the valid_until datetime line? im tryting to manually do everything instructed here using phpMyAdmin because my commercial server im using doesn't let you execute query files like this so how would i do that line in phpMyAdmin? (or at least, what the hell does it mean) __________________ Children in the dark cause accidents, and accidents in the dark cause children. http://www.ronincoders.org