I have downloaded the ODBC driver and while I am fumbling [still
reading] about that the reference it makes if for *.MDB similar
extensions. I have cruised through the on-line manual and still
have no idea how to create one of those type extensions with a
MySql database.
I am sure it is in
What I did was setup my file in mysql directory (i.e. fred.txt)
LOAD DATA INFILE C:\\mysql\\fred.txt INTO TABLE data_table;
Hope this helps, but only a workaround...
Chuck
http://68.43.100.7:81/aa8vs
==
Patriotism is the willingness to kill and
be
Please see last line comments text null,
I do not believe you need the ',' between the
End of statement and the ')'
Try this:
create table guestbook
(
name varchar( 40 ) null,
location varchar( 40 ) null.
email varchar( 40 ) null,
url varchar( 40 ) null,
comments text null
)
;
Regards,
Chuck
To the MySQL group!Happy 2003 and have a safe holiday season...
Hopefully this got past the filter LOL
Chuck
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
I am new at this, but if listings and agents are both tables
I do not see a reference in the select statement:
select name, count(*) as cnt
from agents as p1, listings as p2
where p1.name = p2.agent;
Or something like that
Chuck
http://68.43.100.7:81/aa8vs
Did you also check directory permissions? What system are you using?
Chuck
http://68.43.100.7:81/aa8vs
==
Patriotism is the willingness to kill and
be killed for trivial reasons.
- Bertran Russell
-Original Message-
From: sam [mailto:[EMAIL
Yves,
I am always open for cleaner method, but what I did was in MySQL created
a table 'member' for data.
In Access exported as .txt make sure tab sequential.
Back in MySql I made database active that had 'member'
And did a:
mysql load data infile c:\\mysql\\tmp.txt into member;
it actually
I have some Access pages hooked to web, but a newbe with this [mysql] on
laptop. Running NT, windows office '98. I have found some stuff going
through tutorial, which I am impressed at how much is really working
right out of the book. I am sure has been found. but
I was not able to get