Skip to content
Advertisement

What does .* (dot star) mean in SQL?

What does the .* mean in SQL?

I saw it in this query:

SELECT 
  socialmedia_kat_stundenvorlagen.*,
  socialmedia_zielgruppen.ziel_benutzer,
  socialmedia_zielgruppen.ziel_benutzergruppe,
  socialmedia_zielgruppen.ziel_dashboardgruppe
FROM 
  socialmedia_kat_stundenvorlagen 
  INNER JOIN socialmedia_zielgruppen 
    ON socialmedia_zielgruppen.socialmedia_stunden_ID = socialmedia_kat_stundenvorlagen.ID

Advertisement

Answer

The * means “all columns”.

Combined with the . and the prefix it means “all columns from the table/alias named”.

So in your case

SELECT socialmedia_kat_stundenvorlagen.*

means “select all columns from the socialmeda_kat_stundenvorlagen table”. You can do that so you get only the specific columns from that table, not all the columns from all the joined tables as well.

User contributions licensed under: CC BY-SA
8 People found this is helpful
Advertisement