Category Archive: MySql

Sep 16

MySQL Advance Questions and Answers

1. How many TRIGGERS are allowed in MySql table? Ans.  MySql table allows following 6 triggers: -BEFORE INSERT -AFTER INSERT -BEFORE UPDATE -AFTER UPDATE -BEFORE DELETE and -AFTER DELETE 2. Differentiate between FLOAT and DOUBLE. Ans. FLOAT stores floating point numbers with accuracy up to eight places and has four bytes while DOUBLE stores floating point numbers …

Continue reading »

Jun 06

Mysql_connect and Mysql_pconnect

Mysql_connect and mysql_pconnect both are used to connect the database. Mysql_pconnect use for open a persistent connection means connection is not closed and enable for future use. Mysql_pconnect is much like similar to mysql_connect, but have some difference . Mysql_pconnect try to find connection which is already open with same host, username and password. If …

Continue reading »

May 13

MySQL Interview Questions and Answers

Q1. What’s MySQL ? Ans. MySQL is an relational database management system (RDBMS) that uses Structured Query Language (SQL), the most popular language for adding, accessing, and processing data in a database. MySQL is noted mainly for its speed, reliability, and flexibility. MySQL Provide CREATE and ALTER TABLE which is called DDL(Data Definition Language), SELECT, …

Continue reading »

Mar 02

Fulltext Search in mysql

full

Mysql has supported FULLTEXT Index with VARCHAR and TEXT data type that have been indexed fulltext can be used with special SQL statements that perform the full text search. FULLTEXT Indexed contain multiple columns. In FULLTEXT indexed you can search using MATCH and AGAINST Statements. MATCH MATCHtakes a comma-separated list that names the columns to …

Continue reading »

Older posts «

» Newer posts