7 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi All,
As per my biz requirement, I need to drop the partition from our PROD table based on the retention period.
Hence I have written the script and called the drop partition procedure within the script.
The procedure is working fine and droped the partition from the table when I execute... (4 Replies)
Discussion started by: suresh_target
4 Replies
2. News, Links, Events and Announcements
Fedora and openSUSE will replace MySQL with MariaDB:
Oracle who? Fedora & openSUSE will replace MySQL with MariaDB | ZDNet
The article also has a comment that Chakra is planning on doing the same. No doubt the Fedora based distributions are planning to do the same. (7 Replies)
Discussion started by: figaro
7 Replies
3. Shell Programming and Scripting
Dear All,
I have table files with different measurements for the same sensors. The first column indicate the sensor (7 different sensors and 16 measurements in the example below). I would like to find the best measurement for each sensor. The best measurement is determined by the higher value of... (10 Replies)
Discussion started by: GDC
10 Replies
4. Ubuntu
This is the mistake that i've done :
First of all go to /etc/apt/sources.list folder from terminal or using file manager ...
than copy the content of sources.list in to your adequate source.list.
Create a file named sources.list.bt and paste the same content
In the end open the... (0 Replies)
Discussion started by: dud3
0 Replies
5. Shell Programming and Scripting
Hello guys,
what i want to do is to print a table with two columns (user :: #procs) on the stdout.
The first column should show the users and the second one the number of processes the respective user runs.
I think I need something like the count() - function in sql, don't i?
Shell: Bash
... (2 Replies)
Discussion started by: tiptop
2 Replies
6. SuSE
I have deleted a database. I restored it again with a backup.
Now we lost some data of two days.
Is it possible to restore this lost data? (5 Replies)
Discussion started by: Eastme
5 Replies
7. UNIX for Dummies Questions & Answers
in a xen environment , i see a lot op dropped packets via netstat -i
Is this a sign of network problems, or is it normal to see this kind of numbers? i'm not sure how to interprete the data. is this normal, bad, critical. What are your stats on this?
I guess i have a xen issue of some sort,... (1 Reply)
Discussion started by: progressdll
1 Replies
MYSQL_FIELD_TABLE(3) 1 MYSQL_FIELD_TABLE(3)
mysql_field_table - Get name of the table the specified field is in
SYNOPSIS
Warning
This extension is deprecated as of PHP 5.5.0, and will be removed in the future. Instead, the MySQLi or PDO_MySQL extension should
be used. See also MySQL: choosing an API guide and related FAQ for more information. Alternatives to this function include:
omysqli_fetch_field_direct(3) [table] or [orgtable]
o PDOStatement::getColumnMeta [table]
string mysql_field_table (resource $result, int $field_offset)
DESCRIPTION
Returns the name of the table that the specified field is in.
o $
result -The result resource that is being evaluated. This result comes from a call to mysql_query(3).
o $
field_offset -The numerical field offset. The $field_offset starts at 0. If $field_offset does not exist, an error of level
E_WARNING is also issued.
The name of the table on success.
Example #1
A mysql_field_table(3) example
<?php
$query = "SELECT account.*, country.* FROM account, country WHERE country.name = 'Portugal' AND account.country_id = country.id";
// get the result from the DB
$result = mysql_query($query);
// Lists the table name and then the field name
for ($i = 0; $i < mysql_num_fields($result); ++$i) {
$table = mysql_field_table($result, $i);
$field = mysql_field_name($result, $i);
echo "$table: $field
";
}
?>
Note
For backward compatibility, the following deprecated alias may be used: mysql_fieldtable(3)
mysql_list_tables(3).
PHP Documentation Group MYSQL_FIELD_TABLE(3)