MySQL, PostgreSQL and SQLite data types comparisons

MySQL PostgreSQL SQLite int integer integer tinyint smallint integer smallint smallint integer mediumint integer integer bigint bigint integer bit bit integer int unsigned bigint integer smallint unsigned integer integer bigint unsigned numeric(20) integer   float real real double double precision real decimal decimal real numeric numeric real boolean boolean integer   date date text time time text datetime timestamp text … Continue reading

MySQL JOINS Explained

MySQL joins have been an issue for many. Here is a simple explanation that demystifies JOIN’s. INNER JOIN This is the most used join. This join will return rows from Table 1 that have matching rows in Table 2. SELECT <columns> FROM table_1 t1 INNER JOIN table_2 t2 ON t1.column_key = t2.column_key Another way this can be written is: SELECT … Continue reading