Perintah MySQL - Revision history

Onnowpurbo: /* Insert Some More Records into the Table */

2020-05-27T01:30:18Z

Insert Some More Records into the Table

2020-05-27T01:29:23Z

Change multiple fields at once

← Older revision		Revision as of 01:29, 27 May 2020
Line 210:		Line 210:

	!Remember to put commas between each field you're updating.		!Remember to put commas between each field you're updating.

	mysql 5.0.51b> update table01 set field04=19991022, field05=062218 where field01=1;		mysql 5.0.51b> update table01 set field04=19991022, field05=062218 where field01=1;

2020-05-27T01:29:08Z

It's in there!

← Older revision		Revision as of 01:29, 27 May 2020
Line 200:		Line 200:

	==It's in there!==		==It's in there!==

	~~Now, we're almost done...~~
	~~Updating Existing Records~~
	~~Modify one field at a time~~

	!Again, be careful with syntax. Quote marks need to go around text but not around numbers.		!Again, be careful with syntax. Quote marks need to go around text but not around numbers.

2020-05-27T01:28:45Z

It's in there!

← Older revision		Revision as of 01:28, 27 May 2020
Line 201:		Line 201:
	==It's in there!==		==It's in there!==

	Now, we're almost done...		Now, we're almost done...
	Updating Existing Records		Updating Existing Records
	Modify one field at a time		Modify one field at a time

	!Again, be careful with syntax. Quote marks need to go around text but not around numbers.		!Again, be careful with syntax. Quote marks need to go around text but not around numbers.

	mysql 5.0.51b> update table01 set field03='new info' where field01=1;		mysql 5.0.51b> update table01 set field03='new info' where field01=1;

	Query OK, 1 row affected (0.00 sec)		Query OK, 1 row affected (0.00 sec)


	==Change multiple fields at once==		==Change multiple fields at once==

2020-05-27T00:47:55Z

Insert Some More Records into the Table

← Older revision		Revision as of 00:47, 27 May 2020
Line 161:		Line 161:
	==Insert Some More Records into the Table==		==Insert Some More Records into the Table==

	mysql 5.0.51b> insert into table01 (field01,field02,field03,field04,field05) values		mysql 5.0.51b> insert into table01
	-> (2, 'second', 'another', '1999-10-23', '10:30:00');		-> (field01,field02,field03,field04,field05) values
			-> (2, 'second', 'another', '1999-10-23', '10:30:00');

	Query OK, 1 row affected (0.00 sec)		Query OK, 1 row affected (0.00 sec)

2020-05-27T00:44:32Z

Multiple Line Entry

← Older revision		Revision as of 00:44, 27 May 2020
Line 127:		Line 127:
	-> integer,		-> integer,
	-> field02		-> field02
	-> char(30)); mysql 5.0.51b> create table table33		-> char(30));

			mysql 5.0.51b> create table table33
	-> (field01 inte		-> (field01 inte
	-> ger,		-> ger,

2012-12-24T02:57:42Z

Pranala Menarik

← Older revision		Revision as of 02:57, 24 December 2012
Line 270:		Line 270:
	==Pranala Menarik==		==Pranala Menarik==

	* [[MySQL]]
	* [[Perintah MySQL]]		* [[Perintah MySQL]]
	* [[Instalasi MySQL]]		* [[Instalasi MySQL]]
	* [[Linux Howto]]		* [[Linux Howto]]
	* [[Backup isi database MySQL]]		* [[Backup isi database MySQL]]
			* [[Reset Password MySQL]]
			* [[Mengatasi Masalah Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock']]
			* [[Masalah 'mysqld.sock' yang cukup menjengkelkan]]
			* [[MySQL: Memperbaiki Corrupt Database]]
			* [[MariaDB]]


			[[Category: Linux]]
			[[Category: Database]]

2010-09-19T11:04:02Z

Referensi

← Older revision		Revision as of 11:04, 19 September 2010
Line 266:		Line 266:
	* http://www.mysqltutorial.org/		* http://www.mysqltutorial.org/
	* http://dev.mysql.com/		* http://dev.mysql.com/
			* http://ubuntu.flowconsult.at/en/mysql-set-change-reset-root-password/ - Reset Password [[MySQL]]

	==Pranala Menarik==		==Pranala Menarik==

2010-08-27T03:13:30Z

Referensi

← Older revision		Revision as of 03:13, 27 August 2010
Line 265:		Line 265:
	* http://www.analysisandsolutions.com/code/mysql-tutorial.htm		* http://www.analysisandsolutions.com/code/mysql-tutorial.htm
	* http://www.mysqltutorial.org/		* http://www.mysqltutorial.org/
			* http://dev.mysql.com/

	==Pranala Menarik==		==Pranala Menarik==

2010-07-27T11:44:28Z

Referensi

← Older revision		Revision as of 11:44, 27 July 2010
Line 264:		Line 264:

	* http://www.analysisandsolutions.com/code/mysql-tutorial.htm		* http://www.analysisandsolutions.com/code/mysql-tutorial.htm
			* http://www.mysqltutorial.org/


	==Pranala Menarik==		==Pranala Menarik==