MySQL Basics

[Jackbox]

Whether you are working with MySQL or MariaDB, this is going to probably work perfectly well for you. This is a cheat sheet I have decided to make for database navigation/viewing while developing or testing.

Before we get started I would like to stress that using a GUI is possible and many people do that, this tutorial covers executing queries. You can even use a web interface: Adminer, phpMyAdmin, Navicat, SequelPro (Mac), HeidiSQL

Requirements: You must have MySQL or MariaDB installed on your operating system. Listed are some install guides.

• Debian 7
• CentOS 7
• Windows
• Mac OS X

First, let's go ahead and open SSH (get in a terminal).

mysql -p

Authenticate with your password.

1. show databases;
   
2. use fun;
3. show tables;
   
4. select * from users;

Before I dox myself how about I take out some information, eh?

update fun.users set name = 'nobody' where id > 0;

Notice the structure of the above query is: UPDATE databaseName.tableName SET columnName = 'content' where id > 0;

select id, name from users;

What about generating random integers to write atop emails?



I plan on continuing this. If anyone has requests or ideas for the cheat sheet definitely toss 'em in here.

 

[AlexTomson]

I'd also like to add one more really helpful tool to your GUI list - dbForge Studio for MySQL. In my experiens it is the easiest one and has a lot of great automation features.

 

[mumude]

Whether you are working with MySQL or MariaDB, this is going to probably work perfectly well for you. This is a cheat sheet I have decided to make for database navigation/viewing while developing or testing.

Before we get started I would like to stress that using a GUI is possible and many people do that, this tutorial covers executing queries. You can even use a web interface: Adminer, phpMyAdmin, Navicat, SequelPro (Mac), HeidiSQL

Requirements: You must have MySQL or MariaDB installed on your operating system. Listed are some install guides.

• Debian 7
• CentOS 7
• Windows
• Mac OS X

First, let's go ahead and open SSH (get in a terminal).

mysql -p

Authenticate with your password.

1. show databases;
   View attachment 360
2. use fun;
3. show tables;
   View attachment 361
4. select * from users;

Before I dox myself how about I take out some information, eh?

update fun.users set name = 'nobody' where id > 0;

Notice the structure of the above query is: UPDATE databaseName.tableName SET columnName = 'content' where id > 0;

select id, name from users;

View attachment 362

What about generating random integers to write atop emails?

View attachment 363

I plan on continuing this. If anyone has requests or ideas for the cheat sheet definitely toss 'em in here.

I am new could possibly learn from you

 

[riyuko]

I don't see too much content in here and it seems very useless.

You better off using https://devhints.io/mysql