Not in vs Not Exists
They both (“NOT IN” and “NOT EXIST”) have the same functionality with only one major difference: “NOT IN” will return a “NULL” if there are any NULL column(s) in the subquery. “NOT EXISTS” does not … Read more
Category : MySQL
Find the Storage Engine of my MySQL tables
use Tablename; select table_name, ENGINE FROM INFORMATION_SCHEMA.TABLES WHERE table_schema=DATABASE();
MySQL Varchar Max Length Confusion
I was always under the impression that varchar maximun length was 255. Values in VARCHAR columns are variable-length strings. The length can be specified as a value from 0 to 255 before MySQL 5.0.3, and … Read more
How to find the Mysql Storage Engine Type
Here are your options: 1. Check the my.ini file 2. Check you GUI Configuration or preferences 3. Run the following query: SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE table_schema = ‘ycsoftware’
Last Inserted ID in PHP Mysql
Getting the last inserted ID in PHP(Mysql) is not too bad. I am assuming that you already have a connection to the database; echo mysql_insert_id(); or $result = mysql_query (‘SELECT LAST_INSERT_ID()’); $row = mysql_fetch_array($result); echo … Read more