How to load data from a text file into a table?

Answer Posted / sathya

bcp mydb.dbo.sales in sales.csv /U /P /Ssales_fs /c /t,

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the reasons for selecting lamp (linux, apache, mysql, php) instead of combination of other software programs, servers and operating systems?

578


What is delimiter in mysql?

483


Is mysql still relevant?

523


Do I need to pay for mysql?

496


Why is the basic difference between left join, right join and inner join?

556






List some comparisons operators used in mysql?

535


Explain the difference between primary key and candidate key in mysql?

521


Can you tell the reasons for selecting lamp(linux, apache, mysql, php) instead of any other combination of software programs, servers, and operating system?

466


Is mysql a nosql database?

511


How to store values to array from mysql database in php?

447


How do I stop a mysql service?

515


What is the use of mysql workbench?

524


How do you use auto increment?

516


how you will show all records not containing the name "sonia" and the phone number '9876543210' order by the phone_number field.

516


Explain the different types of constraints?

523