Announce: Upcoming MySQL Certification program

Certificate! https://order.mysql.com/ Regards, Carsten H. Pedersen MySQL AB Certification Manager -- MySQL Certifications, http://www.mysql.com/training/certification.html __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Carsten Pedersen [EMAIL PROTECTED

RE: Rebooting MySql

memory leakage at all. If you have deleted from many tables, OPTIMIZE will be your friend. You might also want to go back to your queries, do an EXPLAIN and see if you need to redefine indexes, etc. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http

RE: Where Did Mysql Go?

of the HD doesn't show it) and, more important, how do I get it back? The socket file is created by mysqld at startup. Are you sure mysqld is running? Have you tried restarting mysqld? / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk

RE: Where Did Mysql Go?

of the HD doesn't show it) and, more important, how do I get it back? The socket file is created by mysqld at startup. Are you sure mysqld is running? Have you tried restarting mysqld? / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk

RE: MySQL on the Playstation2? (OT? You betcha)

Aye. Neither is a matchbox-sized webserver any good. Still someone made it. :-) - Carsten query :-) ...though not as small (or even as useful) as a matchbox- sized server, certainly more interesting in terms of power supply: http://world.std.com/~fwhite/spud/ / Carsten -- Carsten H

RE: MySQL PASSWORD function

, SELECT PASSWORD('thepassword')=Password FROM user WHERE User='username'; will return 1 on a match, 0 on non-match (watch out for nonexisting usernames). / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq

RE: help in running mysql on slak8...

? If not, do a chown... / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

RE: host = %

. For the client, you can twiddle values in my.cnf to suit your needs. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http

RE: Column Alias Bug??

column 'z' in 'where clause' Why isn't z recognized as a column identifier? Because you should be using HAVING rather than WHERE: select a,count(*) as z from aa group by a having z1; / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk

RE: Max Row Length

is there a max row length for MyISAM tables? I'm having a hard time finding it. http://www.bitbybit.dk/mysqlfaq/faq.html#ch9_0_0 / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq

RE: Not updating tables with data but no errors either

-- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

RE: REPLICATION BUG

Changes in release 3.23.46 Fixed problem with aliased temporary tables replication --- / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please

RE: why too long entries get _cut_ without error

both. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

RE: MySQL can't find table forms.

/execute on those dirs/files? Might you at some point have been running mysqld as root, and now you are running it as the user mysql? / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq

FW: ID in table

Is there any way to start Ids in table from some number for exampl 1 with function auto_increment and not from 1? http://www.bitbybit.dk/mysqlfaq/faq.html#ch6_4_0 / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq

RE: big problem with mysqldb

. Mysqldump does not dump the compleat tables. Which command do you use when running mysqldump? What is missing? / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq

RE: Column Limits

#ch9_0_0 / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

RE: Regexp Help !!!

using LIKE as this will often be much faster: SELECT ... WHERE data LIKE TOP/World/Japan/% AND data NOT LIKE TOP/World/Japan/%/% - in essence: select all those records which start with TOP/World/Japan/, then subtract those which contain any further /. / Carsten -- Carsten H. Pedersen keeper

RE: Table marked as readonly

? / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

RE: Select statement help...

.depart_time, t2.arrive_time FROM flights AS t1, flights AS t2 WHERE t1.flight_group = t2.flight_group; / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting

RE: Bind on unix socket: Permission denied

running $ ps -A | grep mysqld - and see if mysqld isn't already running. I don't think you have a problem: mysqld is already running and waiting for you to use it! / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq

RE: When were user variables introduced ?

. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

RE: MySQL starts using a lot of CPU resources

for tables to be released. Try enabling --log-slow-queries, then have a peek at the log file to see what's causing these. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq

RE: MySQL starts using a lot of CPU resources

related question: Does MySQL label as slow (as I believe PostgreSQL does) any query that is not referencing an indexed table? No. Any query that takes longer than long_query_time, e.g. 10 seconds on most systems, to execute. Use SHOW VARIABLES to see it. / Carsten -- Carsten H

RE: Case sensitive in selecting records

-sensitive in selecting records... SELECT BINARY ... / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com

RE: permisions problem, need to understand what is going wrong to get ontop of this.

the root password, follow this procedure: http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_2_0 And some more insight into the privilege system: http://www.bitbybit.dk/mysqlfaq/faq.html#ch11_0_0 / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk

RE: To Mr Bob Hall (and everybody else who wants to read it)

, as well... / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

RE: Newbie install problem

... / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

RE: Can't Connect

on '209.249.147.203' (10060) What does this error 10060 typically indicate? Try reading http://www.bitbybit.dk/mysqlfaq/faq.html#ch10_0_0 - it might give you the hints you need. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq

RE: Getting Possible Values of an Enum Field

of this with regexp's in the Programming language of my Choice, but I am interested to know if there isn't a more beautiful possibility where Mysql gives me back the result direct. SELECT DISTINCT enum_col FROM tablename WHERE enum_col256; / Carsten -- Carsten H. Pedersen keeper and maintainer

IN/BETWEEN operators and ENUM column troubles

returned MyISAM tables on v. 3.23.45. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php

RE: Help! Languages and Characters....

-- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq Thanks Shannon --- Michael Brunson [EMAIL PROTECTED] wrote: On Fri, 21 Dec 2001 11:07:27 -0800 (PST), Shannon Kendrick [EMAIL PROTECTED] wrote: | I have a mysql table (MySAM), a field

RE: ::grumble:: SQL Problem (bug?) with HAVING clause?

with v. 3.23.09. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

RE: Changing the locations of the tables

script: mysqld --datadir=/usr/lib/mysql 4) restart mysqld. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq -Original Message- From: Stephen Johnson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 18, 2001 9

RE: mysql password

: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' I wonder when the mysql team will get around to changing that message... - Don't use '-p'. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http

RE: Error handling in MySQL

table handler This happens when I do an order by in the sql statement. Use perror: [carsten@tsort carsten]$ perror 1 Error code 1: Operation not permitted. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq

RE: MYSQL Database Specs

Hello, I am interested in knowing :- 1) The maximum number of tables possible in MYSQL Database 2) The maximum number of columns that are in a table. http://www.bitbybit.dk/mysqlfaq/faq.html#ch9_0_0 / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http

RE: connecting

It simply won't connect. It just says 'Can't connect to local MySQL server through socket '' (111)' I can connect via terminal so I know MySQL is (at least semi) correctly setup. Any ideas? http://www.bitbybit.dk/mysqlfaq/faq.html#ch10_0_0 / Carsten -- Carsten H. Pedersen keeper

RE: ERROR 1006: Can't create database 'mynewdb'. (errno: 28)

mysql CREATE DATABASE mynewdb; ERROR 1006: Can't create database 'mynewdb'. (errno: 28) mysql [carsten@tsort carsten]$ perror 28 Error code 28: No space left on device - Maybe clearing up some disk space would help??? / Carsten -- Carsten H

RE: root cant control mysqld

Some how I don't have control over mysqld as root. It starts on boot, but I am unable to stop it to reset root password. How can I correct this? http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_2_0 / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http

RE: sequence and nextval

that it generated. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq Thanks / Henrik --- create table MySequence ( nextval int(10) not null default '0' auto_increment ) ; insert into MySequence values (''); select

RE: Error ODBC

(10071)(#2003) More likely, it's a permissions problem. Try reading http://www.bitbybit.dk/mysqlfaq/faq.html#ch10_0_0 / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq

RE: [OT] mod_perl and last_insert_id() (Was: sequence and nextval)

connection. So I don't really see why this would matter. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com

RE: synopsis of the problem (one line)

I would like to know how to create mysql.sock I destructed... Restart mysqld / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please

RE: IN keyword supported?

describe. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

RE: Can't start MySQL,please help......

mysqld have the correct permissions on the directory containing host-bin.1? / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check

RE: startup command line

Hello, cut a'lot them, will the command line over ride the settings in the my.cnf, cut s'more Manual sec. 4.1.2: Options specified on the command line take precedence over options specified in any option file. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk

RE: speed up MySQL Selections

issues above. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

RE: Question

/ Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

RE: Access Error

://www.bitbybit.dk/mysqlfaq/faq.html#ch7_2_0 sec. 4.2.4 - 4.2.10 of the manual / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http

RE: Error 1045 - Access denied

... or by editing the user table directly? In the latter case, did you remember to FLUSH PRIVILEGES? / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting

RE: Could mysql count the datatraffic of DB's posted queries?

? In that case the data traffic is a lousy metric for how many resources each client is hogging. The complexity of the queries is by far more important than the amount of data moved. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq

RE: remove duplicates

Hi all, Is there anyway to delete the duplicate records in mysql without creating new tables. I am wondering what query will achieve this task where mysql doesnt supports like ROWID and sub queries. http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_8_0 / Carsten -- Carsten H. Pedersen keeper

RE: UNION/INTERSECT

... MINUS, INTERSECT and FULL OUTER JOIN. (Currently UNION (in 4.0) and LEFT OUTER JOIN are supported) / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before

RE: correct column name

Hi, Please, how do i correct wrong column name (field name, not one of values stored under the column name) in a table in mysql? I supposed to type password when i was creating the as field but end up typed passwod. http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_26_0 / Carsten -- Carsten H

RE: 0 Records Affected

of matched rather than affected rows. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php

RE: LOAD_FILE does not work

. Please provide any leads you may have. The permissions on the description_file is 777. What about the rest of the path? Is that readably by MySQL as well? / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq

RE: Privileges question.

to read http://www.bitbybit.dk/mysqlfaq/faq.html#ch11_0_0 / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com

RE: dec is treated as a reserved word.

a documentation or software bug. It's a documentation bug. Although not on the list of reserved words, the manual does say: --- 6.2.1 Numeric Types ... and the keyword DEC is a synonym for DECIMAL. --- / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk

Book review: MySQL - Building User Interfaces

DBMSs, the UI part of the book is very narrowly scoped on the use of Glade and GTK+. Full review at: http://www.bitbybit.dk/mysqlfaq/MySQL-BUI.html / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq

RE: dropping auto_increment PK/Index

be defined as a key The following should do the trick: http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_12_0 / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq

RE: INSERT with SELECT on same table

for it. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

RE: nonstandard meaning of KEY in MySQL?

] In everyday speech: a set of not-necessarily-unique values, especially values stored in indexes ... which can be used to search particular rows of a Table. Both [1] and [2] are acceptable... / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http

RE: Index not used with GROUP BY?

collection_id, tcml_field_id (and maybe value), or simply re-define your PRIMARY KEY so that those two fields make up the first part of the key. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq

RE: Index not used with GROUP BY?

On 15 Nov 2001, at 21:59, Carsten H. Pedersen wrote: PRIMARY KEY (`collection_id`,`document_id`,`tcml_field_id`,`order_number`), KEY `collection_field_value` (`collection_id`,`tcml_field_id`,`value`(12)), KEY `value` (`value`(12)), KEY `resource_id` (`resource_id

RE: Boolean column type?

Is a boolean column type possible in mysql? If not, what's the most common column type for true/false (or true/false/null) flags? http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_16_0 / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk

RE: why ever use TINYBLOB/TEXT -- isn't VARCHAR same size?

assume that there is a small speed penalty in using TEXT/BLOB fields, as compared to VARCHARs. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting

RE: Access to MYSQL via ODBC?

running w/o -p is there any way to change/reset the password if any or am i doing something wrong ? http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_2_0 / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq

RE: v3: delete based on select

. If you're using some program to interface w/ MySQL, I would suggest picking up the targettable.id's, collecting these in a comma-separated list and use a query like: DELETE FROM sourcetable WHERE id IN (list). / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http

RE: primary key based on unique value for two columns

and not on a combination of columns. If I am wrong please correct me. You're wrong :-) mysql CREATE TABLE tablename (col_a int not null, - b int not null, PRIMARY KEY (a, b)); I am looking for work arounds. No need to... / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ

RE: Maximum # of Columns

... http://www.bitbybit.dk/mysqlfaq/faq.html#ch9_5_0 / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com

RE: renaming a database

Can you rename a database? If so, how does it handle all the tables inside it? By shutting down the server, renaming the directory of that database and restarting the server. The server will be able to handle the change just fine. / Carsten -- Carsten H. Pedersen keeper and maintainer

RE: String composite key vs auto_increment

. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

RE: varchar in the foodchain

access devices. But, it is all explaind in the manual :) Exactly where in the manual did you find that piece of information? / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq

RE: Where REGEX documentation?

. Since the source is 11 MB and I have no other need for it, I wonder if there's another source for this documentation. http://arglist.com/regex/ / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq

RE: join dilemma

://users.starpower.net/rjhalljr/MySQL/sql.html / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php (the manual

RE: changing column order in MySQL tables?

How do you change the order of columns in MySQL tables? I assume the tables have a concept of column order, since the DESCRIBE command always lists the columsn in the order in which they were created. http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_5_0 / Carsten -- Carsten H. Pedersen keeper

RE: Join syntaxes not all defined

H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

RE: Join syntaxes not all defined

section 6.4.1.1: ... INNER JOIN and , (comma) are semantically equivalent. Both do a full join between the tables used. Normally, you specify how the tables should be linked in the WHERE condition. ... Carsten H. Pedersen ?? Since this does not appear in the manual for v

RE: newby question about datetime fields

://www.bitbybit.dk/mysqlfaq/faq.html#ch7_20_0 / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php

RE: GUI for MySql

What GUIs exist for MySql and which is the best to use? http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_1_0 lists most of them... / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq

RE: Can field names be longer than ONE word?

. Can this be done? Try using backticks (`) instead. AFAICT, this should work with MySQL. Using such a naming strategy will also have the added advantage of making your application almost impossible to port in the future... / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk

RE: Strange results from query

minutes to complete! I'm not surprized -- you're forcing MySQL to calculate date_add on every single one of the 300,000 rows. Indexing doesn't help you there. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq

RE: Can not load database

for the database yet. Those are ISAM files. If they were created on another OS, you're out of luck. Only MyISAM files may be moved between different OS's. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq

RE: MySQL Security w/ PHP

in thousands of users for every single query - ugh... / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com

RESOLVED: C API - mysql_store_result segfaulting

() which caused the next call to mysql_store_result() to segfault. Why these did not cause any problems on the test machine is beyond me. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq I'm having some trouble moving a C

RE: can auto_increment wrap?

I hit the max. Was this feature eliminated? I missed the start of this discussion, but maybe the following explains what's going on... http://www.bitbybit.dk/mysqlfaq/faq.html#ch6_5_0 / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk

RE: Generate random, unique value...

H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

RE: Automatically adding the date to a record.

version of MySQL you're using. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php (the manual

RE: Table Names

of numbers. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

C API - mysql_store_result segfaulting

I'm having some trouble moving a C application from a test machine to production. The program, which uses the small wrapper around mysql_query() shown below, runs flawlessly on the test machine (hours of runtime; tens of thousands if not a million+ queries). On the production machine, the

RE: Proposed Guidelines for Posting to the MySQL list

is willing to read what amounts to two or three printed pages before starting posting. Human beings are simply too lazy to do that, especially when sitting with a problem they need solved yesterday. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http

RE: parse error near ???

?? / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

RE: Is it possible to Rename Database

Is it possible to rename a database? I would assume that the only way to do is is to shut down the server, then rename the directory of the database. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq

RE: query problem

-- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

RE: Convert table type

can off-load the temporary copy (i.e. the dump files) to another disk - which was an important issue in our particular case. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq

RE: Where's this script

a lot of excel files to convert to MySQL. Thanks! Search for excel2mysql on google, there are several results. If you can't follow the link, use the Google cache copy instead :-) / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq

RE: 0000-00-00 vs NULL in Date Field

defined with a default of -00-00, which MySQL then uses when you input no data. That doesn't stop you from entering NULL specifically, unless the field is declared NOT NULL. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq

RE: Dumb Question...

information about how long every query that updated the database took. The binary log is also used when you are replicating a slave from a master. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq

RE: Dumb Question...

of these things are a little hard to find in the online manual. - especially when you don't bother looking... Try starting mysqld without --log-bin. If that doesn't work, then you might want to Read The Fine Manual sec. 4.9.4, The Binary Update Log. / Carsten -- Carsten H. Pedersen keeper and maintainer

  1   2   >