Even the most experienced developer needs to test if his regular expressions work as expected. That’s a little pain in the neck, but there is an interesting website developed by gskinner that can help us in that task: http://gskinner.com/RegExr/ Another cool website to learn regular expressions: www.regular-expressions.info Useful Regular Expressions Regular expression for Validating Emails:
SET A default value for a MySQL Datetime column
If you want a table which populates automatically a DATETIME column with the current date/time value, We may do something INCORRECT like this: Why incorrect? Actually is correct, but you must be aware that the range of TIMESTAMP is only 1970-2038. So we could get unexpected errors when working with higher ranges. The faster and easier approach I found is …