 | |
#1
 
| |||
| |||
|
Text Fields -
06-08-2011
, 07:28 AM
|
Field | Type | Null | Key | Default | Extra | +--------+-------------+------+-----+---------+-------+ name | varchar(40) | NO | | NULL | | report | text | YES | | NULL | | +--------+-------------+------+-----+---------+-------+ |
mysql> INSERT INTO Employees (name, report) VALUES('joe',
'Works hard\nGreat employee\nHire him');
mysql> select * from Employees;
+------+------------------------------------+
Quote:
|
name | report | +------+------------------------------------+ joe | Works hard Great employee |
+------+------------------------------------+
#2
| |||
| |||
|
|
I am just getting started in using the "Text" type in MySQL. Is the following INSERT the proper way to enter newlines in text data? |
Quote:
|
Is there a way to dump the contents of a text file into a text field? Try LOAD FILE. |
Quote:
|
Thank you, Joe mysql> describe Employees; +--------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------+-------------+------+-----+---------+-------+ | name | varchar(40) | NO | | NULL | | | report | text | YES | | NULL | | +--------+-------------+------+-----+---------+-------+ mysql> INSERT INTO Employees (name, report) VALUES('joe', 'Works hard\nGreat employee\nHire him'); mysql> select * from Employees; +------+------------------------------------+ | name | report | +------+------------------------------------+ | joe | Works hard Great employee Hire him | +------+------------------------------------+ |
#3
| |||
| |||
|
|
Is the following INSERT the proper way to enter newlines in text data? |
http://dev.mysql.com/doc/refman/5.1/...ng-syntax.html
Quote:
|
Is there a way to dump the contents of a text file into a text field? |
http://dev.mysql.com/doc/refman/5.1/...tion_load-file
XL
#4
| |||
| |||
|
|
Joe Hesse <JoeHesse (AT) gmail (DOT) com> wrote: Is the following INSERT the proper way to enter newlines in text data? RTFM! http://dev.mysql.com/doc/refman/5.1/...ng-syntax.html Is there a way to dump the contents of a text file into a text field? RTFM! http://dev.mysql.com/doc/refman/5.1/en/string- functions.html#function_load-file XL |
would work with TEXT fields. Your links will help me.
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.