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 th
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
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,
`N
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
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 [mailto:
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
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 th
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 e
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
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 wrote:
>
>> hi eve
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-
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 a
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 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
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
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 wrote:
> hi every one, i am working with some application which is
> developed in php and back end is mysql. in th
19 matches
Mail list logo
