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 … Continue reading →

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 … Continue reading →