Save sql file from query

SELECT users.first_name, users.middle_name, users.last_name, users.email, users.mobile, patient_profiles.niko_id FROM users RIGHT JOIN patient_profiles ON users.id = patient_profiles.patient_id where users.role = 'patient' AND patient_profiles.niko_id IS NOT NULL INTO OUTFILE '/var/lib/mysql-files/users.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n';

Comments

Post a Comment

Popular posts from this blog

Laravel Reverb + Echo naming convention.

   Echo listen() function relies on a very exact and weird naming convention, something to do with Namespaces: If the php Event name is "ChatMessageSent" then Echo knows how to listen to that event as:     Echo.private('chats').listen('ChatMessageSent', (e) => {         console.log('New chat message', e);     }); But if we have a broadcastAs() method in the event class:     public function broadcastAs(): string     {         return 'chat.message.sent';     } Then Echo doesn't know how to listen to chat.message.sent event. Instead, you have to put a dot before the event name: .chat.message.sent Echo.private('chats').listen('.chat.message.sent', (e) => {       console.log('New chat message', e); });    
Read more