Find out the creation date of a MySQL table

Sometimes it’s useful to know when a certain database table was created. For those cases the following statement can be used:

SELECT create_time
FROM INFORMATION_SCHEMA.TABLES WHERE table_schema = 'DB_NAME'

In case you are interested in the creation time of a particular table, just add the appropiate WHERE-clause:

SELECT create_time
FROM INFORMATION_SCHEMA.TABLES WHERE table_schema = 'DB_NAME'
AND table_name = 'TABLE_NAME'

+---------------------+
| create_time         |
+---------------------+
| 2011-12-22 12:32:34 |
+---------------------+
1 row in set (0.00 sec)

Update: As pointed out below in the comments, it is not possible to know the creation date of a database without access to the directory structure of MySQL.

Advertisements

Teach yourself how to program

I’m more into system administration than I am into programming, this is mainly because at my job I”m not involved in programming tasks (left aside scripting stuff). I do however have a very strong desire to refresh those programming classes from university and get to know awesome new programming languages such as Android, Ruby, NodeJS, .., and do cool stuff with them, who knows even join an OpenSource project.

For that purpose I’m collecting links to nice tutorials and books that I come across while browsing the net. Hopefully one day I’m able to read all those (after finishing the Oracle 11g Administration book I’m currently reading, and the RedHat Linux Certification that I wish to prepare afterwards). So little time and that much to discover yet!

Anyway, the links (more links will be added along the way):

http://www.codecademy.com

The idea behind this website is to learn to program by actually doing it instead of reading a book. They offer a nice interactive shell to learn JavaScript (more languages will be added). Users are encouraged by the receiving badges as they accomplish targets (sort of Stack Overflow style). The courses being offered are FREE.

http://www.codeschool.com

Same principle as codecademy, learn by doing. They offer several courses as pay-per-view ($55) or monthly subscription ($25/mo). Some of the courses they offer include:

  • jQuery
  • Functional HTML5 & CSS
  • Ruby on  Rails
  • Ruby (this one is FREE)

http://learncodethehardway.org/

Emphasizes precision, attention to detail, and persistence by requiring you to type each exercise (no copy-paste) and make it run, as well as to read up on outside topics and to return to exercises and ideas that you don’t understand, and understand them. Don’t take “the hard way” to literal, it just means you learn by actually doing the excercices instead of just copying them. They offer various books for FREE in HTML format (PDF and other formats are to be paid, but cost little):

  • Python
  • Ruby
  • SQL (Currently in Alpha version)
  • RegEx (Currently in Alpha version)
  • C (Currently in Alpha version)

http://academicearth.org/subjects/computer-science

Offers FREE academic videos on computer science related topics as taught at leading universities. Just to name a few:

  • Programming Methodology (Stanford)
  • Introduction to Computer Science and Programming (MIT)
  • Introduction to Computer Science (Harvard)
Excellent resource to learn Ruby on Rails. It doesn’t matter whether you already know Ruby or web development in general, all get touched in this book. Available for FREE in HTML and in PDF for $26. They also offer +15 hours of screencasts (to be paid) which allow you to look over the shoulder of an experienced Ruby on Rails developer and see how they do it.
Yet another resource to learn Ruby. Available for FREE in HTML format, to be paid in others.

Please feel free to drop a comment if you know other good resources

How to change password expiration in Oracle 11g

Another quick hint, this time for Oracle database administration.

Starting Oracle 11g the default profile that users belong to, if no other profile is specified, forces the password to be changed within 180 days. Previous versions didn’t have this “feature”, so this might result in a nice surprise when you find out that your application isn’t working anymore after 6 months.

Although security-wise it’s a good idea to change passwords now and then, sometimes it’s necessary for the password to remain the same. To change the expiration time to unlimited for the default profile, execute the following statement:

alter profile default limit password_life_time unlimited;