MySQL

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849
Across
  1. 2. A command to create a new database in MySQL.Answer: CREATE DATABASE
  2. 3. A clause to join multiple tables in a query.
  3. 6. A function to calculate the sum of values in a column.
  4. 9. A command to update data in a table.
  5. 10. A query language for managing and retrieving data from a database.
  6. 13. A keyword used to sort results in ascending order.
  7. 14. A keyword to select distinct values from a column.
  8. 15. A tool used to back up and restore MySQL databases.
  9. 18. A function to count the number of rows in a table.
  10. 20. A join type to retrieve records with matching values in both tables.
  11. 21. A tool to manage user privileges in MySQL.
  12. 26. A function to find the maximum value in a column.
  13. 27. A command to create a new table in MySQL.
  14. 33. A statement to grant permissions to a user.
  15. 35. A keyword to specify a table alias in a query.
  16. 36. A keyword used to insert data into a table.
  17. 39. A command to connect to a MySQL database.
  18. 40. A command to retrieve data from a table.
  19. 41. A command to add a new column to an existing table.
  20. 45. A unique identifier for each row in a table.
  21. 46. A clause used to filter rows in a SELECT statement.
  22. 47. A statement used to modify the structure of a table.
  23. 48. A keyword to remove a table from a database.
  24. 49. A database object used to ensure referential integrity.
Down
  1. 1. A statement to revoke permissions from a user.
  2. 4. A statement to delete a database.
  3. 5. A command to create an index on a table.
  4. 7. A storage engine that supports full-text search in MySQL.
  5. 8. A MySQL storage engine known for its speed and performance.
  6. 11. A keyword used to limit the number of rows returned in a query.
  7. 12. A command to display the structure of a table.
  8. 16. A data type for storing date and time values.
  9. 17. A keyword to perform a case-insensitive search in SQL.
  10. 19. A software program used to manage and interact with MySQL databases.
  11. 22. A command to truncate a table.
  12. 23. A keyword to filter results by a range of values.
  13. 24. A clause to specify conditions for grouping rows.
  14. 25. A command to delete data from a table.
  15. 28. A statement to rename a table.
  16. 29. A function to calculate the average value in a column.
  17. 30. A command to change the values in a table column.
  18. 31. A database structure that stores data in rows and columns.
  19. 32. A function to find the minimum value in a column.
  20. 34. A keyword used to remove duplicate rows from a result set.
  21. 37. A keyword used to sort results in descending order.
  22. 38. A clause to group rows based on a column's values.
  23. 42. A database object that enforces data integrity rules.
  24. 43. A keyword to specify conditions for searching.
  25. 44. A clause to sort results based on multiple columns.