01-16-2004
Just a comment on the comma delimited issue, i am no PERL or XLM person, but if you delimit with | instead of commas, your , and " issues go away and very rarely do people store | (pipes) in their data fields.
i just finished migrating 200GB of company wide data and ran across 3 homegrown tables (out of over 4000) that actaully used | in a record, and oddly enough it was a table describing delimiters!!
hope this helps.
7 More Discussions You Might Find Interesting
1. HP-UX
Hi,
We are planning to migrate oracle 8.1.7.2 (8i) currently installed on a host with HP unix 11.0 to a host with HP Unix 11i.
The method we are adopting is backup and restore of all file systems.
Could this be a problem, apart from linking libraries on the target system.
Thanks for the... (1 Reply)
Discussion started by: amitb
1 Replies
2. UNIX for Dummies Questions & Answers
I don't know what is happening but none of my queries work. When I start mysql, even the use <database> option fails... So when I start mysql with -A, it atleast opens the database and shows the tables. But now, when I perform even a select option on the database, it hangs... Repair is not working... (5 Replies)
Discussion started by: Legend986
5 Replies
3. UNIX for Dummies Questions & Answers
How to connect a MySQL database from unix using unix shell scripting ( people are using perl scrpt to connect the same database).
I want to access a MySQL database through a shell script (4 Replies)
Discussion started by: apsprabhu
4 Replies
4. UNIX and Linux Applications
hi
am getting this error when i tried to login in unix..
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
but my application works fine...
can u guide me,, (0 Replies)
Discussion started by: senkerth
0 Replies
5. Shell Programming and Scripting
Hi ,
I am trying to install mysql but getting below error
$# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
can anyone provide me this file 'mysql.sock'
Thanks (6 Replies)
Discussion started by: aish11
6 Replies
6. UNIX and Linux Applications
On psql
select titolo,lingua from titolo where titolo ~* 'brivid';
titolo | lingua
------- + ------
Brivido | 1
On Sqlplus/gqsql
SQL> select titolo,genere,anno,lingua from titolo where titolo like '%rivid%';
TITOLO... (6 Replies)
Discussion started by: Linusolaradm1
6 Replies
7. Programming
Dear community,
I have to make a "simple" query on ORACLE 11g DB who will output ONLY numbers in field1 who exceeded a specific threshold.
In other words, assuming I have the following data in database.
FIELD1 FIELD2 FIELD3
========= ============== ... (3 Replies)
Discussion started by: Lord Spectre
3 Replies
LEARN ABOUT LINUX
mysql_waitpid
MYSQL_WAITPID(1) MySQL Database System MYSQL_WAITPID(1)
NAME
mysql_waitpid - kill process and wait for its termination
SYNOPSIS
mysql_waitpid [options] pid wait_time
DESCRIPTION
mysql_waitpid signals a process to terminate and waits for the process to exit. It uses the kill() system call and Unix signals, so it runs
on Unix and Unix-like systems.
Invoke mysql_waitpid like this:
shell> mysql_waitpid [options] pid wait_time
mysql_waitpid sends signal 0 to the process identified by pid and waits up to wait_time seconds for the process to terminate. pid and
wait_time must be positive integers.
If process termination occurs within the wait time or the process does not exist, mysql_waitpid returns 0. Otherwise, it returns 1.
If the kill() system call cannot handle signal 0, mysql_waitpid() uses signal 1 instead.
mysql_waitpid supports the following options:
o --help, -?, -I
Display a help message and exit.
o --verbose, -v
Verbose mode. Display a warning if signal 0 could not be used and signal 1 is used instead.
o --version, -V
Display version information and exit.
COPYRIGHT
Copyright (C) 1997, 2014, Oracle and/or its affiliates. All rights reserved.
This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as
published by the Free Software Foundation; version 2 of the License.
This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation,
Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see http://www.gnu.org/licenses/.
SEE ALSO
For more information, please refer to the MySQL Reference Manual, which may already be installed locally and which is also available online
at http://dev.mysql.com/doc/.
AUTHOR
Oracle Corporation (http://dev.mysql.com/).
MySQL 5.5 01/30/2014 MYSQL_WAITPID(1)