Select Page
Posted by admin | December 28, 2018 | Education, Uncategorized | 0 |
Git – team collaboration tool, tracks changes to files/scripts over time with tons of useful features. Setup a web server – Serve websites/files/services over a network. Learn basic SQL – Application data...
Read MorePosted by admin | December 12, 2018 | MySQL - MariaDB | 0 |
MySQL doesnt allow you to use a subquery in a delete cause with the same table name, such as: DELETE a.* FROM myTable a WHERE id IN ( SELECT id FROM myTable WHEREfoo = ‘bar’ ) A workaround (create a derived table...
Read MorePosted by admin | November 20, 2018 | MySQL - MariaDB | 0 |
Thats because: It will order in the order the enum values are defined at table level – not the actual varchar/int/etc value. Fix: SELECT CAST(a.enumfield AS CHAR(255)) AS enumfield, a.* FROM `mytable` a ORDER BY...
Read MorePosted by admin | November 16, 2018 | Hosting/Servers, PHP, Webmaster | 0 |
<?php if(empty($_SERVER[‘HTTPS’]) || $_SERVER[‘HTTPS’] == “off”){ //check for non secure connections $redirect = ‘https://’ . str_replace(‘www.’, ”,...
Read MorePosted by admin | September 25, 2018 | Hosting/Servers, MySQL - MariaDB | 0 |
CREATE TABLE table_backup LIKE my_friend INSERT INTO table_backup (SELECT * FROM table)
Read More