How do we delete a row in a table?

0 Answers  

---

What is dump in mysql?

0 Answers  

---

How to run a sql statement?

0 Answers  

---

What, if a table has one column defined as TIMESTAMP?

0 Answers  

---

How to delete a column and add a new column to database

0 Answers  

---

Is mysql a server or database?

0 Answers  

---

Write a query to count the number of rows of a table in mysql.

0 Answers  

---

What is the use of mysql_fetch_array () function in php?

0 Answers  

---

How large can a mysql table be?

0 Answers  

---

A company wants to store their invoices in a database. They already have their customers and articles in that database. Both customer and article are each identified by an unique integer value. Please create the SQL statements for creating the necessary table(s) for storing the invoices in a MySQL database. An invoice should hold information like invoice number, customer, date, article(s) and quantity etc.

1 Answers  

---

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

0 Answers  

---

how to know the tables in database having foreign key?

2 Answers  

---