MySQL Notes with Examples- AGN HUB

 W hat is database -it is a collection of data stored in a format that can easily be accessed. - a collection of data - made up of "tables" - tables store similar information About Tables - Tables are made of "columns" and "rows" -Columns are like categories -each entry goes on a separate row eg:- Name Age Profession John 23 Teacher Ram 45 developer Ravi 34 student what is SQL -Structured query language -SQL is the language databases use -MySQL is a program that understand SQL -Other software, but MySQL is the best! Advantages of MySQL -Cross Platform -Used with multiple languages (PHP, NodeJS, Python, C#). -MySQL software is Open Source. -MySQL is RDBMS. -The MySQL Database Server is fast, reliable, scalable, and,easy to use. -MySQL Server works in client/server or embedded systems Websites using mysql -Facebook -Twitter -Google -Wikipedia -Youtube -Flickr -Pinterest Primary Key - all tables should have "primary keys...