Welcome to dbFreaks.com!
FAQFAQ   SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log in/Register/PasswordLog in/Register/Password

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

  
   Database Help (Home) -> mySQL RSS
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 encoding, but when I retrieve it from the db, it shows up all wrong. Does anyone know what the problem..

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 open file: (errno: 1)" on the server. There are no '.ibd' files..

Create table syntax? - Warning: Error while executing this TABLE ( int(10) unsigned NOT NULL double unsigned zerofill NOT NULL default

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 create a table with one unique column like this: create table t1 (c1 int..

FLUSH TABLES hangs if table is locked - Using FLUSH TABLES via the C query API 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 already locked, don't try to run a Anyone know how to find..
Next:  mySQL: Message from eBay Member  
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 ? 
Back to top
Login to vote
Display posts from previous:   
   Database Help (Home) -> mySQL All times are: Pacific Time (US & Canada) (change)
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



[ Contact us | Terms of Service/Privacy Policy ]