Re: libexec/mysqld: unknown option '--skip-bdb'

Kris wrote: Hello, I am trying to produce an automated, reliable, and repeatable way of testing mysql releases, and I am finding an error that makes this impossible to accomplish. I am trying to compile mysql and install it in a non-standard directory. I do notwant mysql installed in /usr or

Re: Why can't I kill the query cache?

Little, Timothy wrote: Also titled, I want this to run slow ALL the time... I have a group of dreadful queries that I have to optimize. Some take 20-30 seconds each -- the first time that I run them. But then they never seem to take that long after the first time (taking less than a second

Re: selecting the 'best' match

blackwater dev wrote: I have a hold car data such as color, model, make, year, etc. I want to allow the user to answer some questions and I'll present them with the car that 'best' matches their criteria. How do I do this? I still want to return ones that don't match exactly but want the

Re: mysql problem

AZZOPARDI Konrad wrote: Hello people, I do not know if this the right listI am migrating a very basic application from an older mysql version 4.1.9-standard to a new mysql version 5.0.45 {RedHat default package}. I have migrated DB data from one to the other and all data seems to be there

Re: Can't create table

Octavian Râºniþã wrote: Hello, I've tried to create these 4 test tables, but when I try to create the last one, MySQL gives the following error: ERROR 1005 (HY000) at line 20: Can't create table '.\z\favorite_link.frm' (errno : 150) It seems that the foreign keys are not created well in

Re: failed-mysql-bugreport

Bob wrote: mysql.sock doesn't exist on the hard drive. Start the server. -- Gerald L. Clark Sr. V.P. Development Supplier Systems Corporation Unix since 1982 Linux since 1992 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Basic information: MySQL Table crash?

off the computer without a proper shutdown. Get a UPS. -- Gerald L. Clark Sr. V.P. Development Supplier Systems Corporation Unix since 1982 Linux since 1992 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Join question

1 or 10 times in one day just that it happened at least once on that day for a user. Chris W try DISTINCT. -- Gerald L. Clark Sr. V.P. Development Supplier Systems Corporation Unix since 1982 Linux since 1992 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: Finding gaps

`, MIN(b.id) - 1 AS `To` FROM tbl AS a, tbl AS b WHERE a.id b.id GROUP BY a.id HAVING a.id `To` -- Gerald L. Clark Sr. V.P. Development Supplier Systems Corporation Unix since 1982 Linux since 1992 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: Totaling from several tables away

(calories) from People INNER JOIN Meals ON People.Name=Meals.Name INNER JOIN Meal_Items on Meals.Meal_ID=Meal_Items.Meal_ID WHERE Name='Brian' AND Date='2009-09-04'; -- Gerald L. Clark Sr. V.P. Development Supplier Systems Corporation Unix since 1982 Linux since 1992 -- MySQL General Mailing List

Re: MySQL won't start with external bind-adress in my.cnf

attempt a /usr/local/etc/rc.d/mysql-server.sh restart But the server does not start until I change the address back to the LAN address. Any help would be appreciated. I have not found via Google anyone else having this issue. Does that IP address resolve to your hostname? -- Gerald L. Clark Sr

Re: Filesort on query

=latin1 Regards Phil With no where clause, and aggregate functions, it is faster to do a full table read, and the sort the aggregated results. -- Gerald L. Clark Sr. V.P. Development Supplier Systems Corporation Unix since 1982 Linux since 1992 -- MySQL General Mailing List For list

Re: why are tmp tables being created on disk?

the data is still in cache, so no read is actually made from the disc. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysqld works but not mysqld_safe

Manager Department of Mechanical Engineering University of Michigan 734-764-8482 Fridays: 734-355-6577 AIM/iChat/Skype ID: baiewola mysql does not have write privilege in /usr/local/mysql-5.0.41-osx10.4-i686/data. Is this owned by root too? -- Gerald L. Clark Supplier Systems Corporation

Re: mysqld works but not mysqld_safe

is a permissions error. Check all directories from / to the data directory. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: error in login

the user and only leaving ‘%’ with no difference at all. I’ve also tried the –protocol=TCP option with no luck either. Any pointers? TIA Hector S. Mendoza O PS. mysqld Ver 5.0.27 Use a my.cnf file in the user's home directory. -- Gerald L. Clark Supplier Systems Corporation

Re: peformance help: preventing 'using temporary; using filesort'

| ALL | NULL | NULL | NULL | NULL | 1351 | | ++-+---+---+---+--+-+--+--+--+ -- rich rpt_cpc needs an index on sourceID. -- Gerald L

Re: index question

Linux Administrator/MySQL DBA IT Infrastructure American Home Mortgage w: 631-622-6382 c: 516-652-2475 Use explain, and find out. MySQL may reverse the two and join A to B inorder to use A's index. Since there is no WHERE clause, only one of the tables needs an index. -- Gerald L. Clark Supplier

Re: Upgrading databases?

options with no luck. All tables are MyISAM. Can anyone shed some light on what I'm supposed to do? Thanks, Seth Shut the server down and run myisamchk on users.MYI -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: master status is null

, and how do i fix it. Please help regards anandkl -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: zabbix mysql problem

on this subject, please point me in the right direction? You are not looged in to mysql as a user with create privileges. You might need to backup a few chapters. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: MySql Host through Heartbeat

. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySql Host through Heartbeat

Baron Schwartz wrote: Gerald L. Clark wrote: Ben Clewett wrote: Dear MySQL, I'm running 5.0.26 through Heartbeat. Which seems to work well, even as a replication slave and Heartbeat continously stopping and starting the server. The Heartbeat moves MySQL around from server to server

Re: Access Denied When Trying to Create Database

PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql? [EMAIL PROTECTED] The show grants you ran shows you the proper syntax. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List

Re: Access Denied When Trying to Create Database

, at this point... -untz You have to be logged-in to mysql as a privileged user to grant permissions to others. Logout, and login as root. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Lock Tables Question

to be a long list), I wondered if it is possible to just lock one table, with the gentleman's agreement that in order to modify the database, every process must first lock that particular table. You could use a string lock for this. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing

Re: Lock Tables Question

, perform your updates, and then UNLOCK TABLES. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Frequently MyISAM TABLE corruption.....Pls help

limit of your filesystem, or the default maximum MyISAM size? -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Bin logs...

problem is I have a query that's failing and I can't figure it, I can't read the log file. Suggestions anyone? Use the mysqlbinlog command. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: IS NULL Question

* FROM myTable WHERE col3 = ' '; -- a space character If this is the case, you might consider using a different table type, such as InnoDB. HTH, Kevin MyISAM has no problem representing NULL. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http

Re: Should the db be shutdown before backing up?

the db) Best luck mysqlhotcopy does not require a database shutdown. If it did, it would not be a hot copy. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Permissions and Into Outfile

in the target directory. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Permissions and Into Outfile

I change the mysql home directory to some other folder? Neither. Just make sure that mysql has permission to write in the directory you want to contain the output file. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com

Re: what kind of indices to set up

with model or tyre_type, then no. The index can be used down to, but not including the first column that is compared against '%'. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Re: Stopping Replication

to do to stop the replication process? Thanks, Jesse You have to remove the master information from the slave's my.ini file. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: Trying to open a big sql script

up sending mail to Sy Serson. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Suddenly : mysqld: Can't create/write to file PID

) 070418 8:43:57 [ERROR] Can't start server: can't create PID file: Undefined error: 0 070418 08:43:57 mysqld ended HOw is this fixed? The mysql user must have execute and write privilege on /usr/contrib/var and all subdirectories. -- Gerald L. Clark Supplier Systems Corporation -- MySQL

Re: Does casing of Table names matter on Linux

! -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Mysql and FOREIGN KEY

These are not the same type. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: row count inconsistency

(*) from fidcid; +---+ | count(*) | +---+ | 100480507 | +---+ 1 row in set (0.09 sec) If this table is InnoDB, then count(*) is just an approximation. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com

Re: mysqldump on Freebsd 5 -- out of memory error

rt3 --set-variable=max_allowed_packet=256M Attachments Attachments.sql Try adding the -q option. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Safe DB Distribution

-leading spam and email virus protection. You will not be able to search on encrypted fields. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Date format question

the date in format (-MM-00). -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: [OT} How to pronounce GIF

. How do you pronounce giraffe? -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Instalation issues

manager or server[FAILED] Please advice how I can debug this error. Thanks, --Abhishek What error? -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: +1MB query gets Out of memory

over 1MB again. The only other value i could find that was 1MB was packet_size but that didn't help. What could i do to run this query? You have to change the maximum packet size on both the server and the client. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List

Re: mysql on a NAS

) is there a better, more performant way, to install mysql in a cluster ? See 'MySQL Clustering' BY Alex Davies and Harrison Fisk MySQL Press 3) Just your general idea about this setup. Thanks Stefan Stonki Onken -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List

Re: Backing up large dbs with tar

other db writes during this operation? Thanks, Van Look at mysqlhotcopy. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Can't create database

would be appreciated. Best Regards, MG perror 28 Error code 28: No space left on device You need more disk space. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: Manually Inserted Data

', '-00-00' as z ) ORDER BY z, Start ASC, Status DESC, Time ASC a Does anyone see my mistake? Keith -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Mysql -e Select Fields Enclosed By and NULL values

clause. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: £ (Great Britain Pound) breaks MySQL insert and update - disastrous overwrit e

on the querylog, and see what query mysql is actually getting. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: CREATE TABLE Inv_Id

numbers. They are composed of a casecode prefix, a manufacturers id, a partnumber, and a check digit. You cannot use an autoincrement number as a UPC. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: updating table but afterwards there are duplicate entries that violate a key..

duplicate (tagid, taggerid, objectid) rows. Is there a way to remove duplicate rows like this? Thanks for any pointers!! Peter Use ALTER TABLE IGNORE and put the key back. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com

Re: Quick way to determine existence of an index?

an extremely bad idea to me. You don't want to have any indicies you don't actually need. They will slow down all inserts and updates. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Running a Staging and Development DB on the same server?

database? Just connect to the proper database when you start your application. mysqladmin create testdata mysqldump production | mysql testdata -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Conditional copy of values

cannot add a rowid that already exists. Please help. I am using MySQL version 4.1.14-standard-log. Hence subqueries are not a solution. Thanks, Ravi. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: What happened to left join under version 5?

5.0.22 -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL operators

they are status 6 or not, i need to have a comparison on approveddate, it is either between the two dates or null, but is status 6. ( Approveddate between '2006-09-14' and '2006-09-21' or Approveddate Is Null ) Your query returned all rows where approveddate is NULL. -- Gerald L. Clark Supplier Systems

Re: 2 versions of mysql on Unix: problem with the socket

the socket. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Decimal versus Float Point Type

, and dollar calculations must be rounded to the nearest cent, or mill. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: 1 to many relationships

and Click Add issue, i need that issue to associate with that customer, every Customer Refrences the same issue table Then it is many to many. Many customers are associated with many issues. i have Customers /Issues as tables, -- Gerald L. Clark Supplier Systems Corporation -- MySQL

Re: Load Data Infile and newlines

load data infile '/share/store/library.csv' into table library fields terminated by ',' enclosed by '' lines terminated by '\r\n'; Any help appreciated. Mark You need to quote the actual linefeed character, not a backslash n. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General

Re: Tricky query

(SELECT * FROM keyval inner WHERE outer.key = inner.key AND inner.val = 9) ... Br, Morten How about: SELECT DISTINCT `key`, COUNT(`key`) AS c FROM `table` WHERE `value` in (8,9,10) HAVING c=3; -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list

Re: Tricky query

(SELECT * FROM keyval inner WHERE outer.key = inner.key AND inner.val = 9) ... Br, Morten I forgot the GROUP BY How about: SELECT DISTINCT `key`, COUNT(`key`) AS c FROM `table` WHERE `value` in (8,9,10) GROUP BY `key` HAVING c=3; -- Gerald L. Clark Supplier Systems Corporation

Re: Check out this Free software I found to document your IT infrastruct

action just like a mailing list owner will do. Feel free to send me a private email if you have more concerns. Regards, Will L Nabble.com Well, he also spammed the Centos Forums. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http

Re: [5.0] Left Join Problem

ON tab_d.id = tab_a.id WHERE tab_a.id = 'value' LIMIT 1; -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Distinct problem

INNER JOIN table3 AS t3 ON ??? LEFT JOIN table AS t2 ON t1.item_id = t2.item_id AND t1.dt t2.dt WHERE t2.item_id IS NULL; -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Re: mysql hangs on connection attempt

. this is a really tough bug, so any help would be GREATLY appreciated. thanks, steve connec -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: datetime issue on MySQL 4.x

the imported data, there should be June 28, June 29.until July 7. Please help and many thanks for any reply. Regards Willy Because you specified only for the month of July. AND MONTH(date_time) = MONTH(NOW()) -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List

Re: Trying to understand why Select running out of memory if table not used

' maybe this will fix... -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Allow user to create databases, but limit all privileges to other databases

there is a post regarding this exact same issue, and I was originally going to add a 'me too!' response to that post, but the registration system for the forums seems to be broken and I was never able to successfully log in to post. You asked the same question 2 hours ago. -- Gerald L. Clark Supplier Systems

Re: Multiple joins

am not sure whether you intend them to be LEFT JOINs or INNER JOINs. Try: SELECT fields FROM file1 LEFT JOIN file2 ON something INNER JOIN file3 ON something INNER JOIN file4 ON something INNER JOIN file5 ON something WHERE somecondition -- Gerald L. Clark Supplier Systems Corporation -- MySQL

Re: Recommended backup scripts for mysql databases

in advance exactly how much space it will take... Tim -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: why didn't I insert small number into table?

this occured and how to avoid this? Thanks in advance. Xiaobo Double defaults to double(16,4) and you have more than 4 decimal places. Try double(16,10). -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: error loading data from file ERROR 1329 (02000): No data - zero rows fetched, selected, or processed

the command you used to load the data, we can't tell you what is wrong. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Left Join Help

, -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Left Join Help

| +++---+-+-++---+ I need to be able to run the full query on a daily basis without killing the DB engine. The query needs to pull in about 50,000 results. Does anyone see a way to optimize this query or rewrite it so it doesn't cause a huge system load? Thank you, -- Gerald L

Re: MySQL 4 Kernel Panic-ing

30 20:11:17 PST 2005; root:xnu/xnu-517.12.7.obj~1/RELEASE_PPC How could a user space program like mysqld possibly cause a kernel panic? Sounds like bad kernel or bad hardware. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com

Re: Question on full text search scores, different content same score

titles that are similar. I also tried IN BOOLEAN MODE as well. Thanks, Mark Perhaps because '(' and ')' are ignored, and 'MLM' is a three letter word, and not indexed. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: correct syntax

about LIKE % % -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: ADVICE: Best way to store multi values

Assuming you have table staff with an id and name, and title with id and title, You create a join table. Staff_id Title_id 1 1 1 2 2 1 2 3 Then: Select name,title FROM staff s , title t, jointable j WHERE s.id=j.staff_id AND j.title_id=t.id; Mark Worsdall wrote:

Re: Sending data status

You are joining 5 tables with an OR on only two relations. Give it a year !! Surat Singh Bhati wrote: If I run the following query , mysql server process hangs forever and it shows the "Sending data" status. select Count(*) from Registration,Candidates,CompanyJobs,Resumes,CandQual

Re: MySQL data structure

Asaf Maruf Ali wrote: Hello. I am interested to know the structure of MySQL. My ref book "MySQL and mSQL" by O'Reilly states that for a table named book under a database Test following is the structure: book.ISM book.ISD and book. frm On my system MySQL 3.23.27 beta the structure

Re: Read/write table lock

Fabio Galarraga wrote: Yes, I think this is the problem. But how can I make a read/write lock with only one lock? Best regards, Fabio. -- De: Gerald L. Clark[SMTP:[EMAIL PROTECTED]] Enviado el: Martes, Marzo 20, 2001 04:33 PM Para: Fabio Galarraga CC

Re: selecting null values

Title will never be = NULL. NULL is not equal to anything, not even NULL. SELECT * FROM table WHERE title IS NULL LIMIT 1; Peter Szekszardi wrote: Hi, I have a database which has a text field (let's name it title). The field is NULL initially. Now I have about a hundred thousand records

Re: replace qeustion

That depends. Just the one 9, or all instances of 9 in 'C'? This is a basic SQL question, not a MySQL question. I would suggest finding a book on SQL. You could try: update Table_1 set c=20 where a=10 and b=18 and c=9; This will guarantee that only the first line ( O one just like it ) will be

Re: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)

Well, since PHP is trying to use a socket in the wrong directory, you might check the PHP list to see if they can help you. This is not, strictly speaking a MySQL problem, so waiting here for the correct answer may not be the quickest route to the answer. I have seen several answers indicating

Re: (yet another) sock issue

Charles Mgnin wrote: Although the my.cnf file specifies socket = /tmp/mysql.sock the server expects mysql.sock to reside in /var/lib/mysql [mysql@localhost]$ /usr/bin/mysqladmin -u root -p password Enter password: /usr/bin/mysqladmin: connect to server at 'localhost' failed

Re: [Fwd: Re: problems with linking]

edit /etc/ld.so.conf add a line for the directory that contains your library run ldconfig Alonso Guarisma wrote: Dear MySQL Sirs (or Andrew Schmidt) Please see attachament for error messages. Thaks in advance for any help. Alonso Guarisma Original Message Subject:

Re: select ... having bug?

Having works on the result table, not the source tables. Since you did not select cnt, having can not examine it. Maybe you ment 'where' instead of 'having' ? \"Piotr Gapinski\" wrote: small problems with query below... my fault? mysql desc poll_answer;

Re: MySQL 3.22.32 and RedHat 7.0

Add execute permission to mysql.server. It is compiled without it. Tim Thorburn wrote: Hello, I'm a MySQL newbie (hopefully, there's a few others of me around so I won't feel like I stick out so much). I've setup a Linux box running Red Hat 7.0 with Apache 1.3.12, PHP 3.0.18, and

Re: mysql 3.22.32

houda chraibi wrote: Hello everybody, I have some pb to administrate mysql, I can't create a new database error: you are an anonymous localhost I just can create a new tables in database already exist. what can I do , please help m!!! Read chapter 6sss!!!

Re: Question for the mysql install..

You mus use GNU tar. wrote: Hello!! I have a question for the mysql install. Type of mysqlsource distribution Mysql Versionmysql-3.22.32.tar.gz My System SunOS stachyonbse01 5.7 Generic sun4u sparc SUNW,Ultra-60 After upload gunzip mysql-3.22.34.tar.gz

Re: Can't connect server through socket /var/lib/mysql/mysql.sock(111)

It is more likely /tmp/mysql.sock tmp has no 'e'. denis mettler wrote: Hi, I did. but the problem is the same. regards denis On Tuesday 20 March 2001 17:45, you wrote: try: [mysql] mysql.default_socket = /temp/mysql.sock Cal http://www.calevans.com -Original

Re: How to put and get gziped file to/from mysql db

Did you quote the data before inserting it? [EMAIL PROTECTED] wrote: Hello I am looking for help how to put gziped plain data file to mysql DB and then get it from there. Every time I try OUTFILE to file and then gzip -d file name I got file corrupted Any help will be appreciated Leo

Re: Read/write table lock

Fabio Galarraga wrote: Hi to all: Somebody knows how to make a read/writa table lock? I'm trying with java source: stmt.execute("LOCK TABLES table-x READ, table-x WRITE"); stmt.execute("UNLOCK TABLES"); but it fails. Best regards, Fabio Galarraga [EMAIL PROTECTED] Well

Re: Best column type for an IP address

Jason Bell wrote: Hello all! Does MySQL have a function that converts an IP address from dotted decimal to binary, and back again? Jason Bell INET_NTOA INET_ATON I'll leave it as an exercise to you to read Manual Chapter 7.4.12.

Re: error with mysql configuration.

Make sure all directories in the path to your mysql.sock file are world readable and searchable. Abid Ghufran wrote: Dear All, I am trying to setup a web based email setup on RedHat Linux 7 platform. I am using Horde 2.2, Imp 1.2, Php 4, Apache 1.3 alongwith the following rpms required

Re: Add password to a existing database/table

Read chapter 6 of the MySQL manual. It is explained there. Nyon wrote: Hi, I am a newbie in Mysql and is confused about setting login/passwords. Just want a simple security measure as I am the only user. Here's the scenario: I managed to connect using PHP to mysql via the

  1   2   3   >