Laravel - creating and deleting tables using the terminal, possible errors and their elimination

To create a table, you must enter the line described below in the terminal. It is assumed that the developer has already opened his project in VSCode and is working in the terminal.

php artisan make:migration create_test1_table

If the command executes successfully, the user will see the following code.

INFO Migration [C:\OSPanel\domains\site1\database\migrations/

2023_10_27_122815_create_test1_table.php] created successfully.

At this point, you can make changes to Laravel's table system. To apply migration, enter the line below.

php artisan migrate

The following error message indicates that the PHP driver is not configured to work with databases.

could not find driver (Connection: mysql, SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')

To resolve the issue, you need to check the php.ini file, which is usually located in the PHP directory for working with the server. The file must contain the entry described below.

extension=php_pdo_mysql.dll

or

extension=pdo_mysql

There should not be a semicolon before the above line. This syntax disables the command. In this case, you need to enable it. Usually the first option is enough to connect PHP to MySQL. If the command is executed successfully, the user will see the following message.

PS C:\OSPanel\domains\site1> php artisan migrate

INFO Preparing database.

Creating migration table ......................................... 37ms DONE

INFO Running migrations.

2019_12_14_000001_create_personal_access_tokens_table ............ 44ms DONE

2023_10_27_110025_create_users_teble ............................. 17ms DONE

2023_10_27_122815_create_test1_table .............................. 8ms DONE

PS C:\OSPanel\domains\site1>

If you resend the instruction, no changes will occur in the tables.

INFO Nothing to migrate.

A table can be deleted from the database using code.

php artisan migrate:rollback

The command line will report the success of the operation.

INFO Rolling back migrations.

2023_10_27_122815_create_test1_table .............................. 7ms DONE

2023_10_27_110025_create_users_teble .............................. 5ms DONE

2019_12_14_000001_create_personal_access_tokens_table ............. 8ms DONE

Repeating the migration command will return the tables to the database. However, the number of each table will be increased as the system takes into account each action.

Command Line