create database

The workbench

The key components are in the menu system for the icons.

There are only a few icons, so the process is relatively simple.

• create sql - creates a new sql

• open sql - opens a pre-saved sql

• open inspector

• create schema - creates a new schema (database) in the connected server.

making keywords uppercase

In MySQL Workbench, you can configure the SQL editor to automatically convert keywords to uppercase by following these steps:

Open the Preferences window by going to Edit > Preferences (or by pressing Ctrl + Alt + P).

• In the Preferences window, go to the "SQL Editor" tab.

• Under the "SQL Editor" tab, find the "Case Sensitive" section.

• Check the box next to "Force keywords to uppercase in the SQL editor".

• Click "Apply" to save the changes.

From now on, all keywords in the SQL editor will be automatically converted to uppercase as you type them.

AUTO_INCREMENT vs AUTOINCREMENT

mysql uses AUTO_INCREMENT in workbench but AUTOINCREMENT is vscode. why different ?

In MySQL, the AUTO_INCREMENT attribute is used to generate a unique integer value for a column whenever a new row is inserted into a table. This attribute is often used to create primary key columns that are unique for each row in the table.

In Visual Studio Code (VS Code), the AUTOINCREMENT attribute is used to achieve the same effect. The difference in the attribute names is due to the fact that VS Code is a third-party tool, and it uses its own syntax and conventions for working with MySQL.

Both AUTO_INCREMENT and AUTOINCREMENT are used to create auto-increment columns in MySQL, but the syntax for using them may be different depending on the tool you are using.

For example, in MySQL Workbench, you can create an auto-increment column by setting the "Auto Increment" property for the column in the Table Editor:

• • id INT NOT NULL AUTO_INCREMENT,

In VS Code, you can create an auto-increment column by using the AUTOINCREMENT attribute in the CREATE TABLE statement:

• • id INT NOT NULL AUTOINCREMENT,