Change column position

ALTER TABLE table_name MODIFY COLUMN column_last_name VARCHAR(40) AFTER column_first_name;

Count rows in a table

SELECT COUNT(*) FROM table_name;

Create a new table in the database

CREATE TABLE employees (
    id INT AUTO_INCREMENT PRIMARY KEY,
    first_name VARCHAR(50) NOT NULL,
    last_name VARCHAR(50) NOT NULL,
    email VARCHAR(100),
    hire_date DATE,
    salary DECIMAL(10, 2)
);

Insert data into an existing table in the database

INSERT INTO table_name (column1, column2, ...) VALUES (value1, value2, ...);

Select data from an existing table in the database

SELECT * FROM table_name;

Select specific columns from an existing table in the database

SELECT column1, column2 FROM table_name;

Update data in an existing table in the database

UPDATE table_name SET column1 = value1 WHERE condition;

Alternate table row styles Conditional formatting of table rows Copy text to clipboard Disable spaces in an input field Multi step form with progress indicator Read more or less Remove the leading and trailing space input Toggle visibility with a slide effect Toggle visibility without pushing content Validate checkboxes Validate input fields Validate radio buttons Validate TinyMce editor

Comma after each value, except the last one Convert values of a column to lowercase Display records Display records in a Bootstrap Table Display records in columns Display records with Bootstrap pagination Display records with CSS styles Escape all special characters in a string Highlight the search term in the search results Replace unicode characters by utf-8 characters Search autocomplete with Bootstrap Typeahead Search records by an option Select rows for today's date Short commands Strip HTML tags

MySQL

Short Commands

Change column position

Count rows in a table

Create a new table in the database

Insert data into an existing table in the database

Select data from an existing table in the database

Select specific columns from an existing table in the database

Update data in an existing table in the database

About Luan Morina