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
To filter duplicate data from a table, we use a DISTINCT keyword before the column name (of which data is to filter). Distinct query–
LIMIT is used to display a certain number of rows from the table. n = Number of rows Database: jai_schoolTable: students Rows: s_n name class roll_no due_fee 1 Ram 8 1 8000 2 Rahim 8 2 16000 3 Shyam 8 3 7000 4 Anita 8 4 9000 5 Jai 8 5 7000 6 Ravina 6 … Read more SQL LIMIT | Display certain rows from a table
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()
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
SQL query to change column’s data type:-
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
In SQL, we use CASE to apply conditions. See practical example below- Database ~ jai_school Create a table result Insert data in the table Table Image- CASE example query result- Introduction to SQL create a database in SQL Table in SQL Store data in a table How to delete database How to delete table in … Read more CASE 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
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?