Why it is showing error?

|
ChildProcessError 2022-01-13 13:17:29
MasterZiv 2022-01-13 13:09:44
this is not a JSON I suppose

it works in json file

MasterZiv 2022-01-13 13:20:55
ChildProcessError 2022-01-13 13:06:09
im not sure your got my point
for example i have row with a json column with this value [1,2,3,4,5,6,7,8]
i need to choose one of the items of that list in json randomly with sql query before fetching the data so keep my code clean

what are those numbers ?

ChildProcessError 2022-01-13 13:26:47
MasterZiv 2022-01-13 13:20:55
what are those numbers ?

its just an example

MasterZiv 2022-01-13 13:34:08
ChildProcessError 2022-01-13 13:26:47
its just an example

What are they in practice ?

MasterZiv 2022-01-13 13:35:03
ChildProcessError 2022-01-13 13:26:47
its just an example

anyway, study JSON functions and write an expression returning the needed value.

this is the docs

https://dev.mysql.com/doc/refman/8.0/en/json-search-functions.html#function_json-extract

Psychedello 2022-01-13 15:58:19
How to read from any row in a table…?

For example I have a table containing usernames and passwords and I should be able to read and validate if the username and password exist in the db… How can I do this..? Any help..

Psychedello 2022-01-13 15:59:14
Psychedello 2022-01-13 15:58:19
How to read from any row in a table…?

For example I have a table containing usernames and passwords and I should be able to read and validate if the username and password exist in the db… How can I do this..? Any help..

usr=$(mysql usrpwd -uroot -p**** -se “select username from usrpwd” )
pwd=$(mysql usrpwd -uroot -p**** -se “select password from usrpwd”)

This is the query I use currently but it only returns first row…

Psychedello 2022-01-13 15:59:22
What am I doing wrong..?
Khushi Hura 2022-01-13 15:59:25
Psychedello 2022-01-13 15:58:19
How to read from any row in a table…?

For example I have a table containing usernames and passwords and I should be able to read and validate if the username and password exist in the db… How can I do this..? Any help..

Where condition

Psychedello 2022-01-13 15:59:53
I’m beginner… Could you please help me with the query…?πŸ˜…
Psychedello 2022-01-13 16:00:26
I’m using this script inside a shell script..
Khushi Hura 2022-01-13 16:00:55
Psychedello 2022-01-13 15:58:19
How to read from any row in a table…?

For example I have a table containing usernames and passwords and I should be able to read and validate if the username and password exist in the db… How can I do this..? Any help..

Where username in table_name

Khushi Hura 2022-01-13 16:01:01
U must use in operator
MasterZiv 2022-01-13 16:01:26
Psychedello 2022-01-13 15:58:19
How to read from any row in a table…?

For example I have a table containing usernames and passwords and I should be able to read and validate if the username and password exist in the db… How can I do this..? Any help..

select …

Khushi Hura 2022-01-13 16:01:51
Ya select query with where condition and in operator
MasterZiv 2022-01-13 16:02:33
Psychedello 2022-01-13 15:58:19
How to read from any row in a table…?

For example I have a table containing usernames and passwords and I should be able to read and validate if the username and password exist in the db… How can I do this..? Any help..

it is done by writing a program doing that.

MasterZiv 2022-01-13 16:03:20
Psychedello 2022-01-13 15:59:53
I’m beginner… Could you please help me with the query…?πŸ˜…

If you are a beginner, go learn MySQL, don’t do things you can’t do

Psychedello 2022-01-13 16:03:37
Khushi Hura 2022-01-13 16:01:51
Ya select query with where condition and in operator

Can you help me with an example…?πŸ˜…

MasterZiv 2022-01-13 16:03:48
Psychedello 2022-01-13 15:59:14
usr=$(mysql usrpwd -uroot -p**** -se “select username from usrpwd” )
pwd=$(mysql usrpwd -uroot -p**** -se “select password from usrpwd”)

This is the query I use currently but it only returns first row…

things like this should not be done ever

Khushi Hura 2022-01-13 16:03:50
MasterZiv 2022-01-13 16:03:20
If you are a beginner, go learn MySQL, don’t do things you can’t do

This is correctπŸ‘

Psychedello 2022-01-13 16:03:57
MasterZiv 2022-01-13 16:03:20
If you are a beginner, go learn MySQL, don’t do things you can’t do

πŸ˜‚ that’s what I’m doing bruh ..

Khushi Hura 2022-01-13 16:04:03
U must learn concepts first
Khushi Hura 2022-01-13 16:04:08
Then go for practical
Psychedello 2022-01-13 16:04:36
Concepts are for someone who’s serious about this stuff…
Psychedello 2022-01-13 16:04:44
I’m just exploring things…
Khushi Hura 2022-01-13 16:05:07
If u r not serious u must not go for this
Because it requires a lot of interest
MasterZiv 2022-01-13 16:05:19
Psychedello 2022-01-13 15:58:19
How to read from any row in a table…?

For example I have a table containing usernames and passwords and I should be able to read and validate if the username and password exist in the db… How can I do this..? Any help..

Even more – I answered already this, how to do this, but you (if it was you, sorry if it was not) can’t do that.

Psychedello 2022-01-13 16:05:20
Hmm.. I guess so…
Psychedello 2022-01-13 16:06:01
Anyway thanks for your help…
MasterZiv 2022-01-13 16:06:52
MasterZiv 2022-01-10 11:14:06
You write a query over information schema tables which generates a set of SQL queries or a bash script (like in your case),
store the result as a file, and then run the generated file/script

this is it

MasterZiv 2022-01-13 16:07:11
Psychedello 2022-01-13 16:06:01
Anyway thanks for your help…

wasn’t you, excuse me

MasterZiv 2022-01-13 16:11:11
Although I ‘m not sure the question is about that.
$@ 2022-01-13 16:16:30
https://sqlize.online/sql/mssql2019/29d22708b099f62079666317327d3ef0/

*************SQLIZE.online
$@ 2022-01-13 16:16:43
Why it is showing error?
Khushi Hura 2022-01-13 16:17:30
Which line is showing error
|