Home »
MySQL-Interview-Questions
» difference between mysql_connect and mysql_pconnect?
difference between mysql_connect and mysql_pconnect?
PMA03:11
Mysql_connect:
Categories: MySQL-Interview-Questions
Related Posts:
what is Triggers? A trigger is a stored database object that contains a series of SQL commands, set to activate automatically when certain events take place. Each trigger is associated with a table. You can create a trigger that will fire… Read More
Data Manipulation Language (DML) statements ? Data Manipulation Language (DML) statements Allow you to modify the contents of tables. There are three DML statements: INSERT Allows you to add rows to a table. UPDATE Allows yo… Read More
What’s the default port for MySQL Server? 3306 … Read More
How set a root password if there is on root password? # mysqladmin -u root password newpassword … Read More
What Is SQL? The Structured Query Language (SQL) is the most common way to retrieve and manage database information. An SQL query consists of a series of keywords that define the data set you want to fetch from the database. SQL uses… Read More
Restore database (or database table) from backup? [mysql dir]/bin/mysql -u username -ppassword databasename < /tmp/databasename.sql … Read More
total number of rows? mysql> SELECT COUNT(*) FROM table; … Read More
Use mysqldump to create a copy of the database? mysqldump -h mysqlhost -u username -p mydatabasename > tgdbdump.sql … Read More
Relational Databases-MySQL MySQL is a relational database. An important feature of relational systems is that a single database can be spread across several tables as opposed to our flat-file phone book example. Related data is stored in separat… Read More
MySQL Subqueries? You can use the result of a query like you use a list of values with the IN operator to filter a query based on the result of another query. The subquery appears in parentheses after the IN keyword. The following query f… Read More
What Is a Relational Database? The basic concepts of a relational database are fairly easy to understand. A relational database is a collection of related information that has been organized into structures known as tables. Each table contains rows th… Read More
Show unique records mysql? mysql> SELECT DISTINCT column FROM table; … Read More
Data Definition Language (DDL) statements? Data Definition Language (DDL) statements Allow you to define the data structures, such as tables, that make up a database. There are five basic types of DDL statements: CREATE Allows you to cr… Read More
Data Control Language (DCL) statements ? Data Control Language (DCL) statements Allow you to change the permissions on database structures. There are two DCL statements: GRANT Allows you to give another user access to your database st… Read More
What is SERIAL data type in MySQL? BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT … Read More