Original Message
Subject:Re: Basic Question
Date: Mon, 17 Dec 2012 15:39:39 -0500
From: Rhino
To: Reindl Harald
On 2012-12-17 14:34, Reindl Harald wrote:
Am 17.12.2012 19:09, schrieb Rhino:
Is the version of SQL statements that I write for MySQL based
Am 17.12.2012 19:09, schrieb Rhino:
> Is the version of SQL statements that I write for MySQL based on the
> server version or the client version?
clearly for the server
mysql is a database-SERVER
> According to phpMyAdmin, the version of the MySQL Client is 4.1.22 but the
> MySQL Server vers
On Sunday 04 July 2004 11:36 pm, bruce wrote:
> hi...
>
> i'm trying to figure out how to deal with joins
> (left/right)..
>
> i have the following test tbls...
>
> create table universityTBL(
> name varchar(50) not null default '',
> ID int(10) not null auto_increment,
> pr
Bruce:
The problem is that you have universityTBL listed twice in your list of
tables. Here is your statement, with numbers for each of the sources.
SELECT schoolTBL.name, universityTBL.name
FROM (1) universityTBL, (2) schoolTBL
LEFT JOIN (3) universityTBL ON schoolTBL.universityID =
university
Make it TIMESTAMP
But remember that this data type gets updated every time the record is
changed.
Hope this helps.
Thanks
Emery
- Original Message -
From: "Edward Peloke" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, October 11, 2002 5:50 PM
Subject: basic question
> sql qu
At 11:50 -0400 10/11/02, Edward Peloke wrote:
>sql query
>
>when I am defining a table, how do I set the default of a datetime column to
>the current time? I tried setting the default to now() but it just fills
>the column with 00:00 etc..
You don't. Default values must be constants.
The TIME
