usuario

an anonymous user · June 11, 2021 · SQL
-- create a table
CREATE TABLE usuario (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  gender TEXT NOT NULL,
  endereco char NOT NULL,
  cidade TEXT NOT NULL,
  estado TEXT NOT NULL,
  cep CHAR NOT NULL,
  rg CHAR NOT NULL,
  email CHAR NOT NULL,
  celular CHAR NOT NULL,
  residencial Char NOT NULL
);

insert into usuario (
id, name, gender, endereco, cidade, estado, cep, rg, email, celular, residencial)
values (1, 'Cynthya','F', 'filarmonica 46', 'sao paulo','sp', '313.242.384-19', '62.523.789-5', 'cynthya07@gmail.com', '11 2894-4408', '11 93271-3748'
);

insert into usuario (
id, name, gender, endereco, cidade, estado, cep, rg, email, celular, residencial)
values(2, 'joao', 'M', 'padre miguelinho 54', 'sao paulo', 'sp', '181.237.984-20', '42.613.652-3', 'joao@gmail.com', '11 1091-9832', '11 92383-3824');

select * from usuario;

Comments

Please sign up or log in to contribute to the discussion.