Monday, March 2, 2015
PHP MySQL HTML Code: Create database & Create Table, Add, edit Search...
PHP MySQL HTML Code: Create database & Create Table, Add, edit Search...: create database DBname; CREATE TABLE people (name VARCHAR(30), age INTEGER, height FLOAT, date DATETIME); INSERT INTO people VALUES (...
Create database & Create Table, Add, edit Search Delete in MySQL
create database DBname;
CREATE TABLE people (name VARCHAR(30), age INTEGER, height FLOAT, date DATETIME);
INSERT INTO people VALUES ( "Jim", 45, 1.75, "2006-02-02 15:35:00" ), ( "Peggy", 6, 1.12, "2006-03-02 16:21:00" )
UPDATE people SET age = 7, date = "2006-06-02 16:21:00", height = 1.22 WHERE name = "Peggy"
SELECT name FROM people WHERE age < 12
DELETE FROM people WHERE age < 12
Labels:
Add,
Create database,
CREATE TABLE,
edit Search Delete,
MySQL
Subscribe to:
Posts (Atom)