Since mySql doesn't allow "update or insert" syntax you will need to create a 'before insert' and a 'before update' trigger.
Example code:
Code:
create trigger before_insert_concat before insert on table1
for each row set col_comb = concat( new.cola, ' - ', new.colb, ', ', new.colc );
create trigger before_update_concat before update on table1
for each row set new.col_comb = concat( new.cola, ' - ', new.colb, ', ', new.colc );
Sorry I am a bit confused, does that mean I need to create a table named 'new' with 4 columns, 'col_comb', 'cola', colb', and 'colc'??
--------------Edit--------------------
Ignore all that, it works - thanks your a star :-)
Last edited by barrydocks; 02-24-2014 at 05:45 PM..
I am using HP UX and think this may be done with awk but bot sure.
I have a file with a several header records and undeneath many detail records I need to put in the header record the number of detail records above this header record and number of detail records below this header record
Header... (5 Replies)
hi all,
i hope i am posting this /beginner) question in the right forum:
i want to create an update trigger, which rolls back a transaction if a record of a table is updated. the table has - amongst others - a field 'statusid' - if a record in this table has the statusid X and it is attempted... (0 Replies)
Hello,
from log error file of process that i's updating in append mode, i need to capture the new entries for every day.
How i can know and save only the new errors?
This it's a sample of error log file (oas report server engine)
thanks and regards
Fran (2 Replies)
Hi,
I have a xml file (Config.xml) with following entry
<Date="" Node1="50" Groups="20">
Now I want to use sed to insert/update the Date field with the latest date say - 20120711. I can't use a simple replace command becuase the Date field could be blank ("") or sometimes could have value in... (9 Replies)
So I have a php web application that allows updating of records. I would like to track the changes of only the fields that have changed. There are plenty of how to's that involve recreating the original row in a separate table with an additional time/date stamp column but I think this is a big... (1 Reply)
Hello,
some member created 27000 posts in wrong section (lol :D) so i need to edit all his entries to get new section ID.
SELECT * FROM `phpbb_topics` WHERE `topic_first_poster_name` LIKE "%ozerway%";
this will select all his topics...
the column with forum id is named "forum_id" and... (3 Replies)
Hi
I have a DNS server running on Solaris 5.10, I need to update ip address of two urls defined on our dns server how do i do that?
and do i need to restart dns/named service after? how do i restart the service?
Thanks (4 Replies)
I have a problem with my shell script. I want to insert data from file to table1(empty) and then, compare table1 with table2 and update some fields.
The first part is correct, but the second part does not work. The only way it works is if after the first part I truncate table1 and run the script... (1 Reply)
Discussion started by: nika_mill
1 Replies
LEARN ABOUT DEBIAN
update-default-wordlist
UPDATE-DEFAULT-WORDLIST(8)UPDATE-DEFAULT-WORDLIST(8)NAME
update-default-wordlist - update default wordlist
SYNOPSIS
update-default-wordlist [--dico-postinst] [--triggered]
DESCRIPTION
WARNING: Not to be used from the command line unless you know very well what you are doing.
This program is intended to be called from wordlist package postinst, from select-default-wordlist or from dictionaries-common postinst
(with --dico-postinst).
When called under dpkg control without the --dico-postinst option, a dictionaries-common trigger is enabled to be run later. In the
triggered run (or when is called from the command line or with --trigger option), reads the system default from the debconf database and
set default links in /etc/dictionaries-common pointing to the appropriate files in /usr/share/dict/. and rebuilds the
/var/cache/dictionaries-common/wordlist.db from the files in /var/lib/dictionaries-common/wordlist
When called from from dictionaries-common postinst with --dico-postinst symlinks creation step will be skipped and trigger not enabled.
OPTIONS --dico-postinst Do not enable trigger nor try to set default symlinks. --triggered Run all the code instead of trying to enable
update-default-wordlist trigger
SEE ALSO
The dictionaries-common policy document
AUTHORS
Rafael Laboissiere Agustin Martin Domingo
1.12.11 2013-1-22 UPDATE-DEFAULT-WORDLIST(8)