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.h
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:
> He
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 database
;
>
> the only other way to do it would be to
> import the data from another database like this:
> INSERT INTO table [ (coloumn...) ] SELECT ...
>
> OR
>
> use a LOAD DATA and import a text file.
>
> hope that helps
>
>
> - Original Message -
>
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:51 pm, you wrote:
> > my $0.02:
> &
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 t
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
),
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',
->
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
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 wi
I can answer numb 1. for you but not 2. Look up the manual for mysqldump
and load infile (or something like that, I have to check the manual myself
but I have no time to do that for you).
The other (and probably easier way) is to upgrade your Cobalt machine and
then upgrade your tables from ISM
11 matches
Mail list logo
