Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE DATABASE TESTE
- USE TESTE
- CREATE TABLE CLIENTE22
- (
- COD_CLI NUMERIC(9,0) NOT NULL PRIMARY KEY,
- NOME_CLI VARCHAR(60),
- ENDE_CLI VARCHAR (50),
- BAIR_CLI VARCHAR (30),
- CIDA_CLI VARCHAR(30),
- UF_CLI CHAR(2),
- CEP_CLI CHAR(9),
- FON_CLI VARCHAR(20),
- )
- SELECT *
- FROM CLIENTE
- INSERT INTO CLIENTE
- VALUES(1, ' LEONARDO RODRIGUES','RUA JAMICA, 50', 'CENTRO' , 'VOTOCABA' ,'SP', '18149-000' , '15-99777-8860')
- INSERT INTO CLIENTE
- VALUES(2, ' LEONARDO RODRIGUES','RUA JAMICA, 50', 'CENTRO' , 'VOTOCABA' ,'SP', '18149-000' , '15-99777-8860')
- INSERT INTO CLIENTE
- VALUES (3, ' LEONARDO RODRIGUES','RUA JAMICA, 50', 'CENTRO' , 'VOTOCABA' ,'SP', '18149-000' , '15-99777-8860')
- UPDATE CLIENTE
- SET NOME_CLI='MARIA DA SILVA', FON_CLI= '15-98415-7250'
- WHERE COD_CLI = 2
- DELETE FROM CLIENTE
- FROM CLIENTE
- WHERE COD_CLI =3
- SELECT COD_CLI,NOME_CLI,FON_CLI
- FROM CLIENTE
- WHERE COD_CLI = 1
- DROP TABLE CLIENTE
- DROP DATABASE TESTE
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement