2013/12/30 13:59 +0200, Cabbar Duzayak
We have a basic table, which is something like :
(id varchar50, productId varchar50, category varchar50)
In this table, ID is the primary key and we have a unique index on
(category, productId). And, there is a case where we want to do bulk
inser
Ah, forgot to mention that table is INNODB.
On Mon, Dec 30, 2013 at 1:59 PM, Cabbar Duzayak wrote:
> Hi,
>
>
> We have a basic table, which is something like :
>
>
> (id varchar50, productId varchar50, category varchar50)
>
>
> In this table, ID is the primary key and we have a unique index on
Hi,
We have a basic table, which is something like :
(id varchar50, productId varchar50, category varchar50)
In this table, ID is the primary key and we have a unique index on
(category, productId). And, there is a case where we want to do bulk
inserts (3000 inserts) using:
INSERT INTO (id,
On 2/14/2012 10:30 AM, cars...@bitbybit.dk wrote:
On 14.02.2012 10:20, Alex Schaft wrote:
Hi,
I need to update a table along the lines of the following
update table set LastUpdate=now(), UpdateSource='Abc' Where Key1 = 'Def'
and Key2 = 'ghi'
I need to possible do anywhere from 2 to 20 of the
On 14.02.2012 10:20, Alex Schaft wrote:
Hi,
I need to update a table along the lines of the following
update table set LastUpdate=now(), UpdateSource='Abc' Where Key1 =
'Def'
and Key2 = 'ghi'
I need to possible do anywhere from 2 to 20 of these. Would it be
better
to call an update statem
ch of these,
or should I do a batch INSERT with ON DUPLICATE KEY UPDATE?
Going to try both ways now, but was wondering what would be the best
"internally" my instincts tell me the latter.
Thanks,
Alex
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Saturday, August 8, 2009, DAREKAR, NAYAN (NAYAN)
> wrote:
>> Hi Guys,
>>
>> I need a help, as i am new to mysql and i want to create a batch file that
>> can truncate table and Load (LOAD DATA INFILE) one .csv file which is
>> generated every 2min into that table.
mysql and i want to create a batch file that
> can truncate table and Load (LOAD DATA INFILE) one .csv file which is
> generated every 2min into that table.
> I have created one batch file where i can only able to login into databse,
> further my commands are not working the code
Hi Guys,
I need a help, as i am new to mysql and i want to create a batch file that can
truncate table and Load (LOAD DATA INFILE) one .csv file which is generated
every 2min into that table.
I have created one batch file where i can only able to login into databse,
further my commands are
Thanks, much better.I appended '| mysql' to each line but I am not sure what
you mean by 'then call it' I ran the batch file and tried using source
batch.bat but no joy. What am I missing?
Thanks again
--
Dave
2009/3/19 Gary Smith
> Dir /b
> Sent via BlackBerry
Hi David,
Why not use a FOR loop in a batch file?
This post seems to be doing the same thing, using MS SQL Server:
http://bytes.com/topic/windows/answers/647680-xp-batch-file-loop-help
Andy
David Scott wrote:
Thanks for responding Gary
I get:
---
Volume in
> Dir *.sql > my.bat
>
> Edit batch file for each line to append "| mysql"
>
> Call batch file
>
>
> Sent via BlackBerry by AT&T
>
> -Original Message-
> From: David Scott
>
> Date: Thu, 19 Mar 2009 11:08:28
> To:
> Subject: Mu
HeyaI have folders of sql files which, when there were a few, I executed
using "source d:\folder\file.sql"I now I have 100's, so is there a way to do
"source d:\folder\*.sql" (which sadly does not work) ?
How would you go about automating this?
The DB is running on a windows box.
Thanks for any
In C API, I want to insert 1 sql.
I must have one strSql= insert into tables hello id ,blob
values(?,?),(?,?),(?,?)..。
then bind every pos with mysql_stmt_bind_param（）.
then to exec.
In C API don't have batchexec。
if I can have strSQL = inset into tables hello id,blob values1
Baumann, Michael schrieb:
Hi there,
I got a quite weird problem. Trying to update a table via a batch shell
script that looks like this
while read AAA BBB
do
mysql -u $DBUSER --password=$DBPASS --batch "--execute=update
^
i guess
Hi there,
I got a quite weird problem. Trying to update a table via a batch shell
script that looks like this
while read AAA BBB
do
mysql -u $DBUSER --password=$DBPASS --batch "--execute=update
XY_Table \
set Column1 ='"$BBB"' where Column2 = '"
I just want to see the original insert statement which failed, so that I can
do a search on it.
Is there any option for seeing the insert statement that gets executed and
the error line next to next.?
On 10/5/07, Baron Schwartz <[EMAIL PROTECTED]> wrote:
>
> Arun wrote:
> > I
On Friday 05 October 2007 16:50, Arun wrote:
> Baron,
> I am sourcing it. I do not know if that is the best way though.. I am
> running the insert statement from a mysql prompt in a linux/windows
> machine.
> My script has a single build script which sources other scripts.
> build.sql
> ==
> s
see last run errors, like some errors that
are saved in the buffer. As I know this is the last sql statement that gets
executed.
On 10/5/07, Baron Schwartz <[EMAIL PROTECTED]> wrote:
>
> Arun wrote:
> > I have a large batch of insert sql statements, of which some of them are
>
Arun wrote:
I have a large batch of insert sql statements, of which some of them are
failing. I want to know which one is failing exactly.
Is there anyway I can debug it and which statement went wrong. I have only
4 or 5 out of 200 statements that are failing.
It depends on how you're ru
I have a large batch of insert sql statements, of which some of them are
failing. I want to know which one is failing exactly.
Is there anyway I can debug it and which statement went wrong. I have only
4 or 5 out of 200 statements that are failing.
--
Thanks
Arun George
On Wed, May 2, 2007 08:55, Mogens Melander wrote:
>
> On Tue, May 1, 2007 22:15, Brown, Charles wrote:
>>
>> Because I am running on batch mode therefore I'm trying to direct my
>> session output to a file -- meaning stdout. But I'm having a problem.
>> For
On Tue, May 1, 2007 22:15, Brown, Charles wrote:
>
> Because I am running on batch mode therefore I'm trying to direct my
> session output to a file -- meaning stdout. But I'm having a problem.
> For instance this input: "use test_db" gave me no output but this
Because I am running on batch mode therefore I'm trying to direct my
session output to a file -- meaning stdout. But I'm having a problem.
For instance this input: "use test_db" gave me no output but this input
"show tables" gave me an output.
What is missing, w
Tompkins wrote:
Hi
I've am updating a database with about 20,000 records. What is the best way to perform these updates. Can I use batch updating ?
Thanks
Neil
_
Be one of the first to try Windows Live Mail.
http://ideas.liv
Hi
I've am updating a database with about 20,000 records. What is the best way to
perform these updates. Can I use batch updating ?
Thanks
Neil
_
Be one of the first to try Windows Live Mail.
http://ideas.liv
On 5/10/06, kamaya <[EMAIL PROTECTED]> wrote:
Hi,
I want to install mysql 5.0 in batch mode.
That is, I want to avoid interaction with windows while installing mysql
5.0.
Is there anyone who has an idea?
I have used NSIS from Nullsoft to create a custom install of MySQL,
just cre
Hi,
I want to install mysql 5.0 in batch mode.
That is, I want to avoid interaction with windows while installing mysql
5.0.
Is there anyone who has an idea?
Hi Jeff, all!
Jeff Drew wrote:
Sporadically, the last few entries of a batch are not written. I'm writing
to a mysql database using JDBC. Here's a short version of my code. Does
anyone have suggestions on possible causes or other diagnostics?
I do not claim any JBDC knowledge,
Sporadically, the last few entries of a batch are not written. I'm writing
to a mysql database using JDBC. Here's a short version of my code. Does
anyone have suggestions on possible causes or other diagnostics?
class DatabaseWriter{
int writeCount=0;
public Data
nd tighten the permissions on *that* file.
[client]
password=Your password goes here
I tried that; it does work with mysql but does not appear to work with
mysqldump.
Is there a way to supply the password to mysqldump when running dump
from a
batch scipt and avoid showing it on the command line?
Th
> > password=Your password goes here
>
> I tried that; it does work with mysql but does not appear to work with
> mysqldump.
>
> Is there a way to supply the password to mysqldump when running dump from a
> batch scipt and avoid showing it on the command line?
>
> Thank
sqldump.
Is there a way to supply the password to mysqldump when running dump from a
batch scipt and avoid showing it on the command line?
Thanks in advance
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
ht
Hi.
Remove ';' from the end of the line.
[EMAIL PROTECTED] wrote:
> [-- text/plain, encoding 8bit, charset: US-ASCII, 22 lines --]
>
> I am trying to utilize MySQL's batch execution functionality by using build scripts
> to create tables in my database (ref:
Hi.
System error: 2 = No such file or directory
Check if file exists. Do you have permissions to read this file?
[EMAIL PROTECTED] wrote:
> [-- text/plain, encoding 8bit, charset: US-ASCII, 22 lines --]
>
> I am trying to utilize MySQL's batch execution functionality
I am trying to utilize MySQL's batch execution functionality by using build scripts to
create tables in my database (ref:
http://dev.mysql.com/doc/mysql/en/Batch_Commands.html )
Is it possible to execute additional source files from within a source file from the
MySQL command line
wever, the syntax of your open statement still does not work for me. I
> get a SQL syntax error any time I try combining statements with
Semicolons.
> Since I've been programming using SQL Server for a while now I feel like
I
> SHOULD be able to issue commands in this way but somewhe
mySQL prevents batch queries on purpose.
<[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> For multiple statements in one submission, have you tried using a
> semicolon ; not a comma , ?
> (http://dev.mysql.com/doc/mysql/en/Entering_queries.html)
>
> Each comma
54:27 AM:
> I'm writing my first MySQL app in VB.net using myODBC. However I think
this
> question applies to all languages using MySQL. From what I understand,
I
> am unable to issue a batch statement of commands separated by commas to
> mySQL. I receive an error whenever I
eff Burgoon wrote:
> > I'm writing my first MySQL app in VB.net using myODBC. However I think
this
> > question applies to all languages using MySQL. From what I understand,
I
> > am unable to issue a batch statement of commands separated by commas to
> > mySQL. I re
Jeff Burgoon wrote:
> > I'm writing my first MySQL app in VB.net using myODBC. However I think
this
> > question applies to all languages using MySQL. From what I understand,
I
> > am unable to issue a batch statement of commands separated by commas to
> > mySQL. I r
le to issue a batch statement of commands separated by commas to
mySQL. I receive an error whenever I try to do so from my app. For this
reason, I am unable to make use of SQL variables and temporary tables. I
must instead use persistant tables.
Can anyone tell me if this is in fact the case and
I'm writing my first MySQL app in VB.net using myODBC. However I think this
question applies to all languages using MySQL. From what I understand, I
am unable to issue a batch statement of commands separated by commas to
mySQL. I receive an error whenever I try to do so from my app. For
Version 5.x contains the ability to use stored procedures and logic. You
could also look into using lua as your scripting language for MySQL.
-Original Message-
From: Lourenço de Paula
To: [EMAIL PROTECTED]
Sent: 6/15/04 11:54 AM
Subject: Re: Batch Script
Thanks, but can not I use a
Thanks, but can not I use a MySQL native script language like in MS Sql
Server and Oracle?
- Original Message -
From: "George Chelidze" <[EMAIL PROTECTED]>
To: "Lourenço de Paula" <[EMAIL PROTECTED]>
Sent: Tuesday, June 15, 2004 1:23 PM
Subject: Re: Bat
Hi,
In my database I've a table with a field that control de version of may tables, now I
need to make a script to update my tables and I would like to make something like that:
DECLARE
i number;
BEGIN
select version into i from mytable;
if version = 1 then
create table...
insert
iginal Message -
From: John Mistler
To: [EMAIL PROTECTED]
Sent: Saturday, May 29, 2004 12:16 AM
Subject: "Batch" Update?
Let's say I have a table "A" with 25 columns. I also have an identical
table "B" with 25 columns (column names, indexes, e
UPDATE tableA, tableB
SET tableA.column2 = tableB.column2
WHERE tableA.rowID = tableB.rowID;
PB
- Original Message -
From: John Mistler
To: [EMAIL PROTECTED]
Sent: Saturday, May 29, 2004 12:16 AM
Subject: "Batch" Update?
Let's say I have a table "A"
ed in a repeat loop, this seems
quite tedious. In effect, I'm saying "Copy the column2 entry from one table
to column2 of another table, as long as their row IDs match."
Any ideas on a "batch-type" update?
Thanks,
John
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ructures can be compared whether
they are files containing table definitions or existing databases, local or
remote."
Hope it's what you're looking for..
Cheers,
Andrew
-Original Message-
From: Pointer [mailto:[EMAIL PROTECTED]
Sent: Saturday 20 March 2004 10:28
To: [E
Hi
I'm looking for a tool (program, library), which given a file
describing the structure of the tables in a database, could update
the structure of those tables, i.e. create new table, add fields and
change field size.
Such a tool (especially as a dll library) would be very useful
because i
At 23:12 -0500 11/19/03, r.schacht wrote:
Hi,
I'm new to MySQL. I want to try to create a new database, but I type in the
same commands all the time.
What I want to be able to do is type the commands into text files, then run
them from inside MySQL. This way if I want to change something I can jus
On 19 Nov 2003 at 23:12, r.schacht wrote:
> Hi,
>
> I'm new to MySQL. I want to try to create a new database, but I type in
> the same commands all the time.
>
> What I want to be able to do is type the commands into text files, then
> run them from inside MySQL. This way if I want to change som
Hi,
I'm new to MySQL. I want to try to create a new database, but I type in the
same commands all the time.
What I want to be able to do is type the commands into text files, then run
them from inside MySQL. This way if I want to change something I can just
drop the database and recreate.
Any he
In the last episode (Jul 29), Peter L. Berghold said:
> On Tue, 2003-07-29 at 15:19, azamka wrote:
> >
> > [EMAIL PROTECTED] usr]# mysql security < select * from machine;
> > -bash: select: No such file or directory
> >
>
>
> EEK! What you told the shell to do was open a file called "select" a
On Tue, 2003-07-29 at 15:19, azamka wrote:
>
> [EMAIL PROTECTED] usr]# mysql security < select * from machine;
> -bash: select: No such file or directory
>
EEK! What you told the shell to do was open a file called "select" and
redirect it to mysql.
What you meant to do was "echo 'select * fr
azamka wrote:
I am trying to right sql statement on the shell prompt but its not going
through.
Here is the statement:
[EMAIL PROTECTED] usr]# mysql security < select * from machine;
-bash: select: No such file or directory
echo "select * from machine" | mysql security
or put your select s
I am trying to right sql statement on the shell prompt but its not going
through.
Here is the statement:
[EMAIL PROTECTED] usr]# mysql security < select * from machine;
-bash: select: No such file or directory
It is asking for the text file. And it works fine with the text file. I am
wondering
ll queries went very fast!
James Hicks
-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 10, 2003 7:55 AM
To: [EMAIL PROTECTED]
Subject: Re: Slow batch load after 500MB
"James E Hicks III" <[EMAIL PROTECTED]> wrote:
> I have encou
check the cpu load sometimes is gets real intensive , so i have found , the
cpu's are they
-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 10, 2003 9:55 PM
To: [EMAIL PROTECTED]
Subject: Re: Slow batch load after 500MB
"James E Hicks II
"James E Hicks III" <[EMAIL PROTECTED]> wrote:
> I have encountered an interesting problem using mysql. On both 3.23 and another
> 4.01 server when I try to batch load a file with sql statements (ex. mysql -u
> user -p < mysql_statements.SQL) and the file is greater th
I have encountered an interesting problem using mysql. On both 3.23 and another
4.01 server when I try to batch load a file with sql statements (ex. mysql -u
user -p < mysql_statements.SQL) and the file is greater that 500MB it never
seems to finish. I have never had the patiences to see if
;In an effort to speed up large batch deletes i devised this script.
>
>LOCK TABLES t1 WRITE;
>SELECT * INTO OUTFILE '/data/dump/t1' FROM t1 where date>="2003-06-09";
>TRUNCATE TABLE t1;
>LOAD DATA INFILE '/data/dump/t1' INTO TABLE t1;
>UNLOCK
At 9:01 -0500 6/9/03, Todd Gruben wrote:
In an effort to speed up large batch deletes i devised this script.
LOCK TABLES t1 WRITE;
SELECT * INTO OUTFILE '/data/dump/t1' FROM t1 where date>="2003-06-09";
TRUNCATE TABLE t1;
LOAD DATA INFILE '/data/dump/t1' INTO TAB
8:02 AM
To: [EMAIL PROTECTED]
Subject: Batch Deletes...
In an effort to speed up large batch deletes i devised this script.
LOCK TABLES t1 WRITE;
SELECT * INTO OUTFILE '/data/dump/t1' FROM t1 where date>="2003-06-09";
TRUNCATE TABLE t1;
LOAD DATA INFILE '/data/du
In an effort to speed up large batch deletes i devised this script.
LOCK TABLES t1 WRITE;
SELECT * INTO OUTFILE '/data/dump/t1' FROM t1 where date>="2003-06-09";
TRUNCATE TABLE t1;
LOAD DATA INFILE '/data/dump/t1' INTO TABLE t1;
UNLOCK TABLES;
this script would w
ier; [EMAIL PROTECTED]
Subject: Re: mysql under unix in batch mode
Hi,
most probably there should not be a space after -p.
Try this
mysql -h localhost -uroot -pmysql < did.query > did.out
Dobromir Velev
[EMAIL PROTECTED]
http://www.websitepulse.com/
- Original Message -
From: &q
did.query > did.out
>
> Marianadin, Didier wrote:
> >Hi,
> >
> >I want to execute a simple query in batch mode in a mysql database.
> >my OS : Unix (solaris 2.6)
> >
> >when I run this command :
> >mysql -h localhost -u root -p mysql < did.query &
Create a .my.cnf file in your home directory with permissions set to 600.
In that file put the lines
[mysql]
user=root
password=mysql
now you can enter:
mysql < did.query > did.out
Marianadin, Didier wrote:
Hi,
I want to execute a simple query in batch mode in a mysql database.
my OS
On Wednesday 26 March 2003 13:12, Marianadin Didier wrote:
> I want to execute a simple query in batch mode in a mysql database.
> my OS : Unix (solaris 2.6)
>
> when I run this command :
> mysql -h localhost -u root -p mysql < did.query > did.out
>
> I'm always ask
t;[EMAIL PROTECTED]>
Sent: Wednesday, March 26, 2003 13:12
Subject: mysql under unix in batch mode
> Hi,
>
> I want to execute a simple query in batch mode in a mysql database.
> my OS : Unix (solaris 2.6)
>
> when I run this command :
> mysql -h localhost -u root -p mysql < di
Dnia Wed, 26 Mar 2003 12:12:44 +0100
"Marianadin, Didier" <[EMAIL PROTECTED]> zeznał/a co następuje:
> Hi,
>
> I want to execute a simple query in batch mode in a mysql database.
> my OS : Unix (solaris 2.6)
>
> when I run this command :
> mysql -h l
Hi,
I want to execute a simple query in batch mode in a mysql database.
my OS : Unix (solaris 2.6)
when I run this command :
mysql -h localhost -u root -p mysql < did.query > did.out
I'm always asked password even if I've already specified it in the previous
command li
ine in Edit Plus. So I replaced all the funky
characters with nothing (""), ran the batch file again, and this time I
found the Real line that had the problem which was yet another funky
character that had no business being there, so I deleted that, ran the
file again, and it gave me no
Tab,
>> file). Anyway, it can't help to try the following:
>> C:\mysql\bin>>mysql --max-allowed-packet=32M < \dev_hotel_data.sql
> Thanks, I'll try that... But in the meantime, is there something I can
> do to get Mysql to show me more information about the syntax error? I
> think that the diffe
2003 10:51 AM
Subject: Import Batch syntax error
Still trying to get all the way through my import batch file.
Now I'm getting a syntax error on a certain line of the file, and a
subsequent run produced the same exact error on the same exact line, but
I can't see anything wrong with
h 2003 19:30
>To: Tab Alleman
>Cc: [EMAIL PROTECTED]
>Subject: Re[4]: Import Batch syntax error
>
>
>Tab,
>
>>> Are you running this from a script? Maybe it's just a script
>>> timeout which would stop with the following line when it gets the
>>
Stefan Hinz wrote:
> No really. But you could hit the communications buffer size
> (though that does not seem likely at all with your .sql
> file). Anyway, it can't help to try the following:
>
> C:\mysql\bin>>mysql --max-allowed-packet=32M < \dev_hotel_data.sql
>
> Regards,
Thanks, I'll try th
Tab,
>> Are you running this from a script? Maybe it's just a script
>> timeout which would stop with the following line when it gets the
>> timeout:
> Oops, no sorry for all those who don't know where I left off yesterday
> (tee hee).. This is an import of a .sql file being run from the command
Stefan Hinz wrote:
>
> Are you running this from a script? Maybe it's just a script
> timeout which would stop with the following line when it gets the
> timeout:
Oops, no sorry for all those who don't know where I left off yesterday
(tee hee).. This is an import of a .sql file being run from th
Tab,
> On Thursday 20 March 2003 18:51, Tab Alleman wrote:
>> Still trying to get all the way through my import batch file.
>>
>> Now I'm getting a syntax error on a certain line of the file, and a
>> subsequent run produced the same exact error on the same exact l
On Thursday 20 March 2003 18:51, Tab Alleman wrote:
> Still trying to get all the way through my import batch file.
>
> Now I'm getting a syntax error on a certain line of the file, and a
> subsequent run produced the same exact error on the same exact line, but
> I can'
Still trying to get all the way through my import batch file.
Now I'm getting a syntax error on a certain line of the file, and a
subsequent run produced the same exact error on the same exact line, but
I can't see anything wrong with that line.
Here's the line that produces the
handler
Yes, just as it looks, the same error occurred on subsequent runs of the
same exact batch file. I didn't make any changes to the file or
anything else between the two runs; I just ran it once, got the error
and ran it again. And yet, the error occurs at two different points,
supporti
e same error occurred on subsequent runs of the
same exact batch file. I didn't make any changes to the file or
anything else between the two runs; I just ran it once, got the error
and ran it again. And yet, the error occurs at two different points,
supporting my theory that there's nothing wro
On Sun, 9 Feb 2003 16:24:03 -0700, Pamela Hart wrote:
>My question is this: I need to input data from a .sql file into an
>existing and empty database I have created.
>
>I type this into terminal at the main command line: mysql -uUser
>database_name < filename.sql.
>
>I keep getting an error mes
My question is this: I need to input data from a .sql file into an
existing and empty database I have created.
I type this into terminal at the main command line: mysql -uUser
database_name < filename.sql.
I keep getting an error message that says no such file or directory
exists.
I have trie
whatever.
>> The RADIUS server can call a "stored procedure" and pass parameters to
>> the procedure. This is what I need. I see that MySQL has a "batch
>> mode", but I do not see any mention of how I could pass parameters to a
>> MySQL batch file. C
>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, February 07, 2003 5:27 PM
Subject: Re: Batch mode / stored prodecure question?
> Hmm, I thought this question I posted last weekend was a pretty
> good one, however, no replies have been posted :-(
>
> I am new to MySQL and th
procedure. This is what I need. I see that MySQL has a "batch
> mode", but I do not see any mention of how I could pass parameters to a
> MySQL batch file. Can I do this, if so, how?
>
> I see that stored procedures are being added in a future release of
> MySQL, do I nee
e. This is what I need. I see that MySQL has a "batch mode", but I
do not see any mention of how I could pass parameters to a MySQL batch
file. Can I do this, if so, how?
I see that stored procedures are being added in a future release of MySQL,
do I need to wait for this?
Thanks in adv
only send a single SQL statement, this is not sufficient for
the processing I need to perform.
The RADIUS server can call a SQL "stored procedure" and pass parameters
with each call...this is what I need.
The MySQL documentation talks about batch files, however I see no mention
of h
Anyone know how to run batch queries in phpMyAdmin?
How is it done?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread
Has anyone else experienced this problem? To me, it looks like a bug since
according to the MySQL manual, the batch mode should work just as if the
statements where entered directly from the mysql prompt, but it appears not
to be true.
-Joacim
-Original Message-
From: Joacim Larsson
I am using MySQL 3.23.53 with InnoDB tables on Win2K platform.
My charset is set to latin1 and it works fine when I use Swedish characters
through JDBC. It also works fine if I use them from the mysql command line,
but when I try to use mysql < file.sql to load a set of INSERTs into my
tables
I get
At 6:58 -0500 10/11/02, rick wrote:
>I know how to make a whole batch SQL script silent (-s option of
>mysql), but is there a way within a script to make one or more
>individual statements silent? In Oracle PL/SQL, it can be done
>using echo on/off and termout on/off.
Not re
rick wrote:
>I know how to make a whole batch SQL script silent (-s option of mysql), but is there
>a way within a script to make one or more individual statements silent? In Oracle
>PL/SQL, it can be done using echo on/off and termout on/off.
>
>
Just for testing, I c
I know how to make a whole batch SQL script silent (-s option of mysql), but is there
a way within a script to make one or more individual statements silent? In Oracle
PL/SQL, it can be done using echo on/off and termout on/off.
Thanks,
R
mysqldump
Todd Williamsen wrote:
>i would like to know how to write batch script for dumping schema and
>data into a sql file. This script should dump the whole database and
>data
>
>
>-
>Before posting, p
Todd,
> i would like to know how to write batch script for dumping schema and
> data into a sql file. This script should dump the whole database and
> data
Write this in a batch file:
mysqldump [options] dbname >somename.sql
where is the name of the db. See the manual f
1 - 100 of 136 matches
Mail list logo
