Useful Snippets

Useful Snippets


This blog is used to collect useful snippets related to Linux, PHP, MySQL and more. Feel free to post comments with improvements or questions!

September 2020
M T W T F S S
 123456
78910111213
14151617181920
21222324252627
282930  

Categories


MySQL general usage snippets – connecting, listing, creating and deleting databases

Stanislav KhromovStanislav Khromov

Connect to mysql server

mysql -h localhost -u root -p

List databases

show databases;

Create a database

create database mydb;

Delete a database

drop database mydb;

Select a working database

use mydb;

Show all tables in database

show tables;

See table structure

describe table_name;

Show all rows in a table

SELECT * FROM table_name;

Get 30 results, order by id column (last in first)

SELECT * FROM table_name ORDER BY id DESC LIMIT 30;

Select row by value of a column

SELECT * FROM table_name WHERE table_field = 'meatballs';

Web Developer at Aftonbladet (Schibsted Media Group)
Any opinions on this blog are my own and do not reflect the views of my employer.
LinkedIn
Twitter
WordPress.org Profile
Visit my other blog

Comments 0
There are currently no comments.