homepage Welcome to WebmasterWorld Guest from 54.226.147.84
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

    
Appending Data
Apending Data using SQL query
binarytrends

5+ Year Member



 
Msg#: 89 posted 10:47 am on Oct 13, 2005 (gmt 0)

I wonder if there is any way to APPEND data to an already populated field using a SQL query. I'm presently handeling it through PHP by writing two queries.

 

killroy

WebmasterWorld Senior Member 10+ Year Member



 
Msg#: 89 posted 12:38 pm on Oct 13, 2005 (gmt 0)

I suppose it would go like this:

UPDATE table SET field1=CONCAT(field1,' this will be appended to the end of field1') WHERE id=12345;

SN

binarytrends

5+ Year Member



 
Msg#: 89 posted 7:49 am on Oct 16, 2005 (gmt 0)

Thanks killroy

coopster

WebmasterWorld Administrator coopster us a WebmasterWorld Top Contributor of All Time 10+ Year Member



 
Msg#: 89 posted 12:43 am on Oct 17, 2005 (gmt 0)

That killroy supposes correctly quite often ;)

Welcome to WebmasterWorld, binarytrends.

txbakers

WebmasterWorld Senior Member txbakers us a WebmasterWorld Top Contributor of All Time 10+ Year Member



 
Msg#: 89 posted 12:54 am on Oct 17, 2005 (gmt 0)

I always forget the CONCAT and try to do it with a simple ampersand and wonder why all my data disappears!

binarytrends

5+ Year Member



 
Msg#: 89 posted 5:53 am on Oct 18, 2005 (gmt 0)

Hi Coopster, You must be right :)

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved