Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DROP DATABASE IF EXISTS bolt;
- CREATE DATABASE IF NOT EXISTS bolt;
- use bolt;
- CREATE TABLE IF NOT EXISTS vevok
- (
- vevoAz INT PRIMARY KEY auto_increment,
- vevoNev VARCHAR(64),
- kapcsolatNev VARCHAR(64),
- varos VARCHAR(32),
- cim VARCHAR(32),
- iranyitoSzam INT,
- orszag VARCHAR(64)
- )CHARSET=utf8;
- CREATE TABLE IF NOT EXISTS rendelesek
- (
- rendelesAz INT PRIMARY KEY,
- vevoAz INT not NULL,
- dolgozoAz INT,
- datum VARCHAR(10),
- szallitoAz INT
- )CHARSET=utf8;
- INSERT INTO vevok VALUES
- (null, "Trend Bt","Nagy János","Miskolc", "Pokol u. 35", 3400, "Magyarország")
- ,(null, "Tompa Kft","Kis Péter","Szolnok", "Piros tér 22.",4233, "Magyarország")
- ,(null, "Bocs Bt","Bocs Ernő","Szolnok", "Tekerentyű u. 48", 4832, "Szlovákia");
- INSERT INTO rendelesek VALUES
- (10201, 2, 5, 2014-09-15, 4)
- ,(10203, 2, 3, 2015-09-16, 3)
- ,(10204, 4, 8, 2014-09-17, 3);
Add Comment
Please, Sign In to add comment