Fron google only or any specific good site or video?

But it doesn’t work

Can you tell me why?

But if I do
SELECT * FROM (a NATURAL JOIN b) AS LIST LEFT JOIN C

It works

I forgot to insert the “,ON” clausle in the text but I’ve texted it into the DB

You have lost the join condition, ON phrase

Yes yes I forgot to inser it into the message

But I’ve inserted it into the DB

Probably this is because a subquery must have an alias

When you ask for help, show your error messages.

sorry for italian language

Don’t send photos

SELECT * FROM ((Luogo NATURAL JOIN Indirizzo) LEFT JOIN Recensione ON Luogo.ID = Recensione.Luogo_ID) AS LIST WHERE TipoLuogo=’Alloggio’ AND (Lista.Stato=’na’ OR Lista.Regione=’na’ OR Lista.Provincia=’na’ OR Lista.città=’na’);

this is the query

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘AS LIST WHERE TipoLuogo=’Alloggio’ AND (Lista.Stato=’na’ OR Lista.Regione=’na’ O’ at line 1

this the error

sorry for Italian text and for the photo I sent

Remove all ( and ), they are not needed

thank you! But it still doesn’t work

What is “lista” ?

An alias which should represent the table I’m trying to get

Should I translate the text? Maybe you can get better

You don’t have such an alias, do you?

No, doesn’t matter

I don’t, but I’m trying to use it, I don’t know how to explain ahah

Like
Select * from mytable AS ALIAS;

I don’t want to disturb you btw

SELECT *
FROM Luogo
NATURAL JOIN Indirizzo
LEFT JOIN Recensione AS LIST ON Luogo.ID = list .Luogo_ID WHERE TipoLuogo=’Alloggio’ AND (Lista.Stato=’na’ OR Lista.Regione=’na’ OR Lista.Provincia=’na’ OR Lista.città=’na’);

You don’t have a table named ‘lista’ in your query

Thank you you also used italian omg gonna try

It still doesn’t work and I don’t know why (I wanted to create an alias for the entire table I had) but I’ve resolved just by deleting the alias name and using standard table names

What’s diagnostics?

hi ….i want to learn MySQL dba…can anybody please help where should i start with?

You can start with MySQL architecture first.. then move on to administration of MySQL

Any documents on mysql architecture, if anyone have can you share it

It’s on the site. All is there.

input only date

Form a full, correct question, then you possibly be answered.

Don’t post pictures,if this is not strictly necessary

from current date i want to insert curdate,DAY,DAYNAME,DAYOFWEEK,MONTHNAME,MONTHNAME,MONTH,QUARTER,YEAR dynamically insert into table

use INSERT statement!

eg given 2009-01-01 and 2009-01-13 it would return a one column table with the values:

2009-01-01
2009-01-02
2009-01-03
2009-01-04
2009-01-05
2009-01-06
2009-01-07
2009-01-08
2009-01-09
2009-01-10
2009-01-11
2009-01-12
2009-01-13

i mean list all date between two dates

We don’t do your work instead of you.
We don’t write queries instead of you.
Do your job yourself or quit.

sry bro

Any one guide on Performance Tuning & Capacity Planning.

fron google only or any specific good site or video?

your server ram size

U shud directly go through MySQL offcial documentation .. anything u don’t understand ..Google it

ok..thanks