Sponsored Content
Top Forums Programming MYSQL - trigger update on record insert or update Post 302902147 by barrydocks on Monday 19th of May 2014 02:53:52 AM
Old 05-19-2014
One additional thing, how do I add an additional SQL command to the trigger? For example say I want to create another column with the same data, ie:
Code:
create trigger before_update_concat before update on table1
for each row set new.col_comb  =  concat( new.cola,  ' - ',  new.colb,  ', ',  new.colc );

then add
Code:
for each row set new.col_comb2  =  concat( new.colc,  ' - ',  new.cola,  ', ',  new.colb );

thanks
 

8 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk script to update header record

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)
Discussion started by: klut
5 Replies

2. UNIX and Linux Applications

update trigger

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)
Discussion started by: kalinkula
0 Replies

3. Shell Programming and Scripting

Update trigger for unix file (solaris)

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)
Discussion started by: fran61
2 Replies

4. Shell Programming and Scripting

Insert/Update using sed

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)
Discussion started by: vivek_damodaran
9 Replies

5. Programming

MYSQL - trigger to track changes to fields on update

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)
Discussion started by: barrydocks
1 Replies

6. UNIX for Dummies Questions & Answers

Mysql: How to update value in 27000 rows?

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)
Discussion started by: postcd
3 Replies

7. UNIX for Dummies Questions & Answers

How to update DNS record in Solaris 5.10?

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)
Discussion started by: arocker
4 Replies

8. Shell Programming and Scripting

Insert one table and update another with shellscript

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
GIT-COLA(1)							    Git Manual							       GIT-COLA(1)

NAME
git-cola - A highly caffeinated git GUI SYNOPSIS
git cola [options] DESCRIPTION
git-cola is a powerful git GUI written in Python. It has many unique features that make git's advanced features simple and accessible. See below for a full list of options and usage information. OPTIONS
--classic Launch the standalone cola classic tool. -g, --git-path Specifies the path to the git binary. --prompt Prompt for a git repository instead of auto-detecting it in the current directory. -r, --repo=<path> Run git-cola on the git repository in <path>. Defaults to the current directory. -s, --style=<style> Launch git-cola with a different stylesheet. -v, --version Print the git-cola version and exit. GUI STYLES
git-cola ships with an alternate "dark" stylesheet. Specify --style=dark or provide an external stylesheet with --style=PATH. CONFIG VARIABLES
cola.savewindowsettings Whether git-cola should remember its window settings. cola.fontdiff Specifies the font to use for git-cola's diff display. cola.classicdockable Whether to create a dock widget with the Cola Classic tool. Defaults to false to speedup startup time. gui.diffcontext The number of diff context lines used and displayed by git-cola gui.editor The default text editor is controlled by gui.editor. The config variable overrides the EDITOR environment variable. gui.historybrowser Specifies the history browser to use when visualizing history. diff.tool The default diff tool to use. merge.tool The default merge tool to use. user.email Your email address to be recorded in any newly created commits. Can be overridden by the GIT_AUTHOR_EMAIL, GIT_COMMITTER_EMAIL, and EMAIL environment variables. See linkgit:git-commit-tree[1]. user.name Your full name to be recorded in any newly created commits. Can be overridden by the GIT_AUTHOR_NAME and GIT_COMMITTER_NAME environment variables. See linkgit:git-commit-tree[1]. See linkgit:git-config[1] for more details. ENVIRONMENT VARIABLES
EDITOR Specifies the default editor to use. This is ignored when the git config variable gui.editor is defined. GIT_PYTHON_TRACE When defined, prints git commands and status to the terminal. Print more information when set to the value full. GIT_COLA_TRACE When defined, git-cola outputs the git commands it executes into the Command Output log viewer. SOURCE
A git-cola development repository can be obtained via git: git clone git://github.com/davvid/git-cola.git GUI THEMES
git-cola ships with an alternative stylesheet called dark. You can use this stylesheet by running git cola --style=dark. You can also skin git-cola by providing your own Qt stylesheet. E.g. git cola --style=/path/to/style.qss. Built-in styles can be found in /usr/share/git-cola/styles. LINKS
git-cola homepage http://cola.tuxfamily.org/ git-cola sources on github http://github.com/davvid/git-cola SEE ALSO
linkgit:git-difftool[1] Compare changes using common merge tools. linkgit:gitk[1] The git repository browser. Shows branches, commit history and file differences. gitk is the utility started by git-cola's Repository Visualize actions. GIT
git-cola is independently developed from the linkgit:git[7] suite, but you can use it just like any other git command, e.g. git cola. AUTHOR
Written by David Aguilar <davvid@gmail.com[1]>. NOTES
1. davvid@gmail.com mailto:davvid@gmail.com Git 09/01/2011 GIT-COLA(1)
All times are GMT -4. The time now is 04:45 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy