2012/11/15 00:30 +0100, Mogens Melander
I guess I'm sill learning.
Does that mean that, if the last column in a load blabla. is a -00-00
terminated by ^n it might error ? Or are we talking ODBC ?
Find it under LOAD DATA
If an empty field is parsed for a NOT NULL DATE o
6:40 AM: Sorry, didn't mean to be rude. It's in there.
On Thu, November 15, 2012 00:23, Mogens Melander wrote:
> Dude, which part of RTFM did yoy miss?
>
> http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html
>
> On Wed, November 14, 2012 13:57, sagar bs wrote:
>> Hi,
>>
>>
>> There
I guess I'm sill learning.
Does that mean that, if the last column in a load blabla. is a -00-00
terminated by ^n it might error ? Or are we talking ODBC ?
On Wed, November 14, 2012 18:58, h...@tbbs.net wrote:
> 2012/11/14 18:27 +0530, sagar bs
> There are four columns in my table n
Dude, which part of RTFM did yoy miss?
http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html
On Wed, November 14, 2012 13:57, sagar bs wrote:
> Hi,
>
>
> There are four columns in my table named like account_name, c1, c2 and
> c3.
> Account name is the primary key and c1, c2 contai
2012/11/14 18:27 +0530, sagar bs
There are four columns in my table named like account_name, c1, c2 and c3.
Account name is the primary key and c1, c2 contain two different dates and in
the column c2 there are few fields showing /00/00, now i need to get the
date different(in da
Hi,
There are four columns in my table named like account_name, c1, c2 and c3.
Account name is the primary key and c1, c2 contain two different dates and
in the column c2 there are few fields showing /00/00, now i need to
get the date different(in days)
between the dates present in the c1
2012/11/14 10:26 +0530, sagar bs
As i have the data with some 25 variables in csv file and i need to import
to mysql.
The issue is that the date format in csv file is dd/mm/ and mysql takes
the date format like /mm/dd.
The number of variables in the csv file are same in the table
Did you change the target column to varchar before import ?
On Wed, November 14, 2012 10:23, sagar bs wrote:
> tried to import data as text, but its showing Operation failed with
> exitcode 1
>
> On Wed, Nov 14, 2012 at 1:12 PM, Mogens Melander
> wrote:
>
>> Or you could import the date as text an
tried to import data as text, but its showing Operation failed with
exitcode 1
On Wed, Nov 14, 2012 at 1:12 PM, Mogens Melander wrote:
> Or you could import the date as text and convert dates using:
>
> mysql> SELECT STR_TO_DATE('04/31/2004', '%m/%d/%Y');
> -> '2004-04-31'
>
>
> On Wed, Novem
Or you could import the date as text and convert dates using:
mysql> SELECT STR_TO_DATE('04/31/2004', '%m/%d/%Y');
-> '2004-04-31'
On Wed, November 14, 2012 06:13, Larry Martell wrote:
> On Tue, Nov 13, 2012 at 9:56 PM, sagar bs wrote:
>> Hi,
>>
>> As i have the data with some 25 variables
On Tue, Nov 13, 2012 at 9:56 PM, sagar bs wrote:
> Hi,
>
> As i have the data with some 25 variables in csv file and i need to import
> to mysql.
> The issue is that the date format in csv file is dd/mm/ and mysql takes
> the date format like /mm/dd.
> The number of variables in the csv f
2012.10.29. 20:59 keltezéssel, FHDATA írta:
mysql server 5.1.41
hello
Is there a way mysql server can be told to disallow
any attempt of creating a database whose name contains
certain characters?
thanks,
make an empty dir in /var/lib/mysql with that name + chmod 000, owner
!mysql :)
t
mysql server 5.1.41
hello
Is there a way mysql server can be told to disallow
any attempt of creating a database whose name contains
certain characters?
thanks,
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
>
> Thanks for the response, Peter.
> Yeah, I am aware of this to find it for the tables. However I require to
> find the creation time of a database..
>
> Thanks,
> Uma
>
>
> On 6/3/09, Peter Brawley wrote:
>>
>> >Is there any method to find the CREATION DATE of an EXISTING database and
>> >tab
Is there any method to find the CREATION DATE of an EXISTING database and
tables in MySQL 5.0 or newer versions?
information_schema.tables.create_time for tables.
PB
Uma Bhat wrote:
Hi all !
Is there any method to find the CREATION DATE of an EXISTING database and
tables in MySQL 5.0 or new
Hi all !
Is there any method to find the CREATION DATE of an EXISTING database and
tables in MySQL 5.0 or newer versions?
Thanks,
Uma
drop database_name;
make sure no ones is using the database_name.
--- Calvin Lam <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I am a newbie with this and I need help with Mysql
>
> How can I delete a database
nal Message-
>From: Calvin Lam [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, February 05, 2003 3:50 PM
>To: [EMAIL PROTECTED]
>Subject: Deleting a database in Mysql
>
>
>Hi,
>
>I am a newbie with this and I need help with Mysql
>
>How can I
On Wednesday 05 February 2003 16:50, Calvin Lam wrote:
> I am a newbie with this and I need help with Mysql
>
> How can I delete a database in Mysql
Use DROP DATABASE statement:
http://www.mysql.com/doc/en/DROP_DATABASE.html
--
For technical support contracts, g
DROP DATABASE dataBaseName;
-Original Message-
From: Calvin Lam [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 05, 2003 8:50 AM
To: [EMAIL PROTECTED]
Subject: Deleting a database in Mysql
Hi,
I am a newbie with this and I need help with Mysql
How can I delete a database in
Calvin,
CL> I am a newbie with this and I need help with Mysql
CL> How can I delete a database in Mysql
DROP DATABASE database_name;
Regards,
--
Stefan Hinz <[EMAIL PROTECTED]>
iConnect GmbH <http://iConnect.de>
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970
Hi Calvin,
Just do drop database db_name
Regards,
Eric
On Wed, 5 Feb 2003, Calvin Lam wrote:
> Hi,
>
> I am a newbie with this and I need help with Mysql
>
> How can I delete a database in Mysql
>
> thanks!
---
See DROP DATABASE
Doug
On Wed, 5 Feb 2003 22:50:25 +0800, Calvin Lam wrote:
>Hi,
>
>I am a newbie with this and I need help with Mysql
>
>How can I delete a database in Mysql
>
>thanks!
>
>-
&g
drop database yourdatabasename;
- Original Message -
From: "Calvin Lam" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 05, 2003 2:50 PM
Subject: Deleting a database in Mysql
> Hi,
>
> I am a newbie with this and I need help wi
Hi,
I am a newbie with this and I need help with Mysql
How can I delete a database in Mysql
thanks!
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the
AIL PROTECTED]>
Sent: Tuesday, July 02, 2002 1:59 PM
Subject: Recreating an MS-SQL database in MySQL: redux
> No response from the first post, so here goes for one more try...
>
> My employer recently acquired an existing web site that uses a MicroSoft
> SQL database and I've
No response from the first post, so here goes for one more try...
My employer recently acquired an existing web site that uses a MicroSoft
SQL database and I've been directed to get it running on an in-house
server. As we don't have any Windows servers, I need to recreate the
databas
lt;[EMAIL PROTECTED]>
Sent: Monday, April 08, 2002 8:14 AM
Subject: regular backup database in mysql
> I am using MySql version 4.0.0-alpha in Windows 2000.
> Everytime when I want to backup the database,i do it in MS-DOS.
> Using this command:
> >mysqldump --opt mydatabasename
ter that let Windows manage your database backups.
Enjoy,
Roberto Ramírez
-Mensaje original-
De: lorenzo.kh [mailto:[EMAIL PROTECTED]]
Enviado el: Lunes, 08 de Abril de 2002 12:15 a.m.
Para: [EMAIL PROTECTED]
Asunto: regular backup database in mysql
I am using MySql version 4.0.0-alpha in
I am using MySql version 4.0.0-alpha in Windows 2000.
Everytime when I want to backup the database,i do it in MS-DOS.
Using this command:
>mysqldump --opt mydatabasename > mybackup.sql
Now,lets say i never shut down my pc and the MySql is running all the time.
How can i do a regular backup (ie.eve
On Fri, Jan 11, 2002 at 11:42:59AM +0530, Manish Mehta wrote:
> Hi,
>
> As we know that MySql support maximum of 4 GB data per table.
Actually, you can go far larger than 4GB.
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454
Hi,
As we know that MySql support maximum of 4 GB data per table.
Now the question arise that what is the maximum limit of Database in MySQL.
Manish Mehta
E-mail: [EMAIL PROTECTED]
-
Before posting, please check:
http
32 matches
Mail list logo
