Bug: BINARY, NULL, and GROUP BY

Hours after I left this mailing list, I found a bug in 3.23.47. Since it's so easy to reproduce the bug here, I'll let this example speak for itself: CREATE TABLE t1 (txt varchar(10) default NULL); INSERT INTO t1 VALUES ('aaa'); INSERT INTO t1 VALUES (NULL); SELECT BINARY txt AS t FROM t1 GROUP

Re: 4208 Golden Investment Opportunity 185261

[EMAIL PROTECTED] writes: OTC News Alerts' Last 3 Picks have gained 358%! Here is our next Hot Pick! That's it. I'm out of here too. //C - wonders what the list owner gets for letting the spam in. 10%? -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http

Re: 'got file handler' error

, or some other table type? You're not using the 2.2.14 Linux kernel, right? And ermm.. well, that's all I can thin of now, except.. you didn't run myisamchk on the table while mysqld was running. No... nobody does that. Except me, once, and it didn't do much good. //C -- Carl Troein - Círdan / Istari

Re: apostrophe's in PHP MySQL

, the user would just have to supply the value \' OR 1 to turn the query into DELETE FROM t1 WHERE str_field = '\'' OR 1 which would delete every single row in the table. If there weren't a good reason for addslashes() to exist, it probably wouldn't. //C - paranoid, but for good reasons -- Carl

Re: recovering (with keycache) MyISAM-table problem

for someone here to see if it is indeed a bug. //C - mostly blaming himself if something crashes. -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too

Re: command mysql -u $user without typing it ????

mysql=mysql -p //C - thinks that'll do it. -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting

Re: command mysql -u $user without typing it ????

want user@% to be matched when you connect from localhost. Could that be it? If so, section 4.2.8 is your (rather dull) friend. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud

Re: SELECT MAX makes MYSQL Crush (??)

in in the database? That doesn't make much sense. Why would you want to store more than 4 gigabytes per table row? And what sort of data is that anyway? Since you'll probably not have very many objects of that size, why not use the file system? //C - giving his screen a funny look -- Carl Troein - Círdan

Re: Newbie Question about working with datetime column

offset from your current local timezone. And of course you must know what TZ the server has. The number of hours might not be an integer, btw, but I'm pretty sure the number of seconds will. //C - earlier than usual -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED

About spam

figure out how to restrict posting to subscribers only, how hard can it be? As far as I have seen, it's quite rare with serious posts from non-subscribers, whereas the spam and empty bug reports arrive at a rate that's on the order of mails per day. //C - annoyed -- Carl Troein - Círdan

Re: General Query time question

. If that won't work, but it's not important with perfect accuracy, you could run that evil SELECT once a day or however often you like, and cache the result. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user

Re: General Query time question

, an index will not be used because the overhead of using the index will be greater than the benefit. If this is the case, you'll be better off without the index, and you could consider one of the two options I rambled about in my previous mail. //C - sorry 'bout that. -- Carl Troein - Círdan

Re: count(distinct

Ilic writes: SELECT count(distinct ip) FROM pole_voti It does'nt work. Why ? What's your MySQL version? Check the docs to see what version is required for count(distinct). I think it was added in 3.23.early, so it might be time to upgrade. //C -- Carl Troein - Círdan / Istari

Re: General Query time question

to suggest anything. I just wanted to raise your awareness of the possibility of such a solution. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. mysql

Re: serious password problem

is a special value (meaning connection over unix socket rather than TCP/IP), and it's not matched by % in this case. You need to grant access to user@localhost as well. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga

Re: serious password problem

how things work is http://www.mysql.com/doc/C/o/Connection_access.html It's probably a good idea to remove the entry for ''@'localhost'. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned

Re: problem with mysql connection

problems seem to be that mysqld is not running or just plain old messed up file permissions. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too

Re: Changing part of field

, '@', 1), '@comcat.net') WHERE email LIKE '[EMAIL PROTECTED]' //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too

Re: UPDATE SQL statement

2002. //C - forgets things -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please

STDDEV_POP

STDDEV_POP() which returns the population standard deviation, so I thought that maybe it'd be a good idea to implement this in MySQL as well. What do you think? //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user

Re: Largest System

running on high-end machines. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please

Re: What's the behaviour of mysql when no room on filesystem for databases

to get full before it actually did, and so you should've had time to make more room for the database. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too

Re: Function in index

to make sure that the data in that column is what it's supposed to be (with respect to what's in the longer column). //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. mysql

Re: Very Urgent

if you don't have a problem, consider buying one just to support them. After all, without the money they wouldn't be able to do as much developing as they do. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user

Re: Very Urgent (sic)

. -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http://www.mysql.com

Re: Table Locking...

Shannon Kendrick writes: Does anyone know of a way to lock at the row level instead of table level using MySQL 3.23.46 Yep, use InnoDB instead of MyISAM tables. //C - person of few words. But surprisingly seldom. -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL

Re: temporary table permissions?

tables, and give the user CREATE on that. It's a pretty clean solution, except that it'd give you two rows in mysql.db instead of just one, and you'd have to use database.table[.column] when accessing it. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http

Re: Query help

places. You could possibly use a INSERT...SELECT to a temp table, and then REPLACE from that, although you'll probably need to do table locking to avoid losing simultaneous updates to the table. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http

Re: Locked out

in with mysqladmin either. What exactly are you doing and at what point does it fail? Could you post the contents of your terminal window after failing? //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89

Re: Location of text file for loading data in to table

) //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http

Re: mysql server not starting!

for all IPs? -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. MYSQL MYSQL MYSQL - I hate that bloody 'spam filter

Re: matching an option from SET list

a bitwise AND (), when what you want is probably just a plain equality (=). //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too

Re: Problems installing mysql-4.0-alpha on my Redhat

is to be expected. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http

Re: connecting to mysql from different computer

is a potential security hole. This is certainly true for mysqld, where the default privileges are very permissive. //C - pissed off at procter gamble for screwing up his shampoo. -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga

Re: A News Group Perhaps.

-- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http://www.mysql.com

Re: ADV: Dear Future Millionaire: (very OT in a way)

can get rich by sending us spam? :-o //C - In insane conspiracy theory generation mode -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too

Re: unknown data base

intending to do a SHOW TABLES? Unknown database Just a hunch: Have you actually CREATEd the database? That is, have you done a CREATE DATABASE phpbook? Note that it's legal to grant permissions on databases that haven't been created yet. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN

Re: Does Mysql Have TRIGGER ??????

is to have stored procedures implemented in MySQL 4.1. We are also looking at triggers. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too

Re: ERROR 1006: please help

. Check the permissions on the data dir. Maybe you did a chown -R ... * instead of chown -R ... . when you gave it to the user? //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud

Re: Does Mysql Have TRIGGER ??????

Pragneshkumar Gandhi writes: It doesn't, and IMHO the manual is clear on this: The planned update language will be able to handle stored procedures. Our aim is to have stored procedures implemented in MySQL 4.1. We are also looking at triggers. Hi Carl Troein Sorry Boss LOL

Re: ALTER TABLE error

are is irrelevant. However, what MySQL user you are is not. You should read the chapters on privileges and security, and ask your ISP to do so too. You shouldn't be able to connect as the anonymous user. BTW, your clock is off by ~65 minutes. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN

Re: problem with LIKE when I'm using Ukrainian

manually. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http

Re: Trouble with InnoDB: Error message file errmsg.sys doesn't have enough messages?

to the section on line length in the netiquette FAQ. -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before

Re: optimize for SELECTs on multiple large tables

). What're the table structures (most importantly: what indices exist)? What does the data look like? What did EXPLAIN return? Anything else we should know? (that's a catch-all question from a sleepy and intoxicated person, in case you're wondering) //C - scratching his beard -- Carl Troein - Círdan

Re: queries on particular table produce errors

not completely mistake (could very well be, tho). //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too

Re: mysqladmin reload not rebuilding GRANT information

on host names (maybe not a good idea unless you can control the DNS server and/or hosts file) for additional security. This, of course, assuming that the name-address mapping isn't absolutely constant, but it rarely is. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL

Re: mysqladmin reload not rebuilding GRANT information

cache. The only thing that seems to be missing is some way to have entries live a fixed about of time, but since you can FLUSH HOSTS every now and then, or turn off the caching completely I don't think it's a real problem. //C - learning -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280

Re: Size of table's MYD file?

and every DELETE might be considered overkill, at least if you're not deleting a majority of the rows. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too

Re: Comparing an alias ...

columnconstant. //C - not wearing his glasses -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting

Re: linux, mysql and intel processor or amd processor

a dual AthlonMP @ 1.2GHz, 1GB RAM, 100GB IDE HD, and a nice-looking fulltower with lots of fans. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too

Re: Changing the socket location?

thousands of positions wrong in the list. //C - about to change to pine. Seriously. -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too

Re: html ina text feild

some unwanted pre- or postprocessing of your data, such as escaping some HTML entities? //C - vague -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too

Re: html ina text feild

users. -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http://www.mysql.com

Re: Security problem in Access database

. So what can i do if i want to make a login page to user which the password will be able to match the password in Mysql.User table. See 1. //C - hungry -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89

Re: Yet another can't connect problem

there. Shouldn't it be /var/... and not var/... ? Oh, and unless your mail system had some sort of a problem, your date is off by almost exactly one day. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89

Re: Problem to log to the database with password.

password: YES) localhost is a special value not matched by wildcards. You need a separate row in the user table for web@localhost. It might also be wise not to allow access from every computer in the world, unless you have good reason to do so. //C -- Carl Troein - Círdan / Istari-PixelMagic

Re: select into dumpfile

the file system permissions. Make sure whatever file you try to dump to is really writable by whatever user mysqld runs as. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too

Re: affected rows and found rows

that occurred during the UPDATE. I believe this answers your question. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too

Re: Is converting string to integer possible?

to to this in mySQL). Yes, string_expression+0 will be an integer. It's not pretty, but it works. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too

Re: Is converting string to integer possible?

uptime this morning, and my Amiga1200 has now been running for 59 days without a single reboot. I have yet to see windows do that. :-D And... oh my, it's freaking snowing outside. Aarrghhh! //C - doesn't like cold weather -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL

OT (was: Is converting string to integer possible?)

Jerry writes: How did you know I have an Amiga??? I know everything about everybody. I'm god. :-) Or actually, I just looked at the mail headers. But hey, you can still call me god if you want to. ;-D //C - more diabolic than divine -- Carl Troein - Círdan / Istari-PixelMagic - UIN

Re: Move a column

might have some archeological curiosity value. ;-) //C - listening to Iron Maiden while drinking tea. -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too

Re: corrUPted tabLE questions...

that you don't repeat whatever you did to get the table corrupted. killall -9 mysqld is a BAD idea, as is messing with the table files when mysqld is running. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since

Re: Question on auto_increment

with a DELETE without a WHERE. //C sql -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting

Re: default values

respectively. Also, columns that can be NULL can have a default of NULL. On an altogether unrelated matter: Your time zone is set to pacific time, but your time reveals that you're somewhere on the American east coast. You might want to correct your TZ. //C - defaults to being tired -- Carl

Re: GUI for OSX

prefer other GUIs. //C - ponders pizza -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting

Re: width and height performance

of members (20). //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http

Re: Can't connect via IP, but can via hostname

device (lo0) is up, right? Does your config say something about what post to use? When you try to connect, does netstat -a give you any useful information? //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since

Re: About huge numbers

floating point precision I'm aware of (under normal circumstances, that is) has onle 80 bits, and quite a few of those are used for the exponent. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned

Re: Zip Code proximity search

need to index at least one of latitude and longitude. BTW, I don't want to spend time loooking at it, but... does your expression really work near the poles? //C - three-dimensional -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org

Re: Timestamp allways zero zero

into the number 0. Lose the quotes, and the stuff between the parentheses. (NOW() doesn't take any arguments.) //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too

Re: Newbie: Can't get GRANT to work

for this. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http

Re: order by, group by

GROUP BY date) GROUP BY date,score which would return an arbitrary person for each date's top score. I hope this makes sense and clears things up. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89

Re: Can't connect via IP, but can via hostname

at mysql database probably the problem comes from there My MySQL is not configured properly... I can connect using localhost with -h flag , but when I'm using IP instead of hostname it doesn't connects at all... -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL

Re: Can't connect via IP, but can via hostname

Carl Troein writes: http://www.mysql.com/doc/C/a/Can_not_connect_to_server.html Oops. That only convers the difference between 'localhost' and anything else. If whoever posted the question is interested in actually getting things to work, read the manual chapter on how the privilege system

why ever use TINYBLOB/TEXT -- isn't VARCHAR same size? (fwd)

for CHAR is the most important difference and the reason I use them for names of things (I use TINYTEXT/TEXT for longer descriptions etc.) //C - with a runny nose, a cup of tea, and a glass of Laphroaig mysql, database, bloody, filter, die, die, die. :-P -- Carl Troein - Círdan / Istari

Re: How to decrement int field?

filter-bait: sql, database, nostril-hair -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting

Re: Any possibility for userstamp column type?

different mysql users that one application switches between based on what application-level user is using the application, but that's about it. //C - expressing his $0.02 worth of thoughts. -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http

Re: Load Data with extra field

.: INSERT INTO foo (a,b) SELECT 10,b FROM tmptable //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before

Re: mysqladmin: error

. Have a look at the man page for ldconfig or search the web for LD_LIBRARY_PATH if you want to know more about them. //C - learning -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud

Re: help with newbie (mis)understanding of related tables

number after all, at least as long as you use some form of INT for your primary keys. //C - hopes everything is clearer than his sinuses -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud

GPL and MySQL (was: New fork of MySQL)

will think of aquiring something that might be available to their customers for free. My counter-argument would be that if someone wants to pay us to incorporate it into a proprietary product, some sort of value has to be added, and that is what people will pay for. //C -- Carl Troein - Círdan

Re: MySQL.Sock Missing

on this in the FAQ. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http

taiwan.com

, or should I just ask the admin of my mail server to add a filter? //C database,sql,query,table -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too

Re: Beginner SQL Question

/ANSI_diff_Sub-selects.html //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check

Re: 127.0.0.1 problem

sockets. It's special to the clients, but also to the privilege system. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too

Re: Beginner question - getting last inserted ID

What you're looking for is probably LAST_INSERT_ID(), but I'll let you find it yourself. Oops, now I told you. :-P //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too

Re: Beginner question - getting last inserted ID

is extremely fast, so it doesn't really matter, except that it's a bit more work to make an extra query. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too

Re: why index stops to work ?

to index boolean columns, unless you have a very uneven distribution and run ANALYZE TABLE while you have such a distribution. Question to the list: Is the last part of what I said correct? //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http

Re: New fork of MySQL

between two separate programs. So when they are used for communication, the modules normally are separate programs. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too

Re: New fork of MySQL

into swift and merciless action. //C - always merciless, never swift. Or possibly the other way around. -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too

Re: Newbie MySQL Install Question

allow a SSH connection from a remote machine? You need to install some SSH daemon. I bet there is one or two to choose from on the Redhat CDs. Have a look at what RPMs are named something that starts with ssh or SSH or something like that. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN

Re: Where UPDATE documentation?

you're supposed to do anyway). //C - has 60 mails to read now for some reason. -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too

Re: Help !!

not make any sense. The manual is crystal clear on how to do it. Have you read the entire chapter 4 and appendix A.4? And please correct your date. It's off by a couple of days. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org

Re: Need source codes.

. //C - thinks 20+ line .sigs should be illegal -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before

Re: Query speed

, unless it's the special -00-00. Really, what you want to consider is all dates between 2001-08-01 and 2001-08-31, right? The why not use something like WHERE date BETWEEN '2001-08-01 AND '2001-08-31'? //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http

Re: Importing fixed-width delimited large text files?

to get a tab in the shell. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting

Re: PHP4 and MySQL

, downloading large files is not always ideal to do. :-) There are plenty of mirrors, but they're all pretty well-connected to each other, so I think they mostly exist to provide a primitive form of load balancing. :-P //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL

Re: rearranging id's

, but if having nicely consecutive values is more impostant than referential integrity, be my guest. :-) (If it's your only table I guess it doesn't matter, but who uses a relational database without relations?) //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http

Re: rearranging id's

of the mess you get when you decide to change the type of a column that you've used as a foreign key. It's bad enough to have to choose between the four int types. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga

  1   2   >