What is database clustering in mysql?

954

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

907

Is mysql is a programming language?

937

What is the default port number of mysql?

892

How to shut down the server with 'mysqladmin'?

918

Is blocked because of many connection errors unblock with mysqladmin flush hosts?

870

Which datatype is used for email in mysql?

911

how we will Show selected records sorted in an ascending (asc) or descending (desc).

932

How to update info already in a table and delete a row(s) from a table.

821

How to rename an existing table in mysql?

967

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

1572

How do you know if your mysql server is alive?

992

I want to insert userid of a customer,order time,etc in a table called ordermaster with orderid as primary key.Same time the product codes and required quantities (a1,2 and a2 4 and so on)inserted in another table orderdetails with same orderid reference.How the code will be in JSP using MySQL?

1856

how can you test for null values in a database? : Mysql dba

895

What is difference between mysqli and pdo?

870