Selasa, 01 November 2016

Create Table Mysql

Membuat table mysql :

SET FOREIGN_KEY_CHECKS=0;
DROP TABLE IF EXISTS `tampung`;
CREATE TABLE `tampung` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `msisdn` VARCHAR(255) CHARACTER SET latin1 DEFAULT NULL,
  `message` VARCHAR(255) CHARACTER SET latin1 DEFAULT NULL,
  `senderid` VARCHAR(255) CHARACTER SET latin1 DEFAULT NULL,
  `providerid` VARCHAR(255) CHARACTER SET latin1 DEFAULT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MYISAM DEFAULT CHARSET=utf8;

Sekian Terima kasih.