At 9:30 PM -0300 3/13/07, allysonalves wrote:
Hi everybody
Has some way to set up a function, like now(), as a default value of
an dateTime column.
Is some thing like this.
Create Table Persons (
PersonCode int(10) zerofill not null auto_increment,
PersonName varchar(150) not null,
CadastreDa
# [EMAIL PROTECTED] / 2003-06-25 15:18:09 +1000:
> From: "Roman Neuhauser" <[EMAIL PROTECTED]>
> > please don't piggyback on other people's threads. you can start your
> > own for free.
>
> Although it was the first time for me to send the post on this list, I was
> sure that I did not foll
riginal Message -
From: "Roman Neuhauser" <[EMAIL PROTECTED]>
To: "Ruth Zhai" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, June 24, 2003 7:50 PM
Subject: Re: default value does not set using LOAD DATA INFILE ...
> please don't pigg
please don't piggyback on other people's threads. you can start your
own for free.
# [EMAIL PROTECTED] / 2003-06-24 09:46:24 +1000:
> I am using LOAD DATA INFILE to import some data to MySQL. I would like to
> leave some fields blank and use the default value set in the tables. I have
>
From: "Michal Dvoracek" <[EMAIL PROTECTED]>
> s possible to create table with default value returned by built-in
> function ??
> like:
>
> create table x (a int not null default UNIX_TIMESTAMP());
>
> When inserting new column in table field a will contains timestamp?
In general, this cannot be
Michal Dvoracek wrote:
>Hello,
>
>s possible to create table with default value returned by built-in
>function ??
>like:
>
No.
>
>create table x (a int not null default UNIX_TIMESTAMP());
>
What is wrong with the timestamp field type?
>
>
>When inserting new column in table field a will conta
On Mon, Mar 18, 2002 at 05:32:07PM -0500, Kathy Reyes wrote:
> Can I have a default value call a function in a MYSQL table for example
>
> convert(float,getdate())
Nope.
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell:
Try using the following:-
Format(Date,"-mm-dd") instead of
???/
> -Original Message-
> From: Apolinaras "Apollo" Sinkevicius [SMTP:[EMAIL PROTECTED]]
> Sent: 15 January 2001 20:43
> To: [EMAIL PROTECTED]
> Subject: Default value for
MySQL only supports constant default values. You'll have to insert
the date explicitly when you create the record if you want to simulate
initialization to now().
Timestamps will update themselves whenever any other field in the
record changes, unless you explictly tell them not to. So they are
Use the timestamp datatype, not date.
At 02:43 PM 1/15/2001 -0600, Apolinaras \"Apollo\" Sinkevicius wrote:
>I would like to set a default value in DATE type column to Date(), but it
>doesn't work. Is there a way to do it through column format?
>If not, what should I enter in the VB code below (
10 matches
Mail list logo
