Converting mySQL query to MS Access query...

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
bznutz
Forum Commoner
Posts: 58
Joined: Mon Dec 09, 2002 9:52 pm
Location: Here
Contact:

Converting mySQL query to MS Access query...

Post by bznutz »

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)
",
);
f1nutter
Forum Contributor
Posts: 125
Joined: Wed Jun 05, 2002 12:08 pm
Location: London

Post by f1nutter »

Bad news: You won't be able to use your code directly in Access, because its in PHP for use on a MySQL database.

Good news: You can use MyODBC to connect Access to MySQL. So you will need to create the tables and entries with you code above using PHP, and insert into MySQL.

You can then link to the MySQL db with Access for viewing (updating is a bit akward), or importing for saving in Access.

MyODBC : http://www.mysql.com/downloads/api-myodbc-2.50.html
Post Reply