MSSQL Select Not Null
I mainly use MySQL these days, so get screwed over for a few minutes when I have to do something in MSSQL that is slightly different when it comes to …
Read Article →MySQL
41 articles about mysql development, tools, and best practices
MySQL Main Query Types used in PHP to select, insert, update and delete data
MySQL Main Query Types
SELECT
SELECT * FROM tablename
INSERT
INSERT INTO tablename (col1, col2, col3,..) VALUES (val1, val2, val3,...)
UPDATE
UPDATE …Connect to mysql database from php
If you need to connect to a mysql database from php you can do it like this:
<?php
$DBH = 'localhost';
$DBU = 'root';
$DBPWD = …Warning: mysql_affected_rows(): supplied argument is not a valid MySQL-Link resource
Warning: mysql_affected_rows(): supplied argument is not a valid MySQL-Link resource
You have just gotten a warning when trying to check if an …
Read Article →mySQL select multiple ids
SELECT * FROM tablename WHERE `active`='1' AND `id` IN ('107' , '125' ) ORDER BY `id` DESC LIMIT 12`