Search for a command to run...
Series
In this series, I will document my learning of MySQL Database Management System. I will chronicle the various concepts I have learnt throughout my learning journey.
Structured Query Language or SQL is the language used when we talk to databases. Queries are the commands that interact with the database. MySQL vs SQL MySQL is a database management system, unlike SQL which is a language. There are different databas...
A database is an organized collection of data. It is organized in such a way that the data can be easily managed and accessed. Data can be organized in the form of tables, with rows and columns. Indices can be used to make the retrieval of data easie...
Data Base Management System is a software that is used to store and fetch information stored in the database. DBMS allows us to perform various operations on the data like creation, reading, updating, deletion etc. DBMS can also be used by the user t...
RDBMS is based on the relational data model, which stores data in the form of rows(tuple) and columns(attributes). These rows and columns together form a table(relation). A relational database uses SQL for storing, manipulating, as well as maintainin...
MySQL is an open-source relational database management system (RDBMS) developed by Oracle Corporation. It uses Structured Query Language (SQL) for database management. MySQL is widely used for various applications, from small websites to large-scale ...
Creating users The CREATE USER command is important in MySQL for creating new user accounts that can access the database. The database administrators use this command to define which users are authorized to connect to the MySQL server and specify the...