Prepared statements are what you need. CREATE PROCEDURE `test1`(IN tab_name VARCHAR(40) ) BEGIN SET @t1 =CONCAT(‘SELECT * FROM ‘,tab_name ); PREPARE stmt3 FROM @t1; EXECUTE stmt3; DEALLOCATE PREPARE stmt3; END $$
I also had same problem in past. All had happend after moving database files to new location and after updating mysql server. All tables with InnoDB engine disappeared from my database. I was trying to recreate them, but mysql told me 1146: Table ‘xxx’ doesn’t exist all the time until I had recreated my database … Read more
Sounds like you have Schroedinger’s table… Seriously now, you probably have a broken table. Try: DROP TABLE IF EXISTS contenttype REPAIR TABLE contenttype If you have sufficient permissions, delete the data files (in /mysql/data/db_name)
Don’t put the DB::insert() inside of the Schema::create(), because the create method has to finish making the table before you can insert stuff. Try this instead: public function up() { // Create the table Schema::create(‘users’, function($table){ $table->increments(‘id’); $table->string(’email’, 255); $table->string(‘password’, 64); $table->boolean(‘verified’); $table->string(‘token’, 255); $table->timestamps(); }); // Insert some stuff DB::table(‘users’)->insert( array( ’email’ => ‘name@domain.example’, … Read more