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

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 OPENSOLARIS

mailcap.order

MAILCAP.ORDER(5)                                               Order Mailcap Entries                                              MAILCAP.ORDER(5)

NAME

       /etc/mailcap.order - the mailcap ordering specifications

DESCRIPTION

       The  order  of  entries in the /etc/mailcap file can be altered by editing the /etc/mailcap.order file.  Each line of that file specifies a
       package and an optional mime type.  Mailcap entries that match will be placed in the order of this file.  Entries that don't match will  be
       placed later.

   Example
           mime-support:*/*
           gv:application/postscript
           netscape:text/html
           less:text/*
           emacs:text/*

       The above would make any entries provided by the mime-support package (as found in the /usr/lib/mime/packages directory) take priority over
       everything else.  The gv package will be used over anything else when it comes to postscript documents.  Netscape will be used for any html
       documents  and  less will be used for any remaining text documents.  However, since neither netscape or less provide for editing documents,
       any edit or compose actions will fall through to the emacs rules.

       After modifying this file, be sure to run /usr/sbin/update-mime (as root) to propagate the changes into the /etc/mailcap file.

       Remember that this files takes package names and not executable names.  If you want to define rules that reference specific  programs,  the
       best way is to include them in ~/.mailcap or the user section of the /etc/mailcap file.

LIMITATIONS

       There  is  currently  no way to break out a certain type from a wildcard rule.  If, for example, both xv and gimp were to specify "image/*"
       rules, it isn't possible to use xv for gif images but use gimp for jpeg images.

       Also, I would like to add the ability to specify certain actions in the rules.  For example, if netscape were to have an edit  rule  but  I
       wanted to use emacs for editing/creating html documents, I could place a line like

         emacs:text/* action=edit|compose

       before  the  netscape  entry.  The update-mime program would then spit out entries such that netscape view rule comes before the emacs view
       rule but have the netscape edit rule comes after the emacs edit rule.

SEE ALSO

       mailcap(5) run-mailcap(1) update-mime(8)

AUTHOR

       The mailcap.order specification was written by Brian White <bcwhite@pobox.com>

Debian Project                                                     16th Aug 1998                                                  MAILCAP.ORDER(5)