Am I correct in noting that if table relationships are set up correctly, INNER JOIN and LEFT JOIN are essentially the same?

|
MasterZiv 2019-12-30 17:36:44
notpeepeepoopoo 2019-12-30 17:36:03
Free understanding MySQL?

Yes, but i;m not sure about “free”

MasterZiv 2019-12-30 17:37:40
notpeepeepoopoo 2019-12-30 17:36:03
Free understanding MySQL?

MARTIN GRUBER Understanding SQL

notpeepeepoopoo 2019-12-30 17:37:42
Oh sorry, that was from the search result
notpeepeepoopoo 2019-12-30 17:37:48
MasterZiv 2019-12-30 17:37:40
MARTIN GRUBER Understanding SQL

Thanks santa

MasterZiv 2019-12-30 19:39:27
Frds I need master to master replication documentation
sixpeteunder 2019-12-30 19:46:22
Here’s a stupid question/observation. Am I correct in noting that if table relationships are set up correctly, INNER JOIN and LEFT JOIN are essentially the same?
sixpeteunder 2019-12-30 19:49:50
This is my reasoning:
If foreign keys are set up correctly, mysql will reject entries that do not reference a valid member of the “foreign” table. Therefore, it is guaranteed that every foreign key on table “B” is present as a primary key on table “A”.
piterden 2019-12-30 20:16:59
notpeepeepoopoo 2019-12-30 13:01:52
The schema is this

codephoto.ru

Manogna 2019-12-30 20:30:50
What is SQL injection used for?
Manogna 2019-12-30 20:31:00
In which cases we use it?
piterden 2019-12-30 20:34:04
Manogna 2019-12-30 20:30:50
What is SQL injection used for?

For hacking

Manogna 2019-12-30 20:48:50
What is the query to remove hyphen in a column?
Manogna 2019-12-30 20:49:29
And it should not present if we fetch after replacing
Manogna 2019-12-30 20:53:50
Anyone please help me…
MasterZiv 2019-12-30 21:36:38
sixpeteunder 2019-12-30 19:46:22
Here’s a stupid question/observation. Am I correct in noting that if table relationships are set up correctly, INNER JOIN and LEFT JOIN are essentially the same?

No, your are not correct

MasterZiv 2019-12-30 21:37:23
sixpeteunder 2019-12-30 19:49:50
This is my reasoning:
If foreign keys are set up correctly, mysql will reject entries that do not reference a valid member of the “foreign” table. Therefore, it is guaranteed that every foreign key on table “B” is present as a primary key on table “A”.

This is true, but this has nothing to do with joins

MasterZiv 2019-12-30 21:38:20
Manogna 2019-12-30 20:30:50
What is SQL injection used for?

For hacking into your DB and stealing or erasing your data

MasterZiv 2019-12-30 21:38:40
Manogna 2019-12-30 20:48:50
What is the query to remove hyphen in a column?

Update

Manogna 2019-12-31 05:23:16
MasterZiv 2019-12-30 21:38:20
For hacking into your DB and stealing or erasing your data

Ok

Manogna 2019-12-31 05:24:16
MasterZiv 2019-12-30 21:38:40
Update

I have used the update
But if I fetch after updating , hyphen is coming

piterden 2019-12-31 05:26:03
Manogna 2019-12-31 05:24:16
I have used the update
But if I fetch after updating , hyphen is coming

What do you mean. Can you show?

Manogna 2019-12-31 07:09:15
piterden 2019-12-31 05:26:03
What do you mean. Can you show?

mysql_en-1279.jpg

Manogna 2019-12-31 07:09:43
mysql_en-1280.jpg

piterden 2019-12-31 07:11:33
What is the type of that column?
Manogna 2019-12-31 07:11:55
Date
piterden 2019-12-31 07:13:20
There are not any hyphens there
Manogna 2019-12-31 07:13:48
mysql_en-1284.jpg

piterden 2019-12-31 07:14:35
I see. It’s just output
piterden 2019-12-31 07:14:51
Actually there are not hyphens
Manogna 2019-12-31 07:15:58
mysql_en-1287.jpg
I want to store this permanently
Manogna 2019-12-31 07:16:47
If I you select replace ..
It’s coming…
But if I fetch the table it’s showing “-”
Manogna 2019-12-31 07:17:00
If I use*
piterden 2019-12-31 07:18:48
DATE_FORMAT(CURDATE(), ‘%m/%d/%Y’)
Manogna 2019-12-31 07:19:59
Ya that I know…
But I just want to practice removing hyphens …
So I had this column which has hypehns
So I’m practicing with that
piterden 2019-12-31 07:22:20
You can’t delete them from that data type
Manogna 2019-12-31 07:23:00
Oh!!!
Ok thank you
piterden 2019-12-31 07:54:32
Was I correct in explanation?
MasterZiv 2019-12-31 07:55:30
piterden 2019-12-31 07:54:32
Was I correct in explanation?

Sure!

MasterZiv 2019-12-31 08:00:09
Manogna 2019-12-31 07:19:59
Ya that I know…
But I just want to practice removing hyphens …
So I had this column which has hypehns
So I’m practicing with that

These hythen are printed by the client while fetching and showering your result set.
They are part of date format by means of witch you’re shown the dates. And these hythens have no meaning for the data itself.

TheQuotidian 2019-12-31 08:05:44
piterden 2019-12-31 07:14:51
Actually there are not hyphens

It’s YYYYMMDD, getting represented with hyphens

Manogna 2019-12-31 09:27:53
MasterZiv 2019-12-31 08:00:09
These hythen are printed by the client while fetching and showering your result set.
They are part of date format by means of witch you’re shown the dates. And these hythens have no meaning for the data itself.

Ok

Manogna 2019-12-31 09:36:07
There is a student table having students admission info for one yr

I want students info who has joined last sunday’s of every month .

Manogna 2019-12-31 09:36:26
What is the query for that?
piterden 2019-12-31 09:38:24
You should know it better, cause it’s your DB
MasterZiv 2019-12-31 10:12:46
Manogna 2019-12-31 09:36:26
What is the query for that?

It is SELECT !

Manogna 2019-12-31 10:14:28
Whole query
Manogna 2019-12-31 10:14:37
Complete query I need to know
Manogna 2019-12-31 10:15:19
How to select last sunday’s of every month
MasterZiv 2019-12-31 10:38:04
#books

Books on DB and SQL you can find here

@dbbooks

Gaurav 2019-12-31 15:25:34
can we create a table in mysql without using create keyword??
|