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
.
.
.
columns
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,
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
2kljh
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
2asdd3
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
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 tablename 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 user database
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 = columnname2
where KEY = KEY
Something like that probably
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 (*_*)
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
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
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
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
tables: 1
Open tables: 19 Queries per second avg: 0.017
--
- Original Message -
From: "Sam Smith" [EMAIL PROTECTED]
To: "Erling Paulsen" [EMAIL PROTECTED]
Sent: Friday, March 16, 2001 3:21 AM
Subject: Re: Columns named with the # character
On Fri, 16 Mar
14 matches
Mail list logo