Hi,
We have Oracle SQL statements that uses UNION is there an equivalent for this in mySQL?
// Jocke
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the
-Original Message-
From: Van [mailto:[EMAIL PROTECTED]]
Sent: den 27 augusti 2001 11:01
To: Jarkeborn Joacim
Cc: [EMAIL PROTECTED]
Subject: Re: Help about joins
Jarkeborn Joacim wrote:
Hi,
I have a Oracle SQL string that contains '(+)' but when
running it in mySQL I
Yes, I have got the tip from 'Carl Troein', thanks anyway
CASE value WHEN [compare-value] THEN result [WHEN [compare-value] THEN result ...]
[ELSE result] END
Best regards
Joacim
-Original Message-
From: Harald Fuchs [mailto:[EMAIL PROTECTED]]
Sent: den 27 augusti 2001 11:43
To:
Hi,
I have the table:
CREATE TABLE WI_TEXTLISTUS (
TEXTID VARCHAR(50) NOT NULL,
COUNTRY VARCHAR(2) NOT NULL,
LANGUAGEVARCHAR(3) NOT NULL,
TEXTVARCHAR(250),
PRIMARY KEY (TEXTID,COUNTRY,LANGUAGE),
INDEX TEXTLISTUS_X1 (TEXT)
);
and when
Hi,
I have approx. 110 SQL scripts in a directory. Each containing DROP TABLE, CREATE
TABLE, lots of INSERT INTO and finally a COMMIT.
I need to run all these script in mysql console.
My plan is to write a perl script that looks into the directory and fetch all *.sql
scripts and then execute
space left on my local drives.
BR
Joacim
-Original Message-
From: Miguel Angel Solórzano [mailto:[EMAIL PROTECTED]]
Sent: den 12 juli 2001 18:54
To: Järkeborn Joacim; mySql Mailing List
Subject: Re: Placing database on a novell disk
At 15:01 12/07/2001 +0200, Järkeborn Joacim wrote
Hi,
I need to create a table that have field names 'LEFT' and 'RIGHT'. I have tried the
following but it doesn't work:
CREATE TABLE WI_POSITION (
PICTUREFILE VARCHAR(200) NOT NULL,
PICFILEXT VARCHAR(5),
POSITIONNOVARCHAR(10) NOT NULL,
SEQUENCENOVARCHAR(3),