MySQL - Revision history

Milosivanovic: Fixed headings

2015-01-11T02:35:40Z

Fixed headings

2014-07-09T23:15:25Z

2014-07-04T03:30:28Z

2014-06-26T12:30:42Z

2014-06-26T03:02:54Z

‎After update

2014-06-26T02:56:56Z

2014-06-25T05:14:46Z

2014-06-25T05:11:18Z

2014-06-25T02:24:35Z

2014-06-25T02:22:12Z

@@ Line 1: / Line 1: @@
-= Command-line =
+== Command-line ==
-== Common arguments ==
+=== Common arguments ===
 <code>-h</code> remote host<br />
 <code>-u</code> remote user<br />
 <code>-p</code> requires password
-== Connect to remote MySQL server ==
+=== Connect to remote MySQL server ===
 <source lang="bash">
 mysql -h remote.host.com -u remoteuser -p
 </source>
-= User management =
+== User management ==
-== Adding a user ==
+=== Adding a user ===
 <syntaxhighlight lang="mysql">
 grant all privileges on {database_name}.* to {database_user}@'%' identified by 'their_password';
 </syntaxhighlight>
-== Revoking privileges ==
+=== Revoking privileges ===
 <syntaxhighlight lang="mysql">
 revoke usage on {databse_name}.* from {database_user}@'%';
 </syntaxhighlight>
-== Removing a user ==
+=== Removing a user ===
 <syntaxhighlight lang="mysql">
 drop user {database_user}@'%';
 </syntaxhighlight>
-= Triggers =
+== Triggers ==
-== Before ==
+=== Before ===
 * OLD table name does not exist here
 <syntaxhighlight lang="mysql">
@@ Line 38: / Line 38: @@
 </syntaxhighlight>
-== After ==
+=== After ===
 * OLD and NEW table names can be used to access the old value and the new value respectively
 <syntaxhighlight lang="mysql">
@@ Line 47: / Line 47: @@
 </syntaxhighlight>
-= Importing =
+== Importing ==
-== From CSV ==
+=== From CSV ===
 <syntaxhighlight lang="mysql">
 load data local infile 'file_name.csv' into table table_name

← Older revision		Revision as of 23:15, 9 July 2014
Line 1:		Line 1:
		+	= Command-line =
		+	== Common arguments ==
		+	<code>-h</code> remote host<br />
		+	<code>-u</code> remote user<br />
		+	<code>-p</code> requires password
		+
		+	== Connect to remote MySQL server ==
		+	<source lang="bash">
		+	mysql -h remote.host.com -u remoteuser -p
		+	</source>
		+
	= User management =		= User management =

@@ Line 34: / Line 34: @@
 		insert into {new_table} (col1, col2, col3) values (OLD.col1, NEW.col2, OLD.col3)
 	end
 </syntaxhighlight>

@@ Line 18: / Line 18: @@
 = Triggers =
-== After update ==
+== Before ==
 <syntaxhighlight lang="mysql">
-create trigger {trigger_name} after update on {table_name}
+create trigger {trigger_name} before [update|insert|delete] on {table_name}
 	for each row begin
 		insert into {new_table} (col1, col2, col3) values (OLD.col1, NEW.col2, OLD.col3)
 	end
 </syntaxhighlight>

@@ Line 22: / Line 22: @@
 create trigger {trigger_name} after update on {table_name}
 	for each row begin
-		insert into {new_table} (..., ..., ...) values (..., ..., ...)
+		insert into {new_table} (col1, col2, col3) values (OLD.col1, NEW.col2, OLD.col3)
 	end
 </syntaxhighlight>