Diff database structure with sqlyog

When requirement for information stored in database grow, old table structure need to adjust for flexibility. Common task to do in  normal cycle : 1. Build new application in other place 2. Synchronize database ( tables) 3. Upload application. Second step ( synchronize tables) often  painful when a lot of changes made at home and …

More

Some mysql sql basic command I must remember

I use phpmyadmin in daily environment, do I still know  sql command? My sql file too large, it’s hard to import using phpmyadmin, please help me Some question around mysql from my student, my false make them spoil using phpmyadmin all day long Here’s my answers : 1. Command to create database create database databasename …

More