Answer Posted / nithya

use SQL LOADER.

type in ur command prompt:
> sqlldr

> sqlldr userid=user/password@DB_INSTANCE_NAME
control=import.ctl log=import.log data=import.csv

where u hav to convert ur text file into comma seperated
file(.csv) and ur control file must be:

load data

infile call_list.csv //data file

append

into table bck_up // db table name

fields terminated by ','

optionally enclosed by'"'

trailing nullcols
(
name,num,num2 //columns in ur text file.
)

How to include numeric values in sql statements?

1053

---

Is mysql a dbms?

943

---

What is the function of mysqldump?

1122

---

Can foreign key have duplicate values?

933

---

what is cte? : Mysql dba

991

---

What is database migration in mysql?

1073

---

What are the differences between a primary key and foreign key?

1156

---

What language does mysql use?

949

---

Please can the SQL code below be interpreted IF @xMatchCriteria='MATCH12' BEGIN IF EXISTS (Select * from #InsightData where (EmailAddress=@xDCPEmailAddress ) ) BEGIN SET @xTestMatchCriteria = @xMatchCriteria; SELECT @xCRMCustomerId=CustomerId, @xCRMDcpCustomerId=DcpCustomerId, @xCRMPortalCustomerID=PortalCustomerID,@xCRMDcpID=DcpID, @xCRMCardNumber=CardNumber, @xCRMEmailAddress=EmailAddress, @xCRMfirtLetterFirstName=firtLetterFirstName, @xCRMLastName=Surname,@xCRMAddressLine1=AddressLine1, @xCRMPostCode=PostCode FROM #InsightData where (EmailAddress=@xDCPEmailAddress ) END ELSE BEGIN SET @xTestMatchCriteria='No'+@xMatchCriteria; END END

1688

---

How set mysql root password?

963

---

Where is the mysql config file?

1025

---

What are stored procedures and functions?

952

---

What are the types of queries?

981

---

What is delimiter in mysql stored procedure?

961

---

How to show all records starting with the letters 'sonia' and the phone number '9876543210'

981

---