Category: Database – Desktop, SQL, NoSQL

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

What is Elasticsearch?

Elasticsearch is the most popular, open-source, cross-platform, distributed and scalable search-engine based on Lucene. It is written in Java and released under the terms of the Apache License. Elasticsearch is developed alongside Logstash and Kibana. Logstash is a data-collection and log-parsing engine while Kibana is an analytics and visualization platform. The three products combined are referred to as the Elastic Stack (formerly known as the ELK stack). They are..

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