Unknown command '\;' Post: 303034859

Sponsored Content

Top Forums Shell Programming and Scripting Unknown command '\;' Post 303034859 by RudiC on Wednesday 8th of May 2019 08:16:31 AM

05-08-2019

Registered User

How about preparing an sql- file outside mysql using e.g. awk and then executing this with a single mysql invocation? Like create barisprep:

Code:

{print  "INSERT INTO video_series_files (id, video_id, file_type, protocol, url, languages, quality, accessed ,status )" \
        " SELECT '." ++CNT ".', video_id, 'sub', 'custom', 'http://localhost/test/" $1 "." $2 "." $3 "', 'a:1:{i:0;s:2:'" $2 \
        "';}', '', '1', '1' FROM video_series_files WHERE url like '%" $1 "%.mkv';"}

, running it with

Code:

awk -vCNT=$counter -fbarisprep 2 > barisprep.sql

resulting in

Code:

INSERT INTO video_series_files (id, video_id, file_type, protocol, url, languages, quality, accessed ,status ) SELECT '.106.', video_id, 'sub', 'custom', 'http://localhost/test/Mr.Smith.Goes.to.Washington.en.srt', 'a:1:{i:0;s:2:'en';}', '', '1', '1' FROM video_series_files WHERE url like '%Mr.Smith.Goes.to.Washington%.mkv';
INSERT INTO video_series_files (id, video_id, file_type, protocol, url, languages, quality, accessed ,status ) SELECT '.107.', video_id, 'sub', 'custom', 'http://localhost/test/Mr.Smith.Goes.to.Washington.fr.srt', 'a:1:{i:0;s:2:'fr';}', '', '1', '1' FROM video_series_files WHERE url like '%Mr.Smith.Goes.to.Washington%.mkv';
INSERT INTO video_series_files (id, video_id, file_type, protocol, url, languages, quality, accessed ,status ) SELECT '.108.', video_id, 'sub', 'custom', 'http://localhost/test/Mr.Smith.Goes.to.Washington.el.srt', 'a:1:{i:0;s:2:'el';}', '', '1', '1' FROM video_series_files WHERE url like '%Mr.Smith.Goes.to.Washington%.mkv';

and then source it like

Code:

mysql -uroot -D mydatabase -pmypasswd -sN  < barisprep.sql

EDIT: or even

Code:

mysql -uroot -D mydatabase -pmypasswd -sN  < $(awk -vCNT=$counter -fbarisprep 2)

Last edited by RudiC; 05-08-2019 at 09:30 AM..

These 2 Users Gave Thanks to RudiC For This Post:

RudiC

View Public Profile for RudiC

Find all posts by RudiC

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

unknown host

Hello all I'm new to this site and I have to say that ,it is just awesome. I was able to get most of my questions answered by reading the archives. I've been a UNIX programmer for a while now but new to administration. I just installed SunOS 5.9 on my desktop ( i86pc) . Everything...

2. Solaris

<drive type unknown> when format command run

Hi, we are running solaris 9 on V280R. Due to power failure, one disk's label and lost its details like drive type etc. Disk details: <SUN72G cyl 14087 alt 2 hd 24 sec 424> single partition on slice 6 with UFS. The below i see when i run "format" command ..... ..... 4....

3. Solaris

PING - Unknown host 127.0.0.1, Unknown host localhost - Solaris 10

Hello, I have a problem - I created a chrooted jail for one user. When I'm logged in as root, everything work fine, but when I'm logged in as a chrooted user - I have many problems: 1. When I execute the command ping, I get weird results: bash-3.00$ usr/sbin/ping localhost ...

4. Shell Programming and Scripting

Sed unknown command

Hi everyone, I am trying to replace a string that contains a space using sed. A typical input file is: CATEGORY=1 1:1.0 CATEGORY=2 13:1.0 CATEGORY=3 1:99.0 CATEGORY=8 14:1.0 CATEGORY=11 1:1.0 I want to use a string (as it can change) to make replacements using ...

5. HP-UX

'SP2-0734: unknown command beginning "elect' Error

My environment is HP-UX... NIS CEL | uname -a HP-UX s53kj113 B.11.11 U 9000/800 1510201964 unlimited-user license I ran this command directly from the server's sqllplus. Logically, it should have work. But in my case, it always escaped the 1st character of the next command after the...

6. AIX

Unknown VGs

Hi Guys, I found on one of the server there are 2 VG's which I dont have any Idea of who created .. as below bash-3.00$ lsvg old_rootvg rootvg datavg altinst_rootvg altinst_rootvg under is meant for alternate disk installation.. But I'm not sure for which version of OS it was...

7. Solaris

Unknown fstype?

Dear all I have formatted/labeled/partitioned my new disk but when trying to mount it is returning 'unknown fstype' .Can you please let me know how to solve this problem? Thank you

8. Shell Programming and Scripting

There's a unknown command on line 1 and i don't know whats causing it.

My OS is Linux GL version 2.4.26. I am trying to make a shell script that outputs a chart displaying info of who is online, boot time, and the real time, I have manage to get it to work, but I still get the error "./user/script: line 1: : command not found." I do in fact have access to root, if...

9. Shell Programming and Scripting

Unknown fs on usb?

Error mounting: mount exited with exit code 1: helper failed with: mount: wrong fs type, bad option, bad superblock on /dev/sdb1, missing codepage or helper program, or other error In some cases useful info is found in syslog - try dmesg | tail or soThis happens when I try...

10. Programming

Arduino-cli - Uploading to Unknown Chinese Arduino Boards using the Arduino Command Line Interface

In my further exploration of Arduino, today I decided to install the arduino-cli on my mac today. https://github.com/arduino/arduino-cli I followed the instructions for macOS but when I got to this part: arduino-cli board list I got the dreaded "Unknown" Fully Qualified Board Name...

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

unknown host

Discussion started by: luft

2. Solaris

<drive type unknown> when format command run

Discussion started by: prvnrk

3. Solaris

PING - Unknown host 127.0.0.1, Unknown host localhost - Solaris 10

Discussion started by: Przemek

4. Shell Programming and Scripting

Sed unknown command

Discussion started by: BlueberryPickle

5. HP-UX

'SP2-0734: unknown command beginning "elect' Error

Discussion started by: aimy

6. AIX

Unknown VGs

Discussion started by: kkeng808

7. Solaris

Unknown fstype?

Discussion started by: hadimotamedi

8. Shell Programming and Scripting

There's a unknown command on line 1 and i don't know whats causing it.

Discussion started by: thatguy565

9. Shell Programming and Scripting

Unknown fs on usb?

Discussion started by: 1in10

10. Programming

Arduino-cli - Uploading to Unknown Chinese Arduino Boards using the Arduino Command Line Interface

Discussion started by: Neo