How do I create a table alias in MySQL

by

Off the top of my head

CREATE VIEW dbo_customers AS
SELECT * FROM customers

Maybe not the best solution but should work as the view is updatable. Will definitely work for Read Only

More Related Contents:

  1. How to simulate UNPIVOT in Access?
  2. Emulate MySQL LIMIT clause in Microsoft SQL Server 2000
  3. Stored Procedure with optional “WHERE” parameters
  4. is there a group_concat function in ms-access?
  5. update columns values with column of another table based on condition [duplicate]
  6. How do I list all the columns in a table?
  7. Editing Record issues in Access / SQL (Write Conflict)
  8. What’s the correct name for an “association table” (a many-to-many relationship) [closed]
  9. select yesterday date in where condition
  10. SQL Server dynamic PIVOT query?
  11. Natural Sort in MySQL
  12. MySQL get row position in ORDER BY
  13. SQL Server Process Queue Race Condition
  14. SQL Server 2005 Pivot on Unknown Number of Columns
  15. Is there a LastIndexOf in SQL Server?
  16. Get all table names of a particular database by SQL query?
  17. SQL Server Convert Varchar to Datetime
  18. OPTION (RECOMPILE) is Always Faster; Why?
  19. How to set variable from a SQL query?
  20. Case in Select Statement
  21. Remove duplicates using only a MySQL query?
  22. How do I implement pagination in SQL for MS Access?
  23. Split function in SQL Server 2008
  24. Remove numbers from string sql server
  25. T-SQL How to create tables dynamically in stored procedures?
  26. What is the equivalent of ‘describe table’ in SQL Server?
  27. How can I group by date time column without taking time into consideration
  28. SQL Server: Find out default value of a column with a query
  29. Script entire database SQL-Server
  30. sql pulling a row for next or previous row of a current row

Leave a Comment