Stored procedures and views

2006-03-24 Thread Chris Carrier
Howdy folks, I'm trying to create a flatfile dump from our database which requires some functionality that's not possible with raw sql. Up to now we've been using PHP tied to mySql to do all the work and get the data in the correct format. We would like to switch this functionality over to

Re: Stored procedures and views

2006-03-24 Thread Martijn Tonies
Chriss, I'm trying to create a flatfile dump from our database which requires some functionality that's not possible with raw sql. Up to now we've been using PHP tied to mySql to do all the work and get the data in the correct format. We would like to switch this functionality over to stored

RE: Stored procedures and views

2006-03-24 Thread Chris Carrier
: Re: Stored procedures and views Chriss, I'm trying to create a flatfile dump from our database which requires some functionality that's not possible with raw sql. Up to now we've been using PHP tied to mySql to do all the work and get the data in the correct format. We would like to switch

Re: Stored procedures and views

2006-03-24 Thread Martijn Tonies
, March 24, 2006 10:26 AM To: mysql@lists.mysql.com Subject: Re: Stored procedures and views Chriss, I'm trying to create a flatfile dump from our database which requires some functionality that's not possible with raw sql. Up to now we've been using PHP tied to mySql to do all the work

RE: Stored procedures and views

2006-03-24 Thread Gordon
data_result END// DELIMITER ; -Original Message- From: Martijn Tonies [mailto:[EMAIL PROTECTED] Sent: Friday, March 24, 2006 1:04 PM To: Chris Carrier; mysql@lists.mysql.com Subject: Re: Stored procedures and views I just mean is it possible to hook a set of stored procedures

triggers, stored procedures, and views

2002-01-30 Thread jds
I am building a database system and have been, like many before me, quite surprised that MySQL doesn't support triggers, sp's, and views. I can see how one can get around not having views with advanced permissions, as stated in the manual, although as I understand it this is no substitue for

RE: triggers, stored procedures, and views

2002-01-30 Thread Land, Christopher
Sounds like we just need a table to keep track of LAST_INSERT_ID per table. C:heers -Original Message- From: jds [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 30, 2002 7:05 AM To: [EMAIL PROTECTED] Cc: David T. Anderson Subject: triggers, stored procedures, and views I am