Yii methods for executing SQL statements using the Migrate command _php instance

This article illustrates how Yii uses the Migrate command to execute SQL statements. Share to everyone for your reference, specific as follows:

YII2 has a powerful command line management tool, in the Windows clock out cmd command window, switch to the YII project directory (including Yii.bat), you can run Yii command in CMD.

To execute an SQL statement using the Yii migrate command:

If the path to/console/migrations/m130524_201442_init.php this file defines a user table of SQL, we will execute this SQL to generate the data table, run:

Yii Migrate console/migrations/m130524_201442_init.php

Migrate is the command that YII uses for data migration, which is just one of the uses.

Turn from: Small Talk blog http://www.tantengvip.com/2015/05/yii-migrate-sql/

More about Yii related content readers can view the site topics: "Yii framework Introduction and common skills Summary", "PHP Excellent Development Framework Summary", "Smarty Template Primer Tutorial", "PHP date and Time usage summary", "PHP object-oriented Programming Program", " Summary of PHP string usage, Introduction to PHP+MYSQL database operations, and a summary of PHP common database operations Tips

I hope this article will help you with the PHP program design based on the YII framework.