Rearranging mysql columns

Friends, I goofed up when creating my table - I established my column in reverse order. How can I move them all back around? Regards, Jonathan

Re: How to create random table names on the fly

Mauricio Pellegrini wrote: Hi, I'm using MySql 4.1.4 gamma and there are certain circumstances in wich I need to create tables with random names from within querys. And after using them I need to drop them; so I need a way to *remember* these table names so I can dispose them later. Is that po

Re: queries and mail function

John Visicaro wrote: Hi, This is my first post so I hope I've done it right. I am having trouble querying an email address from MySQL and then placing that field into the PHP mail function. It doesn't work. Here's my code: $query_string = "SELECT Email FROM instructors WHERE HSA_NO = '$insthsaid'";

Re: Newbie problem

program output INSERT INTO wfr_map (filename, facility, lot, wafer, repeat_cnt, dte, tme, prog, product, type, prober, tester, probecard,loadboard, operator, temp, fail_cnt, pass_cnt, d_chips, tot_cnt,yield, neff,flat, b_mode, test_var, w_pass,npar,msg,map_type_id,archive) VALUES('/da

Re: How to create random table names on the fly

At 06:56 AM 12/18/2004, you wrote: Hi, I'm using MySql 4.1.4 gamma and there are certain circumstances in wich I need to create tables with random names from within querys. And after using them I need to drop them; so I need a way to *remember* these table names so I can dispose them later. Is t

Re: can't get the order I want after inserting new rows

Marcus Claesson wrote: Hi! I have a problem with getting the order I want on a table after new rows have been inserted. I try to simplify it...: Perhaps you have simplified too much, then, as I simply do not understand what you want. Comments and questions below. I want to have a one-to-one rela

Re: Current Timestamp upon creating of a record

If you are using 4.1.2 or later, you can define the default and update behavior separately for TIMESTAMP columns with the DEFAULT and ON UPDATE clauses. CREATE TABLE t (ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP, ... In this example, column ts will be set to now on creation (INSERT) because of the

Re: Current Timestamp upon creating of a record

> i would like to create a Timestamp upon initial creation of a record. I > expected this could be done using now() in my INSERT statement but obv. the > related field gets actualised each time a record is updated. Unfortunately > that's not what i like - i would like to have the timestamp set just

How to create random table names on the fly

Hi, I'm using MySql 4.1.4 gamma and there are certain circumstances in wich I need to create tables with random names from within querys. And after using them I need to drop them; so I need a way to *remember* these table names so I can dispose them later. Is that possible with MySql? Thank

Current Timestamp upon creating of a record

Hi all i would like to create a Timestamp upon initial creation of a record. I expected this could be done using now() in my INSERT statement but obv. the related field gets actualised each time a record is updated. Unfortunately that's not what i like - i would like to have the timestamp set jus