Share this:

Like this:

I use InnoDB storage engine in my projects because of its support for transactions and referral integrity rules. However, MySQL still creates new tables as MyISAM by default. It was so annoying for me to always define storage engine when creating new tables and double check that I didn’t forget it until I found how I can set InnoDB as default.

Share this:

Like this:

1.) phpMyAdminphpMyAdmin is a free software tool written in PHP intended to handle the administration of MySQL over the World Wide Web. phpMyAdmin supports a wide range of operations with MySQL. The most frequently used operations are supported by the user interface (managing databases, tables, fields, relations, indexes, users, permissions, etc), while you still have the ability to directly execute any SQL statement. http://www.phpmyadmin.net/home_page/2.) AdminerAdminer (formerly phpMinAdmin) is a full-featured MySQL management tool written in PHP. Conversely to phpMyAdmin, it consist of a single file ready to deploy to the target server.http://www.adminer.org/3.) MySQL WorkbenchMySQL Workbench is a unified visual tool for database architects, developers, and DBAs. MySQL Workbench provides data modeling, SQL development, and comprehensive administration tools for server configuration, user administration, and much more. MySQL Workbench is available on Windows, Linux and Mac OS.

HeidiSQL is an easy-to-use interface and a “working-horse” for web-developers using the popular MySQL-Database. It allows you to manage and browse your databases and tables from an intuitive Windows® interface.

5.) Navicat well-designed (GUI), Navicat for MySQL

Navicat for MySQL is a powerful Database administration and development tool for MySQL. It works with any MySQL Database Server from version 3.21 or above, and supports most of the latest MySQL features including Trigger, Stored Procedure, Function, Event, View, and Manage User, etc.

EMS SQL Manager for MySQL is a high performance tool for MySQL database administration and development. It works with any MySQL versions from 3.23 to the newest one and supports all of the latest features including MySQL triggers, views, stored procedures and functions, InnoDB foreign keys, Unicode data and so on. SQL Manager for MySQL allows you to create/edit all MySQL database objects, design MySQL databases visually, run SQL scripts, import and export MySQL database data, manage MySQL users and their privileges and has many other useful features for efficient MySQL administration. SQL Manager for MySQL has a state-of-the-art graphical user interface with well-described wizard system, so clear in use that even a newbie will not be confused

SQLyog MySQL GUI is the most powerful MySQL manager and admin tool, combining the features of MySQL Query Browser, Administrator, phpMyAdmin and other MySQL Front Ends and MySQL GUI tools in a single intuitive interface.

Share this:

Like this:

What You Need

SQL (Structured Query Language) is a language designed for interacting with relational database management systems (RDBMS), like MySQL, Oracle, Sqlite etc… To perform the SQL queries in this article, I suggest that you have MySQL installed. I also recommend phpMyAdmin as a visual interface to MySQL.

The following applications make it very easy to install both MySQL and phpMyAdmin on your local machine:

We are going to use command line for queries. WAMP already comes with a MySQL Console. For MAMP, you may want to read this article.

If you would like to follow the examples in this article on your own development server, do the following:

Open MySQL Console and login.

If you haven’t already, create a database named “my_first_db” with a CREATE query.

Switch to the database with the USE statement.

When creating a database, common sense dictates that we use separate tables for different types of entities. Some examples are: customers, orders, items, messages etc… But we also need to have relationships between these tables. For instance, customers make orders, and orders contain items. These relationships need to be represented in the database. Also, when fetching data with SQL, we need to use certain types of JOIN queries to get what we need.

There are several types of database relationships. Today we are going to cover the following:

One to One Relationships

One to Many and Many to One Relationships

Many to Many Relationships

Self Referencing Relationships

When selecting data from multiple tables with relationships, we will be using the JOIN query. There are several types of JOIN’s, and we are going to learn about the the following:

Developers love to automate things—for every process between development and production, they are keen to have a script that makes their workflow easier. This is also the case with deployment. The process of pushing the final build and deploying the app should be as easy as pressing a Deploy now button, but that is not what happens most of the time. We end u […]

Storing your app's data in the cloud is very important these days because users tend to own multiple devices and want their apps to be in sync across all of them. With Cloud Firestore, a real-time NoSQL database available on the Firebase platform, doing so is easier and more secure than ever before.In an earlier tutorial, I introduced you to all the pow […]

We started this series by learning how to animate HTML elements using mojs. In the second tutorial, we moved on to animation of built-in SVG shapes using the Shape module. The third tutorial covered more ways of animating SVG shapes using the ShapeSwirl and stagger modules.Now, we will learn how to animate different SVG shapes in a burst formation using the […]

This tutorial will give an introduction to JSON Web Tokens (JWT) and how to implement JWT authentication in Django.What Is JWT? JWT is an encoded JSON string that is passed in headers to authenticate requests. It is usually obtained by hashing JSON data with a secret key. This means that the server doesn't need to query the database every time to retrie […]

In this post, you'll learn what ExpoKit is and how it is used for adding native functionality to Expo apps. You'll also learn some of its pros and cons. In my Easier React Native Development With Expo post, you learned about how Expo makes it easier for beginners to begin creating apps with React Native. You also learned that Expo allows developers […]

What You'll Be CreatingIntroduction A lot of articles, our site included, have focused on helping readers create amazing iOS apps by designing a great mobile user experience (UX). However, with the emergence of the Apple Watch a few years ago, alongside CarKit, and more recently the HomePod this year, we are starting to see a lot more apps and IoT appli […]

If you're ready to take your WordPress skills to the next level and get your feet wet with PHP, you'll love our newly expanded course, Learn PHP for WordPress.What You’ll LearnIn this course, Envato Tuts+ instructor Rachel McCollin will give you an overview of what PHP is and how it's used for WordPress themes and plugins, with examples. You […]

Application widgets provide your users with easy access to your application’s most frequently used features, while giving your app a presence on the user’s homescreen. By adding a widget to your project, you can provide a better user experience, while encouraging users to remain engaged with your application, as every single time they glance at their homescr […]

It wasn't very many years ago when everyone was trying to make a quick buck on a blog. Fast-forward just a few years, and the entire scene has changed radically.Selling advertising on a website isn't as easy as it once was. The "Golden Age of Blogging" has certainly passed, but that doesn't mean monetization has come to an end. It si […]

OverviewThis is part two out of two in a series on cleaning up data using Go. In part one, we covered the basic text facilities of Go and working with CSV files. In this tutorial, we'll dive into actual data cleaning. We'll start by understanding the problem of messy data and coming up with a strategy, and then we'll look into verifying indivi […]

Here’s wishing all of you a very happy and prosperous new year. I’ve been writing rather infrequently in 2009 and thats likely to continue into the first couple of months in 2010. I’m going to be in Ahmedabad around 15-20 th Jan. If anyone wants to meetup, drop me an email. CommentsJanuary 4, 2010, Rama [...]

VoiceTap is a Noida based startup that hopes to connect knowledge seekers with knowledge experts. As the fast-food content on the Internet grows, its becoming more and more difficult to search for relevant, precise, authoritative answers to your questions on Google. VoiceTap hopes to make it easier for those seeking answers to questions to connect [...]

MumbaiTrader is a new startup, offering social investing tips to Indians. The site brings together a network of pre-screened and verified advisors, who will offer their services to investors. Each advisor is ranked and investors can opt to follow an adivsor based on their rating and track record. This Covestor like model has been implemented [...]

Vikas Bajaj has a story on NYT about India’s slow pace of innovation. Nothing new and nothing most of you all didnt know already. Even the ubiquitous Sujai Karampuri gets a mention as is normally the case on stories based on this theme (no offense to Sujai – I love his blog and admire how [...]

Since August, Rediff has lost four key executives - – Long time product head – Zaki Ansari – who quit in August to join UTV New Media – India Abroad editorial director Prem Panicker quit to join Yahoo India – CFO Joy Basu left in August – Most recently, Salil Chandrashekar, director of product development [...]

I recently uncovered an incident where Burrp seems to have deleted a user review. Nishith, founder of Pune based True Sparrow Systems (team behind SocialMedian – acquired by Xing), wrote a review for a Pune based burger joint, which he tweets was deleted by Burrp. While I havent seen this as frequently occurring scenario, I [...]

I’m looking for some data entry work to be done — can you recommend a reliable service provider if you’ve used one ? Leave a comment or drop me an email – contact [at]startupdunia[dot]com. CommentsDecember 8, 2009, Neelabh Prabhat commented: Hi, We have started a rural BPO in collaboration with the CSR arm of Usha [...]

Overall Learnings There is no problem, i.e., (1) there are not enough good problems that startups are working on (2) there seems to be no shortage of funds, platforms and ecosystem partners willing to help startups, there are not enough good startups for them to support. The ecosystem is hungry for successes. It was a [...]

VCCircle reports that Infy co-founder, NR Narayana Murthy, has sold $37 million worth of Infy shares to setup a VC fund. Proceeds from the sale will be used as seed capital for the fund. That is great news. He has amazing street cred and is definitely viewed as an entrepreneurial icon who grew Infy to [...]

Although I’ve been tempted to own an iPhone since the day it launched, I’d held off doing so because AT&T is the sole carrier in the US and frankly – AT&T simply sucks. However, I finally caved in and got myself one a couple of weeks ago. First and foremost – there’s no denying that [...]

Ofgem, the U.K. government’s regulator for gas and electricity, has revealed that projects trialled under the Low Carbon Networks Fund (LCNF) could save 215 tonnes of CO2. The program ran for six years, ending in 2015, with the aim of helping Distribution Network Operators (DNOs) develop cost effective and energy efficient solutions for the smart... Read mor […]

The Internet of Things is sweeping across the globe at breakneck speeds, and before we know it, our entire lives will be facilitated by connected technology. We’re already seeing the IoT make an incredible impact on how the industrial world operates, and we’re seeing it seep into household goods to bring convenience and efficiency to... Read more » The post […]

PARC, the research and development arm of Xerox, announced on Tuesday that it has secured part of $19 million in federal funding from the Energy Department to develop peel-and-stick sensors for homes, businesses, and other buildings. The peel-and-stick sensors will be able to detect air quality, temperature, humidity, occupancy, and more, according to PARC. […]

Studies of traffic congestion regularly point much blame at cars circling for parking. To tackle this perennial problem, Get My Parking is joining a smart city initiative to launch a smart parking pilot in India. As reported in Firstpost, the Delhi-based startup’s technology is being tested in government smart city initiatives. “We are getting a... Read more […]

According to a recent Gartner survey, almost a third of fitness tracker or smartwatch owners end up ditching them. The survey studied about 9,000 users from the U.S., Australia and the U.K. Reasons for the dropped tech use vary from wearables breaking, to just becoming bored of them. “Dropout from device usage is a serious... Read more » The post Do fitness […]

An increasing number of farm fires are being caused by electrical arc faults, a high-power discharge of electricity between two or more conductors. Nare IoT Labs, a South Korean startup, has developed a cost effective solution to prevent and warn farmers of any faults, before the fire starts. The system, called “Prevention System for Electrical... Read more […]

A new report says Google has spun out its self-driving unit — now called Waymo — and is undertaking a major pivot away from making its own autonomous vehicles, instead moving to become a provider of self-driving car tech for major automakers. These Google car revelations revealed in a lengthy report on tech site The... Read more » The post Google’s Waymo to […]

Scotland’s seven major cities are teaming up to develop a number of smart city projects, backed by a $31 million war chest. According to Scottish Construction Now, the seven cities will springboard off the funding to collaboratively develop themselves into future-capable digital hubs. See also: Outdated thinking on wireless could doom UK smart cities The... […]

With trends like ride sharing, autonomous vehicles, and the connected car, the auto industry is increasingly in the spotlight. As drivers contemplate letting computers take over control of the wheel for them, it brings up some important questions. What will cars of the future look like? What things will drivers be able to accomplish on... Read more » The pos […]

Several months ago, CCS Insight surveyed 2,000 people in the US and UK about what they would most like to have tracked about themselves, and a large portion of them answered with, “stress levels.” It looks as though their requests are being answered. Mental health is a big focus in the tech industry right now.... Read more » The post Tech world aims to tack […]