Re: triggers

2007-04-11 Thread Andrew Dashin 

Hi, ch

Probably you should look here 
http://dev.mysql.com/doc/refman/5.0/en/cursors.html


--
Andrew Dashin


ch h пишет:
In a trigger I need to iterate thru a query result that will consist of more than 1 row. Could someone please give me a general example of how this would be accomplished. For example in php i would just use 
  while($row = $result->fetch_assoc)

  {
  ..process the row
  }
   
  I have no idea how to do this with in the confines of a trigger.
   
  Thanks


   
-
No need to miss a message. Get email on-the-go 
with Yahoo! Mail for Mobile. Get started.
  


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Importing data from excel sheet

2007-04-07 Thread Andrew Dashin 

Hi, sam

You can try to export table to file from Excel in CSV format.
And then import data from this file to mysql.
Something like this should help you:

LOAD DATA INFILE 'yourtabledata.txt' INTO TABLE yourtable FIELDS 
TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n';


sam rumaizan wrote:
I have created table in mysql with 12 fields 
   
  Field1Field2 Field3  Field4 ……… Field12
   
   
  I have an excel sheet with 12 columns and 150 rows.
  My question is how can I import all of the columns from the excel sheet to my table without losing any information.  
   




 

 
-
Don't be flakey. Get Yahoo! Mail for Mobile and 
always stay connected to friends.
  


--
Andrew Dashin


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]