FILTER ON:

Status:

All Factoids Active Factoids Deleted Factoids

Type:

All Types Factoids Triggers Other

And

Key or Value Key Trigger Value   is:

Exact Match

Go

NAVIGATION

13 Pages:

<< Previous 1 2 3 4 5 6 7 8 9 10 11 12 13 Next >>

VISIBLE	TYPE	KEY			VALUE
	Factoid	!pastebin			see http://pastie.org/
	Factoid	##php			only registered nicks can join at the moment, see http://freenode.net/faq.shtml#userregistration
	Factoid	1064			the syntax checker bails out at the first thing it cannot understand, either something immediately before is incorrect, or you used a reserved word or its just plain bad syntax and you are not following the manual
	Factoid	121			issue "SHOW ENGINE InnoDB STATUSG" and make sure no fk names are duplicated within the database. Also see "150".
	Factoid	14.04			https://bugs.launchpad.net/ubuntu/+source/mysql-5.5/+bug/1273462 https://bugs.launchpad.net/ubuntu/+source/mysql-5.5/+bug/1308431 https://bugs.launchpad.net/ubuntu/+source/rsyslog/+bug/1311810
	Factoid	150			MySQL error code 150: Foreign key constraint is incorrectly formed --> To see the error: SHOW ENGINE INNODB STATUSG and look for the Latest Foreign Key Error --> More information and FK requirements: http://dev.mysql.com/doc/refman/5.5/en/create-table-foreign-keys.html
	Factoid	1nf			first normal form-> never store more than one piece of data in a single row field
	Factoid	235959			http://code.openark.org/blog/mysql/235959-is-not-the-end-of-the-day-no-really
	Factoid	8601			Regarding date format there is no room for discussion. Please read http://xkcd.com/1179/
	Factoid	990			http://xfs.org/index.php/XFS_FAQ#Q:_I_see_applications_returning_error_990_or_.22Structure _needs_cleaning.22.2C_what_is_wrong.3F
	Trigger	<3			http://pastebin.com/Qs4U8TPQ
	Factoid	a = x and y			SELECT b FROM table WHERE a IN(x,y) GROUP BY b HAVING COUNT(DISTINCT a) = 2
	Factoid	a not in b			SELECT a.* FROM a LEFT JOIN b ON a.id = b.id WHERE b.id IS NULL;
	Factoid	aborted connections			http://dev.mysql.com/doc/refman/5.0/en/communication-errors.html
	Factoid	abstraction			http://dammit.lt/2008/01/02/my-own-database-abstraction-class/
	Factoid	access			http://dev.mysql.com/doc/refman/5.5/en/connector-odbc-examples-tools-with-access.html
	Factoid	achieve			Step back. Tell us what you're trying to achieve.
	Factoid	acid			see http://en.wikipedia.org/wiki/ACID for an explanation
	Factoid	add debian user			mysql -e"GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY '$(awk '$1 ~ /password/ {print $3}' /etc/mysql/debian.cnf)'"
	Factoid	address formats			http://www.upu.int/post_code/en/postal_addressing_systems_member_countries.shtml
	Factoid	administrator			MySQL Administrator: http://mysql.com/products/tools/administrator/
	Factoid	AI			Artificial intelligence is better than natural stupidity!
	Factoid	alias			aliases established in the SELECT clause are not available until the resultset is returned (can be used in GROUP BY, ORDER BY and HAVING clauses). Aliases established in the FROM clause are available earlier (can be used in the WHERE clause).
	Trigger	all grants			mysql -BNe "select concat('show grants for ''',user,'''@''',host,''';') from mysql.user" | mysql -BN
	Factoid	almost			Some men give up their designs when they have almost reached the goal; While others, on the contrary, obtain a victory by exerting, at the last moment, more vigorous efforts than ever before.
	Trigger	alot			http://hyperboleandahalf.blogspot.ca/2010/04/alot-is-better-than-you-at-everything.html
	Factoid	alter table locks			see http://ebergen.net/wordpress/2007/05/07/how-alter-table-locks-tables-and-handles-transacti ons/
	Factoid	alter table time			The speed of alter table is determined mostly by: 1. global buffer sizes (innodb_buffer_pool_size and/or key_buffer_size) 2. The size of the table on disk: SHOW TABLE STATUS LIKE 'table'\G and add up data+index size. 3. The speed of your disk subsystems (hint: raid 1+0 is best). With good hardware and proper tuning you can expect to see 2-4G/hour.
	Factoid	ambigious			http://is.gd/b0FuwC
	Factoid	analyze			http://dev.mysql.com/doc/refman/5.5/en/analyze-table.html
	Factoid	anemometer			Anemometer is a query analysis and trending tool that helps visualize the worst queries on your systems and allows for easy optimization. (https://github.com/box/Anemometer)
	Factoid	anonymous			Although you created user@%, you may be logged in under the ''@localhost account. Create user@localhost, or drop ''@localhost. Search for the text "If you cannot figure out why you get Access denied" at http://dev.mysql.com/doc/refman/5.5/en/problems-connecting.html
	Factoid	anyone			http://en.wikipedia.org/wiki/Warnock's_dilemma
	Factoid	apc			try http://pastebin.ca or http://pastebin.mysql-es.org
	Factoid	app code			don't pastebin app code, we have no way of knowing if your variables contain the values you imagine they do. Echo the query out to SQL only. Also, pastebin any resulting error message, or, if none, explain why you think you're getting different results than you should have.
	Factoid	arbitrary order			see: update row order
	Factoid	archives			http://downloads.mysql.com/archives.php some here http://mirror.provenscaling.com/ and even older http://www.archivist.info/mysql_archive/
	Factoid	archlinux			a lightweight and flexible distribution that tries to Keep It Simple. See /etc/rc.conf, /etc/mysql/my.cnf and /var/lib/mysql/`hostname`.err
	Factoid	ascii			you can ask any first year CS student, or go here: http://en.wikipedia.org/wiki/ASCII
	Factoid	ask			You don't have to ask to ask, or state: "I have a question", Don't ask: "Is anyone around?" or "Can anyone help?". Just Ask The Question. Also, please read: http://workaround.org/getting-help-on-irc
	Factoid	assume			Your assumptions may well be wrong. http://lucene.grantingersoll.com/2009/09/22/assumptions-in-apache-lucene-and-solr-and-pret ty-much-everything-else-considered-harmful/
	Factoid	async			http://jan.kneschke.de/2008/9/9/async-mysql-queries-with-c-api
	Factoid	auth_socket			If "mysql -u root" only works as the system root user, you might be using the auth_socket plugin. SELECT user, host, plugin FROM mysql.user; and see https://dev.mysql.com/doc/refman/5.7/en/socket-pluggable-authentication.html
	Factoid	autoinc			https://hashmysql.net/wiki/Autoincrement_FAQ
	Factoid	autoincrement			https://hashmysql.net/wiki/Autoincrement_FAQ
	Factoid	auto_increment			https://hashmysql.net/wiki/Autoincrement_FAQ
	Factoid	away			http://sackheads.org/~bnaylor/spew/away_msgs.html
	Factoid	baarf			http://www.baarf.com/
	Factoid	backup			Choices for backing up MySQL data include: stopping the server and copying the files :: mysqldump (-F|--single-transaction) :: LVM snapshot :: innobackup/xtrabackup :: replication AND one of the previous.
	Factoid	batch drop			for table in `mysql -u root -pPASS schema -BNe "SHOW TABLES LIKE 'bak_%'"` ; do mysql -u root -pPASS schema -e "DROP TABLE $table"` ; done ## (C) [raymond]