Re: How do I use a dynamic filename for an into outfile statement

-- prepare statement, execute it, discard it prepare s from @s; execute s; deallocate prepare s; Note: I added a '.' before 'txt' and a closing quote to the file name. http://dev.mysql.com/doc/refman/5.5/en/sql-syntax-prepared-statements.html -- Paul DuBois Oracle Corporation / MySQL Documentation Team Madison, Wisconsin, USA www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: does the number of column affect performance

able A > > are there any differences in performance when selecting, inserting, updating, > and deleting data. Sure. For example, with table A, you can select only those blob columns you're interested in. With B, you have to select all of them if you want *any* of them. -- P

Re: delete all hosts using a wildcard

rtcent19.summitnjhome.com | > | repl | virtcent23.summitnjhome.com | > | repl | virtcent30.summitnjhome.com | > +--+-+ > > > I know I can delete them individually and this is what I am going to do. But > I would like to use this as a learning

Re: hide server-version at connect?

rhsoft:~]$ telnet localhost 3306 > Trying 127.0.0.1... > Connected to localhost. > Escape character is '^]'. > N > 5.5.19-logs+%b?QYO]g��ke8'Xg~e\}!(mysql_native_password > > > > -- Paul DuBois Oracle Corporation / MySQL Documentation Team Madison, Wisconsin

Re: Date and Time

OAD DATA. You can use STR_TO_DATE() to reformat the values on the fly. LOAD DATA LOCAL INFILE 'data.txt' INTO TABLE t (name,@date,value) SET date = STR_TO_DATE(@date,'%m/%d/%y'); -- Paul DuBois Oracle Corporation / MySQL Documentation Team Madison, Wisconsin, US

Re: 'myisam_use_mmap' unstable like hell

10 years, independent of the storage engine >>> >>>> much less a not particularly commonly used feature. >>> >>> mmap is not rocket science, so i do not understnd why this >>> is not properly debugged and DEFAULT on > -- Paul DuBois Oracle Corporation / MySQL Documentation Team Madison, Wisconsin, USA www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: error log rotation problem

e using the following commands: shell> mv host_name.err host_name.err-old shell> mysqladmin flush-logs shell> mv host_name.err-old backup-directory (Bug #29751) See also Bug #56821. " -- Paul DuBois Oracle Corporation / MySQL Documentation Team Madison, Wisconsin, USA www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Error Unknown column in 'where clause'

ng players_bids.users_id_from > within the UNION I get back the following error : > > Error Code: 1054 > Unknown column 'players_bids.users_id_from' in 'where clause' > > Any ideas how to overcome this problem ? > > Cheers > Neil -- Paul DuBois Oracle Corporation / MySQL Documentation Team Madison, Wisconsin, USA www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: SQL book recommendation?

@ucl.ac.uk /"\ > Media Services\ / > University College London X ASCII Ribbon Campaign > Windeyer Building, 46 Cleveland Street/ \ Against HTML Mail > London, W1T 4JF > +44 (0)20 7679 9259 (direct), 09259 (internal) -- Paul Du

Re: Is conversion required?

nless perhaps you're also updating to a different version of MySQL. That could be a problem, depending on how different the old and new versions are. Consult the "upgrading" section of the manual to see. http://dev.mysql.com/doc/refman/5.1/en/upgrading.html -- Paul DuBois Oracle Cor

Re: SHA1 returns binary value

3, these functions return binary strings. The same change was made for SHA2() in MySQL 5.5.6. " -- Paul DuBois Oracle Corporation / MySQL Documentation Team Madison, Wisconsin, USA www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: Sequence of Execution in Non-Transactional Script

he same session (within the same connection), they should execute in the same order you issue them. Particularly since you are waiting for the result of the first before you proceed to the second. I suggest that when you observe an out of order entry in your journal, you compare it with the M

Re: Importing User credentials from mysql.sql file???

this time using mysqldump --complete-insert so that the INSERT statements include the column names. -- Paul DuBois Oracle Corporation / MySQL Documentation Team Madison, Wisconsin, USA www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: FLUSH LOCAL LOGS

ted to a slave. " -- Paul DuBois Oracle Corporation / MySQL Documentation Team Madison, Wisconsin, USA www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Why UTF8 need 24bit in MySQL?

ding. This promise makes UTF-8 code easier to write and easier > to future-proof without bad performance penalties. Supplemental Unicode characters (4-byte) are supported as of MySQL 5.5.3: http://dev.mysql.com/doc/refman/5.5/en/charset-unicode.html http://dev.mysql.com/doc/refman/5.5/en/ch

Re: declare multiple 'Definer'

M > To: mysql@lists.mysql.com > Subject: declare multiple 'Definer' > > Good morning! > > I have been struggleing with creating a store procedure, that will allow 2 > users -- Paul DuBois Sun Microsystems / MySQL Documentation Team Madison, Wisconsin, USA ww

Re: set max_allowed_packet

--+ 1 row in set (0.06 sec) > > Can you suggest me how set this value to higher one. By default it is 1 MB. > > Thank you > > VIKRAM A -- Paul DuBois Sun Microsystems / MySQL Documentation Team Madison, Wisconsin, USA www.mysql.com -- MySQL General Mailing List For list arc

Re: Help with the World.sql sample database

'll see an entry for the world database. Direct links are: http://downloads.mysql.com/docs/world.sql.gz http://downloads.mysql.com/docs/world.sql.zip -- Paul DuBois Sun Microsystems / MySQL Documentation Team Madison, Wisconsin, USA www.mysql.com -- MySQL General Mailing List Fo

Re: Selecting Dates

2010-01-30' > ORDER BY order_date; No "=" after BETWEEN. > > or > > SELECT * FROM orders WHERE order_date =>'2010-01-01' AND <= '2010-01-30' > ORDER BY order_date; Need "order_date <=", not just "<=". >

Re: auto_increment without primary key in innodb?

p://lists.mysql.com/mysql?unsub=...@thefsb.org >> >> >> >> > > > > -- > Yang Zhang > http://www.mit.edu/~y_z/ > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql?unsub=paul.dub...@sun.com > -- Paul DuBois Sun Microsystems / MySQL Documentation Team Madison, Wisconsin, USA www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: REGEXP and unicode weirdness

sults with multi-byte character sets. In addition, these operators compare characters by their byte values and accented characters may not compare as equal even if a given collation treats them as equal. -- Paul DuBois Sun Microsystems / MySQL Documentation Team Madison, Wisconsin, USA www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: upgrading mysql

d >>>>> slave dump file under 5.1 server. >>>>> 7. After loading is complete, test then start binary logging on master >>>>> while still preventing updates to updates. >>>>> 8. After loading slave, test then start slave (get configs in plac

Re: upgrading mysql

STER. See: http://dev.mysql.com/doc/refman/5.1/en/replication-options-slave.html http://dev.mysql.com/doc/refman/5.1/en/news-5-1-17.html -- Paul DuBois Sun Microsystems / MySQL Documentation Team Madison, Wisconsin, USA www.mysql.com -- MySQL General Mailing List For list archives: http://lists.m

Re: START TRANSACTION COMMIT ROLLBACK

that are located in two different databases. Would a single START TRANSACTION be sufficient ? Any help would be appreciated. TIA Mos -- - michael dykman - mdyk...@gmail.com "May you live every day of your life." Jonathan Swift -- Paul DuBois S

Re: Getting mySQL to ignore case sensitivity of field names

p://dev.mysql.com/doc/refman/5.0/en/case-sensitivity.html You need to set the field format to a non binary one, and case insensitive will be the default. -- Paul DuBois Sun Microsystems / MySQL Documentation Team Madison, Wisconsin, USA www.mysql.com -- MySQL General Mailing List For list archives: htt

Re: Renaming a Database

ly find the new instance. If you have InnoDB tables, there will be a problem. InnoDB maintains the database name in the shared tablespace, and it will no longer be able to find those tables. -- Paul DuBois Sun Microsystems / MySQL Documentation Team Madison, Wisconsin, USA www.mysql.com --

Re: Why is MySQL using /tmp?

/tmp? Can/should I make the server use a different location instead of /tmp? Thanks, Mike Spreitzer -- Paul DuBois Sun Microsystems / MySQL Documentation Team Madison, Wisconsin, USA www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: How to execute prepare statement when the placeholder is a specific table name?

p://www.percona.com/services.html -- I'm a MySQL DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn -- Paul DuBois Sun Microsystems / MySQL Documentation Team Madison, Wisconsin, USA www.mysql.com -- MySQL General Mailing List For list archives: http://list

Re: mysql full tutorial download or any book

ual. Whew! I was about to panic. :-) -- Paul DuBois Sun Microsystems / MySQL Documentation Team Madison, Wisconsin, USA www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: How to get Error Number and Error Message 2nd Try

ar to get the latest ERROR NUMBER and latest ERROR MESSAGE, SHOW WARNINGS might help. http://dev.mysql.com/doc/refman/5.1/en/show-warnings.html -- Paul DuBois Sun Microsystems / MySQL Documentation Team Madison, Wisconsin, USA www.mysql.com -- MySQL General Mailing List For list archives: ht

Re: Install problem: log file issue

.1/en/server-options.html#option_mysqld_pid-file -- Paul DuBois Sun Microsystems / MySQL Documentation Team Madison, Wisconsin, USA www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Installing MySQL from source

eas a source tarball is created from the result of these tools. The manual should cover that, but I don't have a specific URL handy. It's http://dev.mysql.com/doc/refman/5.1/en/installing-source-tree.html The development tree contains a file "BUILD/autorun.sh" which runs th

Re: Are dates stored as String? Or Integer?

a speed advantage of switching the dates to integer? Dates are stored numerically. See: http://dev.mysql.com/doc/refman/5.1/en/storage-requirements.html Beginning with "The storage requirements shown in the table arise from the way that MySQL represents temporal values ..."

Re: Setting the value for the EDITOR variable

/local/bin/pico export EDITOR I get no error messages when mysql starts up, but the value of the EDITOR variable does not change. Is there any way I can achieve that from the cnf file? No. MySQL option files are for setting MySQL program options, not environment variables. -- Paul DuBois

Book: MySQL, Fourth Edition, now available

The book MySQL, Fourth Edition (aka "Doorstop IV") has been published. More information is available at the book's Web site: http://www.kitebird.com/mysql-book/ -- Paul DuBois Sun Microsystems / MySQL Documentation Team Madison, Wisconsin, USA www.mysql.com -- MySQL General M

Re: Trigger problem

York' where departement_postcode = 1000; END IF; END| but when i insert a new row i don't get my v_place value set so if there someone who has time to help me with this i would greatly appreciate this :) -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA www.mysql.com -- MySQL Gene

Re: reorder records in database

er", e.g 1, 2, 3, 5, 6, 8, 11, 12, 13, 19, 20,... (some numbers are missing). is there built in function to "reset" order_no or I have to create php script for it? Why do you care if there are gaps? Do they really matter? -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin

Re: Floor Decimal Math

rs are type DECIMAL. You might have to cast them. Apparently MySQL 5+ introduced some algorithms that helped with these problems, although not with yours. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA www.mysql.com -- MySQL General Mailing List For list archives: http://lis

Re: CONCAT doesn't work with NULL?

27;b'); +--+ | CONCAT('a',NULL,'b') | +--+ | NULL | +--+ 1 row in set (0.07 sec) mysql> select CONCAT_WS('','a',NULL,'b'); ++ |

Re: connectors: per session persistent connection (PHP)

On May 9, 2008, at 12:17 AM, Sebastian Mendel wrote: Paul DuBois schrieb: On May 7, 2008, at 4:36 AM, Sebastian Mendel wrote: Hi, wouldn't it be very helpful if mysql connectors support some sort of per session persistent connection? this would save a lot of queries in many apps

Re: MySQL purge logs

1-bin.000713 -rw-rw 1 mysql 701 1.1G May 9 09:29 host1-bin.000714 -rw-rw 1 mysql 701 1.1G May 9 19:20 host1-bin.000715 -rw-rw 1 mysql 701 1.1G May 9 21:46 host1-bin.000716 Thanks and Regards Kaushal -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA www.mysql.com

Re: pls help clarify dox: InnoDB Consistent Non-Locking Read behavior

er case Paul was trying to cover when he made that change? Thanks for your time! Hopefully we can clarify this for all mysql users! The background for this change is Bug#30184: http://bugs.mysql.com/bug.php?id=30184 -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA www.mysql

Re: connectors: per session persistent connection (PHP)

would a persistent connection save any of that? Suppose the script that previously used the connection reset any or all of those things? -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mys

Re: viewing passwords as root

.0/en/encryption-functions.html#function_password -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL 5.0.51a and SHOW ENGINES

"--debug-info, -T Before MySQL 5.1.14, this option prints debugging information and memory and CPU usage statistics when the program exits, and also causes display of result set metadata during execution. As of MySQL 5.1.14, use --column-type-info to display result set metadata."

Re: CHARACTER SET

At 8:49 AM -0700 4/16/08, Rob Wultsch wrote: On Wed, Apr 16, 2008 at 7:24 AM, Paul DuBois <[EMAIL PROTECTED]> wrote: > When you create a table, you can specify a character set for a column. How > can you tell what character set was used when the column was created? > SH

Re: CHARACTER SET

ENGINE=MyISAM DEFAULT CHARSET=latin1 1 row in set (0.00 sec) The definition for c1 shows that utf8 is used The definition for c2 shows nothing, so the table character set (latin1) is used. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General M

Re: Create table

e right syntax to use near 'group' at line 1 Does the problem is with table name. "group" is a reserved word. See this page: http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html The page also describes how to quote identifiers to avoid this problem. -- Paul DuBois, My

Re: Question about mysql procedures

-restrictions.html For example, in a stored function, you cannot modify a table if the table is referenced by the statement that invokes the function. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com

Re: select records to send to another table in another database

in Linux? For each corresponding table: INSERT INTO db1.mytable SELECT * FROM db2.mytable; And you can do that using the cli mysql app? Yes. You can do this in any interface that enables you to issue SQL statements. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB

Re: select records to send to another table in another database

table: INSERT INTO db1.mytable SELECT * FROM db2.mytable; -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: We have just moved to a new web server where we are running mysql version: 5.0.45

hanged in MySQL 4.1. You can read about it here: http://dev.mysql.com/doc/refman/5.0/en/password-hashing.html This is likely the cause of the changes that you're observing. I imagine that you'll either need to upgrade the passwords in your table, or look for them using OLD_PASSWOR

Re: Indices in InnoDB/MySQL

en/indexes.html http://dev.mysql.com/doc/refman/5.0/en/multiple-column-indexes.html http://dev.mysql.com/doc/refman/5.0/en/mysql-indexes.html -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Re: 2 mysqld instances

o force a TCP/IP connection, even for localhost, with --protocol=tcp http://dev.mysql.com/doc/refman/5.0/en/invoking-programs.html -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysq

Re: the limitaiton of table size

, yes. InnoDB will use the aggregate file size as the tablespace size. But remember that multiple tables share the tablespace. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mys

Re: Security overrides in mysql.cnf

statement to re-enable the grant tables (so that you can use CREATE USER, GRANT, etc.), and then set up the accounts the way you want (new root password and so forth). -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list

MySQL University session on March 13 - canceled

Today's MySQL University session: Checking Threading and Locking With Helgrind http://forge.mysql.com/wiki/Checking_Threading_and_Locking_With_Helgrind has been canceled and will be rescheduled for a later date. I apologize for the short notice. -- Paul DuBois, MySQL Documentation

Re: function/procedure error!

return the result set to the client. So, don't select from the table in the procedure. Use the procedure to populate the table, and then use your original query, with the originally proposed stored function reference replaced with a reference to the table that contains 0 ... n. -- Paul D

Re: function/procedure error!

en you can select from the table. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: function/procedure error!

at it makes me a error. CREATE OR REPLACE FUNCTION `cantidad`(n integer) RETURNS INTEGER AS DECLARE i integer; BEGIN FOR i IN 0..n LOOP RETURN NEXT i; END LOOP; RETURN; END; -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing

Re: mysql.time_zone_name

fill these tables in mysql-db? Please see this section of the manual: http://dev.mysql.com/doc/refman/5.0/en/time-zone-support.html -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com

Re: MySQL 4 Grant command

g the username and hostname: 'login3'@'%' -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: what is a schema? what is a database?

he two are equivalent. The keyword DATABASE or DATABASES can be replaced with SCHEMA or SCHEMAS wherever it appears. Examples: CREATE DATABASE <=> CREATE SCHEMA SHOW DATABASES <=> SHOW SCHEMAS -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MyS

Re: recursion

ce, Destination) AS (SELECT Source, Destination FROM FLIGHT ) SELECT * FROM ReachableFrom WHERE Source = "Portland"; MySQL does not have "WITH RECURSIVE". -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mail

Re: Is mysql_upgrade *required*?

he check reports errors, rebuild the indexes: Dump and reload the table if it is an InnoDB table, or run OPTIMIZE TABLE or REPAIR TABLE if it is a MyISAM table." So if CHECK TABLE doesn't complain, you should be okay. Thanks! On Feb 16, 2008 9:09 PM, Paul DuBois <[EMAIL PROTEC

Re: Is mysql_upgrade *required*?

y will be inefficient? The server should be able to read them (if it couldn't, mysql_upgrade, which uses mysqlcheck, a client, couldn't tell the server to repair them!). But until those TEXT indexes are rebuilt, you might get incorrect results for some queries. -- Paul DuBois, MySQL Doc

Re: triggers sintax error with IF

IF-THEN-END), so you need to enclose the body within BEGIN/END. http://dev.mysql.com/doc/refman/5.0/en/begin-end.html -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysq

Re: select with table name

row? mysql> select 't1', t1.* from t1 union select 't2', t2.* from t2; ++--+ | t1 | i| ++--+ | t1 |1 | | t2 |2 | | t2 | 3 | ++--+ -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL Genera

Re: 2 cursors in a store procedure

contine handler for not found set y=1; http://dev.mysql.com/doc/refman/5.0/en/cursors.html: "Cursors must be declared before declaring handlers. Variables and conditions must be declared before declaring either cursors or handlers." You have a handler declared before a cursor

Re: Decimal - Maximum is 30

At 9:50 PM -0600 1/31/08, Peter Brawley wrote: Postgres has PostGIS Oracle has OracleSpatial MySQL has ? OpenGis. As stated here: http://dev.mysql.com/doc/refman/5.0/en/gis-introduction.html -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL

Re: ON vs. WHERE

nal is any conditional expression of the form that can be used in a WHERE clause. Generally, you should use the ON clause for conditions that specify how to join tables, and the WHERE clause to restrict which rows you want in the result set." See: http://dev.mysql.com/doc/refman/5.0/en/join.html

Re: cache in mysql Windows

n when the MySQL query cache is disabled. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: What is up with = and trailing spaces?

l.com/doc/refman/5.0/en/char.html Which says: "Note that all MySQL collations are of type PADSPACE. This means that all CHAR and VARCHAR values in MySQL are compared without regard to any trailing spaces." -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mys

Re: BUG: DATE_ADD 99999 fails, but 9999 works.

out a bug report with the text you have already entered by clicking the following button:" ... Well why the heck did you let me choose that option then! UGH! ÐÆ5ÏÐ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.

Re: BUG: DATE_ADD 99999 fails, but 9999 works.

system." The option is there to let you know that the user comment system isn't for reporting bugs *and* to let you know the correct place to report them. It's there as extra reinforcement for people who ignore or overlook the statement that I mentioned in the preceding paragraph.

Re: Why is the average of an int column returned as a string

_fetch() converts the string-format DECIMAL value to numeric form." -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: looking for a good book for learning mysql

r. I'm still a beginner but I learn fast, so I don't want something to simple, I need something that can get me going and can also push me alot further. Thanks in advance ! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://

Re: Behaviour of auto_increment

bably explain it better if you said just what it is you're wondering about. For example, did the things you try not work and you're wondering why? You didn't say what were the results of your actions, nor whether they were what you expected. Please clarify. -- Paul DuBois, MySQ

Re: New error to me...

rom the same table that you're inserting into. http://dev.mysql.com/doc/refman/5.0/en/insert-select.html (You're not quite using INSERT INTO ... SELECT syntax, but what you're doing appears to be effectively equivalent.) -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin,

Re: LOW_PRIORITY_UPDATES

lobal LOW_PRIORITY_UPDATES=1; the same as starting mysql with --low_priority_updates? I think it is but want confirmation. It's the same. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To u

Re: database cache /

.mysql.com/doc/refman/5.0/en/innodb-tuning.html -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: how to get Number of rows matched?

y OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 -- Cheers, Rajan -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: "flush logs" vs. mysqladmin

slow query log (just like the general query log) isn't created as a numbered sequence of files. You'll need to rotate it yourself. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com

Re: maximum number of records in a table

about 5,000,000,000 rows." that's cool but i assume this is distributed over a few machines... No. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://

Re: Change in behaviour in version 5.0.41

At 12:10 PM -0400 6/18/07, Baron Schwartz wrote: Paul DuBois wrote: At 3:29 PM +0100 6/15/07, Ben Clewett wrote: Dear MySql, I have noticed a change in behaviour in MySql 5.0.41 from 5.0.26 with date comparisons. In 5.0.26:'2007-06-15' = '2007-06-15 00:00:00'

Re: Change in behaviour in version 5.0.41

ySQL 5.0.42, a DATE value is coerced to the DATETIME type by adding the time portion as '00:00:00'. To mimic the old behavior use the CAST() function in the following way: SELECT date_field = CAST(NOW() as DATE);." http://dev.mysql.com/doc/refman/5.0/en/date-and-time-types.html

Re: perl DBI does not do execute mysql statement

this works fine). Not sure how crazy this could be. Any clue? No, because you're describing the problem in English without showing any of the code that doesn't work. How can anyone help you? -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- M

Re: Documentation

ble at the main documentation page on our web site: http://dev.mysql.com/doc/ -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Trigger OLD question

use a statement something like this: INSERT INTO table_track SELECT * FROM track_table WHERE key_col=OLD.key_col; I admit I have not tested this. :-) -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http

Re: --xml or --html output to file

you're not likely to "stumble" on it; better to consult the documentation for your interpreter. For Unix, you can do something like this: Put statements in a file "x". Run mysql like this to capture output into "y": mysql --xml db_name < x > y -- Paul DuBo

Re: expire_logs_days

At 9:55 PM -0400 5/3/07, Baron Schwartz wrote: Mark Leith wrote: Paul DuBois wrote: At 8:46 PM -0400 5/2/07, Baron Schwartz wrote: Ofer Inbar wrote: That's a good point, though probably a minor one: At most you would end up with one binary logfile that's "old" and not

Re: expire_logs_days

start. I have a 4.1.13 server that's been up for 100 days. It has expire_logs_days, and I have 7 binlog files. I do flush my logs once a day to force the logs to rotate. So that's one confirmation that it works, at least in 4.1.13. :-) -- Paul DuBois, MySQL Documentation Team Madiso

Re: REGEXP Character Classes

essage, sorry: The character class names *include* the square brackets, so to use them as part of a range, you need another set of square brackets, i.e., [[:upper:]]. What your statement looks for is any values containing :, u, p, e, or r, and that's why you see the values returned that you

Re: REGEXP Character Classes

---+ 25 rows in set (0.00 sec) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing Li

Re: What is /*!40101 SET @...

ecent as the version number at the beginning of the comment. http://dev.mysql.com/doc/refman/5.0/en/comments.html Basically, it's version-specific code for features that are unavailable in older servers. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com

Re: How to overwrite existing file with SELECT .. INTO?

ed rows to a file. The file is created on the server host, so you must have the FILE privilege to use this syntax. file_name cannot be an existing file, which among other things prevents files such as /etc/passwd and database tables from being destroyed. http://dev.mysql.com/doc/refman/5.0/en/sele

Re: dumpfile question

DUMPFILE instead of INTO OUTFILE, MySQL writes only one row into the file, without any column or line termination and without performing any escape processing. This is useful if you want to store a BLOB value in a file. http://dev.mysql.com/doc/refman/5.0/en/select.html -- Paul DuBois, MySQ

Re: Collation Order in MySQL?

n the produces the ordering you want. :-) To be conservative, should I set collation order? Yep. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: information_schema not found

At 12:30 PM -0500 3/29/07, Brown, Charles wrote: Hi all. I just finished installing mysql on a new server. I noticed that database information_schema wasn't found. Can someone help me. What version of MySQL? I_S is present only in 5.0 and up. -- Paul DuBois, MySQL Documentation Team Ma

Re: MySQL Daylight Savings Time Patch

set (0.00 sec) Diagnosis: this database thinks the switch is on April 1, which is wrong. Cure: update your operating system files, check the "MySQL Server Time Zone Support" section of the manual, and update the table. So, as you can see, it's probably easier just to reload the

  1   2   3   4   5   6   7   8   9   10   >