SQL - how to alter info of a cell in table Post: 302966959

6 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Alter Table Shell Script

I want to add some columns to a existing tables through a shell script. Please help.

2. SuSE

my SQL Info command

Is there a command that will output all mysql details. eg. host name, port etc? Cheers Paul

3. Shell Programming and Scripting

How to get full sql table data using shell script

i have a Oracle table like col1 col2 ---- ----- a 1 b 2 c 3 when i write a script for it , it gives me all the data in one column. Please give me the solution which gives the exact result like we see in sql editors. for a in `echo " set feedback off; set pagesize 40;...

4. Programming

SQL: Alter existing bool after printing

I'm writing a DB to manage books & dvd's for the library. So after they added more books/dvd's, they press the print button and all newly added entries are printed. That is, as it prints all 'printed = false' entries, which (false) is the default value for that field for each new entry. ...

5. Solaris

SQL QUERY to Table Output

Hi I am trying to run sql query from solaris in csh script and send the output to email. Below is my sql query select p.spid,se.program seprogram, se.machine, se.username, sq.sql_text,sq.retrows from v$process p inner join v$session se on p.addr = se.paddr inner join ( select...

6. UNIX for Beginners Questions & Answers

Putting query result dynamically to one cell of table from shell

I have to send a data in mail table format.only one cell need to get dynamically from query. my code is like (echo '<table boarder="1"> echo '<tr><td>stock</td><td>/path</td><td>.........</td></tr>' echo '</table> )sendmail.. in ......... I am trying to get query result.By putting query...

LEARN ABOUT OPENSOLARIS

isamlog

isamlog(1)							  MySQL database							isamlog(1)

NAME

       isamlog - Write info about whats in a nisam log file.

USAGE

       isamlog [-?iruvIV] [-c #] [-f #] [-F filepath/] [-o #] [-R file recordpos] [-w write_file] [log-filename [table ...]]

SYNOPSIS

       isamlog [-?|-I] [-V] [-c] [-f] [-F] [-i] [-o] [-p #] [-r] [-R] [-u] [-v] [-w]

DESCRIPTION

       isamlog

       -?|-I  info

       -V     version

       -c     do only # commands

       -f     max open files

       -F     file path

       -i     extra info

       -o     offset

       -p #   remove # components from path

       -r     recover

       -R     file recordposition

       -u     update

       -v     verbose

       -w     write file

NOTE

       If  no  file name is given isam.log is used One can give a second and a third '-v' for more verbose.  Normaly one does a update (-u).  If a
       recover is done all writes and all possibly updates and deletes is done and errors are only counted.  If one gives table names as arguments
       only these tables will be updated

SEE ALSO

       isamchk(1),   mysql(1),	 mysqlaccess(1),   mysqladmin(1),   mysqld(1),	mysqld_multi(1),  mysqld_safe(1),  mysqldump(1),  mysql_fix_privi-
       lege_tables(1), mysqlshow(1), mysql_zap(1), perror(1), replace(1)

       For more information please refer to the MySQL reference manual, which may already be installed locally and which is also available  online
       at http://www.mysql.com/doc/en/

BUGS

       Please refer to http://bugs.mysql.com/ to report bugs.

AUTHOR

       Ver  1.0,  distribution	4.0.24	Michael (Monty) Widenius (monty@mysql.com), MySQL AB (http://www.mysql.com/).  This software comes with no
       warranty.  Manual page by L. (Kill-9) Pedersen (kill-9@kill-9.dk), Mercurmedia Data Model Architect / system developer  (http://www.mercur-
       media.com)

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +--------------------+------------------------------------+
       |  ATTRIBUTE TYPE    |	       ATTRIBUTE VALUE		 |
       +--------------------+------------------------------------+
       |Availability	    | SUNWmysqlr, SUNWmysqlu, SUNWmysqlt |
       +--------------------+------------------------------------+
       |Interface Stability | External				 |
       +--------------------+------------------------------------+
NOTES

       Source for mysql is available on http://opensolaris.org.

MySQL 4.0							 19 December 2000							isamlog(1)