Hello.
These links could be helpful:
http://dev.mysql.com/doc/mysql/en/export-of-data.html
http://dev.mysql.com/doc/mysql/en/mysql-tools-with-access.html
For more information search in archives at:
http://lists.mysql.com/mysql
nephish [EMAIL PROTECTED] wrote:
Well thanks, these look as if to be exactly what i have been looking
for. will test this stuff out when i get to work, thanks again.
On Tue, 2005-07-12 at 10:10 +0300, Gleb Paharenko wrote:
Hello.
These links could be helpful:
http://dev.mysql.com/doc/mysql/en/export-of-data.html
odbc driver for your MySQL database on your windows machine.
export tables in access to odbc source that you created
On Mon, 11 Jul 2005, nephish wrote:
Hello there
i need to import an entire database or find a way to get all the info in
a microsoft access .mdb database into a MySQL
At 15:33 -0800 2/25/02, Bob Rea wrote:
I'm getting a syntax error when I try to insert more two
sets of values into a table.
I have looked at the manual on the insert statement, and
don't see what is wrong.
The error message indicates that the problem is at the word values.
The problem with
On Tuesday, 26. February 2002 00:33, Bob Rea wrote:
I'm getting a syntax error when I try to insert more two
sets of values into a table.
I have looked at the manual on the insert statement, and
don't see what is wrong.
ERROR 1064: You have an error in your SQL syntax near
'values(
Get rid of the second values.
mysql INSERT into book(
- isbn,
- title,
- authlname,
- authfname,
- publisher,
- pubdate,
- dewey,
- lcnum
- )
- values (
- '1-56592-434-7',
- 'MySQL mSQL',
- 'Yarger',
- 'Randy Jay',
- O'Reilly,
-
Change it to
INSERT into book(
isbn,
title,
authlname,
authfname,
publisher,
pubdate,
dewey,
lcnum
)
values (
'1-56592-434-7',
'MySQL mSQL',
'Yarger',
'Randy Jay',
O'Reilly,
null,
null,
null
),
Bob,
This is just a guess, but looking at
http://www.mysql.com/doc/I/n/Insert_speed.html it appears that the way
to do multiple inserts looks like:
INSERT INTO a VALUES (1,23),(2,34),(4,33);
a(col1, col2).. Perhaps multiple inserts requires that you specify all
columns in the order that the
]
To: daniel [EMAIL PROTECTED]
Sent: Monday, February 25, 2002 4:40 PM
Subject: Re: Beginner needs help
On Monday 25 February 2002 03:51 pm, you wrote:
my $0.02:
insert into TABLE (booknum, isbn, title) values ('001',
'1-56592-434-7', 'MySQL mSQL');
you want to keep all your field names
[ (coloumn...) ] SELECT ...
OR
use a LOAD DATA and import a text file.
hope that helps
- Original Message -
From: Bob Rea [EMAIL PROTECTED]
To: daniel [EMAIL PROTECTED]
Sent: Monday, February 25, 2002 4:40 PM
Subject: Re: Beginner needs help
On Monday 25 February 2002 03
10 matches
Mail list logo
