|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
executing mysql load statement from shell script
Post 302279107 by DILEEP410 on Thursday 22nd of January 2009 02:11:34 AM
01-22-2009
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I am a beginner. I need an example of using DB2 Load Utility in Shell script.
I appreciate if anyone could help me about it.
Thanks,
Paris (0 Replies)
Discussion started by: parisbeginner
0 Replies
2. Shell Programming and Scripting
hi all
need your help.
I am wrting a script that will load data into the table.
then on another load will append the data into the existing table.
Regards
Ankit (1 Reply)
Discussion started by: ankitgupta
1 Replies
3. Shell Programming and Scripting
Hi All,
I need to select one column from a table based upon the passed in parameter.
I tried this:
sqlplus -silent $MISP_USER << EOF
set feedback off;
set verify off;
set sqlprompt ""
SELECT mail_flag
FROM dailyjobs
WHERE job_name = '$1';
exit 0
EOF
exit... (1 Reply)
Discussion started by: ganga.dharan
1 Replies
4. Shell Programming and Scripting
I have a csv file in a folder that is roughly 500,000 rows long.
Rather than using PHP, I would like to use SH to run a MYSQL LOAD DATA command to load the data in, as I think it would be much faster and would not cause any memory problems associated with PHP.
But the problem is, I am not... (18 Replies)
Discussion started by: worchyld
18 Replies
5. Shell Programming and Scripting
friends , need a shell script to create a disk load. can any one pls guide me with how this can be implemented. Pls provide the concept. from there i will try to design my script. (3 Replies)
Discussion started by: achak01
3 Replies
6. Homework & Coursework Questions
Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted!
1. The problem statement, all variables and given/known data:
Create a phonebook program.
It should use functions to perform the required tasks. It should be menu-based,... (1 Reply)
Discussion started by: Rgasin02
1 Replies
7. Programming
hi,
I am trying to load a sybase table using a file ( unit separator is the delimiter) which is in IQ server.
I Used load statment as below
execute ('LOAD TABLE schemaname.tablename (' || ' name, age, date, Symbols) from ' || ' '' /filepath/file.txt '' ' || ' QUOTES off ' || ' DELIMITED... (0 Replies)
Discussion started by: irudayaraj
0 Replies
8. Shell Programming and Scripting
Hi All,
Please see the below script for mysql 3 commands. Its giving me the right output for all three commands but showing some errors in first two commands , i guess there might be an issue with date.
Can anyone help me .
#! /bin/bash
TABLE_NAME=testingddatabase
USER_NAME=root... (3 Replies)
Discussion started by: aish11
3 Replies
9. Shell Programming and Scripting
Hi,
I need to balance the load to be processed by the system using shell script.
The scenario is like below:
Suppose there are some files in a directory:
-rw-rw-r-- 1 usr usrgrp 456432306 Oct 23 07:53 abc_queue_q1
-rw-rw-r-- 1 usr usrgrp 4123934 Oct 23 07:53... (1 Reply)
Discussion started by: vsachan
1 Replies
10. Shell Programming and Scripting
How to keep staying on remote server after executing a shell script with if then exit end statement?
i have a "if .. then exit end " in s shell script on remote servers.
now the connection to the remote server got killed after i run this script on the remote servers. How do i run this script on remote hosts and still keep remote connections alive after executing the script.
Thank you. (10 Replies)
Discussion started by: moonmonk
10 Replies
LEARN ABOUT LINUX
ndb_drop_table
NDB_DROP_TABLE(1) MySQL Database System NDB_DROP_TABLE(1) NAME
ndb_drop_table - drop an NDB table SYNOPSIS
ndb_drop_table options DESCRIPTION
ndb_drop_table drops the specified NDB table. (If you try to use this on a table created with a storage engine other than NDB, the attempt fails with the error 723: No such table exists.) This operation is extremely fast; in some cases, it can be an order of magnitude faster than using a MySQL DROP TABLE statement on an NDB table. Usage ndb_drop_table -c connect_string tbl_name -d db_name The following table includes options that are specific to ndb_drop_table. Additional descriptions follow the table. For options common to most MySQL Cluster programs (including ndb_drop_table), see Options Common to MySQL Cluster Programs(1). Table 17.19. ndb_drop_table Options and Variables: MySQL Cluster NDB 7.2 +--------------------------+-----------------------------------+-------------------------------------+ |Format | Description | Added / Removed | +--------------------------+-----------------------------------+-------------------------------------+ | | Name of the database in which the | | | --database=dbname, | table is found | All MySQL 5.5 based releases | | | | | | -d | | | +--------------------------+-----------------------------------+-------------------------------------+ COPYRIGHT
Copyright (C) 1997, 2014, Oracle and/or its affiliates. All rights reserved. This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as published by the Free Software Foundation; version 2 of the License. This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see http://www.gnu.org/licenses/. SEE ALSO
For more information, please refer to the MySQL Reference Manual, which may already be installed locally and which is also available online at http://dev.mysql.com/doc/. AUTHOR
Oracle Corporation (http://dev.mysql.com/). MySQL 5.5 01/30/2014 NDB_DROP_TABLE(1)