10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi dears
i use bash shell
i have INPUT.txt
like this
number of columns different in one
some row have 12 , some 11 columns
see last column
INPUT.txt
CodeGender Age Grade Dialect Session Sentence Start End Length Phonemic Phonetic
63 M 27 BS/BA TEHRANI 3 4 298320 310050... (2 Replies)
Discussion started by: alii
2 Replies
2. Shell Programming and Scripting
Hi There,
I'm trying to write a simple script that will email me when we have an application job in a certain status that needs human intervention. I've used this script for other tables and it works great. However, this one gives me the warning that there is binary data so it might not. ... (2 Replies)
Discussion started by: Colel2
2 Replies
3. Shell Programming and Scripting
I want to lookup values from two different tables based on common columns and append. The trick is the column to be looked up is not fixed and varies , so it has to be detected from the header. How can I achieve this at once, for multiple data files, but lookup tables fixed.
The two lookup... (5 Replies)
Discussion started by: ritakadm
5 Replies
4. Shell Programming and Scripting
HOw to extracts data from tables in database. Merges them into one output file. This output file is loaded into another tables in database. (1 Reply)
Discussion started by: nari.bommi
1 Replies
5. AIX
Please help me in creating the script in AIX.
requirement is;
The new component's main function is to extract the data from DB2 tables and company's firewall directly.
The component function needs to check the timestamp in the DB2 tables ((CREDAT and CRETIM) with the requested timestamp and... (1 Reply)
Discussion started by: priyanka3006
1 Replies
6. Shell Programming and Scripting
Hi,
I have two databases with same tables on different servers.I need to check the data content in each table and if something is missing, should print that.
I have a tool which takes the snapshot the table structure,index so on and compares with the other server tables snapshot.
Now i need... (1 Reply)
Discussion started by: nessj
1 Replies
7. UNIX Desktop Questions & Answers
Hi
I am trying to write a script to extract information from a database and save that info to a csv file.
I am using sql, an oracle database
I have no idea how to even begin this.
Can somebody please help. (8 Replies)
Discussion started by: ladyAnne
8 Replies
8. Shell Programming and Scripting
Hi ,
I want to read the data from 9 tables in oracle DB into 9 different files in the same connection instance (session). I am able to get data from one table to one file with below code :
X=`sqlplus -s user/pwd@DB <<eof
select col1 from table1;
EXIT;
eof`
echo $X>myfile
Can anyone... (2 Replies)
Discussion started by: net
2 Replies
9. UNIX for Dummies Questions & Answers
hi
i need to use unix to extract data from several rows of a table coded in html. I know that rows within a table have the tags <tr> </tr> and so i thought that my first step should be to to delete all of the other html code which is not contained within these tags. i could then use this method... (8 Replies)
Discussion started by: Streetrcr
8 Replies
10. Shell Programming and Scripting
I am trying to transpose tables listed in the format into format. Any help would be greatly appreciated.
Input:
test_data_1
1 2 90%
4 3 91%
5 4 90%
6 5 90%
9 6 90%
test_data_2
3 5 92%
5 4 92%
7 3 93%
9 2 92%
1 1 92%
...
Output:... (7 Replies)
Discussion started by: justthisguy
7 Replies
MYSQL_TABLEINFO(1) User Contributed Perl Documentation MYSQL_TABLEINFO(1)
NAME
mysql_tableinfo - creates and populates information tables with the output of SHOW DATABASES, SHOW TABLES (or SHOW TABLE STATUS), SHOW COL-
UMNS and SHOW INDEX.
This is version 1.1.
SYNOPSIS
mysql_tableinfo [OPTIONS] database_to_write [database_like_wild] [table_like_wild]
Do not backquote (``) database_to_write,
and do not quote ('') database_like_wild or table_like_wild
Examples:
mysql_tableinfo info
mysql_tableinfo info this_db
mysql_tableinfo info %a% b%
mysql_tableinfo info --clear-only
mysql_tableinfo info --col --idx --table-status
DESCRIPTION
mysql_tableinfo asks a MySQL server information about its databases, tables, table columns and index, and stores this in tables called
`db`, `tbl` (or `tbl_status`), `col`, `idx` (with an optional prefix specified with --prefix). After that, you can query these information
tables, for example to build your admin scripts with SQL queries, like
SELECT CONCAT("CHECK TABLE ",`database`,".",`table`," EXTENDED;") FROM info.tbl WHERE ... ;
as people usually do with some other RDBMS (note: to increase the speed of your queries on the info tables, you may add some index on
them).
The database_like_wild and table_like_wild instructs the program to gather information only about databases and tables whose names match
these patterns. If the info tables already exist, their rows matching the patterns are simply deleted and replaced by the new ones. That
is, old rows not matching the patterns are not touched. If the database_like_wild and table_like_wild arguments are not specified on the
command-line they default to "%".
The program :
- does CREATE DATABASE IF NOT EXISTS database_to_write where database_to_write is the database name specified on the command-line.
- does CREATE TABLE IF NOT EXISTS database_to_write.`db`
- fills database_to_write.`db` with the output of SHOW DATABASES LIKE database_like_wild
- does CREATE TABLE IF NOT EXISTS database_to_write.`tbl` (respectively database_to_write.`tbl_status` if the --tbl-status option is on)
- for every found database, fills database_to_write.`tbl` (respectively database_to_write.`tbl_status`) with the output of SHOW TABLES FROM
found_db LIKE table_like_wild (respectively SHOW TABLE STATUS FROM found_db LIKE table_like_wild)
- if the --col option is on,
* does CREATE TABLE IF NOT EXISTS database_to_write.`col`
* for every found table,
fills database_to_write.`col` with the output of
SHOW COLUMNS FROM found_tbl FROM found_db
- if the --idx option is on,
* does CREATE TABLE IF NOT EXISTS database_to_write.`idx`
* for every found table,
fills database_to_write.`idx` with the output of
SHOW INDEX FROM found_tbl FROM found_db
Some options may modify this general scheme (see below).
As mentioned, the contents of the info tables are the output of SHOW commands. In fact the contents are slightly more complete :
- the `tbl` (or `tbl_status`) info table
has an extra column which contains the database name,
- the `col` info table
has an extra column which contains the table name,
and an extra column which contains, for each described column,
the number of this column in the table owning it (this extra column
is called `Seq_in_table`). `Seq_in_table` makes it possible for you
to retrieve your columns in sorted order, when you are querying
the `col` table.
- the `index` info table
has an extra column which contains the database name.
Caution: info tables contain certain columns (e.g. Database, Table, Null...) whose names, as they are MySQL reserved words, need to be
backquoted (`...`) when used in SQL statements.
Caution: as information fetching and info tables filling happen at the same time, info tables may contain inaccurate information about
themselves.
OPTIONS
--clear
Does DROP TABLE on the info tables (only those that the program is going to fill, for example if you do not use --col it won't drop the
`col` table) and processes normally. Does not drop database_to_write.
--clear-only
Same as --clear but exits after the DROPs.
--col
Adds columns information (into table `col`).
--idx
Adds index information (into table `idx`).
--prefix prefix
The info tables are named from the concatenation of prefix and, respectively, db, tbl (or tbl_status), col, idx. Do not quote ('') or
backquote (``) prefix.
-q, --quiet
Does not warn you about what the script is going to do (DROP TABLE etc) and does not ask for a confirmation before starting.
--tbl-status
Instead of using SHOW TABLES, uses SHOW TABLE STATUS (much more complete information, but slower).
--help
Display helpscreen and exit
-u, --user=#
user for database login if not current user. Give a user who has sufficient privileges (CREATE, ...).
-p, --password=# (INSECURE)
password to use when connecting to server. WARNING: Providing a password on command line is insecure as it is visible through /proc to
anyone for a short time.
-h, --host=#
host to connect to
-P, --port=#
port to use when connecting to server
-S, --socket=#
UNIX domain socket to use when connecting to server
WARRANTY
This software is free and comes without warranty of any kind. You should never trust backup software without studying the code yourself.
Study the code inside this script and only rely on it if you believe that it does the right thing for you.
Patches adding bug fixes, documentation and new features are welcome.
TO DO
Use extended inserts to be faster (for servers with many databases or tables). But to do that, must care about net-buffer-length.
AUTHOR
2002-06-18 Guilhem Bichot (guilhem.bichot@mines-paris.org)
And all the authors of mysqlhotcopy, which served as a model for the structure of the program.
perl v5.8.0 2003-04-05 MYSQL_TABLEINFO(1)