05-16-2011
I think you need a staging table, because you are inserting one column and autoincrementing the other, which is not copy-friendly. Copy to the staging table, and then insert to the list_ip column, and the other column will autoincrement. Remember to clear your staging table on each run.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi, hopefully this is a fairly simple Q&A.
I have a clean file list of approximately 180 filenames with no directory or slashes in front of the filename nor any extension or dot ".". I would like to read from this list, find these files recursively down through directory trees, copy the files... (1 Reply)
Discussion started by: fxvisions
1 Replies
2. UNIX for Dummies Questions & Answers
Hi Guru's,
I need to create 3 files with the contents "ABC" using single command.
Iam using:
echo "ABC" > file1.txt file2.txt file3.txt
the above command is not working. pls help me...
With Regards / Ganapati (4 Replies)
Discussion started by: ganapati
4 Replies
3. Solaris
Hello,
Can anybody please tell me how we can copy and paste text from a word document into a text file that we are editing in vi? Is it possible to do that while we are editing the text file in vi in insert mode?
Thanks, (3 Replies)
Discussion started by: Pouchie1
3 Replies
4. Shell Programming and Scripting
hye there...
i have a problem to copy file in specific folder
that will change the name according to
host,time(%m%s) and date(%Y%M%D)
example folder name:
host_20100531.154101801
this folder name will always change...
but i just want to copy the AAA.txt and BBB.txt file..
really need... (17 Replies)
Discussion started by: annetote
17 Replies
5. Shell Programming and Scripting
I have a text file called file.txt which has a list of file as shown below that i need to find and copy to a particular location.
FILENAMES
skter.pdf
abcdf.sas
tereen.lst
abc12.txt
i am using following code and it never works however i try it.
cat file.txt | while read FILENAME;do find... (4 Replies)
Discussion started by: MILAN KUMAR
4 Replies
6. Shell Programming and Scripting
I have this 15 postgres sql queries similar to below to run in linux... Its taking a lot of time to run (3hours) .
can any one plz guide me how can i reduce the time of execution
execute 'insert into cc.rpt_cons_sub_ccdb_data(report_date, server_name, report_type, count)
select... (3 Replies)
Discussion started by: nikhil jain
3 Replies
7. UNIX for Dummies Questions & Answers
Hi I would like to know how to copy a file opened in unix editor like Nedit or vi editor to a word document
Since I am newbie I want to make sure I am not really copying onto real subdirectories
I tried to right click and copy the entire .sql file or any other file opened..
Nedit doesn't... (3 Replies)
Discussion started by: swathi123
3 Replies
8. Shell Programming and Scripting
Hi Everyone ,
Below is output from a TL1 , I want just the NE Name: and beside that the Temperature and the voltages in a csv file , Is this possible?
> act-user:AB1S2a:ArshadFO:493::**********;
AB1S2a 2016-02-07 10:13:24
M 493 COMPLD
"ArshadFO:2016-02-07 10-04-55,0"
;... (11 Replies)
Discussion started by: adgjmpt
11 Replies
9. UNIX for Beginners Questions & Answers
Hi everybody,
I am working on Windows 10 and using cygwin.
I have a vbscript as follows:
Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = True
Set wb1 = objExcel.Workbooks.open("\\files\share\path\file1.xlsx")
wb1.Worksheets("Sheet1").Range("A1:CR89").Clear
Set... (0 Replies)
Discussion started by: supernono06
0 Replies
10. UNIX for Beginners Questions & Answers
I have a txt file with a list of error messages in a xml tag format, and each error message is separated with a identifier(endresult).Need to split that and copy and create a new html file.Error message has some special character. how to escape the special character and insert my data into the... (7 Replies)
Discussion started by: DevAakash
7 Replies
LEARN ABOUT PHP
fbsql_fetch_field
FBSQL_FETCH_FIELD(3) 1 FBSQL_FETCH_FIELD(3)
fbsql_fetch_field - Get column information from a result and return as an object
SYNOPSIS
object fbsql_fetch_field (resource $result, [int $field_offset])
DESCRIPTION
Used in order to obtain information about fields in a certain query result.
PARAMETERS
o $
result -A result identifier returned by fbsql_query(3) or fbsql_db_query(3).
o $field_offset
- The numerical offset of the field. The field index starts at 0. If not specified, the next field that wasn't yet retrieved by
fbsql_fetch_field(3) is retrieved.
RETURN VALUES
Returns an object containing field information, or FALSE on errors.
The properties of the object are:
o name - column name
o table - name of the table the column belongs to
o max_length - maximum length of the column
o not_null - 1 if the column cannot be
NULL
o type - the type of the column
EXAMPLES
Example #1
fbsql_fetch_field(3) example
<?php
fbsql_connect($host, $user, $password)
or die("Could not connect");
$result = fbsql_db_query("database", "select * from table")
or die("Query failed");
# get column metadata
$i = 0;
while ($i < fbsql_num_fields($result)) {
echo "Information for column $i:<br />
";
$meta = fbsql_fetch_field($result);
if (!$meta) {
echo "No information available<br />
";
}
echo "<pre>
max_length: $meta->max_length
name: $meta->name
not_null: $meta->not_null
table: $meta->table
type: $meta->type
</pre>";
$i++;
}
fbsql_free_result($result);
?>
SEE ALSO
fbsql_field_seek(3).
PHP Documentation Group FBSQL_FETCH_FIELD(3)