Pixeltests 0 Comments

SQL Made Easy for AI – Day 1


Environment Setup and Basics

Installation:

MySQL Community Addition:
https://dev.mysql.com/downloads/mysql/

MySQL Workbench

https://www.mysql.com/products/workbench/

Queries Used:

CREATE DATABASE students;

CREATE TABLE student_info (    
student_id INT PRIMARY KEY,    
name VARCHAR(50),    
email VARCHAR(100),  
enrollment_date DATE
);

INSERT INTO students.student_info (student_id, name, email, enrollment_date)
VALUES (1, ‘Aparna Singh’, ‘aparna@gmail.com’, ‘2022-01-01’),
      (2, ‘Bharath Kumar’, ‘bharath@hmail.com’, ‘2022-01-02’);

SELECT *
FROM student_info;

Leave a Comment