0

I've seen few posts here saying I can do hierarchical queries using mysql.

I've not used PostgreSQL, yet. If I change to PostgreSQL, do I have to change a lot of syntax or can I do that hierarchical stuff in MySQL itself?

Hierarchical queries in MySQL

What sender sends is Facebook invite so can I do this in SQL?

Community
  • 1
  • 1
  • @Jeff Atwood:I've not got an proper answer to the above question. –  Nov 13 '11 at 11:14
  • What kind of hierarchical queries are you doing in MySQL? Please, be more specific in what you want to achieve. There are many ways of represening and querying hierarchical data in SQL. Postgres supplies many of them... – filiprem Nov 13 '11 at 17:51

1 Answers1

1

MySQL doesn't have recursive queries, databases like PostgreSQL, SQL Server and Oracle do have these types of queries. Very powerful and easy to use, but in MySQL you're on your own.

You could use a work around like a nested set, works in almost any database but is not as fast.

Frank Heikens
  • 117,544
  • 24
  • 142
  • 135