Useful Snippets

Welcome!


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

RSS Latest posts from my personal blog


Most viewed posts


Subscribe to RSS feed


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.