4 ms·

This is nice, but it's unfortunate that it starts off with commands specific to MySQL.

• tole42 8y ago
  i.e. "You may limit number of records using LIMIT keyword"
  • collyw 8y ago
    Postgres seems to use that as well.
    • petepete 8y ago
      Limit is the standard isn't it? Only Sybase/MSSQL Server use top x afaicr.
• arendtio 8y ago
  Is there an alternative (like a command to list all tables and which works on all DBMS)? I mean using a specific sqlite/oracle/tsql/... command wouldn't be any better.
  • michaelmior 8y ago
    No, there isn't. But I don't see the need to start with these commands anyway. Or if the OP really feels like that's a necessary starting point, it would be great to have an option in the future to select what DBMS you're using. I wasn't intending to bash the work, but sticking to a single DBMS really limits the utility of what seems like it could be very general resource.
    • arendtio 8y ago
      I like the idea of being able to select which dialect one wants to learn and maybe a table listing the most prominent differences (like LIMIT vs. TOP) at the end, would be nice too.
  • bdarnell 8y ago
    In theory `information_schema` is supposed to be universal, so you could do `select table_name from information_schema.tables`. However, getting useful information out of `information_schema` tends to require fairly complex queries and still has quirks and differences between databases.