Category: SQL Database, MySQL, Oracle, Sqlite, PostgreSQL, MS-SQL

How to use MySQL in Ubuntu 14.04 ?

Use MySQL The standard tool for interacting with MySQL is the mysql client, which installs with the mysql-server package. The MySQL client is accessed through a terminal. Root Login To log in to MySQL as the root user: mysql -u root -p When prompted, enter the root password you assigned when the mysql_secure_installationscript was run.You’ll then be presented with the..

Read more

What are some relational database systems that do not use SQL?

TurboIMAGE – A relational database that was installed on Hewlett Packards MPE operating system back in the 70’s / 80’s / 90s. All database access was done via an API rather than a query language. 3rd party products such as Cognos PowerHouse provided a SQL-like query language that in some (many?) ways was more sophisticated than SQL. Pick..

Read more

What is SQL and why is it important?

This will be a long answer, I’ll start with the basics: Database – Logical collection of data with some inherent meaning. DBMS – Collection of programs that helps the user to create and maintain a database. Database System – The database and the DBMS together are called the database system. Advantage of DBMS: Controlled Redundancy Restriction of unauthorized..

Read more

A MySQL foreign keys “drop table” and re-create table example

MySQL FAQ: How can I drop a series of database tables that have foreign keyrelationships between them? If you ever have a problem where you need to drop a series of MySQL database tables that have foreign key relationships between them, the key to doing this is setting the FOREIGN_KEY_CHECKS variable before and after your MySQL DROP..

Read more

MySQL syntax examples – create table, primary key, foreign key

Just a quick note here today that if you need some example MySQL database tables, you can use these. I created them for some experiments I ran last night. They show the MySQL create table, primary key, and foreign keysyntax: create table authors ( id int auto_increment not null primary key, first_name varchar(20), last_name varchar(20) ); create table..

Read more

MySQL: How to show the schema of a MySQL database table

MySQL table/schema FAQ: How do I show a database table schema in a MySQLdatabase? Short answer: To show the schema for a MySQL database table, use the MySQL desc command. You issue this command from the MySQL client command line prompt, like this: mysql> desc orders; A complete MySQL “show tables” example Longer answer: You need to log into your..

Read more