Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: tushar Kanvinde
  Where is tushar Kanvinde?
 Kolhapur, Maharastra
 India
 tushar Kanvinde
 To: eijdor errotal
  Where is eijdor errotal?
 Catbalogan
 Philippines
 eijdor errotal
 Tags
Subject: RE: MariaDB date issue
Thread ID: 373538 Message ID: 373541 # Views: 53 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Other
Date: Saturday, March 23, 2013 5:06:17 AM         
   


> Hi expert
>
> how will i be able to insert a null value in a date field in mariadb?
> i tested it in MYSql and it works well, but in mariadb it always prompt
> an error..
>
>
>
> i created a sample table named test and a date field (allow null), when i try to insert a data
> using this sqlquery.
>
> insert into test values ('01-02-1990') && results to null,this query has an error in mariadb
> insert into test values ('null') && results to null,this query has an error in mariadb
> insert into test values ('') && results to null,this query has an error in mariadb

Try

insert into test values ('1990-02-01')
insert into test values (null)


Regards
Tushar
http://weblogs.foxite.com/tushar/

ENTIRE THREAD

MariaDB date issue Posted by rodjie latorre @ 3/23/2013 3:21:44 AM
RE: MariaDB date issue Posted by tushar @ 3/23/2013 5:06:17 AM