01-13-2014
Why do you think DDL on a table to be done via script? Is this going to be repeated activity?
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi All,
I need to write a shell script in UNIX that should accept booking number as an argument and update it with value "NULL" if the transaction date is greater than 2 years. Booking number and transaction_date are the two columns of the table table_booking.
Something like this, through... (3 Replies)
Discussion started by: shilpa_acc
3 Replies
2. Web Development
Hi all,
I was wondering if anyone knew a good/safe way to update a single column in a table that could contain upto 8 million rows...
simple command like:
UPDATE set blah=foo where bar=XXX;
I will be running this on tables being written to and tables that have already been created.
... (3 Replies)
Discussion started by: muay_tb
3 Replies
3. Shell Programming and Scripting
Hi all,
I am running this script on Mandrakelinux release 10.1, 2.6.8.1-12mdksmp #1 SMP
I have also installed 'expect' separately.
I have created an Rsync script, but before any Rsync command does run, a MySql dump must be done first, and I am battling a bit to pass the MySql password from... (2 Replies)
Discussion started by: codenjanod
2 Replies
4. Shell Programming and Scripting
Hi, i have the following:
db="create database xxx;GRANT ALL PRIVILEGES ON xxx.* TO user@localhost IDENTIFIED BY 'password';FLUSH PRIVILEGES;quit;"
mysql -u root -p$mysql_pass -e "$db"
I don't understand why this is failing, it works fine when run from cmd but when is run in a bash script,... (1 Reply)
Discussion started by: ktm
1 Replies
5. Shell Programming and Scripting
Can someone tell me the syntax to run a shell script from within MySQL? I know there is a way to do it, but I can't remember the syntax. I thought it was something like:
mysql> \. /user/myscript;
but I get this error:
Failed to open file '/user/myscript;', error: 2
Please help!... (4 Replies)
Discussion started by: peterv6
4 Replies
6. Shell Programming and Scripting
i'm trying to write a bash script that executes a mysql statement
mysql -sN -e INSERT INTO "$database"."$tableprefix"users (var1, var2,var3) VALUES (123, '1','')
i don't know where to put the quotes
it doesnt work with this one: `
it seems i can only put double quotes around the... (0 Replies)
Discussion started by: vanessafan99
0 Replies
7. Shell Programming and Scripting
I'm running mysql in a bash script
mysql <<EOF
query
EOF
one query is like this:
UPDATE $dbname.$prefix"config" SET value = $var WHERE "$prefix"config.name = 'table colname';
with variable
but it's giving an error
i'm not sure what to put for
"$prefix"config.name
the table... (3 Replies)
Discussion started by: vanessafan99
3 Replies
8. Shell Programming and Scripting
Hello!
I've got script to write. It should read databases (names, volumes) from table testdatabase and compares it to actually existing databases in /var/lib/mysql/. If there is no informations about database in table - we should see information "There is no declared informations about database... (1 Reply)
Discussion started by: Zimny
1 Replies
9. Programming
Right I have a MYSQL database with table1 with 3 columns, colA, colB and colC. I want to combine the data in the 3 columns into a 4th column names col_comb. Here's the SQL command that works:
UPDATE table1 SET `col_comb` = CONCAT( `colA` , ' - ', `colB` , ', ', `colC` );
So now I want this... (5 Replies)
Discussion started by: barrydocks
5 Replies
10. Ubuntu
Hi guys,
I recently managed to write up my working script, but now I have a problem.
If the file isn't there in the remote server, my actual script jumps it and all ok, but I need something like this:
Search file -> if there, then download -> if not, download next file in the list.
Any... (7 Replies)
Discussion started by: virtus96
7 Replies
LEARN ABOUT DEBIAN
starpu_workers_activity
STARPU_WORKERS_ACTIVITY:(1) User Commands STARPU_WORKERS_ACTIVITY:(1)
NAME
starpu_workers_activity: - manual page for starpu_workers_activity: 40: [: --version: unexpected operator
DESCRIPTION
./starpu_workers_activity: 40: [: --help: unexpected operator ./starpu_workers_activity: 40: [: --help: unexpected operator ./starpu_work-
ers_activity: 45: [: --help: unexpected operator ./starpu_workers_activity: 45: [: --help: unexpected operator ./starpu_workers_activity:
45: [: --help: unexpected operator Error. File <--help> not found
Offline tool to display the activity of the workers during the execution.
The starpu_fxt_tool utility now generates a file named 'activity.data' which can be processed by this script to generate a plot
named activity.eps
Typical usage:
./starpu_fxt_tool -i /tmp/prof_file_foo ./starpu_workers_activity activity.data
OPTIONS
-h, --help
display this help and exit
-v, --version
output version information and exit
-h, --help
display this help and exit
-v, --version
output version information and exit
REPORTING BUGS
Report bugs to <starpu-devel@lists.gforge.inria.fr>
./starpu_workers_activity: 40: [: --version: unexpected operator ./starpu_workers_activity: 45: [: --version: unexpected operator
./starpu_workers_activity: 45: [: --version: unexpected operator ./starpu_workers_activity: 45: [: --version: unexpected operator
Error. File <--version> not found
Offline tool to display the activity of the workers during the execution.
The starpu_fxt_tool utility now generates a file named 'activity.data' which can be processed by this script to generate a plot
named activity.eps
Typical usage:
./starpu_fxt_tool -i /tmp/prof_file_foo ./starpu_workers_activity activity.data
Report bugs to <starpu-devel@lists.gforge.inria.fr>
starpu_workers_activity: 40: [: --version: unexpected operator November 2013 STARPU_WORKERS_ACTIVITY:(1)