Creating insert query using excel

posted in: MySql | 0

Summary: In Most of our project we got data from client in an excel file and we have to insert the same in our database. If excel data is complex then it is feasible to write the program to read … Continued

Uploading bulk data to database

posted in: MySql | 0

Summary: In many of our projects we need to do import/batch upload of data from a csv or xls file. We usually do data import by reading csv file and inserting records line by line. In this way the no … Continued

Comparison between MyIsam and Innodb

posted in: MySql | 0

Summary: Description: S.No Particular MyISAM InnoDB         1 Limitation No foreign keys and cascading deletes/updates No full text search     No transactional integrity (ACID compliance)       No rollback abilities           … Continued

Optimize tables and database in MySQL automatically with PHP

posted in: MySql | 0

Summary: Optimize Mysql Database Table: The Following Command will show the present status of the Database Table show table status like ‘mytablename’; The following command will optimize the Database Table optimize table mytablename; Optimize Database in MySQL automatically with PHP  … Continued

1 2 3