Mysql: How to update value in 27000 rows? Post: 302894474

8 More Discussions You Might Find Interesting

1. Web Development

Mysql question: Best way to update a column containing 8 million rows

Hi all, I was wondering if anyone knew a good/safe way to update a single column in a table that could contain upto 8 million rows... simple command like: UPDATE set blah=foo where bar=XXX; I will be running this on tables being written to and tables that have already been created. ...

2. Web Development

[MYSQL] problem with spaces in rows

Hello. I'm not sure how I can get around this, or what I am doing wrong, but I need some help. :) I want to do an select query looking like this: SELECT venue, SUM( amount ) FROM IWD WHERE venue = 'Foxy Hollow' Unfortunately I need to have spaces in the names in these fields, is...

3. Shell Programming and Scripting

Mulitple rows update by sed command

Hi All, I need to update 2 rows in my file. But i can do only one row update by sed command. Please help me how can i change mutltiple rows in single sed commana my i/p file: (example.txt) record integer (10) present_id; string (10) first_name; string (10) last_name; string...

4. UNIX and Linux Applications

Online insert MySQL rows by perl-script

Hello, Met a problem when I tried to insert rows to MySQL database from an old book that fits my learning level (MySQL and Perl for the Web, by Paul DuBois, 2001). First, under mysql console I created a database: webdb and the table: todo. Then I draft the perl-cgi script to have online page....

5. Programming

Getting Rows from a MySQL Table with max values?

I feel stupid for asking this because it seems that MYSQL code isn't working the way that I think it should work. Basically I wrote code like this: select * from `Test_DC_Trailer` HAVING max(DR_RefKey); Where the DR_RefKey is a unique numeric field that is auto iterated (like a primary key)...

6. Shell Programming and Scripting

Retrieve multiple rows from mysql and automatically create a table

Hi, i want to create a table automatically based on another table (sms_key). For example; If user create a new row with sms_keyword field: IRC then a table created automatically (with some field on it, like: name, ph_number, messages). select * from sms_key; +-------------+ |...

7. Shell Programming and Scripting

MySql split rows

Dear community, I have to split string in table and list all values. I'll skip the code and jump directly to mysql query. This is the table: category title ======= ======= 7,3 title 1 1,3 title 2 1,2,3 title 3 Now, what I need is split category into single...

8. Programming

MYSQL - trigger update on record insert or update

Right I have a MYSQL database with table1 with 3 columns, colA, colB and colC. I want to combine the data in the 3 columns into a 4th column names col_comb. Here's the SQL command that works: UPDATE table1 SET `col_comb` = CONCAT( `colA` , ' - ', `colB` , ', ', `colC` ); So now I want this...

LEARN ABOUT REDHAT

mod-active

MOD-ACTIVE(8)						      System Manager's Manual						     MOD-ACTIVE(8)

NAME

       mod-active - batch processing of ctlinnd newgroup/rmgroup/changegroup

SYNOPSIS

       mod-active [ ctlinnd_command_file ]

DESCRIPTION

       mod-active  is  a  perl script that updates the active file based on its input lines of ctlinnd newgroup, rmgroup and changegroup commands.
       It pauses the server briefly while the existing active file is read and rewritten, which not only keeps innd from updating the active  file
       but also locks against other instances of mod-active.

       The  input to mod-active can come either from one or more files named on the command line, or from the standard input.  Typically its input
       is the output from the docheckgroups or actsync commands.  Every line which contains the string "ctlinnd newgroup",  "ctlinnd  rmgroup"	or
       "ctlinnd  changegroup", optionally preceded by whitespace and/or the path to ctlinnd, is noted for the update.  Redundant commands, such as
       a newgroup directive for a group that already exists, are silently ignored.  All other lines in the input are also silently ignored.

       After the new active file has been generated, the existing one is renamed to active.old and the new one is moved into  place.   The  script
       then displays the differences between the two files.

       Any groups that were added to the active file are also added to the active.times file with the string "checkgroups-update".

BUGS

       Though  innd is paused while mod-active works, it is not inconceivable that there could be a conflict if something else tries to update the
       active file during the relatively short time that mod-active is working.  The two most realistic ways I can think of for this to happen are
       either by an administrator concurrently doing a manual ctlinnd command, or by innd receiving a control message, then mod-active pausing the
       server, then the control message handler script that innd forked running its own ctlinnd command while mod-active is  working.	I've  been
       using mod-active regularly for several years, though, and never had either problem.

HISTORY

       Written by David C Lawrence <tale@isc.org>.

SEE ALSO

       active(5), actsync(8), ctlinnd(8), innd(8).

																     MOD-ACTIVE(8)