PHP Classes

File: verificadb.sql

Recommend this page to a friend!
  Classes of Renato Menezes Portugal   Verify User   verificadb.sql   Download  
File: verificadb.sql
Role: Auxiliary script
Content type: text/plain
Description: SQL file to Database
Class: Verify User
Validate user with a record in a MySQL table
Author: By
Last change:
Date: 5 years ago
Size: 332 bytes
 

Contents

Class file image Download
CREATE DATABASE IF NOT EXISTS `verificadb`;
USE `verificadb`;
   
CREATE TABLE `usuarios` (
    `id` INT NOT NULL,
    `usuario` VARCHAR(200) NULL,
    PRIMARY KEY (`id`)
)
COLLATE='latin1_general_ci'
ENGINE=InnoDB
;

INSERT INTO `usuarios` (`id`, `usuario`) VALUES
    (1, 'Renato'),
    (2, 'Jorge'),
    (3, 'Maria'),
    (4, 'Daniel');