help,a regular text file how to sql 2000 table code ?

FAQ

Profile

help,a regular text file how to sql 2000 table code ?

Database Help (Home) -> mySQL

Next: primary key

Author

Message

agiler

External

Since: Apr 05, 2008
Posts: 3

(Msg. 1) Posted: Sat Apr 05, 2008 10:01 pm Post subject: help,a regular text file how to sql 2000 table code ? Archived from groups: mailing>database>mysql (more info?)

help,a regular text file how to sql 2000 table code ? i have a text file as follow, line with ¡°\|¡±and {LF}, 8\|-000000186075919.\|+000000000387820.\|2008-03-31\|20010423\| 9\|-000000000003919.\|-000000000123620.\|2008-03-31\|20010123\| 8\|-000000018623419.\|+000000000381230.\|2008-05-30\|20010423\| i want to sign char(1)£¬year decimal(18,3) , month decimal(18,3), trandate smalldatetime£¬update smalldatetime£¬after to sql table is as follow, sign year month trandate update 8 -186075919.000 387820.000 3/31/2008 4/23/2001 9 -3919.000 -123620.000 3/31/2008 1/1/2001 8 -18623419.000 387820.000 5/30/2008 4/23/2001 could you help me how write the sql code ? >> Stay informed about: help,a regular text file how to sql 2000 table code ?

Display posts from previous:

Related Topics:

Saving text in russian - Hi, I have a table with a field that is to save text in Russian. The text is then retrieved by a PHP page. I run a query passing text in windows-1251 encoding, but when I retrieve it from the db, it shows up all wrong. Does anyone know what the proble...

Can't open file: 'mytable.ibd' (errno: 1) - Hi, I read in the mysql manual that it's possible to copy the 'frm' files from one mysql server to another, but when I try to do this I get the error "Can't open file: 'mytable.ibd' (errno: 1)" on the detstination server. There are no '.ibd...

Create table syntax? - Warning: Error while executing this query:CREATE TABLE "purchaseorder" ( "PurchaseOrderID" int(10) unsigned NOT NULL auto_increment, "PurchaseCost" double unsigned zerofill NOT NULL default '0000000000000000000000', &...

syntax problem for CREATE TABLE ?? - Hi, I was playing with MySQL (4.1.9) during the weekend, but noticed a minor problem and would like someone to explain this to me. Basically I could successfully create a table with one unique column like this: mysql> create table t1 (c1 int....

FLUSH TABLES hangs if table is locked - Using FLUSH TABLES via the C query API mysql_query() hangs if the table is locked already. That is to say, nothing prevents me from running a LOCK TABLES twice; it won't tell me "it's already locked, don't try to run a FLUSH". Anyone know ...

	Database Help (Home) -> mySQL	All times are: Pacific Time (US & Canada)
Page 1 of 1

You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum