Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE user0
- (
- Dname VARCHAR(100) UNIQUE NOT NULL,
- Dpassword VARCHAR(100) NOT NULL
- );
- CREATE TABLE data0
- (
- Dbrand VARCHAR(100) NOT NULL,
- Dmodel VARCHAR(100) NOT NULL,
- Ddescription VARCHAR(10000) NOT NULL,
- Dprice DECIMAL(20,4) UNSIGNED NOT NULL
- );
- INSERT INTO user0(Dname,Dpassword)
- VALUES ("alvi","alvi");
- INSERT INTO user0(Dname,Dpassword)
- VALUES ("zafir",SHA1("alvi"));
- INSERT INTO data0(Dbrand,Dmodel,Ddescription,Dprice)
- VALUES("a0","b0","c0",20.0);
- INSERT INTO data0(Dbrand,Dmodel,Ddescription,Dprice)
- VALUES("a1","b1","c1",21.1);
- INSERT INTO data0(Dbrand,Dmodel,Ddescription,Dprice)
- VALUES("a2","b2","c2",22.2);
- INSERT INTO data0(Dbrand,Dmodel,Ddescription,Dprice)
- VALUES("a3","b3","c3",23.3);
- INSERT INTO data0(Dbrand,Dmodel,Ddescription,Dprice)
- VALUES("a4","b4","c4",24.4);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement