show databases;

CREATE DATABASE SampleApp;

USE SampleApp;

SHOW TABLES;

CREATE TABLE USERS (username VARCHAR(255), password VARCHAR(255));


SHOW TABLES;


/* Get all records from a table */

SELECT * FROM test_db.employees;


/* Insert data into a database */

use test_db;
INSERT INTO employees (firstname, lastname) VALUES ('John', 'Wayne');



/* Add a column to a row */

ALTER TABLE `test_db`.`employees` 
ADD COLUMN `id` INT NULL AFTER `lastname`;



/* Create a table with an autoincrement id */

CREATE TABLE Persons (
    Personid int NOT NULL AUTO_INCREMENT,
    LastName varchar(255) NOT NULL,
    FirstName varchar(255),
    Age int,
    PRIMARY KEY (Personid)
);