Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / anubhav tiwari
1.DELETE COMMANDS: ONLY DELETE DATA FROM TABLE NOT THE
STRUCTURE OF THE TABLE.DATA CAN BE CALL BACK USING ROLL
BACK.
2.DROP COMMANDS DLETE TABLE AND STRUCTURE BOTH FROM THE
DATABASE ie.DATA CANT BE ROLL BACK OVER HERE.
| Is This Answer Correct ? | 21 Yes | 0 No |
Post New Answer View All Answers
What is difference mysql and mysqli?
What is the difference between mysql and sql?
What could be the reason that the mysql statement 'select avg (salary) from emp' generates an inaccurate output?
How to give user privilages for a db. Login as root. Switch to the mysql db. Grant privs. Update privs.
What is mysql routine?
How do I set user privileges in mysql?
How to use in conditions?
How do I view a mysql database?
how to get only updated, deleted , inserted records after certain interval time in mysql with out using triggers...
What does the file with the extension: frm, myd, and myi contain?
What is horizontally scalable?
What does do in mysql?
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
How to use mysqldump to create a copy of the database?
Can mysql and mariadb coexist?
