Re: [SQL] Looking for a "show create table " equivalent

2011-07-14 Thread Jasen Betts
On 2011-07-12, B.Rathmann wrote: > Hello, > > I've been trying to find out how to find out which sql was run to create > a certain table. That's like trying to find what change was used to create $1.83 there several possible answers all but one of them wrong, but many of them may . > As I nee

Re: [SQL] [NOVICE] Compare rows

2011-07-14 Thread Oliveiros d'Azevedo Cristina
- Original Message - From: LALIT KUMAR To: Oliveiros d'Azevedo Cristina Hi, I do have order of rows. The problem originally is: I need to set all flag with value 0 to -1 whose next row has flag as 1. This is to be done for each city separetly, i.e. flag of last row of

Re: [SQL] Looking for a "show create table " equivalent

2011-07-14 Thread Craig Ringer
On 14/07/2011 6:22 PM, Jasen Betts wrote: On 2011-07-12, B.Rathmann wrote: Hello, I've been trying to find out how to find out which sql was run to create a certain table. That's like trying to find what change was used to create $1.83 Yep, and just like that question, sometimes any valid