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

update

UPDATE(7)							   SQL Commands 							 UPDATE(7)

NAME

       UPDATE - update rows of a table

SYNOPSIS

       UPDATE [ ONLY ] table SET col = expression [, ...]
	   [ FROM fromlist ]
	   [ WHERE condition ]

   INPUTS
       table  The name (optionally schema-qualified) of an existing table. If ONLY is specified, only that table is updated. If ONLY is not speci-
	      fied, the table and all its descendant tables (if any) are updated. * can be appended to the table name to indicate that	descendant
	      tables  are  to  be scanned, but in the current version, this is the default behavior. (In releases before 7.1, ONLY was the default
	      behavior.) The default can be altered by changing the SQL_INHERITANCE configuration option.

       column The name of a column in table.

       expression
	      A valid expression or value to assign to column.

       fromlist
	      A PostgreSQL non-standard extension to allow columns from other tables to appear in the WHERE condition.

       condition
	      Refer to the SELECT statement for a further description of the WHERE clause.

   OUTPUTS
       UPDATE #
	      Message returned if successful.  The # means the number of rows updated.	If # is 0 no rows are updated.

DESCRIPTION

       UPDATE changes the values of the columns specified for all rows which satisfy condition. Only the columns to be	modified  need	appear	as
       columns in the statement.

       Array  references use the same syntax found in SELECT [select(7)].  That is, either single array elements, a range of array elements or the
       entire array may be replaced with a single query.

       You must have write access to the table in order to modify it, as well as read access to any table whose values are mentioned in the  WHERE
       condition.

       By  default  UPDATE  will  update  tuples in the table specified and all its sub-tables. If you wish to only update the specific table men-
       tioned, you should use the ONLY clause.

USAGE

       Change word Drama with Dramatic on column kind:

       UPDATE films
       SET kind = 'Dramatic'
       WHERE kind = 'Drama';
       SELECT *
       FROM films
       WHERE kind = 'Dramatic' OR kind = 'Drama';

	code  |     title     | did | date_prod  |   kind   | len
       -------+---------------+-----+------------+----------+-------
	BL101 | The Third Man | 101 | 1949-12-23 | Dramatic | 01:44
	P_302 | Becket	      | 103 | 1964-02-03 | Dramatic | 02:28
	M_401 | War and Peace | 104 | 1967-02-12 | Dramatic | 05:57
	T_601 | Yojimbo       | 106 | 1961-06-16 | Dramatic | 01:50
	DA101 | Das Boot      | 110 | 1981-11-11 | Dramatic | 02:29

COMPATIBILITY

   SQL92
       SQL92 defines a different syntax for the positioned UPDATE statement:

       UPDATE table SET column = expression [, ...]
	   WHERE CURRENT OF cursor

       where cursor identifies an open cursor.

SQL - Language Statements					    2002-11-22								 UPDATE(7)