![]() That said: While its appearance is far better than many "cross platform" DB solutions, it still doesn't feel like a "native" OS X app, and the overall navigation seems more cumbersome than it need be (for instance, one must open a separate "edit table" window, rather than simply editing a table in its current view). The price is reasonable, and the publisher is constantly improving the app with frequent free updates that continue to move it forward. I've purchased it and remain happy with it. This is a full-featured DB app, and it's one of the few that handles both MySQL and SQLite (among several others). RazorSQL has been tested with virtually all popular databases, and includes built-in driver support for Cassandra, DB2, Derby, DynamoDB, Firebird, FrontBase, Hive, HSQLDB, Informix, MongoDB, MySQL, OpenBase, Oracle, PostgreSQL, Redshift, Salesforce, SimpleDB, SQLite, SQL Azure, SQL Anywhere, SQL Server, Sybase, Teradata, and others. The SQL programming editor has syntax highlighting for SQL, PL/SQL, TransactSQL, SQL PL, and Java, automatic function/method lookup, automatic column lookup, key ahead, built-in and customizable templates, multi-tabular display of query results, query logging, and many other features including a tool to call stored procedures and a tool to compare table and/or query data. It even comes with a built-in relational database engine that requires no configuration. With RazorSQL, a SQL query tool, SQL editor, and database navigator, you can run SQL scripts, visually edit, create, alter, and view tables, import and export data, build queries with a query builder tool, and navigate databases with the database navigator. In other words, any foreign key field must agree with the primary key that is referenced by the foreign key.RazorSQL allows you to query, update, navigate, and manage all major databases from one database tool. Iii) Insert data into a specific table Referential Integrity A) a relational database concept, which states that table relationships must always be consistent. I) Remove privileges to a specific user or role, or to all users, to perform actions on database objects I) Give privileges to a specific user or role, or to all users, to perform actions on database objects WHERE CustomerName = 'Alfreds Futterkiste' ) Create Table A) Used to create a new tableĭ) Table will be automatically created after command is runĮ) Can copy an existing table into a new table using the SELECT statement with CREATEĬREATE TABLE table_name ) Drop Table A) Used to Delete all information in a Table as well as the Table itselfī) Complete loss of the table with no undoĬ) Can user TRUNCATE TABLE to delete data but not the table itselfĭROP TABLE table_name) Object Permissions A) Grant WHERE CustomerID = 1 ) Delete Statement A) Used to delete the existing records from a tableī) Either all the rows can be deleted, or a subset may be chosen using a conditionĬ) Use the WHERE clause to DELETE only specific records VALUES ) Update Statement A) Used to modify the existing records in a tableī) Either all the rows can be updated, or a subset may be chosen using a conditionĬ) Use the WHERE clause to UPDATE only specific records allows you to select rows that do not match a certain condition Logical Examples A) SELECT * FROM tbl_Population WHERE Statecode BETWEEN 100 AND 200ī) SELECT * FROM tbl_Population WHERE (StateCode > 100 AND StateCode ) Insert Statement A) Used to add new rows of data to a table in the databaseī) You do not need to specify the column(s) name in the SQL query if you are adding values for all the columns of the tableĬ) The order of the values is in the same order as the columns in the tableĭ) Can be used to populate the data into a table through the select statement over another table allows you to select rows that satisfy either of two conditions allows you to select only rows that satisfy two conditions allows you to select rows that contain no data in a given column allows you to select only rows within a certain range allows you to specify a list of values you'd like to include ![]() allows you to match similar values, instead of exact values ![]() can combine multiple operands if desired return a Boolean data type (true, false, unknown) Logical Operators - used to perform some conditional check and comparison check
0 Comments
Leave a Reply. |