How to create table in MySql?

Run this query:

CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) NOT NULL,
  `username` varchar(1024) COLLATE utf16_unicode_ci NOT NULL,
  `password` varchar(64) COLLATE utf16_unicode_ci NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `block` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB;

Comments

Posts Quoted:
Reply
Clear All Quotes