RSS
Copy Paste Code
personal pastebin - debug, share, develop, store
  • Home
  • Add Code
  • Languages
    • ActionScript
    • Active Server Pages
    • C
    • C#
    • C++
    • Cascading Style Sheets
    • eXtensible Markup Language
    • Hypertext Markup Language
    • Java
    • JavaScript
    • Lisp
    • mIRC
    • MySQL
    • Perl
    • PHP
    • Python
    • Ruby
    • Ruby on Rails
    • Scheme
    • Smalltalk
    • vb
    • Visual Basic .NET
  • Your Code

mysql

by nick on March 8th, 2010
No notes
Syntax: MySQL
Show lines - Hide lines - Show in textbox - Download
51&q=CREATE&lr=lang_en">CREATE 51&q=TABLE&lr=lang_en">TABLE `yourDatabaseTableName`(  
   `id` 51&q=INT&lr=lang_en">int(5) 5.1/en/non-typed-operators.html">NOT 51&q=NULL&lr=lang_en">NULL 51&q=AUTO_INCREMENT&lr=lang_en">auto_increment,  
   `date` 51&q=TIMESTAMP&lr=lang_en">timestamp 5.1/en/non-typed-operators.html">NOT 51&q=NULL&lr=lang_en">NULL 51&q=DEFAULT&lr=lang_en">default 5.1/en/date-and-time-functions.html">CURRENT_TIMESTAMP,  
   `name` 51&q=VARCHAR&lr=lang_en">varchar(25) 5.1/en/non-typed-operators.html">NOT 51&q=NULL&lr=lang_en">NULL 51&q=DEFAULT&lr=lang_en">default 'anonimous',  
   `comment` 51&q=VARCHAR&lr=lang_en">varchar(255) 5.1/en/non-typed-operators.html">NOT 51&q=NULL&lr=lang_en">NULL 51&q=DEFAULT&lr=lang_en">default '',  
   51&q=PRIMARY%20KEY&lr=lang_en">PRIMARY KEY (`id`)  
); 
Click here to cancel reply.

Leave a Reply

Note: XHTML is allowed. Your email address will never be published.

Subscribe to this comment feed via RSS