Re: mysql BLOB field -- need help

nd ADO. > Thanks. As far as I know a BLOB is just a TEXT with string comparisons defaulting to be case sensitive. Have you tried storing whatever data you're handling in TEXT fields to see if that works? Just a random thought. :-o //C -- Carl Troein - Círdan / Istari-PixelMagic -

Re: Changing auto_increment field in mysql to start at 1000

impossible due to uniqueness constraints. What auto_increment does is this: "When you insert a value of NULL (recommended) or 0 into an AUTO_INCREMENT column, the column is set to value+1, where value is the largest value for the column currently in the table." //C -- Carl Troein - Cí

Reply-to and this list

le to stop the same questions from reappearing, and if there's something this list has too much of it's the same questions over and over... :-o //Círdan -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user s

Re: Primary Key pairs and auto-incrementing

s, but could you please point me to the chapter in the manual where this is discussed? I just can't seem to find it. :-P //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org

Re: duplicate delete query

index to the email column as you should've done in the first place if you didn't want duplicates. :-) //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since &#

Re: Reply-to and this list

as long as I don't post to the list I won't have the problem of getting my inbox filled with duplicates of replies. Hmm.. that could work. //Círdan - will be quiet now. MySQL newbies go RTFM instead. ;-D -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] |

Re: how to write procedure.

C - points out that the second sentence is missing a verb. -- 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: On Redhat 7.1

ead of TCP/IP? Can you connect using the command line client (mysql)? That's all I can think of. :-o //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned

Re: Determine Percentages

two queries and use the result of the first when constructing the second, or (if you're just doing raw SQL instead of using some script language) do it to a temporary table which just contains the sum of all Packets. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PR

Re: Query help needed

ngle value you could just do that query first and then use it when building the main query. Also, please do set your time and time zone to the correct values. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user

Re: Query Question

gt; > '%TOMMY%' OR Notes LIKE '%TOMMY%' order by Title > > > > What I need is to have the results that match Title LIKE '%TOMMY%' to > > appear first and then the rest. > > ORDER BY !LOCATE('tommy',Title), Title should

reach the hard limits!? (fwd)

as of now. Once I get the system I'm working on running I might get some experience of hitting the 2GB barrier. :-o //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmag

Re: Question on root login

ayon" but only will allow > connecting to "localhost" Carefully read the documentation on mysql's privilege system. What's probably missing is access for [EMAIL PROTECTED] (or simply @yourhost, since it's the transalted IP addy that's being used. I don'

Re: HTML Checkbox -> php -> MySQL SET

warning and you'll get the string 'Array' in the query. Use implode() if you want a comma-separated list. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndn

Re: mysql c api

nty of those available on the net. The easiest to find would of course be for the client programs that come with mysql. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89,

Query Question (fwd)

... order by check desc, Title Even simpler would be SELECT Title FROM ... ORDER BY !!LOCATION(Title, 'Tommy'), Title although I don't know if it would be any faster. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.or

Re: Query Help

Islam, Sharif writes: > I have this two table. LEFT JOIN -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud o

Re: Design question from newbie

per line. This will be less convenient to handle as it's muss less general, but on the other hand I saved some much-needed space. (Some numbers: old: 12 bytes per row (19 with overhead), times 38 rows = 722 bytes. new: 100 or 133 bytes. Multiply with 3 per input file and 1000 for the number

Re: Column name in Big 5

hy ÿ is not allowed in names. The only special thing about that character is that it has a special meaning in telnet, but that can hardly be relevant, can it? //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user sin

Re: About 123box.co.uk

123box.co.uk, > and the owner of the 123box.co.uk email address seems not > to be active on this list (correct me if I'm wrong). Therefore > I think it would be in the interest of this list to have any > subscribed address at 123box.co.uk unsubscribed. > > If the list owner is

Re: Help somehow turn this into a single query

ecord just later than this record's date. Do it in two queries or be prepared to take a performance hit. Honestly I can't even think of a way to do it with just one query, but looking into using SQL variables might help. I'm not sure, though. //C -- Carl Troein - Círdan /

Re: Loosing(sic) Autoincrement

scott.alexander writes: > > Why would I loose(sic) all of a sudden my autoincrement feature on a table. Did it pass CHECK TABLE, and if not did REPAIR TABLE help? If not, try myisamchk -o, but make sure you're not using the table when you do it. //C -- Carl Troein - Círd

Re: problem with count (*) max (*) min (*)

Antonio Ortega Sancho writes: >I'm trying to do select count (*) from table. but it doesn't work Try count(*) instead. -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and

Re: COUNT elements in a LIMIT query

o emails as well. -- 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, pleas

Re: newbie:

d you try connecting with telnet like the manual suggests? -- 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: transaction tables

sactions I'm sticking with MyISAM for now. //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. ---

Billionium Bug (fwd)

-- 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. --Forwarded message -- Return-Path: <[EMAIL PROTECTED]> Delivered-To: [EMAIL PROTECTED] Recei

Re: SQL query

if it doesn't, since it'd probably mean that you've found a bug in mysql_query(). My guess would be that your script gets stuck in a loop somewhere. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga u

Re: Select where A is not a member of B

ons? > > SELECT DISTINCT userid FROM userlist WHERE listid != thislistid > might be what you want. > > -- > Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 > [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ > Amiga user since '89, and damned proud of i

Re: Should We purchase mysql license Under Windows 2000??----Please Help!!!

? I have limited space on my account and on my HD, and this is a high-traffic list as it is. http://rfc1855.x42.com/ is a good place to start if you're new to the concept of mailing lists. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.

Re: UPDATE with automatic INSERT if not found..

rse you could skip the first UPDATE and try the INSERT immediately, but this will probably be less efficient since most of the time the first UPDATE would be all that is needed. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~ci

Re: Creating new user

Access denied for user: 'admin1@localhost' to database 'mysql' Isn't it rather obvious? If you don't have permission to create new users, you don't have permission to create new users. The same goes for altering their passwords. //C -- Carl Troein - Círdan / Is

Re: Phone Puzzler

the brains of the world!!! Indeed it isn't. SQL doesn't include a shortest path algorithm. It's easy enough to implement Dijkstra's algorithm (unless you want use Fibbonaci heaps, in which case it's a wee bit trickier). I suppose this is a task for which stored procedure

Re: How To

Tabitha Ridwan writes: > How to install MySQLGUI under redhat 6.2 ? What about it? Are you wondering how to do it? Have you tried and failed? If so, why don't you want to let anyone know what you did and what errors you got? Vague questions deserve vague answers. -- Carl Troein

Re: Managing MySQL /w large tables

record_buffer=1M & Of course, otherwise there'd me no point in having them. If you have a gigabyte of RAM I see no point in not letting mysqld use at least a few hundred megabytes or so just for buffers. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | h

Re: Oops... I think I deleted mysql.sock - WHAT CAN I DO?

Felipe Baytelman writes: > Oops... I think I deleted mysql.sock - WHAT CAN I DO? Just restart mysqld and it'll be created. -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned pr

Re: mysql password

victor writes: > can mysql use the linux password /etc/passwd for the authentication No, and it'd be a _really_ bad thing to do anyway. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since

Re: How to find socket #

ket, which on a typical mysql installation will reside in /tmp, /usr/local/mysql, or somewhere else (I think). If you can't find it, look in your my.cnf or figure out what the default is for your mysql build. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED]

Re: SQL GUI-Based Table Creation Tools?

rested in a stand-alone application such as MySQLGUI. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned prou

Re: safe_mysql...

are command-line parameters. -- 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: Mysql List Bounce Message?

s something similarly braindead. If someone from MySQL reads this, PLEASE do delete whatever domainhost.com address is causing this problem. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89,

Re: new user.

think so. http://www.mysql.com/doc/S/H/SHOW_DATABASE_INFO.html -- 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: storing images in MYSQl database

images, such as where to find them in the file 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: Alphabetical AUTO_INCREMENT?

f this column was alphabetical > instead. I'd be surprised if there's a way to do it. But what is stopping you from converting numbers to char codes? Look at the string functions in the manual. //C mysql, database, bullshitfilterthatdoesn'twork -- Carl Troein - Círdan / Istar

Re: DB dumpfile import error.

ant is probably the (ANSI standard) VARCHAR(length) type. //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: null columns after loading

u don't tell it? :-O You need to specify SEPARATED BY and possibly some more stuff. Look at the chapter on LOAD DATA INFILE in the manual and all will become clear. Hopefully. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.or

Re: My SELECT is still returning the same rows

hat contain 'award' but not 'section' and that match the other criteria? Could it be that you're confusing OR with some other operator, like XOR or AND NOT? //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMA

Re: creating database

s. Read the manual on how GRANT works and things may become a little clearer (although that part of the manual _does_ need more information. But _I_ ain't gonna write it. Not today, anyway.) //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.

Re: REGEXP and PHP Forms

ubmit" value="GO"> This looks very very broken. Head over to the php manual and look at the examples there. -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/

Re: Multiple field separators

enclosed-by=," but your fields aren't enclosed by commas. If they were, it would look something like this, assuming that they were separated by commas: ,26 Sep 2001,,,05:42:24,,,Text message to be read., //C -- Carl Troein - Círdan / Istari

Re: Hassle with standard SQL queries

Tobias Bohlin writes: > Get in trouble with: > SELECT COUNT (DISTINCT V_CODE) FROM INVENTRY; > - SYNTAX ERROR Two errors in your query: MySQL doesn't allow you to insert whitespace between the function name and the parentheses, and you've misspelled inventory. :-o //

Re: why would LOWER

Joe Kaiping writes: > Is it expected that using the LOWER function should greatly increase query > time? The way you do it, yes. Is that email column a BLOB or a BINARY VARCHAR? If not, why on earth do you do LOWER() on it? And do you have an index on the column? //C -- Carl

Re: How to delete diferent lines in 2 tables ?

;s no way to specify more than one table when doing DELETE or SET. -- 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: ISAPI & MySQL

fe version of the mysql client library. A good place to start would probably be http://www.mysql.com/doc/T/h/Threaded_clients.html //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and

Re: Yes or No

ed. I use tinyint(1) in all places where I need a boolean, and it works fine for me. I've seen rumors about bool being an alias for tinyint(1), but it's not in the manual and I haven't tested it. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | ht

Re: Hazardous problem making arithmetic operation on date fields.

Malko Malko writes: > mysql> select date,coef,sec_to_time(time_to_sec(date*coef)) from testdate; Why do you multiply the date with a number and then convert it to a number? Shouldn't it be the other way around? :-O //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353

Re: HOW: Getting a list of connected users?

David Ayliffe writes: > Is it possible to get a list of all users currently connected to a mysql > server? Preferably the login name they use? Any ideas? http://www.mysql.com/doc/S/H/SHOW_PROCESSLIST.html -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PRO

Re: Multiple queries

eries, which (if I didn't glance too briefly at) them was 2. //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: Mysql -3 installation problem

l MySQL server through socket '/tmp/mysql.sock' Did you by any chance forget to actually _start_ mysqld after installing it? If so, start it. //C - ever so helpful -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns

Re: AW: Order By & Limit; Count

Ashwin Kutty writes: > The query I tried is:- > SELECT * from table1 WHERE title LIKE %keyword% ORDER BY title LIMIT 0,10; The quotes are missing around the string constant. -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~

Re: Installing PHP with MySQL

do with MySQL, no luck. Did you install all 5 RPMs or just a subset of them? As far as I can tell, you need to install the RPM that has 'devel' in its name. If you've already done so and it still doesn't work, try locating the files with 'find', or something. //C --

Re: Left Join problem

the window criteria into a temporary > table. Right? That's unnecessary. Use an ON condition instead, i.e. ... LEFT JOIN table ON field=value WHERE ... //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga us

Re: Problem with a specific select

to > repair it If you get an error message, be sure to read it. :-O Run a REPAIR TABLE on the table, and then it should work. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user sinc

Re: inserting images

of assuming that every function call succeeds, and print sensible error messages when things fail. At the very least take a look at mysql_error(). Actually printing (and looking at) the query that fails would not be a bad idea either. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280

Re: Yes or No

ere's absolutely no need to send both to the list and to my email address. //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: Yes or No

E bar" will return all rows that don't have '' in bar, which is not the expected behavior if bar is a boolean. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned

Re: need help setting up and rinning mysql server

Error messages can be found in the error log, which the manual discusses here: http://www.mysql.com/doc/E/r/Error_log.html -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga u

Re: my sql driver

0 prof. If what you're lacking is a JDBC driver for MySQL, have a look in the MySQL manual. There are links to a couple of different drivers. http://www.mysql.com/doc/J/a/Java.html -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org

Re: Migration to mysql from MS SQL Server

s worth of redundant irrelevance when you post. //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. - Bef

My attitude (Was:Migration to mysql from MS SQL Server)

int out that his date was wrong. Anyway, if there is some sort of consensus here that I should leave (or be nice to people), I might consider doing so (or possibly so, but that's a lot less complicated). //C - Never loses his patience, but sometimes his sanity -- Carl

Re: MySQL performance and limit

will/won't it be? Also, what file system (for linux) do you recommend? ReiserFS or ext3 or something else? //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user sinc

Re: AW: Date interval problem

These are the ones that end before tab2.interval starts or start after tab2.interval ends. I didn't realize this blindingly obvious fact until I made a take of all the comparisons and positions of the intervals and started looking for boolean operators to separate the cases as easily as possible.

Re: privileges for SHOW PROCESSLIST

the manual, seeing as how it's a common source of questions. I'd do it if I knew more about it, but I don't. (Per definition, more or less.) //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '

Re: UPDATE IGNORE

ich there of course is (or you wouldn't be needing UPDATE IGNORE). I know this isn't a good solution, but it's the best I can think of. I'd rather just upgrade to 3.23 though. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmag

Re: error when installing mysql, plz help

unless you're fairly sure that your mail didn't get through, i.e., wait for other mails to appear, and check if they were sent after your mail. (This list has a tendency to send mails in burst. I'm not sure whether this is because of the server or the users' habits.) //C -

Re: help with resequencing...

ou didn't specify the start value, you've found some sort of bug. :-o //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: I am getting crazy!!!

.. maybe that would be a useful feature. I wonder if Monty can create telepathic code that knows what the user wants. :-o ) //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, an

Re: where to put a txt file to fill a table?

th to the file in the query? Don't rely on mysql's current directory to be something specific, but give the full path to the file instead. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user

Re: Antigen found VBS/VBSWG_based@mm.Worm (Norman) virus

l post, but I'd expect other mailers to cope better. Ah well, no harm done, AFAIK. //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: load data infile problems

he standard escape character (backslash)? Of course if you have fields with " represented as "", you can forget about what I said, make sure all your fields are in enclosed in " to resolve ambiguities, and if it doesn't work report it as a bug. Or something like that. //C -

Re: load data infile problems

as a bug. In the meantime, I guess you'll have to search and replace before inserting into the database. :-/ //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~c

Re: selecting rows where all rows meet a criterion

7;s average, right? Something like "SELECT DISTINCT s.id FROM students s LEFT JOIN grades g ON g.id=s.id AND g.grade > s.average AND g.year=2000" ought to do the trick. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.

Re: enum errors - what is the correct syntax?

f "WHERE !field" you'll have to write "WHERE field == '1'". Because of this, I've ended up using TINYINT(1) instead, but if you're really concerned about space requirements, you should consider using a CHAR(0) _without_ NOT NULL. Now that's an

Re: Formatting Large amounts of Text into Mysql

look at the non-standard WRAP attribute to the TEXTAREA tag. WRAP=hard outght to work in most browsers. //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: select stmt problem

and GROUP BY work, you'll see that the grouping is done _after_ it's known what rows there are to group and what they should be grouped on. What you probably want to use is HAVING for the 'counts = 10' part. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMA

Re: into outfile error

e specified where mysql will write to? It will write where you tell it to, if that location fulfils the criteria listed in the manual. I think mysql chdir()s to the data directory, but I wouldn't rely on it. Entering the full path isn't all that work anyway. //C -- Carl Troein -

Re: Histogram?

erts any value into the number of its box. A simple example would be SELECT FLOOR(col1/10), COUNT(*) FROM table1 GROUP BY FLOOR(col1/10) //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, an

Re: Autoincrement

want to clean it up before it goes live. //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. sql, database, anal-retentive filter -

Re: Problem with query

at x = NULL returns something which appears to be undefined rather than something well-defined (such as false all the time) or an error (which could be said to be well-defined, if errors are considered to be valid responses to queries...). //C -- Carl Troein - Círdan / Istari-PixelMagic - U

Re: Generate random, unique value...

two-column table and sort on the random number. //C - pondering quasi-random numbers -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since &#

Re: Mysql extensions

html > Thx in advance > Stef Hmm... not Stef from User Friendly, I hope. Noo... he'd never join about something technical. :-) //C - needs his daily UF fix -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user

Re: Generate random, unique value...

course! Ah, how true. All of it. It is more complicated, and although I see some points, I don't they're very strong ones. :-o //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] |

Re: createing database

ing everything as root or ''. That you're able to SELECT VERSION() is not very strange. You're logged in as the anonymous (or nameless) user, and you don't need any privileges to SELECT without a FROM. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL

Re: createing database

alhost' (using password NO) mysql --help shows you this: -p[password], --password[=...] Password to use when connecting to server If password is not given it's asked from the tty. In other words, you must specify -p (without a password) if you want to be as

Re: Mysql query optimiser performance question (second post)

t starts to return rows. Try executing a query that would return a billion rows, and get just a few before aborting. Also try joining ten tables with a million (or a billion if you wish) rows each, and look at what the optimizer does (with EXPLAIN). //C -- Carl Troein - Círdan / Istari-Pixel

re: installatin problem

n think of is that you don't have write access to the data dir, but since mysql_install_db worked, that shouldn't be the case. BTW, I've installed mysql at work w/o being root, and I didn't have any problems aside from having to add the location of the client shared lib to LD_

Re: How Can I Set CurrentDate As Default Date

the manual, did you? In the chapter on CREATE TABLE, it says this: "Default values must be constants. This means, for example, that you cannot set the default for a date column to be the value of a function such as NOW() or CURRENT_DATE" Consider using a TIMESTAMP, or insert NOW() whenev

Re: rearranging id's

bly dumb thing to do, 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 -

Re: rearranging id's

aranteed never to change. And just think 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] |

Re: Query speed

to that string constant, 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-PixelMa

  1   2   3   >