mysql creating table

Creating database with auto_incrementing id:

CREATE TABLE test (
id INT NOT NULL AUTO_INCREMENT,
name VARCHAR(20),
        nickname VARCHAR(20),
PRIMARY KEY(id)
);


Inserting values:

INSERT INTO test (name, nickname) VALUES("John", "Fire");

Updating values: (for multiple values put comma, after each SET clouse

UPDATE test 

SET vardas = 'Power'

WHERE id = 1;

Deleting values:

DELETE FROM test WHERE id = 11;

Adding additional rows in table:

ALTER TABLE test ADD comment VARCHAR(100);

Dropping column:

ALTER TABLE test DROP COLUMN comment;

Resources:

https://www.youtube.com/watch?v=nWeW3sCmD2k - SQL Crash Course - Beginner to Intermediate
https://www.youtube.com/watch?v=Thd8yoBou7k - MYSQL for pyhon developers

How to allow remote mysql access?

Edit MySQL config file:

$ sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf

Find line:

bind-address            = 127.0.0.1

Change it to:

bind-address            = 0.0.0.0

Restart MysQL Server:

$ sudo systemctl restart mysql.service

Logging to MySQL database, and create new user:

$ mysq -u username -p

CREATE USER 'username'@'%' IDENTIFIED BY 'password';

edifact

http://bots.sourceforge.net/en/index.shtml