IN Php I want to get the 20 record from each table in the database using the php code or mysql store procedure .
Any one help..
Thanks
I've managed to achieve something.
First of all you have to add the file
privilege to the user. So you have to login to mysql as root and run this command:
GRANT FILE ON *.* TO youruser@localhost;
And here's the code that will export each table in a separate file:
$tables = ['specs', 'devices', 'categories'];
foreach($tables as $table)
{
$file = '/home/chromespecs/public/sql/' . $table . '.sql';
DB::statement("select * into outfile '$file' FROM $table");
}
I've just tested it and it works.
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments