Backup your php.ini file before you do anything. Then open the php.ini file so that you can edit it. Check that file_uploads is set to On (needed to upload files via a PHP script). Set upload_max_filesize to 64M (or less). Set post_max_size to 64M (or less). Set memory_limit, to 64M (or less). Set max_input_time to 600 or less. Set max_execution_time to 300 or less. Save your php.ini file.​ (or minimal modifications): upload_max_filesize = 500M post_max_size = 500M max_execution_time = 500

PHP automates inserting data into MySQL table by using INSERT command within PHP code.

Use asterisk character in the SELECT statement like this: SELECT * FROM name_of_table

SELECT field_name, another_field_name FROM table_name

INSERT INTO table_name (column_name1, column_name2, …) VALUES (‘value1’, ‘value2’, …) Important: there should be no comma after the last element within both sets parentheses; single quotes must be used for any string values; order of columns should correspond to the order of values. 

mysql> CREATE TABLE `name_of_table` ( `first_field_name` varchar (100),  `second_field_name` varchar(100), `and_s0_on` );

mysql> CREATE DATABASE nameofdatabase;

MySQL terminal and phpMyAdmin.

Structured Query Language.

MySQL is an application that allows user to store data in databases and tables, as well as to insert/retrieve data using SQL language.