SHOW STATUS provides server status information. This information also
can be obtained using the mysqladmin extended-status command. The LIKE
clause, if present, indicates which variable names to match. The WHERE
clause can be given to select rows using more general conditions, as
discussed in MySQL :: MySQL 5.5 Reference Manual :: 19.28 Extensions to SHOW Statements
Hi all,
When a process is hung in unix and when we list the process using "ps" command, then does the elapsed timeELAPSED column time display the time elapsed since the process started to the time till the "ps"command was called. Or does the elapsed time column display only the time since the... (4 Replies)
I created file called "tape_name" which contains
tape_mon_A="TAPE_MON_A"
tape_tue_A="TAPE_TUE_A"
tape_wed_A="TAPE_WED_A"
tape_thr_A="TAPE_THR_A"
tape_mon_B="TAPE_MON_B"
tape_tue_B="TAPE_TUE_B"
tape_wed_B="TAPE_WED_B"
tape_thr_B="TAPE_THR_B"
I created test script as follow
... (4 Replies)
Dear all,
Is there any generic command working on all Unix listing the CPU of a server?
I found different command line per OS but I am looking for a more generic one.
Thanks for your answer. (5 Replies)
Hello,
I start an adapter using the following command -
nohup ./start_embargoAdapter >/dev/null 2>&1 &
and when I do the following, I can see:
/export/home/xxxxx> ps -ef | grep embargo
xxxxx 28086 20761 0 23:23:29 pts/7 0:00 grep embargo
xxxxx 8866 1 0 Oct 06 ? 0:00... (2 Replies)
how to extract user machine name for current terminal using finger command
below command gives machinename for all session , is it possible to filter it to only currernt terminal ?
finger -b -p $LOGNAME | grep from (12 Replies)
Hi,
I am trying to find files that are more than a gig with this command
find . -size +1073741823c and it just gives me the names of the files. How do i get it to give me the actual size of the files too?
---------- Post updated at 09:41 AM ---------- Previous update was at 09:37 AM... (2 Replies)
Hello,
I am newbie on mysql and trying to edit my database from terminal under linux.
What I need to do is to change the information written in a cell in table.
Let me explain what I tried:
$ mysql -u mysqluser -p
$ show databases;
$ USE catalogue;
$ show tables ;
$ select * from... (2 Replies)
Hi All,
I want to run multiple sql queries and store the data in variable but i want to use sql command only once. Is there a way without running sql command twice and storing.Please advise.
Eg :
Select 'Query 1 output' from dual;
Select 'Query 2 output' from dual;
I want to... (3 Replies)
Discussion started by: Rokkesh
3 Replies
LEARN ABOUT DEBIAN
dbix::searchbuilder::handle::mysql
DBIx::SearchBuilder::Handle::mysql(3pm) User Contributed Perl Documentation DBIx::SearchBuilder::Handle::mysql(3pm)NAME
DBIx::SearchBuilder::Handle::mysql - A mysql specific Handle object
SYNOPSIS DESCRIPTION
This module provides a subclass of DBIx::SearchBuilder::Handle that compensates for some of the idiosyncrasies of MySQL.
METHODS
Insert
Takes a table name as the first argument and assumes that the rest of the arguments are an array of key-value pairs to be inserted.
If the insert succeeds, returns the id of the insert, otherwise, returns a Class::ReturnValue object with the error reported.
SimpleUpdateFromSelect
Customization of "SimpleUpdateFromSelect" in DBIx::SearchBuilder::Handle. Mysql doesn't support update with subqueries when those fetch
data from the table that is updated.
DatabaseVersion
Returns the mysql version, trimming off any -foo identifier
CaseSensitive
Returns undef, since mysql's searches are not case sensitive by default
SimpleDateTimeFunctions
Returns hash reference with specific date time functions of this database for "DateTimeFunction" in DBIx::SearchBuilder::Handle.
ConvertTimezoneFunction
Custom implementation of "ConvertTimezoneFunction" in DBIx::SearchBuilder::Handle.
Use the following query to get list of timezones:
SELECT Name FROM mysql.time_zone_name;
Read docs about keeping timezone data up to date:
http://dev.mysql.com/doc/refman/5.5/en/time-zone-upgrades.html
AUTHOR
Jesse Vincent, jesse@fsck.com
SEE ALSO
DBIx::SearchBuilder, DBIx::SearchBuilder::Handle
perl v5.14.2 2011-09-21 DBIx::SearchBuilder::Handle::mysql(3pm)