Create a SQL table with autoincrement id and timestamps

By -
CREATE TABLE `tutorials` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `published` tinyint(1) DEFAULT '1',
  `createdAt` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updatedAt` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) 

Comments

Post a Comment

Popular posts from this blog

How to add Diggit, Technorati, Del.icio.us, Stumbleupon, Reddit and pInterest buttons to your Blogger posts

By Dora -
Image
Here's how you can add a row of social media sharing buttons all at one go :) Step 1 Locate the <data:post.body/> code in the HTML template. Step 2 Copy and paste the code below just after the  <data:post.body/> tag. <!--Digg--> <a expr:href='"http://digg.com/submit?phase=2&amp;url=" + data:post.url + "&amp;title=" + data:post.title' target='_blank'><img src="https://sites.google.com/site/mydesiowfamily/Home/diggit.png" border="0"/></a> <!--Technorati--> <a expr:href='"http://technorati.com/faves?add=" + data:post.url' target='_blank'><img src="https://sites.google.com/site/mydesiowfamily/Home/technorati.png" border="0"/></a> <!--Del.icio.us--> <a expr:href='"http://del.icio.us/post?url=" + data:post.url + "&amp;title=" + data:post.title' target='_blank'...
Read more

How to create an organizational chart in your webpage using Google Organization Chart Tools

By Dora -
Image
https://developers.google.com/chart/interactive/docs/gallery/orgchart While googling for some information on organizational charts of various companies, I came across this cool visualization tool on Google Developers. If you are comfortable with JavaScript and want a quick and easy way to churn out a simple organizational chart that displays on a webpage, this tool is quite useful. Organizational chart churned out using Google's Visualization OrgChart object To use it, follow these few steps Step 1: Include this tag in your <head> tag in your HTML file <script type = 'text/javascript' src = 'https://www.google.com/jsapi' ></script> Step 2: Load visualization package and set callback method when page loads In this case, the callback method is "drawChart". <script type = 'text/javascript' >       google . load ( 'visualization' , '1' , { packages :[ 'orgchart' ]});     ...
Read more

How to remove “Git” from Windows 7 context menu

By Dora -
Image
Click “Start->Run->cmd” to open up a command prompt window Type the following commands in the command prompt Technorati Tags: Git , Windows 7 , context menu You should see the above "success" message to inform you that the DLL has been unregistered and you should no longer see the "Git" menu items on your context menu
Read more