Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > body text

Migration of Lavarel's commonly used statements

不言
Release： 2023-03-24 11:32:01
Original
1872 people have browsed it

The content of this article is about Migration, a commonly used statement in Lavarel. It has a certain reference value. Now I share it with you. Friends in need can refer to it

Lavarel5.2 Mainly, the previous parts need to be operated frequently. As long as you master the commonly used statement functions, it will become much easier to implement them


  1. Controller

  2. Model

  3. ##View

  4. Route

  5. Migration


##Migration Chapter

1. Create Migration

in Enter the command in the console

Command to create a table, we are used to naming it with behavior

php artisan make:migration create_users_table --create=users
Copy after login

Command to modify the table

php artisan make:migration add_votes_to_users_table --table=users
Copy after login

This way there will be more files in /database/migrations

2. Create a column

Schema::create('users', function ($table) {    $table->increments('id');    $table->string('name');
});
Copy after login
Corresponding command and type in the corresponding database

Auto-increment ID, type is bigint##$table->bigInteger('votes');$table->binary('data');##$table->boolean('confirmed');$table->char('name', 4);$table->date('created_at');$table->dateTime('created_at');##$table->decimal ('amount', 5, 2);$table- >double('column', 15, 8);$table->enum('choices', ['foo', 'bar']);$table->float('amount');$table->increments('id');Equivalent to the INTEGER type in the databaseEquivalent to the JSON type in the database##$table->jsonb('options');Equivalent to the JSONB type in the databaseEquivalent to the JSONB type in the database LONGTEXT type is equivalent to the MEDIUMINT type in the databaseEquivalent to the MEDIUMTEXT type in the databaseAdd an INTEGER type taggable_id column and a STRING type timestamps() but allows NULL values. column: VARCHAR(100) NULL.Add a column for soft deletion.Equivalent to VARCHAR in the database, with a lengthEquivalent to the TEXT type in the database##$table->time('sunrise ');##$table->tinyInteger('numbers');##$table->timestamp('added_on');Add column.##$table->uuid('id');
CommandDescription
##$table->bigIncrements('id ');
Equivalent to the BIGINT type in the database
Equivalent to The BLOB type in the database
is equivalent to the BOOLEAN type in the database
Equivalent to the CHAR type in the database
Equivalent to the DATE type in the database
Equivalent to the DATETIME type in the database
Equivalent to the DECIMAL type in the database, with a precision and range
Equivalent to the DOUBLE type in the database, with precision, a total of 15 digits, 8 digits after the decimal point.
Equivalent to the ENUM type in the database
Equivalent to the FLOAT type in the database
Database primary key auto-increment ID##$table-> integer('votes');
$table->json('options');
##$table->longText('description');
$table->mediumInteger('numbers');
$table->mediumText('description');
$table->morphs('taggable');
taggable_type column ##$table->nullableTimestamps();Same as
##$table->rememberToken();Add a remember_token
$table->smallInteger('votes');Equivalent to the SMALLINT type in the database
$table->softDeletes();deleted_at
$table->string('email');Equivalent to the VARCHAR column in the database.
$table->string('name', 100);
$table ->text('description');
Equivalent to the TIME type in the database
Equivalent to the TINYINT type in the database
Equivalent to TIMESTAMP type in the database##$table->timestamps();
created_at and updated_at
is equivalent to the UUID of the database

3.修改列

如果我们执行的是类似第二行命令的话
新生成migration里up方法的Create就会变成table，然后就可以在方法里写修改的一些代码

Schema::table('users', function ($table) {

});
Copy after login

我们将name列的尺寸从 25 增加到 50：

$table->string('name', 50)->change();
Copy after login

我们还可以修改该列允许 NULL 值：

$table->string('name', 50)->nullable()->change();
Copy after login

重命名列

 $table->renameColumn('from', 'to');
Copy after login

注意：暂不支持 enum类型的列的重命名。

删除列

$table->dropColumn('votes');
Copy after login

  • 1

删除多个列：

$table->dropColumn(['votes', 'avatar', 'location']);
Copy after login

  • 1

以上就是一些Migration的常用语句，学会Migration可以节省大量用命令行建表的时间

我把整个Lavarel系列的所有链接都更新了，欢迎大家点评

版权声明：本文为博主原创文章，未经博主允许不得转载。            https://blog.csdn.net/qq_32198277/article/details/52592769





The above is the detailed content of Migration of Lavarel's commonly used statements. For more information, please follow other related articles on the PHP Chinese website!

Related labels：
lavarel migration Commonly used
source：php.cn
Previous article：Random number generation from array in PHP Next article：PHP determines whether a string contains an element value in an array
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
function_exists() cannot determine the custom function Function test () {return true;} if (function_exists ('test')) {echo "test is function...
From 2024-04-29 11:01:01
0
2
2021
How to display the mobile version of Google Chrome Hello teacher, how can I change Google Chrome into a mobile version?
From 2024-04-23 00:22:19
0
11
2187
The child window operates the parent window, but the output does not respond. The first two sentences are executable, but the last sentence cannot be implemented.
From 2024-04-19 15:37:47
0
1
1842
There is no output in the parent window document.onclick = function(){ window.opener.document.write('I am the output of the child ...
From 2024-04-18 23:52:34
0
1
1733
Where is the courseware about CSS mind mapping? Courseware
From 2024-04-16 10:10:18
0
0
1756
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template

Public welfare online PHP training，Help PHP learners grow quickly！

About us Disclaimer Sitemap

© php.cn All rights reserved