<div>
Hello,<br />
<br />
You can use the command LOAD DATA for that purpose. For example: mysql&gt; LOAD DATA LOCAL INFILE '/path/pet.txt' INTO TABLE pet;<br />
<br />
<a href="http://dev.mysql.com/doc/refman/5.0/en/loading-tables.html" rel="ugc">http://dev.mysql.com/doc/refman/5.0/en/loading-tables.html</a>
</div>


Hello,

You can use the command LOAD DATA for that purpose. For example: mysql> LOAD DATA LOCAL INFILE '/path/pet.txt' INTO TABLE pet;

http://dev.mysql.com/doc/refman/5.0/en/loading-tables.html [http://dev.mysql.com/doc/refman/5.0/en/loading-tables.html]

<div>
<div class="content wysiwyg-content">
Hi, <br />
<br />
I have a table with the following fields:<br />
<br />
PDI Number, Category, Reference, Description, Status, Example, Script Version, UNIX Checklist Page.<br />
<br />
Now the list is going will have several PDI's and each one will have all of the fields above.<br />
<br />
I look forward hearing from you.<br />
<br />
Regards,<br />
<br />
Michael<br />

<pre><code id="code-7989575">PDI Number: EXA000260
Category: FAT II
Reference: LINUX 3.1
Description: A shared account is not documented by the IAO.
Status: Open

For example:
ZEN000260: The following accounts require justifying documentation from the IAO.
ACCT     LOGGED IN FROM
-------   --------------
sysadmin Fri
sysadmin Mon
sysadmin Sat
sysadmin Sun
sysadmin Thu
sysadmin Tue
sysadmin Wed

Script Version: Jan2009
UNIX Checklist Page: 30</code></pre>
</div>
</div>


Hi, 

I have a table with the following fields:

PDI Number, Category, Reference, Description, Status, Example, Script Version, UNIX Checklist Page.

Now the list is going will have several PDI's and each one will have all of the fields above.

I look forward hearing from you.

Regards,

Michael

Bash script to insert text into MYSQL

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

The term 'shell' refers to a general class of text-based command interpreters most often associated with the UNIX and Linux operating systems. Popular shells include Bourne, Debian Almquist (dash), Korn (ksh), Bourne Again (bash) and the C shell family (csh). Some view the DOS 'cmd' prompt as a minimal shell of sorts. It is also possible to install Cygwin on Windows and emulate a full Unix environment with complete shell capabilities. Terminal emulators, such as xterm, GNOME Terminal and OS X Terminal, can be used to access shell.