MyJgui logoCross-platform graphical MySql client/front-end

How to create user in mysql (simple example)

Create user :

This is simple example, how to create user in msyql database and provide privileges to work with specified database.

Read more: How to create user in mysql (simple example)

Update command syntax

Update syntax introduction:

    Update command alters the data contained in the table. It can change multiple columns at once and use multiple conditions. 

 

Read more: Update command syntax

Select syntax

Select syntax introduction:

    Select command is used to acquire and return data from certain table. In this intro I will describe only the most elementary select statements and modifiers.

Select syntax is very self explanatory, but you must respect positiong of all modificators (where, limit, order by, etc). When I explain the details of using a modifier I always mention the positioning of the parameter within the query.

Read more: Select syntax

Insert command syntax

Insert syntax introduction

    Insert command is used to insert data into a table. There are three basic syntax options how to write these queries. 

Read more: Insert command syntax