Re: Batch update

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

Re: Batch update

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

Re: batch in a read loop

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 your qu

Re: batch mode

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 instance this input: "use test_db" gave

Re: batch mode

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 input > "show tables" gave me an out

Re: Batch Update of records

Hallo Neil, take a look at the utility mysqlimport which will exactly fit your needs importing those records into a database table. The basic syntax is: mysqlimport database_name table_name.txt Tablename.txt would be your datafile with the records. The filename must match the name of the t

Re: batch installation of mysql 5.0

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 created a conf

Re: Batch Querying

I did a little deeper reading and the MySQL C API (probably the same API they wrote the ODBC driver with) does not support multiple statements through most (if not all) of its "querying" interfaces: http://dev.mysql.com/doc/mysql/en/mysql_query.html http://dev.mysql.com/doc/mysql/en/mysql_real_q

Re: Batch Querying

Hey. Thanks. First off, I meant to say semicolon (;) in my first post but I mistyped and said comma by accident. I am trying to use semicolon as my delimiter. This method works if I issue statements from PHPMyAdmin, but not through my ODBC app. However, your pseudocode made me realize something

Re: Batch Querying

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 command may return a recordset of its own. Be prepared to either cycle through the returned recordsets or ignore them as they arrive. Wh

Re: Batch Querying

Victor, I think I found what you're referring to: http://dev.mysql.com/doc/mysql/en/C_API_multiple_queries.html ... "From version 4.1, MySQL supports the execution of multiple statements specified in a single query string. To use this capability with a given connection, you must specify the CLIEN

Re: Batch Querying

4.0.20a-max, just because I thought this was the most stable build. "Victor Pendleton" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > What version of MySQL are you using? I believe multiple delimited > statements are available in 4.1.x and later. > > Jeff Burgoon wrote: > > I'm writ

Re: Batch Querying

What version of MySQL are you using? I believe multiple delimited statements are available in 4.1.x and later. 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 i

RE: Batch Script

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

Re: Batch Script

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

Re: "Batch" Update?

For reference, multiple-table updates are documented in the manual . They work starting with mysql 4.0.4. Michael Peter Brawley wrote: UPDATE tableA, tableB SET tableA.column2 = tableB.column2 WHERE tableA.rowID = tableB.rowID; PB - Original

Re: "Batch" Update?

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" with 25 columns. I also

RE: Batch table structure update tool

Hi, The only utility I know about that does this kind of thing is mysqldiff which can be found at: http://freshmeat.net/projects/mysqldiff/ I haven't used it myself but it comes quite highly rated on freshmeat.net A quote from it's description: "mysqldiff is a Perl script which compares the d

Re: batch files usage

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

Re: batch files usage

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

Re: batch mode

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

Re: batch mode

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

Re: batch mode

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

Re: Batch Deletes...

At 11:01 -0500 6/9/03, Todd Gruben wrote: in the TRUNCATE TABLE t1 This is the documented behavior: http://www.mysql.com/doc/en/TRUNCATE.html You cannot use TRUNCATE on tables for which you hold locks. On Monday 09 June 2003 10:57 am, you wrote: At 9:01 -0500 6/9/03, Todd Gruben wrote: >In an

Re: Batch Deletes...

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 TABLE t1; UNLOCK TABLES; this script w

RE: Batch Deletes...

You may find that it is the index that is slowing you down. Have you tried disabling the index(s) on your table before the delete and re-enabling them after? Regards, Mike Hillyer www.vbmysql.com -Original Message- From: Todd Gruben [mailto:[EMAIL PROTECTED] Sent: Monday, June 09, 2003

Re: batch

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

Re: Batch mode / stored prodecure question?

> 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

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 this mailing list, is the the proper place and format for questions of this type? Regards, Bill > Hi all: > > I am building a database containing usage

Re: Batch load of data problems (fwd)

t;[EMAIL PROTECTED]> Sent: 31 January 2002 01:01 Subject: Re: Batch load of data problems (fwd) > I'm forwarding this to the list since I can't offer any more advice > myself. -- Forwarded message -- > Date: Wed, 30 Jan 2002 19:41:32 -0500 > From: [EM

Re: Batch load of data - got it!

At 21:57 -0500 1/30/02, [EMAIL PROTECTED] wrote: >I found out why my LOAD DATA INFILE did not work. > >The editor I was using translated the tabs I entered to spaces. >That's why my load data infile didn't work! >I used the following command to load the data successfully: > >load data infile "tes

Re: Batch load of data problems (fwd)

I'm forwarding this to the list since I can't offer any more advice myself. -- Forwarded message -- Date: Wed, 30 Jan 2002 19:41:32 -0500 From: [EMAIL PROTECTED] To: "William R. Mussatto" <[EMAIL PROTECTED]> Subject: Re: Batch load of data problems I

Re: Batch load of data problems

On Wed, 30 Jan 2002, Eurico de Sousa wrote: > Date: Wed, 30 Jan 2002 16:56:24 -0500 > From: Eurico de Sousa <[EMAIL PROTECTED]> > To: mysql post <[EMAIL PROTECTED]> > Subject: Re: Batch load of data problems > > Hi. Resubmitting a post... > > Basically, m

Re: Batch load of data problems

Hi. Resubmitting a post... Basically, my question is if you have defined an INT NOT NULL AUTO_INCREMENT id field in a table, and you want to load a data file into the table using the LOAD DATA INFILE command, must you also put the ids in the data file? Thanks. Eurico *

RE: Batch UPDATE with C API

On 22-Jun-01 Jean-Philippe Cote wrote: > > > Hello, > > Suppose I want to update n rows (where n is a possibly large number) > using the mySQL C API. I can create n separate UPDATE > statements and send each of them to the server with mysql_[real_]query(), > but that doesn't seem particularly