Re: mysterious SQL query

2007-04-08 Thread [EMAIL PROTECTED]
thx for you info but the SELECT COUNT(*) AS count FROM `groups` AS `Group` WHERE 1 = 1 still confuse me... On 4月7日, 下午10时41分, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: The DESC command asks the database to DESCribe a table. Cake uses these queries to get the names and data types of your

Re: mysterious SQL query

2007-04-08 Thread Chris Hartjes
It's used by the database models themselves. On 4/8/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: thx for you info but the SELECT COUNT(*) AS count FROM `groups` AS `Group` WHERE 1 = 1 still confuse me... On 4月7日, 下午10时41分, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: The DESC command

Re: mysterious SQL query

2007-04-08 Thread DJ Spark
and most of them are cached when in debug is 0 :) spark On 4/8/07, Chris Hartjes [EMAIL PROTECTED] wrote: It's used by the database models themselves. On 4/8/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: thx for you info but the SELECT COUNT(*) AS count FROM `groups` AS `Group`

mysterious SQL query

2007-04-07 Thread [EMAIL PROTECTED]
1 DESC `groups` 3 3 4 2 DESC `users`4 4 4 3 DESC `contacts` 7 7 4 4 SELECT COUNT(*) AS count FROM `groups` AS `Group` WHERE 1 = 1 when I debug ,I always find some sql query like above ... I didn't do

Re: mysterious SQL query

2007-04-07 Thread [EMAIL PROTECTED]
The DESC command asks the database to DESCribe a table. Cake uses these queries to get the names and data types of your fields. Try running DESC `users` and look at the results. On Apr 7, 7:25 am, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: 1 DESC `groups` 3 3 4 2