PHP Classes

File: SQL File

Recommend this page to a friend!
  Classes of Mohamed Elbahja   MySQLi Manager   examples/example_table.sql   Download  
File: examples/example_table.sql
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: MySQLi Manager
Execute MySQL queries from parameters using MySQLi
Author: By
Last change:
Date: 9 years ago
Size: 505 bytes
 

Contents

Class file image Download 

CREATE TABLE `example_table` (
  `id` int(11) NOT NULL,
  `title` varchar(100) CHARACTER SET utf8 NOT NULL,
  `description` varchar(150) CHARACTER SET utf8 NOT NULL,
  `text` text CHARACTER SET utf8 NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


INSERT INTO `example_table` (`id`, `title`, `description`, `text`) VALUES
(1, ' title', ' desc', ' text');

ALTER TABLE `example_table`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `example_table`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;