Questions tagged [sql]
The sql tag has no usage guidance.
150
questions
0
votes
2
answers
115
views
Load files in sequential order
I need to load multiple files in my shell script with the same filename but appended in the front of each file name is YYMMDDPERSONNEL
Examples: 231102PERSONNEL and 230103PERSONNEL
There are many ...
-1
votes
1
answer
77
views
Why no one thought of the concept of joins before the 70s? [closed]
So, let me see if I have my history right:
In 1976, the first system sold as an RDBMS was Multics Relational Data Store. I don't know if it had JOIN, but let's assume it did.
The UNIX command join ...
0
votes
0
answers
520
views
Unix : How to convert HTML output from Shell script
How to display the sql query output to HTML table format output.
am having shell script code to display output as html table format. and input is taken form sql query but am not getting the proper ...
0
votes
1
answer
45
views
Sqlite table creation
Is it possible to create tables based on a columns data?
I currently have a table named Exchange which contains numerous columns
ID:NAME:PRICE
1:Stick:12
2:Stone:20
3:Water:1
4:Water:1
But I want to ...
0
votes
2
answers
8k
views
How to write a shell script to run a sql query and send the query results in table format in email?
I need to run a SQL query using SHELL script in PUTTY and send the results in email body in table format with headers along with a message line on top.
I have written this so far but I am not able to ...
0
votes
1
answer
901
views
Cannot install Microsoft SQL Server to Ubuntu AWS /lib/x86_64-linux-gnu/libc.so.6: version 'GLIBC_2.30' not found
I am trying to install SQL server onto a Ubuntu machine on AWS and it has been nothing but trouble. I get stuck on the last step, configuring the server after selecting edition and setting an ...
0
votes
0
answers
85
views
filewatcher script in ksh script
I wanted to edit a already created filewatcher script with the given logic
the source file path is stage path (stage/filewatcherwrap.ksh)
there are 4 files in the below given format in stage path
...
0
votes
1
answer
109
views
why when I execute a select it works and when I execute an update the script blocks?
when I try to execute a query of type update the script hangs and the sql console stays still.
This command executes all queries in the script:
res=$(mysql --defaults-file=conf_file --skip-column-...
0
votes
2
answers
650
views
Slackware and postgres
I want to install postgres and psql via a Slackbuild and I did so. After installing it I tried running the command as suggested in the readme of the Slackbuild but I get an error upon running it as ...
-1
votes
2
answers
123
views
Running SQL databases offline
I'm running a Debian 10 based distro. As an experiment, I downloaded one of these Wikipedia-like sites which gives you a download size of several gigabytes. I was hoping to run it offline.
I don't ...
2
votes
2
answers
2k
views
How to store query multiple result in shell script variable(Array)?
I'm trying to do a query and store every row result in an array element in ksh (maybe bash).
I do:
result=($($PATH_UTI/querysh "
set heading off
set feedback off
SELECT columnA,columnb FROM user....
1
vote
3
answers
158
views
Regular expression - SQL manipulation
[pol@fedora data]$ lsb_release -a
LSB Version: :core-4.1-amd64:core-4.1-noarch
Distributor ID: Fedora
Description: Fedora release 34 (Thirty Four)
Release: 34
Codename: ThirtyFour
I'm ...
1
vote
1
answer
47
views
whole data isn't showing on POST sql injection
sqlmap -u "http://192.168.0.106/get_method/get_data_login/" --data="name=name&password=pass" -D get_method -T user --dump
Output :
[11:27:40] [INFO] the back-end DBMS is ...
0
votes
1
answer
137
views
not getting whole data by sqlmap
$ sqlmap -u http://192.168.0.106/get_method/get_data/?id=1 -D get_method -T user --dump
But, my data
CSV also completely same as terminal picture
name,serial,password,timestamp
asdf,1,asdf,2021-03-...
0
votes
1
answer
3k
views
using of sqlmap by different ip addresses
sqlmap -u http://192.168.0.106/get_method/get_data/?id=1 --dbs
I know that if we sent any request to any server that server takes ip address of user(mine). So, while I am running the above source ...