Hello List,
Is it true that the date_sub function(s) will only work on datetime column
types?
SELECT count(id) as id FROM messages WHERE client_id = '2' AND datetime_col
date_sub(NOW(),interval 1 day)
To get the above query to work, I had to change my datetime_col column from
timestamp to
Is it true that the date_sub function(s) will only work on datetime column
types?
SELECT count(id) as id FROM messages WHERE client_id = '2' AND datetime_col
date_sub(NOW(),interval 1 day)
To get the above query to work, I had to change my datetime_col column from
timestamp to datetime, and
This has probably been asked a thousand times before but only once from me.
I am able to programme in MS Access to quite a high level to which I have now
realised its limitations, where is the best place to start learning and reading up on
MYSQL, I am not really a book reader as I prefer to do
At 13:36 +0200 28-10-2002, Victoria Reznichenko wrote:
MdB 2) How many entries can one single table have?
MdB (The absolute maximum)
There are no limits on number of rows.
What if the values for Primary Key run out? Can you use a unsigned bigint as Primary
Key?
I mean, we /have/ to store the
Monday, October 28, 2002, 2:00:28 PM, you wrote:
MS At 13:36 +0200 28-10-2002, Victoria Reznichenko wrote:
MdB 2) How many entries can one single table have?
MdB (The absolute maximum)
There are no limits on number of rows.
MS What if the values for Primary Key run out?
You get Duplicate key
1. When using GROUP BY it is not possible to order the rows before the grouping
takes place, is that right? Like, if you're selecting books, grouping on author, and
you want to show the first book of each author, you'd want to order by date and then
group by author?
2. Other grouping