No, If you are using non-persistence connection once the query get
complete you are closing the connection properly.
On Wed, Nov 14, 2012 at 11:44 AM, Trimurthy trimur...@tulassi.com wrote:
hi every one, i am working with some application which is
developed in php and back
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 mog...@fumlersoft.dkwrote:
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'
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
mog...@fumlersoft.dkwrote:
Or you could import the
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 in
Hi Machiel
use following steps
1) make binary log into readable format through mysqlbinlog
mysqlbinlog -u{user} -p{password} log.log(this any text
file)
2) read text file check next position just after position where replication
is stuck
3) run the *change master* command on
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
Hi everybody,
2013 is near… and so is the next FOSDEM edition !
This year again, MySQL will be represented by its Community.
If you want to discuss with friends of MySQL it's the place to be in
February !
Like every year, FOSDEM takes place the first week-end of February in
Brussels.
We will
While it is possible to pivot a table like that, the code is ugly, and does not
work well if you need a variable number of columns.
SQL can do the JOIN to get a single resultset for the information, but the
layout is best done in a application language, such as PHP.
-Original Message-
On Tue, November 13, 2012 22:38, Prabhat Kumar wrote:
No, If you are using non-persistence connection once the query get
complete you are closing the connection properly.
Is this true if you are using mod_php or equivalent?
On Wed, Nov 14, 2012 at 11:44 AM, Trimurthy trimur...@tulassi.com
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 days)
I have a query I'm having trouble with. If do this query which is DATE plus
ProcModecode, it is very fast:
SELECT e.zzk FROM exams e
-- JOIN Appt_ a ON e.IdAppt = a.IdAppt
-- JOIN Affil_ af ON a.IdAffil_primary = af.IdAffil
WHERE e.dateexam = '2012-09-01' AND e.dateexam = '2012-09-30'
AND
Thanks Rick
Yes, I know it's not going the most (in lack of descriptive words) pretty
piece of code. The variable number of columns is the key phrase here.
I've already told them, this is not a SQL task, but having infinite
trust in my peers out there I know it can be done. I just fail
to do the
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 contain two
Can't help without the SHOW CREATE TABLEs.
Perhaps e needs one of these:
INDEX(zzk)
INDEX(ProcModeCode, dateexam) -- in that order
(I can't predict which index it would use.)
Are IdAppt the same datatype and collation in each table?
-Original Message-
From: James W. McNeely
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 named like
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 are four
Rick,
Thanks! Here is the create table info. Sorry for the size, but you can skip
down from all the fields to see the indexes.
CREATE TABLE `exams` (
`zAddDate` date DEFAULT NULL,
`zModDate` date DEFAULT NULL,
`IdPatient` varchar(32) DEFAULT NULL,
`zModBy` varchar(255) DEFAULT NULL,
A PRIMARY KEY is a KEY, so the second of these is redundant:
PRIMARY KEY (`zzk`),
KEY `zzk` (`zzk`),
Compound indexes are your friend. Learn from
http://mysql.rjweb.org/doc.php/index1
`zzr_StatusTime` mediumtext,
`zzr_StatusDate` mediumtext,
Don't need 16MB for a date or time.
On 2012-11-14 5:08 PM, Mogens Melander wrote:
Thanks Rick
Yes, I know it's not going the most (in lack of descriptive words) pretty
piece of code. The variable number of columns is the key phrase here.
I've already told them, this is not a SQL task, but having infinite
trust in my peers out
19 matches
Mail list logo