by Peter | Jun 24, 2013 | MySql, Notes
Did you ever notice that MySQL auto increment used as default value to write in, if column value is null (or not specified). This is a really great feature, used I think in 80% of tables as id. If you delete the last row of a table eg. where id=5, time comes for...
by Peter | May 15, 2013 | MySql, Notes
The name of this database object, view in MySQL can give straight away an answer of the functionality. A view or “virtual table” can be created to retrieve data from tables actually hold the data or from other views. Update, delete, insert statements can...
by Peter | May 12, 2013 | MySql, Notes
Stored procedures in MySQL can encapsulate statements which can be used later. I think the real power of using stored procedures is in the amount of time can be saved by using one line against maybe dozens of insert, delete etc. Benefits of Stored Procedures in MySQL:...
