Can we use SQL injection vulnerability to successfully obtain website database data?

|
smlkw 2022-05-31 16:30:39
It’s for people who can’t learn SQL syntax
smlkw 2022-05-31 16:32:25
mysql_en-21179.jpg

smlkw 2022-05-31 16:32:27
It’s fun
Alejandro 2022-05-31 16:41:54
Guys, another soft recommended as alternative to mysql workbench?
Swapnil 2022-05-31 17:00:27
Alejandro 2022-05-31 16:41:54
Guys, another soft recommended as alternative to mysql workbench?

Dbeaver

Kk R 2022-05-31 18:28:32
Hi team, Accenture is recruiting mysql admins
Kk R 2022-05-31 18:29:42
3 plus experienced folks can reach me on kumarreddy769504@gmail.com
Sachin Kansal 2022-05-31 19:27:41
Pls vote
Luis 2022-05-31 19:38:35
Alejandro 2022-05-31 16:41:54
Guys, another soft recommended as alternative to mysql workbench?

Heidi Sql

ChildProcessError 2022-05-31 20:05:43
anyway to get primary key before adding the row? 😀
smlkw 2022-05-31 20:09:06
ChildProcessError 2022-05-31 20:05:43
anyway to get primary key before adding the row? 😀

Last insert id + 1

Dude 2022-05-31 20:11:34
Alejandro 2022-05-31 16:41:54
Guys, another soft recommended as alternative to mysql workbench?

Datagrip. But it’s licensed

ChildProcessError 2022-05-31 20:19:44
smlkw 2022-05-31 20:09:06
Last insert id + 1

thats not a good idea
mybe someone delete the last added row

smlkw 2022-05-31 20:22:52
ChildProcessError 2022-05-31 20:19:44
thats not a good idea
mybe someone delete the last added row

For primary key you can use own field , just don’t use database auto increment mechanism and generate them using your app

Alejandro 2022-05-31 20:37:17
Thank you guys
svart 2022-05-31 21:18:33
ChildProcessError 2022-05-31 20:05:43
anyway to get primary key before adding the row? 😀

You’d better use autoinc columns. most likely You do not need to lock key in advance

bba223344 2022-06-01 09:32:09
Can we use SQL injection vulnerability to successfully obtain website database data?
smlkw 2022-06-01 12:26:42
bba223344 2022-06-01 09:32:09
Can we use SQL injection vulnerability to successfully obtain website database data?

Yes

Ramya9821 2022-06-01 14:23:55
Guys I just installed MySQL on my macOS monterey
Ramya9821 2022-06-01 14:25:54
In terminal bash profile I gave export PATH=${PATH}:/usr/local/mysql/bin/
Ramya9821 2022-06-01 14:26:15
I order to set the path
Ramya9821 2022-06-01 14:27:03
But when I gave mysql -u root -o
Ramya9821 2022-06-01 14:27:39
It’s showing

Zsh: command not found: mysql

Ramya9821 2022-06-01 14:27:48
Can anyone help me with this
Ramya9821 2022-06-01 14:30:42
Ramya9821 2022-06-01 14:27:03
But when I gave mysql -u root -o

Sorry -p

Liran 2022-06-01 14:38:18
What is the correct/better for modeling this —>
we have products in our store and for each product there are search words related. for example if the product is “Logitech keyboard” the search words can be “keyboard,computer,logitech…”
should i make a column containing all the search words as a text with comma between or to create a one to many table product_id + single_search_word?
bba223344 2022-06-01 15:26:43
smlkw 2022-06-01 12:26:42
Yes

contact you?

smlkw 2022-06-01 15:27:14
bba223344 2022-06-01 15:26:43
contact you?

Yes

bba223344 2022-06-01 15:30:56
smlkw 2022-06-01 15:27:14
Yes

friend you private message me

hgrgdagddsada 2022-06-01 15:52:55
mysql_en-21229.jpg
cant create order table, can anyone help me?
Swapnil 2022-06-01 16:10:07
hgrgdagddsada 2022-06-01 15:52:55
cant create order table, can anyone help me?

line no 21 after int place a comma ,

Swapnil 2022-06-01 16:10:52
https://www.w3schools.com/sql/sql_foreignkey.asp

SQL FOREIGN KEY ConstraintW3Schools
W3Schools offers free online tutorials, references and exercises in all the major languages of the web. Covering popular subjects like HTML, CSS, JavaScript, Python, SQL, Java, and many, many more.
Nandini Agarwal 2022-06-01 17:52:53
Hi All,
Can’t we create merge tables in mysql?
Nagarjun 2022-06-01 18:37:17
mysql_en-21234.jpg
SELECT salary,rank() over(order by salary desc) as rankn from EMPLOYEE

How can I get only rows with 2nd rank?
Does anyone know

Nagarjun 2022-06-01 18:37:51
Nandini Agarwal 2022-06-01 17:52:53
Hi All,
Can’t we create merge tables in mysql?

Do u mean joins?

|