How to change mysql engine from Myisam to Innodb
ALTER TABLE tbl_employees ENGINE=INNODB;
Category Archives: SQ L& MYsql
How to upload large size file upload through phpmyadmin
If you are using Xampp server then use the following method go to the below folder phpmyadmin/libraries/config.default.php inside config.default.php edit the line as like below $cfg[‘ExecTimeLimit’] = 0;
Getting the following error while import sql file in phpmyadmin.
Fatal error: Out of memory (allocated 998506496) (tried to allocate 496760462 bytes)phpMyAdmin\libraries\import.lib.php on line 373 Step1:Copy the .sql file into the xammp folder in the below path xampp/mysql/bin Step2:create a database called testdatabase in phpmyadmin step3: Execute the below command through command prompt C:\xampp\mysql\bin>mysql -u root -D testdatabase < db_dump_db.sql
How to copy a table from one database to another database including structure and data in mysql
There are different options for copying table from one database to another database. Two methods i m giving here 1.In phpmyadmin one option is there to copy tables.Phpmyadmin if you go to operations tab->copy database to using the below options using a checkbox. Structure only Structure and data Data only CREATE DATABASE before copying Add… Read More »
Column ’emp_id’ in IN/ALL/ANY subquery is ambiguous
Below query execution throwing the error Column ’emp_id’ in IN/ALL/ANY subquery is ambiguous select employees.emp_id,emp_reg_date from employees join emp_linking_table on emp_linking_table.emp_id=employees.emp_id where emp_id not in( select emp_id from data_record_table) solution: if you change condition like as below will give proper result where employees.emp_id not in( select emp_id from data_record_table)