Help with SQL commands to interact with a MySQL database
- Mac /usr/local/mysql/bin
- Windows /Program Files/MySQL/MySQL version/bin
- Xampp /xampp/mysql/bin
!DOCTYPE html> | |
<html lang="en"> | |
<head> | |
<meta charset="UTF-8"> | |
<meta name="viewport" content="width=device-width, initial-scale=1.0"> | |
<meta http-equiv="X-UA-Compatible" content="ie=edge"> | |
<meta name="description" content="Venture Garden Group Network - join our ever-growing tech community of interns. Signing up is easy"> | |
<link href="https://fonts.googleapis.com/css?family=Raleway&display=swap" rel="stylesheet"> | |
<link href="style.css" rel="stylesheet"> | |
<title>VGG Network Registration</title> |
element{ | |
padding: 5px 10px 15px 20px; | |
} |
element{ | |
padding-top:5px; | |
padding-right: 10px; | |
padding-bottom: 15px; | |
padding-left: 20px; | |
} |
QUICK SIMPLE ASSIGNMENT | |
1. | |
We have the following arrays | |
color = ["Blue ", "Green", "Red", "Orange", "Violet", "Indigo", "Yellow "]; | |
o = ["th","st","nd","rd"] | |
Write a JavaScript program to display the colors in the following way : | |
"1st choice is Blue." |
const tags = document.querySelector('#tags') | |
const search = document.querySelector('#search'); | |
const imagesBox = document.querySelector('#imagesBox'); | |
search.addEventListener('click', getInput) | |
function getInput(){ | |
if(tags.value.length === 0){ | |
alert("You haven't entered any username") | |
}else{ |
CREATE SCHEMA myschooldb; | |
SET search_path = myschooldb; | |
DROP TABLE IF EXISTS students; | |
CREATE TABLE students( | |
id serial PRIMARY KEY, | |
first_name VARCHAR(100) NOT NULL, | |
last_name VARCHAR(100) NOT NULL, | |
middle_name VARCHAR(100) NULL, | |
gender VARCHAR(1) NOT NULL, |