From Big Teal, 3 Years ago, written in SQL.

This paste is a reply to Re: Re: Re: Re: Re: Re: Re: motoryzacja from Sexy Pheasant - view diff

Embed

Download Paste or View Raw
Hits: 81

CREATE DATABASE motoryzacja

CREATE TABLE samochody(

id INT PRIMARY KEY AUTO_INCREMENT,

marka VARCHAR(20),

model VARCHAR(30),

pojemnosc FLOAT(5),

kolor VARCHAR(20)

);

INSERT INTO samochody(id, marka, model, pojemnosc, kolor) VALUES (NULL, 'BMW', 'e39', 1.8, 'czerwony')

INSERT INTO samochody(id, marka, model, pojemnosc, kolor) VALUES (NULL, 'Volkswagen', 'golf', 1.8, 'niebieski')

INSERT INTO samochody(id, marka, model, pojemnosc, kolor) VALUES (NULL, 'Fiat', 'Punto', 1.2, 'różowy')

INSERT INTO samochody(id, marka, model, pojemnosc, kolor) VALUES (NULL, 'Dodge', 'Viper', 1.2, 'zielony')

UPDATE samochody

SET pojemnosc = 1300

WHERE ID = 2;

UPDATE samochody

SET pojemnosc = 2.0

WHERE ID = 1 AND kolor = 'czerwony';

DELETE FROM samochody WHERE ID = 1;

DELETE FROM samochody WHERE ID = 3 AND kolor = 'zielony';

Replies to Re: Re: Re: Re: Re: Re: Re: Re: motoryzacja

Title	Name	Language	UNIX	When
Re: Re: Re: Re: Re: Re: Re: Re: Re: motoryzacja	Stained Tern	sql	1616764864	3 Years ago.

Author

Title

Language

Your paste - Paste your paste here

Private - Private paste aren't shown in recent listings.

Delete After - When should we delete your paste?

Spam protection -

{"html5":"htmlmixed","css":"css","javascript":"javascript","php":"php","python":"python","ruby":"ruby","lua":"text\/x-lua","bash":"text\/x-sh","go":"go","c":"text\/x-csrc","cpp":"text\/x-c++src","diff":"diff","latex":"stex","sql":"sql","xml":"xml","apl":"apl","asterisk":"asterisk","c_loadrunner":"text\/x-csrc","c_mac":"text\/x-csrc","coffeescript":"text\/x-coffeescript","csharp":"text\/x-csharp","d":"d","ecmascript":"javascript","erlang":"erlang","groovy":"text\/x-groovy","haskell":"text\/x-haskell","haxe":"text\/x-haxe","html4strict":"htmlmixed","java":"text\/x-java","java5":"text\/x-java","jquery":"javascript","mirc":"mirc","mysql":"sql","ocaml":"text\/x-ocaml","pascal":"text\/x-pascal","perl":"perl","perl6":"perl","plsql":"sql","properties":"text\/x-properties","q":"text\/x-q","scala":"scala","scheme":"text\/x-scheme","tcl":"text\/x-tcl","vb":"text\/x-vb","verilog":"text\/x-verilog","yaml":"text\/x-yaml","z80":"text\/x-z80"}

Re: Re: Re: Re: Re: Re: Re: Re: motoryzacja

Replies to Re: Re: Re: Re: Re: Re: Re: Re: motoryzacja

Reply to "Re: Re: Re: Re: Re: Re: Re: Re: motoryzacja"