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 DEBIAN

bp_meta_gff

BP_META_GFF(1p) 					User Contributed Perl Documentation					   BP_META_GFF(1p)

NAME

       bp_meta_gff.pl - Get/set Bio::DB::GFF meta-data

SYNOPSIS

	 # set the following meta data values
	 % bp_meta_gff.pl -d testdb tag1=value1 tag2=value2

	 # get the indicated meta data value
	 % bp_meta_gff.pl -d testdb tag1 tag2

DESCRIPTION

       This script gets or sets metadata in a Bio::DB::GFF database.  Not all adaptors support this operation!	To set a series of tags, pass a
       set of tag=value pairs to the script.  To get the contents of a series of tags, pass the bare tag names.

       The output from the get operation will be an easily parseable set of tag=value pairs, one per line.

COMMAND-LINE OPTIONS
       Command-line options can be abbreviated to single-letter options.  e.g. -d instead of --database.

	  --database <dsn>	Mysql database name (default dbi:mysql:test)
	  --adaptor <adaptor>	Mysql adaptor (default dbi::mysqlopt)
	  --user    <user>	Username for mysql authentication
	  --pass    <password>	Password for mysql authentication

SEE ALSO

       Bio::DB::GFF

AUTHOR

       Lincoln Stein, lstein@cshl.org

       Copyright (c) 2002 Cold Spring Harbor Laboratory

       This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.  See DISCLAIMER.txt for
       disclaimers of warranty.

perl v5.14.2							    2012-03-02							   BP_META_GFF(1p)