MySQL basics - Revision history

Paul: added sql dump command example

2021-10-08T14:54:34Z

added sql dump command example

← Older revision		Revision as of 09:54, 8 October 2021
Line 23:		Line 23:

	Alternatively, you can use <code>mysql -u root -p</code> then enter password at prompt.		Alternatively, you can use <code>mysql -u root -p</code> then enter password at prompt.

			Perform SQL dump from CLI

			<code>mysqldump -u username -ppassword -h hostname databasename > filename.sql</code>

	=== Using MySQL Client Programs ===		=== Using MySQL Client Programs ===

2013-08-07T15:31:39Z

Inserting data into a table

← Older revision		Revision as of 10:31, 7 August 2013
Line 98:		Line 98:
	Two formats:		Two formats:

			<pre>
	INSERT INTO table_name SET		INSERT INTO table_name SET

Line 114:		Line 114:
	-> (columnName1, columnName2, etc...)		-> (columnName1, columnName2, etc...)
	-> VALUES (value1, value2, etc...);		-> VALUES (value1, value2, etc...);
			</pre>

	Table Commands		Table Commands
			<pre>
	mysql>CREATE TABLE table_name ( column1_name column1_type column1_details,		mysql>CREATE TABLE table_name ( column1_name column1_type column1_details,
	-> column2_name column2_type column2_details, ... );		-> column2_name column2_type column2_details, ... );
Line 135:		Line 135:

	mysql>DELETE FROM table_name WHERE conditions;		mysql>DELETE FROM table_name WHERE conditions;
			</pre>

	== Viewing stored data ==		== Viewing stored data ==

2013-05-01T17:32:19Z

Basic Commands

← Older revision		Revision as of 12:32, 1 May 2013
Line 38:		Line 38:

	Type <code>exit</code> or <code>quit</code> and press Enter anytime you want to exit. These commands do not require a semicolon.		Type <code>exit</code> or <code>quit</code> and press Enter anytime you want to exit. These commands do not require a semicolon.

			<code>show table status;</code>

	<code>show databases;</code>		<code>show databases;</code>

2011-11-06T21:27:00Z

← Older revision		Revision as of 16:27, 6 November 2011
Line 241:		Line 241:
	mysql> update user set password=PASSWORD("newpassword") where User='root';		mysql> update user set password=PASSWORD("newpassword") where User='root';
	Query OK, 1 row affected (0.00 sec)		Query OK, 1 row affected (0.00 sec)
	Rows matched: 1 Changed: 1 Warnings: 0</pre>		Rows matched: 1 Changed: 1 Warnings: 0

			mysql></pre>

			== Set operations ==

			[http://en.wikipedia.org/wiki/Set_operations_%28SQL%29 Set Operations]


	~~mysql>~~

	<center>[[MySQL \| To MySQL]]</center>		<center>[[MySQL \| To MySQL]]</center>

2010-11-15T20:06:43Z

Locking Tables

@@ Line 229: / Line 229: @@
 Syntax:
 <code>UNLOCK TABLES</code>
 <center>[[MySQL | To MySQL]]</center>

2010-08-03T18:50:33Z

Basic Commands

← Older revision		Revision as of 13:50, 3 August 2010
Line 46:		Line 46:

	<code>use <db_name>;</code>		<code>use <db_name>;</code>

			<code>show tables;</code>

	<code>show <table_name>;</code>		<code>show <table_name>;</code>
Line 65:		Line 67:
	mysql>\h Among other things, \h produces this output:		mysql>\h Among other things, \h produces this output:

			<pre>
	help (\h) Display this help.		help (\h) Display this help.
	? (\?) Synonym for `help'.		? (\?) Synonym for `help'.
Line 85:		Line 88:
	tee (\T) Set outfile [to_outfile]. Append everything into given outfile.		tee (\T) Set outfile [to_outfile]. Append everything into given outfile.
	use (\u) Use another database. Takes database name as argument.		use (\u) Use another database. Takes database name as argument.
			</pre>

	== Inserting data into a table ==		== Inserting data into a table ==

2010-06-22T14:35:33Z

2010-06-22T14:25:40Z

To access a database from the command line

← Older revision		Revision as of 09:25, 22 June 2010
Line 21:		Line 21:

	Note: There is no space between the -p and the password. Password after -p is optional here. If left blank, you will be prompted to enter your password.		Note: There is no space between the -p and the password. Password after -p is optional here. If left blank, you will be prompted to enter your password.

			Alternatively, you can use <code>mysql -u root -p</code> then enter password at prompt.

	=== Using MySQL Client Programs ===		=== Using MySQL Client Programs ===

2007-12-17T05:38:48Z

Inserting data into a table

@@ Line 106: / Line 106: @@
 -> (columnName1, columnName2, etc...)
 -> VALUES (value1, value2, etc...);
 == Viewing stored data ==

2007-12-17T05:38:21Z

Basic Commands

← Older revision		Revision as of 00:38, 17 December 2007
Line 54:		Line 54:

	<code>\</code> tells MySQL to treat the next character as a character string instead of any special meaning that it may have.		<code>\</code> tells MySQL to treat the next character as a character string instead of any special meaning that it may have.

			mysql>SHOW DATABASES;

			mysql>DROP DATABASE [databasename];

			mysql>CREATE DATABASE [databasename];

			mysql>\h Among other things, \h produces this output:

			help (\h) Display this help.
			? (\?) Synonym for `help'.
			clear (\c) Clear command.
			connect (\r) Reconnect to the server. Optional arguments are db and host.
			edit (\e) Edit command with $EDITOR.
			ego (\G) Send command to mysql server, display result vertically.
			exit (\q) Exit mysql. Same as quit.
			go (\g) Send command to mysql server.
			nopager (\n) Disable pager, print to stdout.
			notee (\t) Don't write into outfile.
			pager (\P) Set PAGER [to_pager]. Print the query results via PAGER.
			print (\p) Print current command.
			prompt (\R) Change your mysql prompt.
			quit (\q) Quit mysql.
			rehash (\#) Rebuild completion hash.
			source (\.) Execute a SQL script file. Takes a file name as an argument.
			status (\s) Get status information from the server.
			system (\!) Execute a system shell command.
			tee (\T) Set outfile [to_outfile]. Append everything into given outfile.
			use (\u) Use another database. Takes database name as argument.

	== Inserting data into a table ==		== Inserting data into a table ==