ALTER TABLE myemp1
ADD salary DOUBLE(10,2); # 預設添加至表中的最後一個欄位
ALTER TABLE myemp1
ADD phone_number VARCHAR(20) FIRST; # 添加至表中的第一個欄位
ALTER TABLE myemp1
ADD email VARCHAR(45) AFTER emp_name; # 添加至 emp_name 欄位的後面
ALTER TABLE myemp1
MODIFY emp_name VARCHAR(25); # 修改欄位長度
ALTER TABLE myemp1
MODIFY emp_name VARCHAR(25) DEFAULT 'aaa'; # 修改預設值
ALTER TABLE myemp1
CHANGE salary monthly_salary DOUBLE(10,2);
ALTER TABLE myemp1
CHANGE email my_email VARCHAR(50);
ALTER TABLE myemp1
DROP COLUMN my_email;
RENAME TABLE myemp1
TO myemp11;
ALTER TABLE myemp2
RENAME TO myemp12;
DROP TABLE [IF EXISTS] myemp2;
TRUNCATE TABLE employees_copy;
MySQL
pom.xml 添加 MyBatis 依賴
Jul 27, 2023Override the validationData() function to apply validation rules to the URL parameters. <?php namespace App\Http\Requests; use Illuminate\Foundation\Http\FormRequest; class DateRangeRequest extends FormRequest {
May 29, 2023參考自:MongoDB Docs > $unionWith (aggregation)stackoverflow > SQL ‘UNION ALL’ like implementation in MongoDB
Jan 6, 2023對於多條折線圖,若每條線的 X 軸與 Y 軸的值都不盡相同時 (如下圖所示)
Jan 6, 2023or
By clicking below, you agree to our terms of service.
New to HackMD? Sign up