#{茶男與藍牌}
Currently viewing the tag: "MySQL"
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
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://ondra.zizka.cz/stranky/programovani/java/index.texy
When working with MySQL over JDBC and the driver encounters a zero DATE, TIME, or DATETIME value (that is, e.g, ‚0000–00–00‘ for DATE), an exception is thrown:
java.sql.SQLException: Cannot convert value ’0000-00-00 00:00:00′ from column 4 to TIMESTAMP.
In this case, using SQL commands like
SET GLOBAL sql_mode = ‘NO_ZERO_DATE’;
does [...]
from http://blog.jamiedoris.com/geek/560/ MySQL: Get Next Auto_increment Thursday April 24th, 2003
** It is not recommended to use this method for generating foreign keys for lookups. In a multiuser environment with simultaneous requests the results will be utterly useless and unreliable. OK? **
So I was working on the preview feature of [...]
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
