You need to build some dynamic sql for this. I prefer to build it in one go and execute as a whole: declare @sql varchar(max) = '' select @sql += ' update ' + QUOTENAME(replace(tablename,' ','')) + ' set column1 = replace(column1,''A'',''B'')' from table1 exec (@sql) ...
mysql,laravel,routes,prefix,tablename
You can make use of Laravels pagination functionality. It splits your data into pages and let's you generate links to get to each page... $selected_table = DB::table($argument)->paginate(100); // how many records you wan't on one page And then in your view do this to generate the links {{ $table_name->links() }}...
You asked, How can I use a variable in a SQL query without using dynamic SQL and the concat method? Sorry, you can't. Dynamic SQL is the way that's done in MySQL. This applies to the names of schemas, tables, and columns -- that is, data dictionary names -- and...