あるカラムを参照する外部キーの一覧を取得する
SELECT tb1.TABLE_NAME,
tb1.COLUMN_NAME,
tb1.CONSTRAINT_NAME,
tb1.REFERENCED_TABLE_NAME,
tb1.REFERENCED_COLUMN_NAME,
tb2.UPDATE_RULE,
tb2.DELETE_RULE
あるカラムを参照する外部キーの一覧を取得する
SELECT tb1.TABLE_NAME,
tb1.COLUMN_NAME,
tb1.CONSTRAINT_NAME,
tb1.REFERENCED_TABLE_NAME,
tb1.REFERENCED_COLUMN_NAME,
tb2.UPDATE_RULE,
tb2.DELETE_RULE
<?php | |
namespace App\Xxx; | |
use Illuminate\Database\Eloquent\Builder; | |
use Illuminate\Database\Eloquent\Collection; | |
use Illuminate\Database\Eloquent\Relations\HasOne; | |
/** | |
* Class HasOneCustomResolver |
function myFunction() { | |
var issues = []; | |
var offset = 0; | |
do { | |
var fetchedIssues = fetchIssues(offset); | |
Array.prototype.push.apply(issues, fetchedIssues); | |
offset += 100; | |
} while (fetchedIssues.length == 100); | |
writeHeader(); |