PHP Classes

File: examples/example_table.sql

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: 8 years ago
Size: 505 bytes


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;