-
Question: What are Heap tables? HEAP tables are present in memory and they are used for high speed storage on temporary basis. Check Important Points about Heap Tables? BLOB or TEXT fields are not allowed. Only comparison operators can be used like =,... -
In Websites we display the data which fetch from database using string based conditions. OR Login Feature / Change password Featured based on string based conditions. OR Show the user detils behalf on user slug like "http://example.com/users/user-slug-value" If you want... -
Question: How many ways we can retrieve the data in the result set of MySQL using PHP? Following are different ways $sqlQuery = mysql_query("SELECT id, name FROM users"); while ($row = mysql_fetch_array($result, MYSQL_BOTH)) { ... -
Stored Procedure can return zero or n values whereas function can return one value which is mandatory. Functions can be called from procedure whereas procedures cannot be called from function. Procedures can have input/output parameters for it whereas...
-
Question: What are 3 different ways to connect  with MySQL? Following are 3 API with which we can connect to MySQL 1. MySQL 2. MySQLI 3. PDO We should use MySQLI because MySQLI is imporoved version of MySQL and it have lot of functions which are absent in MySQL. Question:... -
Question: Can I concatenate multiple MySQL rows into one field? use GROUP_CONCAT function For Example SELECT group_concat( city, '--' ) AS all_city FROM `cities`WHERE 1 LIMIT 0 , 30 Output: New York--,London--,Chicago--,Frankfurt--,Paris-- Question: How to... -
![SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 2269548 for key PRIMARY](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjlxV_TXTC1EDBhC_FDMORSmgdN7WoC9TfJDMM-FvPB3-g32gbMKyCGYOwnLRNUQ397krCiE4B93gyolGWQbFeRPg0XYKft0dY4hifNRXw2EyoQfrGnb1y-dGGPDK1fw7TiQS3b_RBUfPGo/s300/Integrity+constraint+violation+1062+Duplicate+entry+2269548+for+key+PRIMARY.png)
Following are few reasons with solutions: Reason 1: ID is auto-increment and primary key. id is auto filed when an record is insert. When we try to insert record with same id which is already exist in table, then such type of error comes.... -
There are three types of privileges in MySql Administrative privilege(s) enable users to manage operation of MySQL server. These are global because they are not specific to a particular mysql database. Database privileges apply to a database... -
We have Following Table Structure of myvideos CREATE TABLE IF NOT EXISTS `myvideos` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL, `time` time NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB...
-
Question: what is the difference between where and having clause in mysql?Answer: where can restrict each row or recordhaving clause restrict group of records. Question: What is Atomicity?Answer: This means whether execution of "all" statements or "no"...
-
Primary Key Primary Key can identify a row as uniquely A table can have  only one primary key It can't be Null Indexing added automatically to Primary key Foreign Key A FOREIGN KEY in one table reference to a Primary Key in another table A table can have... -
In MySqL Database, we stored lots of data like city address, city description and city full description etc. Many times we stored different language's character like Chinese OR Japanese which take multibyte to single single character. When...
-
Question: Can you give me an MySQL Self Join Example? SELECT l1.city, COUNT(l1.city) AS cityview, l2.link_count FROM LOGS AS l1 LEFT JOIN ( SELECT city,COUNT(city) AS link_count FROM LOGS WHERE TYPE="city_blurb_click" GROUP BY city ) AS l2... -
Following are functions which is most command used in mysql Least: Return Least value amont all SELECT LEAST(4,3,8,-1,5); Greatest: Return greatest value amont all SELECT GREATEST(4,3,8,-1,5); Interval(): takes a comparison value as its first argument. The remaining arguments... -
It is query very similar to Normal queries in databases like It may return one column it may return more column It may return single rows It may return multiple rows OR any of above combination. SubQuries are those queries which are... -
Advantage of  Stored Procedure Stored procedures can be used to maintain data integrity and enforce database policy without relying on an external program to do so. the DBA can add behavior that the application doesn't care about. For example, storing a modify date on...
-
Who is the Father of PHP? Rasmus Lerdorf Which programming language does PHP resemble to? PHP resemble to pearl and C How can we create a database using PHP and MySQL? We can create MySQL database in php with the use of mysql_create_db ("db_name"); Is variable...
-
Indexing It is a data structure that improves the speed of search in database. We add the indexing on columns of table. We can one or more indexing on table. Advantage of Indexing It improve the speed of search. If we add indexing... -
Yes, You can use update statement with mysql join also. See Below Example 1) Create users Table CREATE TABLE IF NOT EXISTS `users` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `address` text, PRIMARY KEY... -
Q1: Table restrict for delete, if child table have records. Q2:Â Mysql constraint restrict. Q3. How to prevent from delete a parent record, if child exists. Above all Questions have only one answer that is below with fine example. Create a table products CREATE TABLE products ( ...
We are Web Technology Experts Team who provide you Important information on Web Development, Interview Questions and Answers, live project problem and their solution and online free tutorials.
MYSQL Interview Questions and Answers
Subscribe to:
Posts
(
Atom
)