Skip to content

Instantly share code, notes, and snippets.

@DavidBernalGonzalez
Last active May 31, 2022 21:56
Show Gist options
  • Save DavidBernalGonzalez/1ece6f6ddc733b64493506dff64cfa3f to your computer and use it in GitHub Desktop.
Save DavidBernalGonzalez/1ece6f6ddc733b64493506dff64cfa3f to your computer and use it in GitHub Desktop.
DROP DATABASE IF EXISTS db_test;
CREATE DATABASE IF NOT EXISTS db_test;
USE DB_TEST;
CREATE TABLE IF NOT EXISTS users (
id INT AUTO_INCREMENT PRIMARY KEY,
nombre VARCHAR(255) NOT NULL,
apellidos VARCHAR(255) NOT NULL,
fechaNacimiento DATE
);
INSERT INTO users(nombre, apellidos, fechaNacimiento) values ('David', 'Bernal', '1991-02-13');
INSERT INTO users(nombre, apellidos, fechaNacimiento) values ('Alejandro', 'Fernandez', '1991-02-13');
INSERT INTO users(nombre, apellidos, fechaNacimiento) values ('Matias', 'Coronado', '1991-02-13');
SELECT * FROM users;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment