Re: Sorting by relevance? [SOLVED]

Thank you Roger! :) This works well for me! ^_^ Thanks also to the other guys that I replied. :) Ang sabi sa akin ni Roger Baklund noong 06:12 AM 5/10/2005... "This way" and only four rows in the example is a bit vague, but maybe something like this could work for you: $crit = 'Ang'; # test case

RE: innodb problem (with JDBC/transactions)

al transaction wasn't released, and perhaps the database did not even receive or process the COMMIT. Is anyone having similar problems, and hopefully found a solution? Thanks, Erik -Original Message- From: jean-philippe [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 10, 2001 4

RE: innodb problem (with JDBC/transactions)

e. PLEASE HELP! JDBC Driver: mm.mysql-2.0.6.1.jar MySQL: mysql-max-3.23.42-win Thanks, Erik -Original Message- From: Heikki Tuuri [mailto:[EMAIL PROTECTED]] Sent: Friday, October 19, 2001 3:11 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: innodb problem (

RE: JSP newbie needs to run MySQL-JDBC.

Are you sure MySQL is listening on port 80? The default port is 3306: jdbc:mysql://192.168.1.2:3306/ -Original Message- From: Benj Arriola [mailto:[EMAIL PROTECTED]] Sent: Monday, October 29, 2001 10:56 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: JSP newbie n

RE: Need to repair InnoDb tables

table. Erik -Original Message- From: Heikki Tuuri [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 17, 2001 2:20 AM To: [EMAIL PROTECTED] Subject: Re: Need to repair InnoDb tables Brent, maybe you have moved .frm files around? If there is an orphaned .frm file for a table without a

Re: Field name DESC

How about desc_ ? Erik On Jul 13, 2006, at 8:42 AM, Anthony wrote: Hello, i want to know how i can create a table with the feild name "desc" ? when i do: CREATE TABLE bank ( name varchar(50) NOT NULL default '', desc varchar(50) NOT NULL default '', )

Vertical Tab problem

er v in it. Any ideas would be great. Erik -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Vertical Tab problem

Brent, Both worked like a charm. Thank you so much. I kicked myself for not thinking of CONCAT. Yes, Filemaker joy. Actually I have another word in mind. But with you help and expertise we are slowly walking away from Filemaker. Erik On Jul 14, 2006, at 7:02 AM, Brent Baisley wrote

Re: Assistance avoiding a full table scan

Brent, I tried this and it definitely boosted performance. On a test query that would take 2+ seconds to run with 20 id's - it ran in 0.002 seconds. Thanks everyone for your help and comments. Erik On Sep 21, 2007, at 2:01 PM, Brent Baisley wrote: As others have mentioned,

Re: Performance problem - MySQL at 99.9% CPU

t) and see if there is one query that's particularly problematic, perhaps optimizing the indexes etc on the table might help with the performance. Also, make sure your HD's aren't full... that will kill performance very quickly if the needed disk space isn't there.

Re: Performance problem - MySQL at 99.9% CPU

dependent on your code etc) but I have seen on a shared host machine I'm on my resource load drop in 1/2. Freeing up those resources for other tasks (like MySQL.) Good luck! Erik On Jan 8, 2008, at 5:47 AM, Gunnar R. wrote: Thank you Erik! HDs are OK, a couple of GB free. Not tha

Storing Larger MySQL Backups

aller segments so I can distribute the data over 2 DVD-R (or multiple CD-R's if so desired.) Does anyone have any feedback on this approach? Without laying out money for a higher capacity DVD/BlueRay drive or tape backup system, what options are you using for data retention? Thanks for

What about binary files? [was: Re: transfer huge mysql db]

MySQL Documentation: http://dev.mysql.com/doc/refman/5.0/en/moving.html Erik -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Where are actual databases stored?

RedHat centric systems store them in /var/lib/mysql On Feb 8, 2008, at 2:55 PM, Riccardo Perotti wrote: Hi all: Our sistem crashed and we're trying to recover our data. The disc is fine but the OS is gone, so I'm trying to get at the actual mysql databases document. Does anybody know where

Re: % wildcard host permission not working

Did you "FLUSH PRIVILEGES"? I'd also check that the username and passwords are the same for each host entry, I've had problems if passwords were different for a shared username from different hosts. On Apr 24, 2008, at 8:58 AM, Adam Gerson wrote: I set up a user and entered % for the host.

Assistance avoiding a full table scan

is to avoid the full table scan? Thank you in advance for your assistance. Erik Giberti -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Sorting by relevance?

I just learned a lot stuff at http://dev.mysql.com/doc/mysql/en/sorting-rows.html including sorting by number-to-text, text-to-number, names, specific values, etc. However, the document didn't mention on how to sort by relevance. For instance, someone search for "Ang": COLUMN NAME: name COLUMN T

Mysql replication with 2 masters and 1 slave

Is it possible for slave to connect to 2 different masters and have synchronized database from both? Planning to have one backup mysql backup server that's has to synchronize/backup 2 master server. Followed the manual and got master / slave up and running without problem. Can I use something e

RE: Mysql replication with 2 masters and 1 slave

Yes. The idea was to backup 2 masters, 1 that is ours and 1 that is a costumer. The slave's job is just going to have a synchronised db of both servers db. The plan was to have it on a different place in case of fire. But I must find another solution then. Erik Olsen wrote: > Is it

RE: Secure way of storing passwords in the database

=SHA1("$password"); $password is the user's input password. Regards, Erik Osterman http://osterman.com/ -Original Message- From: David T-G [mailto:[EMAIL PROTECTED] Sent: Friday, November 07, 2003 9:05 PM To: mysql users Cc: Luis Lebron Subject: Re: Secure way of stor

RE: Update table with UNIX_TIMESTAMP

le; or even... SELECT FROM_UNIXTIME( start, '%m/%d/%Y' ) as start_date FROM table; For more information go to http://www.mysql.com/doc/en/Date_and_time_functions.html Hope that helps, Erik Osterman http://osterman.com/ -Original Message- From: Ron McKeever [mailto:[E

RE: help on my query statement

UNT(*) FROM TRANSACTION WHERE REGDATE < Now()-INTERVAL 15 DAY GROUP BY WHAT Would let you know how many times WHAT happened 15 days ago. Regards, Erik Osterman http://osterman.com/ -Original Message- From: Roger Baklund [mailto:[EMAIL PROTECTED] Sent: Sunday, November 09, 2

RE: Aliases

However, you can use HAVING. HAVING is post-processed, in a brute force method (no indexes can be used). Select invno, invdate, invamt, left(invdate,2) as month from salesfile HAVING month = '01' But I would use Roger's example since it can take advantage of indexes.

RE: Aliases

> From: Matt W [mailto:[EMAIL PROTECTED] > Sent: Monday, November 10, 2003 5:47 PM > To: Erik Osterman; [EMAIL PROTECTED] > No, Roger's method can't use an index. :-) But yes, using WHERE is > better than HAVING. Ah... right indeed. In this case it wouldn't wor

RE: Aliases

urate generalization: Indexes may be used where a function's input domain does not reside in the table itself. Unfortunately for David, he's still SOL. Let's see, what else am I neglecting? =) Regards, Erik Osterman http://osterman.com/ -Original Message- From: Leo [mai

A question on INTERVAL

wonderful date & time functions to accomplish what I am trying to do? I'd like to avoid using approximate techniques such as using 86400 seconds for a day, since calculating months and years _accurately_ is very involved. P.S. DATE_SUB(created, INTERVAL subscriptions.term subscriptions.un

Re: MySQL IMAP Server

Pretty sure dbmail can use mysql. www.dbmail.org -Erik --- Ben Clewett <[EMAIL PROTECTED]> wrote: > Paul DuBois wrote: > > > > I believe the Horde IMP server uses MySQL: > > > > http://www.horde.org > > Thanks. Looking at this, I belive it's

query re: Innodb Table Locks

the table lock? i would really appreciate a reply Best Regards Erik DeBattista Systems Developer Webcraft Ltd. --CONTACT DETAILS--- www.webcraft.com.mt Email: [EMAIL PROTECTED] Tel: +356 21421540 Fax

query

the table lock? i would really appreciate a reply Erik DeBattista Systems Developer Webcraft Ltd. --CONTACT DETAILS--- www.webcraft.com.mt Email: [EMAIL PROTECTED] Tel: +356 21421540 Fax

query

the table lock? i would really appreciate a reply Erik DeBattista Systems Developer Webcraft Ltd. --CONTACT DETAILS--- www.webcraft.com.mt Email: [EMAIL PROTECTED] Tel: +356 21421540 Fax

another xml thread

ng up the wrong tree, but storing data in flat files doesn't seem to be the only way to use XML. I don't plan on beginning this project for a couple of weeks at least, so it's not really important. Again, if this is an inappropriate question for the list, send me pack

Re: another xml thread

they were talking, but kept > insisting on their point. But I did not have a second look, so I am > not sure if I am mis-remembering. Yes, there was a lot of back-and-forthing. Thanks, Erik Erik Price Web Develop

Can't restart MySQL after innodb table filled up

is causing the crash 020304 11:33:02 mysqld ended - I've also tried changing a few values in the my.cnf file including changing the number of threads to 1 and increasing the size of the DB to 600M. Is this a known bug? Thanks, -- Erik B

bumping up table values

ed "prefix" and the new bumped-up "base" value, telling user what to label the CD (i.e., "45:109"). This seems like a lot of steps, and almost a kludge to me. But then, this is the first web application I have written ever, and up until now all of the database

Syntax question.

Hi, Trying to figure out how to convert Sybase ASA syntax to MySQL. Need to select alpha ranges as in: SELECT * FROM table WHERE name LIKE '[A-Z]%' but this doesn't work. Appreciate your help, Erik Schwartz Systems Engineer InfoUSA 818-428-1040 [EMAIL PROTECTED] --- Ou

Re: time zones?

TIMESTAMP data type as a convenient way to keep tabs on when a row was modified, if doing date arithmetic on the column is a concern. Erik Rantapaa [EMAIL PROTECTED] On Fri, Apr 12, 2002 at 09:26:33AM -0400, Bradley Brown wrote: > I would like to second this notion if I may. > I was up unti

table-building advice requested

ntedfiles ADD COLUMN source ENUM('files', 'userfiles') to qualify the file_id as belonging to either a "files" record or a "userfiles" record. But I am wondering if this is really a good idea -- when I need to query for all records in "print

Re: table-building advice requested

uot; file_id or a "user" file_id. It doesn't seem very smart to have a setup like this. So I think I should go with the big "files" table and just have some columns that apply to some kinds of files and not to others. Is this done? I'm just hesitant to have a l

Re: Selecting Information Just Inserted

hy this function is better than doing SELECT MAX() on that column. Erik Erik Price Web Developer Temp Media Lab, H.H. Brown [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the ma

Re: LAST_INSERT_ID()

ill end up with a result for each row in that table, unless you use a WHERE clause. Erik Erik Price Web Developer Temp Media Lab, H.H. Brown [EMAIL PROTECTED] - Before posting, please check: http://www.m

Re: MySQL on OS X

to /usr/lib/libSystem.dylib, which is a link to /usr/lib/libSystem.B.dylib I'm running 10.1.3, with the Dec2001 Developer Tools installed. Perhaps it was provided by those, do you have them installed? Erik Erik Price Web

Re: AW: MySQL on OS X

e two different ways to put MySQL on your Mac OS X system: Install the precompiled binary, or build your own binary from source code - The MySQL binary on the web site, that is built for "Mac OS X", does NOT need to be compiled, so you do NOT need the developer tools to use i

Re: how to get support help?

problems for you, one that welcomes bitching when things don't go your way. In other words, do you want your money back? Erik On Thursday, April 25, 2002, at 12:11 PM, Clay Loveless wrote: > At this point, I'd like to solicit tips on how I might get my support > related conce

Re: how to get support help?

hat are essentially "RTFM" > questions/answers, I'm stumped on why a legitimate, undocumented problem > doesn't seem to be a concern to anyone but me. Did you submit a bug report? http://www.mysql.com/doc/B/u/Bug_reports.html Erik PS: way off the subject, > a p

Re: how to get support help?

e person, though you're correct -- this does not reassure them that their problem was heard. Erik Erik Price Web Developer Temp Media Lab, H.H. Brown [EMAIL PROTECTED] - Before posting, please check: http

Re: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

fic socket location at compile time? If so, use that. It would look something like: /usr/local/mysql/bin/safe_mysqld --socket=/path/to/socket Good luck Erik Price Web Developer Temp Media Lab, H.H. Brown [EMAIL PROTECTED] --

Re: Order by

e best way to sort your data. Most likely you'd do a similar thing as above in PHP, so why not just save the extra processing cycles by doing it in the database? Erik Erik Price Web Developer Temp Media Lab, H.H. Brown [EMAIL PROTECTED] -

Databases with Tables approaching several million

l was optomized to be fast, and would not be able to handle databases of large sizes and I'm just wondering if this is largely true or not. Thanks, Erik Fears - Before posting, please check: http://www.mysql.com/manu

mulitple uses of a foreign key

project_id = 8 AND projects.canceler_id = people.people_id, or projects.finisher_id = people.people_id, depending on whether the project was finished or canceled. But I also need to be able to determine from the query whether the project was finished or canceled. Thanks! Erik Erik Price Web Develo

is this query possible?

"sub1other" column is NULL in one record, then I'll use the value of sub2other to do what I want to do, and vice versa). But this just doesn't seem possible. I can always do it with two separate queries if need be, but it would be elegant to do it with one. Any advice? T

Re: MySQL not starting ?

mysqld ended Are you really only using one hyphen before "user"? Try using two: [root]# safe_mysqld --user=root & Erik Price Web Developer Temp Media Lab, H.H. Brown [EMAIL PROTECTED] - Before post

Re: is this query possible?

t way to do it. Erik On Friday, June 14, 2002, at 04:05 PM, Luc Foisy wrote: > How bout > > SELECT main.id, sub1.other, sub2.other FROM main LEFT JOIN sub1 ON > main.sub1fk = sub1.id LEFT JOIN sub2 ON main.sub2fk = sub2.id > > Luc > mysql,sql > >> -Orig

Re: Reconstructing SQL create table statements

tch. Just chop off the contents if you only want the CREATE TABLE statements. Erik Erik Price Web Developer Temp Media Lab, H.H. Brown [EMAIL PROTECTED] - Before posting, please check: http://www.mysq

Re: getting totals with data

lts that are handed to the PHP script and turned into HTML low) would yield the LIMITed number of rows, whereas I'm trying to determine how many rows would be returned if I had not used LIMIT (the "total hits" part of "displaying X through X of X total hits"). Thanks f

slow-queries.log vs. explain

I've been monitoring slow-queries.log to try and find querys that might be causing problems. I see the following logged: # Time: 020903 16:59:14 # User@Host: cfweb[cfweb] @ storm.centurytel.net [10.10.1.17] # Query_time: 47 Lock_time: 0 Rows_sent: 5 Rows_examined: 145240 SELECT

VIRUS on the list

I got this Virus warning concerning this person: Original message header is included below. Received: (qmail 10967 invoked by uid 7797); 22 Aug 2001 07:42:01 - Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm (http://www.ezmlm.org) List-ID: Precedence: bulk List-Help:

Apache 1.3.17 and mod_auth_mysql problem.

version has been released in years. Are there any other (maybe better) authentication modules for apache and mysql? Regards, Erik Tjernlund Stockholm, Sweden - mailto:[EMAIL PROTECTED] | http://erik.tjernlund.net "I was so much older then

tmp_disk_tables vs. tmp_tables

ble= record_buffer=1M set-variable= tmp_table_size=16M set-variable= max_heap_table_size=32M set-variable= sort_buffer=8M Redhat Linux: 2.2.14-5.0smp MySQL: Ver 10.12 Distrib 3.23.27-beta, for pc-linux-gnu (i686) (still on a beta version is b

Re: tmp_disk_tables vs. tmp_tables

en to disk. Temp tables are initially created in memory and only written to disk if they become too large, correct? Queries that use group bys and sort bys will create temp tables, regardless of index usage, correct? If so, then that would explain most the the temp table creation for our installation.

Re: Too Many Connections

| db | Command | Time | State | Info | +--+-+++-+---+---+--+ .... Good luck, Erik - Before posting, please check: http:

MySQL question

MySQL, how much support is "minimal" support? What will you guys answer and not answer if they do not pay for the support? (I have recommended to my clients to go with the $200 a year package, but this was one of their questions before making a decision.) Thank you for your time! E

Re: Query: Error 2002 Can't connect to local mysql server.

/mysql/mysql.sock (this config should startup mysqld with default socket to /var/lib/...) Regards, Erik On Fri, 23 Mar 2001, Foresight Systems Ltd. wrote: > Dear Sir, > > We are trying to install and configure mysql version .23.32 on Linux Red > Hat 7. > Usinf the configure optio

client problems

ust stalls at the splash screen when I try to run it. Can you tell me where to get a client that works? Thanks, Erik [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manua

Re: MySQLGUI for MacOS 10.1

Hi, Nice to see Mac users out there. There seem to be some equivalent interfaces. I haven't tried them yet, but go to www.stepwise.com and click on the softrack link and then the MacOS X one. I found my mysql version there. It was nice to be able to install with a double click. /Eri

creating a Unix socket

or program that I can use to create the socket? Any advice would be greatly appreciated, I'd like to avoid recompiling the whole distribution if possible. (If that is not possible, is it simply a matter of not having the /usr/local/mysql/run directory set up at compile time?) Thank y

Re: creating a Unix socket

ket option? -- Erik PS: the documentation at mysql.com is incredible. --- Bill Adams <[EMAIL PROTECTED]> wrote: > Erik Price wrote: > for > > some reason I assumed that the socket would be created dynamically > when > > I started the mysql daemon. > > It does.

mysqld shutdown

th-unix-socket-path=/usr/local/mysql/run/mysql_socket Although I confess I am very new to MySQL and am not sure how to use the debug yet. Thanks for anyone who can help!!! -- Erik = Microsoft e[X]tra [P]roprietary -- Is this where you really wanted to go today ? -- http://www.redhat.co

Re: failer to start the mysql server

discovery. check this page: http://www.mysql.com/doc/C/a/Can_not_connect_to_server.html Erik --- "R.Neubert" <[EMAIL PROTECTED]> wrote: > and this is wrong: > > [root@linux mysql]# mysqladmin reload > mysqladmin: connect to server at 'localhost' failed > e

Re: HELP - Setting up MySQL on Mac OS X 10.0.4

inary install, there's Fink or Marc Liyanage's packages: http://fink.sourceforge.net http://www.entropy.ch/software/MacOSx/mysql/ Fink is well worth it, it is a port of Debian's package management for Darwin (and there are plenty of ports available through Fink). Erik = Micros

Re: Need A book for dynamic website

I was having a great deal of trouble following the text. I took it back to the store to get the DuBois book. Erik --- Webmaster <[EMAIL PROTECTED]> wrote: > > Hi, > I need a book to teach me how to make a database driven website, I > think php > mySql is the way to go and have s

Re: mysqld shutdown

--+--+ | 4 | root | localhost || Query | 0| | show processlist | ++--+---++-+--+---+--+ mysql:localhost~:$ I'm assuming that this says that the only query is the actual "processlist" command itself, so it doesn&#x

Re: mysqld shutdown

irectory, and start over from ./configure ? I'm new to compiling from source, so I don't know what the standard procedure is. Thanks, Erik __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com

Re: mysqld shutdown

en Hmm... isn't this the same thing as /usr/local/mysql/bin/mysqladmin -u root -p shutdown ? Either way, I tried it... cd to /usr/local/mysql/bin and then ./mysqladmin -u root -p shutdown... same effect. Note that on my system, safe_mysqld is located in /usr/local/mysql/bi

Re: mysqld shutdown

ards, > Sergei Interesting! I'm using Darwin 1.3.1 (from Mac OS X 10.1.0), which was partly derived from one of the BSDs (I think it was FreeBSD in fact). What was the fix that was used? Maybe I can get it to apply to this situation. -- Erik _

Re: mysqld shutdown

n suggest Darwin-friendly ./configure options. Interesting that the first (50-line commit) patch to FreeBSD's libc_r was almost three years ago to the day! Erik --- Dan Nelson <[EMAIL PROTECTED]> wrote: > In Mysql 3.22.11, the signal was changed to SIGTERM and a signal > handler w

shutdown still a problem on Darwin

Does anyone have any advice? Suggestions? Input? Help? I really appreciate anyting anyone can add to this situation. Thanks in advance, Erik PS: if you respond directly to the list, please CC me as I am a "digester" and won't get your response until the digest comes out... ___

Re: shutdown still a problem on Darwin

would be. Thanks to Sinisa, Sasha and to anyone who has input on this situation, Erik PS: do you advise that I beta-test the upcoming MySQL version? I would be open to this idea, especially if it fixes my problem, but I am working in a production environment and so would be best served with as

I think I have a solution! (was: mysqld shutdown)

amchk first, every time I wish to re-load ("refresh") the information? I understand that my database probably won't become corrupted every single time from a "kill -9" command, but it is likely to happen at some point as I will be doing this daily. Does anyone think that thi

Re: shutdown still a problem on Darwin

stable server, so I'm not worried about any connections being open, but won't the grant tables be accessed when I execute mysqladmin shutdown? Oh... right, I'm not executing that. Alright, that's good news! Thanks! Erik ___

List Info

generating a new web page for every email I get is kind of slow) -- I look forward to getting a "proper" email address sometime soon. Erik = Microsoft e[X]tra [P]roprietary -- Is this where you really wanted to go today ? -- http://www.red

Re: Dumb Question: Listing tables in telnet

Todd, The "arrow" is like the PS2 prompt from your shell in Unix. That is, the first line of your command says Mysql> and every line thereafter is just a "greater-than". This is because the mysql client is waiting for more commands. You can enter more than one command at a time this way, and

Re: Nusphere is spamming me (this is cheese)

doesn't offer anything that you can't get at www.mysql.com (and you can get a lot more at the latter). Nothing technically illegitimate, but shifty nonetheless. -- Erik --- Andy Woolley <[EMAIL PROTECTED]> wrote: > For a long time now Nusphere has been treading on far too many

argument to --with-mysql option for PHP

hat it is '--with-mysql=/usr/local/mysql' , but I wanted to make sure. Thank you, Erik Price PS: Just to re-clarify about my system, it is: Darwin 1.4.1 running beneath Mac OS X 10.1.1 Apache 1.3.22 with DSO capability enabled MySQL 3.23.44 (source install) installed in /usr/local/mysql

RE: argument to --with-mysql option for PHP

hp4.so did not get built during the 'make'. And I assume that this happened because the 'make' process could not find the lmysqlclient.so . Am I very far off the mark in this guess? Thanks to any who can help with this quandary! Sincerely, Erik Price --- Ravi Raman <[EMAIL

does lmysqlclient.so exist in 3.23.44 ?

I need it for my PHP4 > Apache DSO compile. Thank you, Erik __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo

RE: does lmysqlclient.so exist in 3.23.44 ?

so file. Thanks for your suggestions, though -- if I don't hear back about lmysqlclient.so then I'll just have to do it with the built-in MySQL support and worry about mod_perl later in the future. Erik --- Ravi Raman <[EMAIL PROTECTED]> wrote: > Hi again. > > Why w

Re: Mac OS X and MySQL 3.23.45

do I find out what options are compiled into the binary? I'm not sure. Someone else could take a stab at this? I use the source and 3.23.44 has worked fine for me (except the shutdown problem). I'm going to compile 3.23.45 now and see how it goes. Erik = Microsoft e[X]tra [

the official name of 3.23.45 source

hp" source code files in my source code directory over time. The 3.23.44 file was called "mysql-3.23.44.tar.gz" , but I don't want to make an assumption about the filename. Thanks! Erik - Before post

Re: the official name of 3.23.45 source

Thanks! I'll change the name from "download.php" to "mysql-3.23.45.tar.gz" in my source directory, and I'll remember the valuclick mirror. I'm assuming that's in N. America somewhere. Erik On Monday, November 26, 2001, at 11:29 AM, Mike(m

Re: Mac OS X and MySQL 3.23.45

ied it once) but this setup seems to work for me -- the "bin/mysqladmin shutdown" command works great now!! (No more "flush tables ; kill -9 %1" or any of that!) My thanks to the developers for taking into account the needs of Darwin users in their work -- we won't be a mino

display size of integers

t is the point of specifying a width? I only see it being useful in combination with the ZEROFILL attribute, which would add leading zeros up to the display width if the number is fewer characters than the display width. Otherwise, it seems to serve little purpose. Would anyone mind

Re: HELP! Hosed Database!

ch as /apache/mysql/lefeber). I think the command you want to try would be something like cat lefeber.txt | /apache/mysql/bin/mysql -u MyUserName -pMyPassword lefeber Try that, it seems to make more sense (though I am hardl

Re: Mac OS X and MySQL

ly have a fully-supported desktop Unix implementation with plenty of open-source AND commercial software available. I guess I'm biased, though. Don't knock it if you haven't used it, OS X/Darwin is awesome. Erik On Monday, November 26, 2001, at 05:20 PM, Paul DuBois wrote: >

PHP install w/MySQL difference question

ory? Thanks to any who can help me -- and I apologize to those who are becoming annoyed with these questions! Once I get this up and running I will do my best to never bother anyone again! -- Erik - Before posting, please c

Re: Please redo this horrible web page

ey have provided the documentation, mailing list, archives, and the software itself for FREE, this is something that you can pay for. You know, your suggestions are actually helpful, but the tone with which you deliver them invalidates you as

Re: Please redo this horrible web page

money back, and found a better way to spend it. So, while I can understand your frustration, I guess that begs the question -- do you want your money back? Erik On Wednesday, November 28, 2001, at 04:29 PM, john wrote: > Erik, > >Thanks for your input. I had no idea of wh

Re: How To Install Under MacOS X?

ce code. I used to think that was hard core, but now I prefer it over the GUI or binary installs. Feel free to contact me directly if you have a problem, I just got MySQL up and running on Mac OS X the other day. --Erik On Thursday, November 29, 2001, at 08:29 PM, Kundan

WAY OFFTOPIC: Re: How To Install Under MacOS X?

t is taken from NeXT. (anyone care to clarify?) -- Erik On Thursday, November 29, 2001, at 11:53 AM, Todd Williamsen wrote: > I am going to take a stab at this... > > Since MacOS X is actually an open sourced kernel, I would assume you > could use the Linux or Unix version to i

Designing a database to track files

| | || | | || | | ++---+---+ I'm trying to give the name "division1" and get the name "picture1" back. W

Re: Designing a database to track files

. And also for the tip about using single ticks. Sincerely, Erik On Friday, November 30, 2001, at 01:53 PM, Jens Vonderheide wrote: > That's nearly correct. You could use > > SELECT files.file_name > FROM files, divisions > WHERE files.file_id = divisions.div_id >

  1   2   >