README.md

The Pixelated Coder 👨‍💻

📝 SQL JOURNEY

👥 Author

• Kavish Pandit

My journey of 10000 lines of sql commands using 3 databases

🎉 ALL SQL COMMANDS USED

• Sql Link

DATABASED INVOLVED

DataBases	Name	School	Company	OnlineShop
Tables	School	Students	Teachers	Subjects
Tables	Company	Employess	Clients	Projects
Tables	Onlineshop	Items	Categories	Customers	Orders

Basic Snapshotting

mysql> CREATE USER 'admin' IDENTIFIED BY 'password1234';

Query OK, 0 rows affected (0.02 sec) //CHANGE PASSWORD

mysql> ALTER USER 'admin' IDENTIFIED BY 'php1234'; Query OK, 0 rows affected (0.01 sec)

//GRANT ALL PRIVELLEGES TO ALL DB () ALL TABLES () TO THE USER 'ADMIN' WITH USER CAN SET PRIVELLEGES AND NEW USER

mysql> GRANT ALL ON . TO 'admin' WITH GRANT OPTION; Query OK, 0 rows affected (0.02 sec) //PRIVILEGES TO TAKE PLACE

mysql> FLUSH PRIVILEGES;

//EXIT TO LOG IN TO ADMIN

SCHOOL

COMPANY

ONLINESHOP

Description:

Created an repository using SQL ON MYSQL WORKBENCH. Feel free to reach out if any issues 🙌