Answer Posted / manish gupta

Mysql : - select count(*) [tablename];
PHP :- mysql_num_rows();

Is there a free version of mysql?

923

---

How can I see connections in mysql?

899

---

Tell us something about heap tables?

972

---

what is a cursor? : Mysql dba

987

---

Consider a scenario where you have two to three tables with thousand tuples in each of them. Now, if you have to perform a join operation between them will you choose to perform filtering of rows or transforming of rows first.

980

---

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

851

---

Can you tell the difference between mysql_connect and mysql_pconnect? : Mysql dba

998

---

How to filter data from a mysql database table with php?

878

---

Explain the architecture models of SQL Server?

2311

---

Is mysql a good database?

928

---

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

1609

---

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

870

---

How do you use auto increment?

917

---

How would you get the current date in mysql?

1081

---

How many sql ddl commands are supported by 'mysql'?

1116

---