Author Archives: user

MySQL – VARCHAR Table of content The MySQL Varchar Data Type The MySQL VARCHAR data type is used to store variable-length character strings, having a length up to 65,535 bytes. In MySQL, when you store text in a VARCHAR column, it needs a little extra space to keep track of how long the text is. […]

MySQL – Data Types Table of content Data types are referred as the type of data, like string, integer, date-time etc., that can be stored in a column (field) of a table. Properly defining the fields in a table is important to the overall optimization of your database. You should use only the type and […]

MySQL – After Delete Trigger Table of content In general, a Trigger is defined as a response to an event. In MySQL, a trigger is called a special stored procedure as it does not require to be invoked explicitly like other stored procedures. The trigger acts automatically whenever the desired event is fired. Triggers are […]