Скачать с ютуб Php Mysql tutorial - Learn Mysql database, CRUD in One video - in Bangla в хорошем качестве

Php Mysql tutorial - Learn Mysql database, CRUD in One video - in Bangla

This video will teach you how to up and running with MySQL . At the end of this lesson, you will be able to create a database, create a table, insert data to the table, read data from a table, update data, delete data from the table by your self. turorial and source code could be found in https://github.com/polodev/mysql_crea... mysql 101 tutorial Here anything i put inside will be variable value. It will be different in your case. SQL is not case sensitive so uppercase and lowercase is same thing. to login into mysql mysql -uroot -p to know about all database show databases; crate a database CREATE DATABASE dbname; database use USE dbname to know about all tables show tables; Table create CREATE TABLE tableName( id INT(11) AUTO_INCREMENT PRIMARY KEY, name VARCHAR(30) NOT NULL, email VARCHAR(30) ); to know table structures describe tableName to insert a row in a table (C) INSERT INTO TABLENAME (column1, column2) VALUES('column1value', 'column2value'); to retrieve data from table (R) SELECT columnName, columnName FROM tableName SELECT * FROM tableName to update row from table (U) UPDATE tableName SET column="value" WHERE columnName='value' to delete row from table (D) DELETE FROM tableName where columnName='value'