>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?
>
>
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
>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 d
> >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 t
>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
>timest
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 questio
