differences between InnoDB and MyISAM

Differences between InnoDB and MyISAM     In MySQL, major difference of InnoDB and  MyISAM are given below. MyIsam is supporting the table level locking in database. But InnoDB is supporting the row level locking in the database. MyIsam is supporting the FULL TEXT SEARCH functionality and InnoDB also supporting the FULL TEXT SEARCH after MySQL Version of 5.6.4.    MyISAM Engine :  1. It supporting Table-level...

Read More

How to describe the single field in table by using mysql?

mysql> desc codingslover; +----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+-------------+------+-----+---------+-------+ | ProjId | varchar(20) | NO | PRI | NULL | | | BranchId | int(11) | YES | | NULL | | | AddedOn | datetime | YES | | NULL | | | Status | int(11) | YES | | NULL | | +----------+-------------+------+-----+---------+-------+ 4...

Read More

What is .frm, .myi, .myd. txt file in PhpMyadmin and MySQl?

What is .frm, .myi, .myd. txt file in PhpMyadmin and MySQl? When creating the table in database,that time 3 text file is generated in local.That files are   .FRM  =>  It has the table structure of your table or table definition  .MYI  =>   It has the indexes of your table  .MYD =>   It contains your data Generally you can find the data directory of your file with your .my.cnf file. The physical structure of db is some thing like a directory structure, where each database is a subdirectory...

Read More

Import CSV Files using php and mysql

  To import csv files into the mysql table,for this removing the header of the csv files and then run the below script.It will be insert into our mysql table. //Import csv files into mysql table LOAD DATA LOCAL INFILE 'd:\\Site.csv' INTO TABLE `siteurl` FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n'; //ends Character Escape Sequence \0 An ASCII NUL (0x00) character \b A backspace character \n A newline (linefeed) character \r A carriage return character \t A tab character \Z ASCII 26 (Control+Z) \N NULL Note...

Read More