laravel 中的 Mysql 查询在使用显示语法时给出语法错误

Question

我有如下的sql查询

show indexes from `users` where not Non_unique and Key_Name <> 'PRIMARY';

但是当我在 Laravel 中编写相同的查询时，如下所示。

$columns = DB::select(DB::raw(" SHOW INDEXES FROM $table WHERE NOT Non_unique and Key_Name <> PRIMARY "))->get();

它给了我以下错误

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'PRIMARY' at line 1

Answer 1

你需要添加'来包装primary，所以改变

$columns = DB::select(DB::raw(" SHOW INDEXES FROM $table WHERE NOT Non_unique and Key_Name <> PRIMARY "))->get();

到

$columns = DB::select(DB::raw(" SHOW INDEXES FROM $table WHERE NOT Non_unique and Key_Name <> 'PRIMARY' "))->get();