•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 401,997 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,523 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Views: 751 | Replies: 4
 |
•
•
Join Date: Oct 2006
Posts: 62
Reputation: 
Rep Power: 2
Solved Threads: 0
Junior Poster in Training
How to create a trigger to UPDATE this for me when a new record is inserted.
I want to create a column called "fullthumb" where by default it has the words "http://example.com/thumbs/" and add the words in "thumb" column.
UPDATE files SET
fullthumb = CONCAT('http://example.com/thumbs/', thumb);
I want to create a column called "fullthumb" where by default it has the words "http://example.com/thumbs/" and add the words in "thumb" column.
UPDATE files SET
fullthumb = CONCAT('http://example.com/thumbs/', thumb);
•
•
Join Date: Oct 2006
Posts: 62
Reputation:
Rep Power: 2
Solved Threads: 0
Junior Poster in Training
•
•
Join Date: Dec 2007
Posts: 112
Reputation:
Rep Power: 1
Solved Threads: 13
Junior Poster
What you have made so far?
|
•
•
•
•
•
•
•
•
DaniWeb MySQL Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
- Trigger problem (MS SQL)
- Problem on IF STATEMENT on TRIGGER with MySql (MySQL)
- Trigger problem... (MySQL)
- Create trigger mysql5 with java (Java)
- Trigger help (MS SQL)
- Computed column in view VS trigger on update (MS SQL)
- Ms Sql 2000 (MS SQL)
- Auto update columns? (Database Design)
Other Threads in the MySQL Forum
- Previous Thread: Count number of searches with with database/flat file
- Next Thread: displaying images
