Cawley, Gerald Clark and Michael Dykman for
helping with this problem.
I learnt a lot from the list today. Thanks!
Regards, Adai.
On Mon, 2004-07-26 at 18:04, Keith Ivey wrote:
> Adaikalavan Ramasamy wrote:
>
> >This naive syntax does not work :
> >IF EXISTS (SELECT myID FROM
, but you could make use of the
> ON DUPLICATE KEY mechanism. Assuming you create a unique index on
> firstname, lastname, your update might read:
> INSERT INTO tb (firstname, lastname) VALUES ('Jack', 'Doe')
> ON DUPLICATE KEY UPDATE lastname = lastname;
>
firstname='Jack' AND
lastname='Doe') ELSE (INSERT INTO tb(firstname, lastname) VALUES
('Jack', 'Doe');
On Mon, 2004-07-26 at 16:20, [EMAIL PROTECTED] wrote:
> Adaikalavan Ramasamy <[EMAIL PROTECTED]> wrote on 26/07/2004
> 16:05:23:
>
>
I am creating a small database that keeps track of users and assigns
them a unique user ID.
The problem is that sometimes the users might request to be added more
than once (i.e. click on the submit button multiple times). Therefore I
only want to add users if their details (here defined by both
-26 at 14:07, Victor Pendleton wrote:
> Try using the REPLACE command.
>
> -Original Message-
> From: Adaikalavan Ramasamy
> To: [EMAIL PROTECTED]
> Sent: 7/26/04 8:04 AM
> Subject: String substitution in MYSQL
>
> I am looking for a string substitution command in
I am looking for a string substitution command in MYSQL and was
wondering if anyone can help me. Searching the archives was not
fruitful. Here is an example :
CREATE TABLE tbl (id INT(2), names VARCHAR(20));
INSERT INTO tbl VALUES (1, 'aaa');
INSERT INTO tbl VALUES (2, 'bbb; aaa; ccc');
SE
ppreciated. Thank you very much.
Regards, Adaikalavan Ramasamy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Dear all,
My system specs are Sun Solaris 8. As I do not have root permission, is it
possible to install mysql locally in my home drive ? I checked the manuals
but there does not seem to answer my question.
If so, what is the expected total size on disk and recommended steps
(./configure, make, m
