Skip to content

Instantly share code, notes, and snippets.

@mayararysia

mayararysia/query.sql

Last active July 23, 2023 11:54
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mayararysia/5937c96192af587ddcc6f7b29cb15ddc to your computer and use it in GitHub Desktop.
Save mayararysia/5937c96192af587ddcc6f7b29cb15ddc to your computer and use it in GitHub Desktop.
Download ZIP
Example query for mysql connection exercise
Raw
query.sql
create database bd;
use bd;
CREATE TABLE `user` (
`id` SERIAL PRIMARY KEY,
`name` VARCHAR(30) NOT NULL,
`cpf` VARCHAR(20) NOT NULL
);
INSERT INTO `user` (`name`, `cpf`) VALUES ('Leta Lestrange', '012.236.987-44'), ('Newt Scamander', '021.545.258-55'),
('Hermione Granger', '024.547.658-77');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment