MySQL 5.7 change a datetime column to default NULL from 0000-00-00 00:00:00
So I started working on one of my Laravel projects, due to its large size, I was not able to perform migrations. In this case, we decided to directly export...
Category: SQL
50+ SQL Interview Questions Answers
Today, most businesses depend on data to manage their information. And SQL (Structured Query Language) is one of the essential database programming languages in the Information Technology (IT) industry. Top...
How to learn Analytic or Windows functions in MySQL for data science – Part 1?
Data Science is in too much Hype these days. Every organization is now a day looking for data scientists. The Data science role includes the collection, retrieval, analyzing, and representation...
How to learn Strings and datetime Analytic functions in MySql for data science?
Data Science is in too much Hype these days. Every organization is now a day looking for data scientists. The Data science role includes the collection, retrieval, analyzing, and representation...
Some Useful aggregate and mathematical functions in MYSQL for data science
Data Science is in too much Hype these days. Every organization is now a day looking for data scientists. The Data science role includes the collection, retrieval, analyzing, and representation...
SQL DROP Table
This statement is used to DROP OBJECTS in the database. It can be a whole database or just a table, index, or view. Note: Be careful while dropping a table....
#3144 – Cannot create a JSON value from a string with CHARACTER SET ‘binary’.
Error #3144 – Cannot create a JSON value from a string with CHARACTER SET ‘binary’. last day when i was exporting my database, i got above error. I solved the...
SQL About me
Today i am writing about SQL. In the internet Era, we all are having smart phones, Gadgets etc devices. We are using them to search/surfing on net. So, how data...
SQL TRUNCATE TABLE Statement
This statement is used to delete all rows from the table. Its similar like DELETE statement BUT it does not have WHERE clause in it. Syntax: DELETE ALL DATA in table...
SQL INSERT Statement
How to store data in a Table? Answer is very simple, Use INSERT query. There are two ways to insert data in table. Syntax: Form1 : INSERT INTO “tableName” values...
SQL SELECT
This statement is used to fetch the rows from the database table. Data is returned in the form of result table, which are also know as result-sets. Syntax: SELECT coulmn1,...
SQL UPDATE Statement
How to update data in a Table? Answer is to use UPDATE query. It is used with WHERE clause to avoid accidental update in all the columns rather than updates required...
SQL DELETE STATEMENT
This statement is used to delete one/more/all rows from the table depending upon some conditions. Syntax: DELETE ALL DATA in table without deleting table structure, index, constraints. DELETE * FROM...
SQL DROP Database
This statement is used to Delete all Structure/Data in database. Syntax: DROP database “DatabaseName”; Example: Below query will delete Structure/Data from the database. To DROP the database in “CREATE database tutorialmines”...
SQL SELECT/USE Database
When you open your database editor, you will have to select which database you would like to use among multiples database residing on your system. USE keyword offers this feature....
SQL CREATE Database
This statement is used to create a new database in the SQL. Syntax: CREATE database “DatabaseName”; DatabaseName – It can be anything i.e. combination of alphanumericals, alphabets, undrscore, hypens etc....
Sql – Start with me
SQL – Start with me. Now the question arise, how to start with it? You just need one database and you are ready to go with the editor to start...