Variable Visions

MySQL



How to rename a MySQL database?

Published on Sun. Dec. 09, 2012

Read other tutorials on MySQL and Web-Development.




Add multiple new tags with an SQL statement

Or INSERT multiple entries at once by chaining statements together

Published on Sat. Sep. 22, 2012

Read other tutorials on MySQL and Web-Development.




BIG SQL

Use a big sql insert statement when adding multiple entries at once.

Published on Sun. Sep. 16, 2012

Read other tutorials on MySQL and Web-Development.




How to execute a random SQL query

Published on Sun. Sep. 16, 2012

Read other tutorials on MySQL and Web-Development.




PHP IF statement for hidding NULL fields from a MySQL database

This if statement will hide the image container when the result is NULL.

Published on Tue. Jul. 31, 2012

Read other tutorials on MySQL and Web-Development.




Password encryption using sha256 and salts

When storing passwords in a database it is good practice to store only the hash encrypted 64 digit hexadecimal string so the actual passwords are never potentially viewed by malicious viewers.

Published on Thu. Jul. 29, 2010

Read other tutorials on MySQL and Web-Development.