offline solutions for database?

ns do they have? I was just shocked when they said that. Anyway, I don't know where to post this type of question so forgive me for posting it here. Any suggestions is greatly and gratefully appreciated! Thanks! Jordan -- MySQL General Mailing List For list archives: http://lists.mysql.co

Re: ERROR 1006: Can't create database

Thanks! That makes senses. And once I chmod as instructed, I can create directory in the mysql folder. Tom Crimmins wrote: [snip] How can find the user mysql password? The hosting company which I got the dedicated server package from set that up of course. Should I go to phpAdmin and reset that p

Re: ERROR 1006: Can't create database

go to phpAdmin and reset that password so that I know what it is from now on? Thanks again! Jordan Tom Crimmins wrote: [snip] I'm using version 3.23.58. I tried to create a database foo using phpAdmin(logged in as root) and got: ERROR 1006: Can't create database 'foo'. (err

ERROR 1006: Can't create database

s what I got: drwx--x--x 2 mysql root 4096 Sep 15 10:34 mysql So I don't know what else I can do. I can't do anything if I can't create a database. Your help is greatly appreciated! Thanks! Jordan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: querying tables in the url address?

to find an easy way to do that? -C = Chris Ripley [EMAIL PROTECTED] KOZE Radio __ Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! http://webhosting.yahoo.com/ps/sb/ -- ~~~ Bret Jordan

Installation Direcotry Question

t/sbin \ --libdir=/usr/local/mysql-test/lib \ --includedir=/usr/local/mysql-test/include \ --datadir=/usr/local/mysql-test/share \ --enable-assembler \ --with-mysqld-ldflags=-all-static -- ~~~ Bret Jordan Dean's Of

datadir variable issue

manual section 4.1.2 is says you can locate a my.cnf file in DATADIR/ but it took some time to realize that this is the datadir from the mysqld command line variable not the ./configure script datadir variable. Thanks in advance for you time. Bret

Re: newbie Q: How to display Search Results in a secure way?

Thanks millions Dan! That's exactly what I need. And I used your method and it worked beautifully! I'm so excited! Thanks again! Jordan Dan Greene wrote: > To make this back to being a MySQL question > > What if you used the encode or md5 functions when you retrieve

Re: newbie Q: How to display Search Results in a secure way?

ill didn't work. any comments? thanks! Jordan Patrick Shoaf wrote: > I am not very familiar with php, but why are you using an echo within an > echo statement? > > echo "$fname $lname width=200>$title"; > > why not try this > > echo "$fname $lnam

newbie Q: How to display Search Results in a secure way?

th my script? How can I fix that? or 2) Is there another way to achieve my goal without using the Submit button at all? Thanks for reading this and all your help. Jordan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: newbie select statement question

s for checking for me btw. Nobody wrote: > I am not sure if this has any significance - but isn't 31 Dec 1969 the day > before the UNIX epoch (1 Jan 1970 - i think)? > > Jordan, how are the dates stored in the database - as dates or unix > timestamps? > > Also, the funct

Re: newbie select statement question

quot; (and not only "="). > > On Fri, 2003-10-10 at 05:43, Jordan Morgan wrote: > > Hi, > > > > I have the following statement: > > > > echo "$tenureid"; > > > > if ($tenureid=3) > > { > > // get faculty em

newbie select statement question

by adding to those 3 fields as I want null to be a default selection. but I can't imagine why that'll mess up the if statement evaluation. It seems that the 1st if statement just runs whatever the tenureid is. Can anyone help me on this? I'm using PHP 4.2.2 and MySQL 3.23.54

Re: Unexpected $ on line XX

Thanks! Paul DuBois wrote: > At 3:29 PM -0400 9/14/03, Jordan Morgan wrote: > >Hi, > > > >Can anyone of you kindly tell me what that error usually means? The > >line number > >given is always the last line of the script and I'm sure it means something

Re: Newbies asking help with LEFT JOIN

WOW! It worked! What's the darn difference? Man, you're the greatest! I'm really really glad that we have people like you who are so willing and kind enough to help others! Your help is greatly appreciated!!!!! :) Jordan David Sears wrote: > OK, > > The server

Re: Newbies asking help with LEFT JOIN

ch > info in the mysql docs. > > -Original Message- > From: Jordan Morgan [mailto:[EMAIL PROTECTED] > Sent: Sunday, September 14, 2003 2:45 PM > To: David Sears > Cc: [EMAIL PROTECTED] > Subject: Re: Newbies asking help with LEFT JOIN > > I tried the parenthese

Re: Newbies asking help with LEFT JOIN

I tried the parentheses () first and still it didn't work. :( David Sears wrote: > That's parentheses () around the inner join, not braces {}. > > -Original Message- > From: Jordan Morgan [mailto:[EMAIL PROTECTED] > Sent: Sunday, September 14, 2003 12:56

Unexpected $ on line XX

Hi, Can anyone of you kindly tell me what that error usually means? The line number given is always the last line of the script and I'm sure it means something in particular but I just don't know. Parse error: parse error, unexpected $ in XX.php4 on line 167 Thanks! Jordan -- MyS

Re: Newbies asking help with LEFT JOIN

amp;& !empty($fname) && !empty($rank) && !empty($tenure)). So I don't know what's missing to cause her record pulled out even without the incorrect tenure status. I don't like to type too much either so I gotta learn to use the table reference thingy. ;) Any id

Newbies asking help with LEFT JOIN

n't work. With the complexity of the query, I don't know how to 1) make it work and 2) make it work using LEFT JOIN. Any help is highly appreciated. Thanks! Regards, Jordan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Newbie Question: how to set field a lookup field from another table?

MySQL through a web interface provided by my hosting company. I can use SQL statements as well as clicking a few buttons. Any advice is highly appreciated. Thanks a bunch! Jordan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

variables in select into outfile

I wan to use a variable for the outfile file name in a select into clause. I am doing something like: set @fileName="/tmp/result.text" SELECT col1, col2 INTO OUTFILE @fileName FIELDS TERMINATED BY ',' FROM test_table; the interpreter dies at the @fileName... if I exchange @filename with "/tmp/re

RE: auto_increment, creating table

forward to seeing your new book when it comes into print! Dan Jordan -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 3:02 PM To: Steve Bearss Cc: MySQL Info Subject: Re: auto_increment, creating table On Tue, Jan 08, 2002 at 04:56:52PM -0

Prevent WinMySQLAdmin from auto startup when windows 98 reboots

is rebooted? Thanks, Dan Jordan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]&

Re: [PHP-DB] Re: Yes or No

en selected in string context, you're gonna get > 'yes', which is true (it will work if one selects it in integer > context). But using characters '0' and '1' will always work, string '0' > is false in perl. -- Jordan Elver Web Developer The InternetO

Re: [PHP-DB] Searching MySQL using LIKE

like this: > > SELECT * FROM table WHERE keywords REGEXP '%keyword%'; > > If this does not work I may have the wrong string pattern, if so, do a > search on REGEXP on the mySQL manual: http://www.mysql.com/doc/. I'm sure > they have examples on using REGEXP. >

errors trying to compile programs with mysql binary

.a(my_compress.o): In function `my_compress_alloc': my_compress.o(.text+0x12a): undefined reference to `compress' collect2: ld returned 1 exit status make: *** [radiusd] Error 1 - Can someone please help me troubleshoot this. BR, Jordan

Need help with outer join...

Date Patient Name Alice Dsk Lab Type Ref PhyInt PhyRTech STech Scored Faxed NULL NULL, NULL NULL NULL NULL NONE NULL NULL NULL NULL NULL NULL, NULL NULL NULL NULL NONE NULL NULL NULL NULL

Re: Case Sensitive??

If you add BINARY to the column it WILL make it case sensitive. On Thursday 22 March 2001 22:01, you wrote: > Hello All, > > I have a table with a column called "bus_name" varchar(100) which is used > in a Business Name search form. I need to make the Business Name that is > entered into the sear

Re: Need help optimizing this (simple) query

speculation though. (If only a MySQL developer could clarify this... ;) Jordan Russell - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To re

Re: Need help optimizing this (simple) query

++-+ Adding an index for dir_id on files did not help (see my other post). Jordan Russell - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Re: Need help optimizing this (simple) query

T 1; But it actually made this query slower -- 0.07 sec instead of 0.03! SELECT files.id, dirs.name FROM files, dirs where files.dir_id=dirs.id ORDER BY files.date DESC LIMIT 1; Jordan Russell - Before posting, please

Re: Need help optimizing this (simple) query

files.date DESC LIMIT 1; And I tried reversing the column/table order; that didn't help either: SELECT dirs.name, files.id FROM dirs, files where dirs.id=files.dir_id ORDER BY files.date DESC LIMIT 1; Jordan Russell - B

Re: Need help optimizing this (simple) query

ESC LIMIT 1; SELECT name FROM dirs WHERE id=; Later I want to use a LIMIT of 100 or more so I don't think using the multiple queries will be an option then... Jordan Russell - Before posting, please check: http:/

Re: Need help optimizing this (simple) query

> You have no where clause, so no index is used. Oops, missed this part. Where exactly do I need a WHERE clause, and for what? The first query doesn't have a WHERE clause and yet it appears to be using the "date" inde

Re: Need help optimizing this (simple) query

where the time does add up... My real question is, why does MySQL not use any index to sort when LEFT JOIN is used. (Refer to the EXPLAIN SELECT output at the end of my message.) Jordan Russell - Before posting, please check

Need help optimizing this (simple) query

NULL|NULL | NULL | 5000 | Using filesort | | dirs | eq_ref | PRIMARY | PRIMARY | 4 | files.dir_id |1 | | +---++---+-+-+--+--+ + Thanks very much in advance for any assistance. Jordan Russell ---

Re: MySQL 3.23.34a - "Lost connection to MySQL server during query"

piece of the old server was still running(?). I didn't ensure the old server was stopped before I upgraded the RPM... Jordan Russell - Before posting, please check: http://www.mysql.com/manual.php (the manual) htt

Re: MySQL 3.23.34a - "Lost connection to MySQL server during query"

lem anymore. :/ I was getting it very frequently yesterday (on almost every try). I'm not sure what has changed since then. I'll let you know if the problem happens again and try to narrow down the exact steps to reproduce. Jordan Russell -

Re: Installation on RH7 box

ll of the latest RedHat updates installed, if that makes any difference. Jordan Russell - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) T

MySQL 3.23.34a - "Lost connection to MySQL server during query"

arted Same thing works fine in 3.23.33 (I've gone back and checked). Jordan Russell - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To

Indexes not used when LEFT JOIN is used?

read reports of similar-sounding problems in the mailing list archive, but I can't seem to find a working solution... Thanks. Jordan Russell - Before posting, please check: http://www.mysql.com/manual.php (the manua

+ or - in place of = does what???

First time here, sorry if this is too much of a novice question to get answered... I just sent the command: DELETE FROM users WHERE user_num+"AL011-33"; by accident (I meant to use an "=" not the "+"). It killed 81 rows. I restored the data, but I couldn't find anything in the docs about what

RE: Windows ME under MySQL?

Your pupil is right. Microsoft has done a good job of hiding DOS in Windows ME. Microsoft would like you to believe that ME is not based on DOS anymore but it must be since it is based on the Windows 9X kernel. The plan for the next version of Windows is apparently to have DOS removed completely.