priya

In MySQL, regular expressions are used in queries for searching a pattern in a string. * Matches 0 more instances of the string preceding it. + matches one more instances of the string preceding it. ? Matches 0 or 1 instances of the string preceding it. . Matches a single character. [abc] matches a or … Read more

The default location of MySQL data directory in windows is C:\mysql\data or C:\Program Files\MySQL\MySQL Server 5.0 \data. To determine the location of the MySQL data directory, you can use one of the following methods: Using MySQL Command Line: You can log into the MySQL command line interface and run the following SQL query: SHOW VARIABLES … Read more

MySQL data directory is a place where MySQL stores its data. Each subdirectory under this data dictionary represents a MySQL database. By default, the information managed my MySQL = server mysqld is stored in the data directory. The MySQL data directory is the location on a file system where MySQL stores its databases, tables, and … Read more

Mysql_close() cannot be used to close the persistent connection. However, it can be used to close a connection opened by mysql_connect(). In MySQL, the mysql_close() function is used to close the connection to the MySQL server that was previously opened with mysql_connect() or mysql_pconnect() functions. When you no longer need to access the database, it’s … Read more

Mysql_connect() is used to open a new connection to the database, while mysql_pconnect() is used to open a persistent connection to the database. It specifies that each time the page is loaded, mysql_pconnect() does not open the database. mysql_connect and mysql_pconnect are both functions used to establish a connection to a MySQL database in PHP, … Read more