Archive: Interview Question
-
Feb 22, 2012
Comments Offhow to do table partition in mysql
HI all of my php programmer. Mostly MYSQL DBA done the partitioning but if we talk about programmer then they are unable to do. so don’t worry friends here is the solutions for mysql partitioning in easy steps. First run this query to you panel and check patition is on or not. mysql> SHOW VARIABLES...
-
Sep 02, 2011
Comments OffHow to Build Web Apps Faster in cakephp?
The pressure is on. You’ve got limited time, and you need a system to catalogue your extensive movie collection in 15 minutes. Who ya gonna call? CakePHP of course! CakePHP is a rapid application development framework that covers all the common tasks required to get a web application up and running. Handling all the repetitive...
-
Sep 02, 2011
Comments OffBuild a file sharing application in cakephp
The honeymoon is over baby. Now it’s time for the real work to begin. This iteration of our CakePHP tutorial series will result in your very own file-sharing tool. This is handy in the situation that you have a file you need to send to a business partner or client, or share with a friend,...
-
Sep 02, 2011
Comments Offhow to Build a bookmark site in cakephp?
If you’ve followed our last few tutorials, you’ll be a CakePHP expert by now: you know how to navigate controllers, delve into the depths of models and create views that astound your viewers. But having a taste of the sweet rapid development that CakePHP offers you, you want more, and you want to do more...
-
Sep 02, 2011
Comments OffHow to optimize mysql query and mysql database?
There is lots of way to optimize mysql. once you optimize your query and database of mysql it will make your website and application very fast. Firstly choose which table being used every time for delete, insert or update make a list and always repair these tables. after 15 days. this is very good question...
-
Sep 02, 2011
Comments OffHow to optimize php code.
In this post we are going to learn how to optimize our php code. once you optimize your php code then your applicationa and website will be very fast this will make quality code. Hi php programmer don’t forget these rules if you want to be good in php and want to work in MNC...
-
Aug 29, 2011
Comments OffWhat does myisamchk do?
It compressed the MyISAM tables, which reduces their disk...
-
Aug 29, 2011
Comments OffThe CHAR and VARCHAR Types
the CHAR and VARCHAR types are similar, but differ in the way they are stored and retrieved. As of MySQL 5.0.3, they also differ in maximum length and in whether trailing spaces are retained. The CHAR and VARCHAR types are declared with a length that indicates the maximum number of characters you want to store....
-
Aug 29, 2011
Comments OffOrder by vs GROUP By
The easiest explanation is that order by is doing the sorting of a table and the group by clause is used for aggregation of a...
-
Aug 29, 2011
Comments OffExplain the difference between BOOL, TINYINT and BIT
Prior to MySQL 5.0.3: those are all synonyms. After MySQL 5.0.3: BIT data type can store 8 bytes of data and should be used for binary...
-
Aug 29, 2011
Comments OffHow many values can the SET function of MySQL take?
MySQL set can take zero or more values but at the maximum it...
-
Aug 29, 2011
Comments OffHow can I load data from a text file into a table?
We can use LOAD DATA INFILE file_name; syntax to load data from a text file. but we have to make sure that a) data is delimited b) columns and data matched...
-
Aug 29, 2011
Comments Off
-
Aug 29, 2011
Comments OffWhat is the maximum length of a table name, database name, and fieldname in MySQL?
The following table describes the maximum length for each type of identifier. Database – 64 bytes Table – 64 bytes Column – 64 bytes Index – 64 bytes Alias – 255 bytes There are some restrictions on the characters that may appear in...
-
Aug 29, 2011
Comments OffExplain the difference between MyISAM Static and MyISAM Dynamic
MyISAM static all the fields have fixed width. The Dynamic MyISAM table would include fields such as TEXT, BLOB, etc. to accommodate the data types with various lengths. MyISAM Static would be easier to restore in case of corruption, since even though you might lose some data, you know exactly where to look for the...
-
Aug 29, 2011
Comments OffHow many ways we can we find the current date using MySQL?
SELECT CURDATE(); CURRENT_DATE() = CURDATE() for time use SELECT CURTIME(); CURRENT_TIME() =...
-
Aug 29, 2011
Comments OffWhat is the difference between Primary Key and Unique key?
Primary Key: A column in a table whose values uniquely identify the rows in the table. A primary key value cannot be NULL. Unique Key: Unique Keys are used to uniquely identify each row in the table. There can be one and only one row for each unique key value. So NULL can be a...
-
Aug 29, 2011
Comments OffPlease explain .frm .myd .myi in mysql?
Each MyISAM table is stored on disk in three files. The files have names that begin with the table name and have an extension to indicate the file type. The ‘.frm’ file stores the table definition. The data file has a ‘.MYD’ (MYData) extension. The index file has a ‘.MYI’ (MYIndex)...
-
Aug 29, 2011
Comments OffWhat is maximum size of a database in MySQL?
If the operating system or filesystem places a limit on the number of files in a directory, MySQL is bound by that constraint.The efficiency of the operating system in handling large numbers of files in a directory can place a practical limit on the number of tables in a database. If the time required to...
-
Aug 29, 2011
Comments OffWhat is the default table in MYSQL?
What is the default table in MYSQL and which type of table is generatedby default. MyISAM is the default storage...