Sponsored Content
Special Forums UNIX and Linux Applications SQL - how to alter info of a cell in table Post 302966960 by baris35 on Thursday 18th of February 2016 09:09:30 AM
Old 02-18-2016
Quote:
Originally Posted by cero
The mysql-documentation tells you in detail how to formulate the statment. For you example, if you'd like to change Lacatus age to 58 it would look like this:
Code:
update phonebook set age = 58 where id = 4;


Voila! It's done! Thanks for your reply Cero.
I will also check that mysql documentation for other functions.

b.regards
Boris
 

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

2. SuSE

my SQL Info command

Is there a command that will output all mysql details. eg. host name, port etc? Cheers Paul (1 Reply)
Discussion started by: runnerpaul
1 Replies

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;... (1 Reply)
Discussion started by: ss135r
1 Replies

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. ... (3 Replies)
Discussion started by: sea
3 Replies

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... (2 Replies)
Discussion started by: tharmendran
2 Replies

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... (2 Replies)
Discussion started by: meera_123
2 Replies
wml::fmt::xtable(3)						     EN Tools						       wml::fmt::xtable(3)

NAME
wml::fmt::xtable - HTML tables through Advanced Syntax SYNOPSIS
#use wml::fmt::xtable <xtable table-options> initial text (e.g. <caption> ... </caption>). (X, Y) options for cell (X, Y) text for cell (X,Y)... ((X,Y)) options for header cell X,Y text for header cell (X,Y)... </xtable> DESCRIPTION
This is just a WML wrapper for interfacing the freetable(1) utility which converts its advanced table syntax to plain HTML table markup code. See freetable(1) for more details. CAVEATS
An error is reported if "xtable" body contains ePerl code, so the special variable "IPP_NOSYNCLINES" has to be written onto "#include" lines (see wml_p1_ipp(1)), and macros expanded by "mp4h"(1) must not print ePerl code. AUTHOR
Ralf S. Engelschall rse@engelschall.com www.engelschall.com REQUIRES
Internal: P1, P2, P3, freetable (PATH) External: -- SEE ALSO
freetable(1), HTML "<table>" tag. EN Tools 2014-04-16 wml::fmt::xtable(3)
All times are GMT -4. The time now is 10:42 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy