command line interface for entering sql in access?

[johnmerlino]

Hey all,

Is there a way to use mysql syntax in a command line interface in access, despite it not using mysql as its database? I'm looking to do two things:

Compare a table with a temporary table to only show records in the table where it and the temp table have certin fields that match and where the temp table has a specific field set to a condition:

Select contacts.first_name, contacts.last_name, contacts.mi, contacts.address FROM contacts INNER JOIN temp_table ON (c.last_name = t.last_name && c.first_name = t.first_name) WHERE temp_table.prop = 'real';

The other thing is two compare two tables and where last names and first names are the same, change a field of one table and update another field:

UPDATE contacts c
INNER JOIN temp_table t
ON (c.last_name = t.last_name && c.first_name = t.first_name)
SET c.status_change = 1,
c.updated_at = CURDATE()
WHERE c.updated_at IS NOT NULL;

Then I would like to save these sql statements in access for later use, using the Access built-in gui.



Is this possible?

Thanks for response.

[ajetrumpet]

Hey all,

Is there a way to use mysql syntax in a command line interface in access, despite it not using mysql as its database?

what do you mean by this? the code example you posted looks like a PHP/MYSQL command. mysql is nothing more than a different syntax for sql, which is universal for all databases.

for example, translating your mysql code example into the Access version of sql, you would write:

UPDATE contacts ( c )
INNER JOIN temp_table ( t )
ON (c.last_name = t.last_name)
SET c.status_change = 1,
c.updated_at = date()
WHERE c.updated_at IS NOT NULL;

that of course it just temp code, as the syntax is not entirely correct. But then again, what do you mean by your first statement?

[NoellaG]

Hi John,

I think, for your purpose, you'd better be off with Toad as an interface on mySQL. Check out this link (it's free for mySQL):

www.quest.com/toad-for-mysql