MYSQL-TOOLS

Comparison of graphical tools for MySQL

Home Articles

Mysql Articles, Using MySQL GUI Tools, MySQL Features



SmartSupp livechat

Print PDF

Hello all.

Best tool for live chat on your website!

Try for free!

 

Create SSH tunnel for MySQL connections

Print PDF
User Rating: / 72
PoorBest 

Today we consider the organization of SSH tunneling through PUTTY to MySQL.

Some programs require a connection to the database MySQL. For example mysql.exe console or other tools to work with databases of online stores or websites.

Very often, in the application, which requires a connection to the database MySQL, there are only 5 fields:

  • Host
  • Port
  • Login
  • Password
  • Database

Some hosting providers allow direct access to the databases from outside, but others provide access to MySQL only through SSH protocol.

To build a SSH tunnel from your local machine to the database on the hosting, we recommend using PuTTY.

Next, write out step by step process.

 

Using MySQL views

Print PDF
User Rating: / 455
PoorBest 
MySQL Views using
  • Advantages and restrictions of using views
  • Creating, altering and dropping views
  • Algorithms of views
  • Setting security configuration, SQL SECURITY and DEFINER properties
  • Updatable views
  • View metadata

 

view – is a database object based on a SELECT query that has tables or other views specified inside it. In other words, this is a named query that is stored in a database as a separate object. Unlike a table, a view is not a data storage.

When referring to a view, we just receive data that is returned by the internal SELECT query.

 

Use of a DELIMITER in MySQL

Print PDF
User Rating: / 336
PoorBest 

delimiter mysql

Depending on the nature of the script, you may need control of the delimiter used to separate the statements that will make up a script. The most common example of this is where you have a multi-statement stored routine as part of your script. In this case if the default delimiter of ; is used you will get an error when you attempt to execute the script.

 

The DELIMITER command is used to change the standard delimiter of MySQL commands. The standard command delimiter is the ';' character that defines the end of the query.

Script for example:

INSERT INTO actor VALUES (1, 'PENELOPE', 'GUINESS', '2006-02-15 04:34:33');
INSERT INTO actor VALUES (2, 'NICK', 'WAHLBERG', '2006-02-15 04:34:33');
INSERT INTO actor VALUES (3, 'ED', 'CHASE', '2006-02-15 04:34:33');
INSERT INTO actor VALUES (4, 'JENNIFER', 'DAVIS', '2006-02-15 04:34:33');
INSERT INTO actor VALUES (5, 'JOHNNY', 'LOLLOBRIGIDA', '2006-02-15 04:34:33');

 

Now let’s have a look at the following script. It consists of several INSERT queries, procedure creating and several more INSERT queries.

 

How to: convert or migrate Access to MySQL

User Rating: / 213
PoorBest 

Have a Access database about 50 tables, you must convert them to MySQL, how to do this? By what means?

To migrate from an Access database to MySQL we will be using a good program called DBSync. DBSync has a feature that allows us to directly import data from Access databases.

 

 

Here's how to convert Access data to MySQL:

Convert databases from MS Access to MySQL rapidly and reliably! Operate with a whole database or select only needed tables, fields, indexes and foreign keys to proceed!

 
  • «
  •  Start 
  •  Prev 
  •  1 
  •  2 
  •  3 
  •  4 
  •  Next 
  •  End 
  • »


Page 1 of 4
mysql tools