Converting mySQL query to MS Access query...
Posted: Mon Dec 09, 2002 9:55 pm
Is there an automated way to do this? How about a good faq on the subject? I don't want to have to convert the whole darn thing by hand:
CREATE TABLE ".$table_prefix."links_cat (
id bigint(20) NOT NULL auto_increment,
name text NOT NULL,
hidden tinyint(2) NOT NULL default '1',
owner mediumint(10) NOT NULL default '0',
UNIQUE KEY id (id)
) TYPE=MyISAM
","
CREATE TABLE ".$table_prefix."links_url (
id bigint(20) NOT NULL auto_increment,
url text NOT NULL,
name text NOT NULL,
description text NOT NULL,
added int(11) default NULL,
owner mediumint(8) NOT NULL default '0',
clickcounter int(12) NOT NULL default '0',
lastclickid mediumint(8) NOT NULL default '0',
lastclicktime int(11) NOT NULL default '0',
bbcode_uid varchar(10) NOT NULL default '',
enable_bbcode tinyint(1) NOT NULL default '1',
UNIQUE KEY id (id)
) TYPE=MyISAM
","
CREATE TABLE ".$table_prefix."links_urlincat (
id bigint(20) NOT NULL auto_increment,
url_id bigint(20) NOT NULL default '0',
cat_id bigint(20) NOT NULL default '0',
pos mediumint(10) NOT NULL default '9999',
UNIQUE KEY id (id)
) TYPE=MyISAM
","
INSERT INTO ".$table_prefix."links_cat VALUES (1,'Default','','')
","
INSERT INTO ".$table_prefix."links_url VALUES (1,'www.handykoelsch.de','Handykoelsch','Kölns größtes Mobiltrunkforum. Definitely worth a visit ;)',1021659072,0,0,0,0,0,0)
","
INSERT INTO ".$table_prefix."links_urlincat VALUES (1,1,1,9999)
",
);
CREATE TABLE ".$table_prefix."links_cat (
id bigint(20) NOT NULL auto_increment,
name text NOT NULL,
hidden tinyint(2) NOT NULL default '1',
owner mediumint(10) NOT NULL default '0',
UNIQUE KEY id (id)
) TYPE=MyISAM
","
CREATE TABLE ".$table_prefix."links_url (
id bigint(20) NOT NULL auto_increment,
url text NOT NULL,
name text NOT NULL,
description text NOT NULL,
added int(11) default NULL,
owner mediumint(8) NOT NULL default '0',
clickcounter int(12) NOT NULL default '0',
lastclickid mediumint(8) NOT NULL default '0',
lastclicktime int(11) NOT NULL default '0',
bbcode_uid varchar(10) NOT NULL default '',
enable_bbcode tinyint(1) NOT NULL default '1',
UNIQUE KEY id (id)
) TYPE=MyISAM
","
CREATE TABLE ".$table_prefix."links_urlincat (
id bigint(20) NOT NULL auto_increment,
url_id bigint(20) NOT NULL default '0',
cat_id bigint(20) NOT NULL default '0',
pos mediumint(10) NOT NULL default '9999',
UNIQUE KEY id (id)
) TYPE=MyISAM
","
INSERT INTO ".$table_prefix."links_cat VALUES (1,'Default','','')
","
INSERT INTO ".$table_prefix."links_url VALUES (1,'www.handykoelsch.de','Handykoelsch','Kölns größtes Mobiltrunkforum. Definitely worth a visit ;)',1021659072,0,0,0,0,0,0)
","
INSERT INTO ".$table_prefix."links_urlincat VALUES (1,1,1,9999)
",
);