Freshershome

Interview Questions for Freshers

Tagged: mysql

database

Database / General

How to Create Database using PHP and mysql

Q:How can we create a database using PHP and mysql? Answer: In the earlier versions of PHP we were using mysql_create_db($dbstring,$link) to create a database,but PHP5 n latest versions of PHP do not support this function. Now we will have to use mysql_query(“create database databasename”); to create database. mysql_drop_db($dbname,$link) is also...

Php and MySQL Important Questions

Unix / Linux

Php and MySQL Important Questions

Which will be faster out of these two queries – one with OR or one with IN? Where does MyISAM cache table records? Which will be faster out of queries with explicit INNER JOIN and implicit one? Is InnoDB faster/better than MyISAM? Is CHAR faster than VARCHAR? Is VARCHAR(80) faster than...