What is mysql_pconnect

what is mysql_pconnect Mysql_pconnect: 1. In Mysql_pconnect, “p” stands for persistent connection so it opens the persistent connection. 2. The database connection cannot be closed. 3. It is more useful if your site has more traffic because there is no need to open and close connection frequently and every time when page is loaded. /* […]

What is mysql_pconnect Read More

What is drop in sql

what is drop in sql DELETE – -DML COMMAND -Delete Rows from the table one by one -We can use where clause with Delete to delete single row -Delete is slower than truncate -ROLLBACK is possible with DELETE DROP- -DDL COMMAND -Delete the entire structure or schema -We can’t use where clause with drop -Drop […]

What is drop in sql Read More

What is delete in sql

what is delete in sql DELETE – -DML COMMAND -Delete Rows from the table one by one -We can use where clause with Delete to delete single row -Delete is slower than truncate -ROLLBACK is possible with DELETE DROP- -DDL COMMAND -Delete the entire structure or schema -We can’t use where clause with drop -Drop […]

What is delete in sql Read More

What is an index in sql

what is an index in sql “An index is an on-disk structure associated with a table or view that speeds retrieval of rows from the table or view. These keys are stored in a structure (B-tree) that enables SQL Server to find the row or rows associated with the key values quickly and efficiently.”

What is an index in sql Read More

What is an aggregate in sql

SQL Aggregate Functions MAX – To find the number of the maximum values in the SQL table. MIN – Number of the minimum values in the table. COUNT – Get the number of count values in the SQL table. AVG – Find average values in the SQL table. SUM – Return the summation of all […]

What is an aggregate in sql Read More

What is a view in sql

what is a view in sql In SQL, a view is a virtual table based on the result-set of an SQL statement. A view contains rows and columns, just like a real table. You can add SQL functions, WHERE, and JOIN statements to a view and present the data as if the data were coming […]

What is a view in sql Read More