SQL COUNT() function | Get length of rows in a table

A table ‘students‘ that has some rows in it (table image is given below). How many rows this table have? I want to know that. So I will use SQL COUNT() function. For this, SQL provides a COUNT() function. With the help of that, we can get the total number of rows. SQL Count() function … Read more SQL COUNT() function | Get length of rows in a table

SQL NULL, AUTO_INCREMENT & PRIMARY KEY()

NULL :- When a table contains two or more columns and we insert data into only one column then data in the second column will be automatically inserted as a NULL value. NOT NULL & AUTO_INCREMENT:- When we want to make column auto-increment then it needs to be disabled its ‘NULL‘ feature. Write NOT NULL … Read more SQL NULL, AUTO_INCREMENT & PRIMARY KEY()

CONCAT() in SQL

We use CONCAT() function in SQL to concatenate two or more column’s data. To understand CONCAT(), we are going to create a database ‘jai_school‘. The database contains the table, so make a table: users Insert some data Use CONCAT() function Other Articles SQL CASESQL MIN() and MAX() functionsSQL operators

Copy Table or a Particular Column’s data in another table SQL

We can copy the whole table or its specific columns we want to copy. Create table and copy another table data Or But column count in both tables should match if you use all column selector ( * ). In the above example, the admission table contains five columns & the users table also contains … Read more Copy Table or a Particular Column’s data in another table SQL

MIN() and MAX() functions in SQL

Sql MIN() function is to get the minimum number from a column. And, MAX() function is used to display maximum number from a table’s column. Examples are given below- Database Name– jai_school Create a table– result Insert data in result table Table Image- SQL MIN() function query result- Display MIN(marks) in another column– query result- … Read more MIN() and MAX() functions in SQL

How much RAM is needed for MySql Database Engine?

As you know that Mysql is database software. We store data in it with the help of SQL (structured query language). Approximately 512 MB (Megabyte) ram is recommended to proper work MySql. For example, If you create a droplet on the Digitalocean cloud server with 1 GB of ram and 1 CPU. And, then Install … Read more How much RAM is needed for MySql Database Engine?