#{茶男與藍牌}
Currently viewing the category:
"Database"
SELECT id, name, email INTO OUTFILE ‘/tmp/result.csv’ FIELDS TERMINATED BY ‘,’ OPTIONALLY ENCLOSED BY ‘”‘ ESCAPED BY ‘\\’ LINES TERMINATED BY ‘\n’ FROM users WHERE 1
@see http://dev.mysql.com/doc/refman/5.6/en/load-data.html
from: http://archives.postgresql.org/pgsql-admin/2005-08/msg00333.php
psql <any needed connection parameters> –quiet –no-align –field-separator ‘,’ –pset footer –output youroutputfile.csv –command <select …….> databasename
from http://willbryant.net/software/mac_os_x/postgres_initdb_fatal_shared_memory_error_on_leopard
When doing the post-install setup of postgresql default database using initdb, you may hit this error:
FATAL: could not create shared memory segment: Cannot allocate memory DETAIL: Failed system call was shmget(key=1, size=1646592, 03600).
You can either change the postgresql configuration to use less shared memory, or increase the system setting.
I suggest the [...]
For functionality similar to mysql SHOW TABLES use:
select * from information_schema.tables where table_schema=’public’ and table_type=’BASE TABLE’
from http://blogs.sun.com/divas/entry/no_such_file_to_load
Rails never fails me. As soon as I publish a series of tutorials for a NetBeans release, a new Rails release comes out which breaks my tutorials (and, apparently, most everyone else’s). Gratefully, some customers took the time to click the Feedback button at the end of our tutorials to let us [...]
Happen on version 5.1.7, so switch back to 5.1.6 is the solution…
From http://bugs.mysql.com/bug.php?id=41448
Bug #41448 java.sql.SQLException: !Statement.GeneratedKeysNotRequested! Submitted: 13 Dec 2008 18:22 Modified: 28 May 20:29 Reporter: Rico H. Status: Documenting Category: Connector/J Severity: S1 (Critical) Version: 5.1.7 OS: Linux Assigned to: Target Version: [13 Dec 2008 18:22] Rico H. Description: [...]
From http://support.microsoft.com/default.aspx?kbid=184988
View products that this article applies to.
function loadTOCNode(){}
Article ID : 184988 Last Review : January 22, 2007 Revision : 3.1 This article was previously published under Q184988 Novice: Requires knowledge of the user interface on single-user computers. SYMPTOMS
loadTOCNode(1, ‘symptoms’);
When you try to open a database [...]
From Re: Mysqldump error 1017: errno: 24 – help? Yep, that seems to have done it, at least when I’m testing it. I’m pretty sure the problem is fixed, but the next couple of days of automated backups will tell. Thanks! On Tue, 2005-01-11 at 00:43, Gleb Paharenko wrote: > Hello. > > [...]
-
Articles
- February 2012
- December 2011
- November 2011
- October 2011
- September 2011
- August 2011
- June 2011
- May 2011
- April 2011
- March 2011
- February 2011
- January 2011
- December 2010
- November 2010
- October 2010
- September 2010
- August 2010
- July 2010
- June 2010
- April 2010
- March 2010
- February 2010
- January 2010
- December 2009
- November 2009
- October 2009
- September 2009
- August 2009
- June 2009
- May 2009
- April 2009
- March 2009
- February 2009
- January 2009
- December 2008
- November 2008
- October 2008
- September 2008
-
Meta
