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
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
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 kil
I got a gift certificate for book store. I am looking for good MySql
books with reference, examples, etc? Anyone have some ideas on good
books to look at
Chuck
=
"Incoming rounds always have the right of way"
- Rules of War
-
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)
http://lists.mysql.co
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 P
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 [fo
