Sql Queries

SQL is a standard language for storing, manipulating and retrieving data in databases.

Create a new user:

CREATE USER ‘hokageKvT’@’localhost’ IDENTIFIED BY ‘hokageKvT’;

GRANT ALL PRIVILEGES ON * . * TO ‘hokageKvT’@’localhost’;

#
# Starting with MySQL 8.0.4, the MySQL team changed the
# default authentication plugin for MySQL server
# from mysql_native_password to caching_sha2_password.
#
# The command below will make the appropriate updates for your user account.
#
# See the MySQL Reference Manual for details:
# https://dev.mysql.com/doc/refman/8.0/en/caching-sha2-pluggable-authentication.html
#
ALTER USER ‘hokageKvT’@’localhost’ IDENTIFIED WITH mysql_native_password BY ‘hokageKvT’

Create a new Table:

CREATE DATABASE IF NOT EXISTS `student_tracker`;
USE `student_tracker`;

—
— Table structure for table `student`
—

DROP TABLE IF EXISTS `student`;

CREATE TABLE `student` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`first_name` varchar(45) DEFAULT NULL,
`last_name` varchar(45) DEFAULT NULL,
`email` varchar(45) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;