JC <[EMAIL PROTECTED]> wrote on 02/01/2006 01:15:00 PM:
> Hi all,
>
> I really need your help.
>
> I have two tables:
>
> table1:
> id1|1|2|3|4|
> 000+a+b+c+d
> 001+e+f+g+h
> .
> .
> .
> and
>
> table2:
> id2|col1|col2|col3
>1+val1+val2+val3
>2+val4+val5+val6
>3
>4
>.
>
IF the dates are limited and can be agreed upon before running the
kwiri, you can use:
SELECT no,
IF (date=d1, data, NULL) d1,
IF (date=d2, data, NULL) d2,
IF (date=d3, data, NULL) d3
FROM table
GROUP BY no;
It will also NOT work if one date can contain multiple data, e.g.
I disagree, even though I had my own share of problems in compiling 4.0.13.
The clue is in the error message
>> configure:error: no acceptable C compiler found in $PATH
It is very likely that if he typed
which cc or which gcc
the reply would come back
No cc (gcc) in ... (a list
"Phil Evans" <[EMAIL PROTECTED]> wrote:
> Hi there. I am a rank amateur at this trying to make sense out of a heap (and
> growing) of data.
>
> I have a resultset with this structure:
>
> nodatadate
> 1uytd1
> 1klhd2
> 1oiud3
> 2kjhd1
> 2kljhd2
> 2
On Sat, Jul 12, 2003 at 01:11:41AM +1000, Phil Evans wrote:
> Hi there. I am a rank amateur at this trying to make sense out of a heap (and
> growing) of data.
>
> I have a resultset with this structure:
>
> nodatadate
> 1uytd1
> 1klhd2
> 1oiud3
> 2kjhd1
>
John,
Saturday, May 11, 2002, 3:13:33 AM, you wrote:
JD> is there a way to delete a column from a table, without droping the whole
JD> table?
Sure, you can use ALTER TABLE:
http://www.mysql.com/doc/A/L/ALTER_TABLE.html
JD> If not is can I get sql to replicate the command to re create the
> is there a way to delete a column from a table, without droping the
> whole table?
Yep!
ALTER TABLE DROP [COLUMN] col_name
http://www.mysql.com/doc/A/L/ALTER_TABLE.html
> If not is can I get sql to replicate the command to re create the table?
Yep!
mysqldump -qd -u
http://www.mysql.com
eith A. Calaman [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, 13 February 2002 5:08 a.m.
> To: Max Mouse; [EMAIL PROTECTED]
> Subject: RE: Columns
>
>
> Sounds like an UPDATE:
>
> http://www.mysql.com/doc/U/P/UPDATE.html
>
> UPDATE TABLE
> SET columnname1 = columnnam
UPDATE mytable SET newcol=oldcol;
-Original Message-
From: Max Mouse [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 06, 2002 3:11 PM
To: [EMAIL PROTECTED]
Subject: Columns
Hey all,
Is it possible to copy the contents of one column to another column using
mySQL? I just
changed my
Sounds like an UPDATE:
http://www.mysql.com/doc/U/P/UPDATE.html
UPDATE TABLE
SET columnname1 = columnname2
where KEY = KEY
Something like that probably. If it was me I would copy the whole table so
I had a backup...UPDATES and DELETES can be destructive if writting
improperly (*_*)
-Origi
On Wed, Feb 06, 2002 at 04:10:33PM -0500, Max Mouse wrote:
> Hey all,
>
> Is it possible to copy the contents of one column to another column
> using mySQL? I just changed my table structure by adding a few more
> columns and I need to be able to move the data from the original
> column to 4 new
On Fri, Mar 16, 2001 at 10:33:05AM +0100, Fred van Engen wrote:
> The mysql client doesn't know about backticks and therefore handles the #
> (and '-- ') as the beginning of a comment. It wouldn't do that for quoted
> and double-quoted strings.
>
> I see no workaround other than to change the cli
Erling and MySQL guys,
On Fri, Mar 16, 2001 at 02:18:55AM +0100, Erling Paulsen wrote:
> I just exported (via myodbc) an old access database for my sportsclub to
> mysql (the tables). The ms-access database application still works nicely on
> the new linked tables in mysql. However, I'm now also
day 17 hours 47 sec
Threads: 19 Questions: 2457 Slow queries: 0 Opens: 30 Flush tables: 1
Open tables: 19 Queries per second avg: 0.017
--
- Original Message -
From: "Sam Smith" <[EMAIL PROTECTED]>
To: "Erling Paulsen" <[EMAIL PROTECTED]>
At 2:18 AM +0100 3/16/01, Erling Paulsen wrote:
>I just exported (via myodbc) an old access database for my sportsclub to
>mysql (the tables). The ms-access database application still works nicely on
>the new linked tables in mysql. However, I'm now also writing a php based
>client to use the data
15 matches
Mail list logo
