CODEWITHSUNDEEP
phplaravel-5
sarika
sarika

Reputation: 11

Syntax error or access violation: 1327 Undeclared variable:

Why do i get this error

Syntax error or access violation: 1327
Undeclared variable: database1 (SQL: SELECT * INTO `database1`.dbo.`tablename` FROM `database2`.dbo.`tablename`

when copying database on same server?

Upvotes: 0

Views: 953

Answers (1)

sarika
sarika

Reputation: 11

$newdatabase = 'newdatabase';
$tablename = 'users';
$olddatabase= 'existingdatabase';``
$results = DB::unprepared("CREATE TABLE $newdatabase.$tablename LIKE $olddatabase.$tablename") ;
 $sql = "INSERT INTO `$newdatabase`.`$tablename` SELECT * from `$olddatabase`.`$tablename`";
 $data = DB::insert($sql);

Upvotes: 1

Related Questions