Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Discussions :

Request SQL ?

Jan 10, 2004, 5:39 AM
mick31
User (201 posts)
Jan 10, 2004, 5:39 AM
Post #1 of 6
Views: 1483
Shortcut
Quote Reply
Request SQL ?
Hello.

I must modify a date in my table lsql_Links.


Table: lsql_Links
Column: Add_Date
2003-07-09 with -> 2003-10-09

But, I do not want to modify the other dates in the column...

It is possible to work with a request SQL ?


I did not find an answer on the forum.
Thank you for your assistance.


Mick.
Jan 10, 2004, 6:26 AM
mick31
User (201 posts)
Jan 10, 2004, 6:26 AM
Post #2 of 6
Views: 1447
Shortcut
Quote Reply
Re: [mick31] Request SQL ? In reply to
Hello,

I found this request :

UPDATE lsql_Links SET Add_Date='2003-10-09'

But, it replaces all the entries (dates) in the column. Unsure

Thank you for your assistance.
An idea?
Mick
Jan 10, 2004, 6:41 AM
mick31
User (201 posts)
Jan 10, 2004, 6:41 AM
Post #3 of 6
Views: 1460
Shortcut
Quote Reply
Re: [mick31] Request SQL ? In reply to
Hello

I found this request

UPDATE lsql_Links SET Add_Date='2003-07-09' WHERE Add_Date='2003-10-09'

Somebody little to confirm ?

Thank you

Mick


Jan 10, 2004, 7:13 AM
mick31
User (201 posts)
Jan 10, 2004, 7:13 AM
Post #4 of 6
Views: 1447
Shortcut
Quote Reply
Re: [mick31] Request SQL ? In reply to
Hello,

This request worked well.

UPDATE lsql_Links SET Add_Date=REPLACE(Add_Date, '2003-07-09', '2003-10-09');

Words of research in the forum : UPDATE lsql_Links

http://www.gossamer-threads.com/...i?post=236525#236525

Excuse, but I am not a programmer ... Frown

Mick
Jan 10, 2004, 7:14 AM
pugdog
Veteran / Moderator (6956 posts)
Jan 10, 2004, 7:14 AM
Post #5 of 6
Views: 1445
Shortcut
Quote Reply
Re: [mick31] Request SQL ? In reply to
>> UPDATE lsql_Links SET Add_Date='2003-07-09' WHERE Add_Date='2003-10-09'


That will change an existing date of 2003-10-09 to 2003-07-09


PUGDOG� Enterprises, Inc.

The best way to contact me is to NOT use Email.
Please leave a PM here.
Jan 10, 2004, 7:19 AM
mick31
User (201 posts)
Jan 10, 2004, 7:19 AM
Post #6 of 6
Views: 1442
Shortcut
Quote Reply
Re: [pugdog] Request SQL ? In reply to
Hello Pudog,

Thank you for your assistance. Smile

Mick