Best practices for writing professional SQL code require good formatting skills. In this article, we will learn different professional SQL code formatting techniques :
Category: MySQL
Select all columns except a few specific column in snowflake [New Feature].
We all know that SELECT * FROM table_name gives us all the columns from table but sometimes we need to select all the columns except a few columns. One of the easiest ways is to manually specify columns and exclude unwanted columns, like:
SELECT column_1,column_2, column_3,…column_n FROM table_name;
SQL Cheat Sheet [Basic DDL and DML commands]
DATA DEFINITION LANGUAGES (DDL) COMMANDS A Data Definition Language (DDL) statement is used to define
How to Install MYSQLND: mysqli Extension for php in Ubuntu? [SOLVED]
The mysqli extension is missing. Please check your PHP configuration. See our documentation for more information.
MySQL Create and Drop database/schema.
In this tutorial, we will learn how to create and drop the database/schema in the MySQL workbench and MySQL command-line tool.
[Django Tutorial] Connect MySQL Database in Django Framework
If you are looking forward to connect your MySQL database with python code that check
Laravel5.7 CRUD Operations Examples from Scratch.
We learned to set up our database and perform initial database migration in previous blog.
How to Change the Authentication Method in MySQL? [Ubuntu-18.04]
Issue I have an instance of mysql installed in my system. Say my username is
How to Connect MySQL Database using Python?
In order to connect your database using python, you need to install a database connector.
MySQL Server 8.0.15(Community Edition) Easy Installation in Windows 10
It took me a few hours to figure out the proper way of installing MySQL