Search
 
SCRIPT & CODE EXAMPLE
 

PHP

laravel migration table bigint

$this->bigIncrements('id');
This takes care of making it unsigned, auto increment and primary key
Comment

laravel migration smallint length

For Laravel & Mysql

String types
CHAR - 1 to 191 (trailing spaces removed)
STRING - 1 to 16,300 (user defined)
TEXT - 1 to 65,535
MEDIUMTEXT - 1 to 16,777,215
LONGTEXT - 1 to 4,294,967,295

Integer types
TINYINT - 0 to 255 (unsigned) | -128 to 127 (signed)
SMALLINT - 0 to 65,535 (unsigned) | -32,768 to 32,767 (signed)
MEDIUMINT - 0 to 16,777,215 (unsigned) | -8,388,608 to 8,388,607 (signed)
INT - 0 to 4,294,967,295 (unsigned) | -2,147,483,648 to 2,147,483,647 (signed)
BIGINT - 0 to 18,446,744,073,709,551,615 (unsigned) | -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807 (signed)

Floating types
Structure: `([max decimal places], [max precision])`
FLOAT - ([0-7], [0-23])
DOUBLE - ([0-14], [24-53])
DECIMAL - ([0-65], [0-30])
Comment

PREVIOUS NEXT
Code Example
Php :: A Livewire component was not found 
Php :: connect php in sql server 
Php :: cf7 remove p tags 
Php :: magento 2 colllection set select 
Php :: show phpinfo just modules 
Php :: how to login first before see index php 
Php :: array in php 
Php :: call satic blco in magento 2 
Php :: AuthController 
Php :: database connection in pdo php 
Php :: Toaster switch Statement 
Php :: laravel eloquent get x number of results 
Php :: install composer laravel 
Php :: remove some state from state list woocommerce 
Php :: nginx php-fpm 
Php :: turn off wordpress user list exposed 
Php :: php remove duplicates from string 
Php :: codeigniter number format function 
Php :: echo placeholder image if post thumbnail not found 
Php :: substr last 3 characters 
Php :: woocommerce_product_is_on_sale filter 
Php :: custom blade 
Php :: php rand between 0 and 1 
Php :: string put inside tag string php 
Php :: blade check if variable exists 
Php :: livewire check no errors 
Php :: php config file 
Php :: laravel query builder delete all 
Php :: laravel create method 
Php :: check if any field update laravel 
ADD CONTENT
Topic
Content
Source link
Name
7+2 =