Re: MySQL 4.0.26 has been released

2005-09-08 Thread Diana Soares
Just a note: the main site still reports version 4.0.25-0. I dowloaded version 4.0.26 from a mirror, but it was necessary to tweak the URL. Congratulations for this fantastic project, Diana Soares On 9/8/05, Joerg Bruehe [EMAIL PROTECTED] wrote: Hi, MySQL 4.0.26, a new version

Re: Suppression of result in SELECT @temp := column?

2004-09-02 Thread Diana Soares
= whatever LIMIT 0,1 \n SELECT -- Diana Soares On Tue, 2004-08-31 at 23:00, Eamon Daly wrote: Did anyone ever follow up on this question? I'm looking for the answer, too. Eamon Daly - Original Message - From: [EMAIL

Re: count() on multiple similar tables?

2004-05-04 Thread Diana Soares
You may use MERGE TABLES: http://dev.mysql.com/doc/mysql/en/MERGE.html -- Diana Soares On Tue, 2004-05-04 at 10:08, Ken Gieselman wrote: Heya folks -- Trying to come up with a way to count across multiple tables, and failing miserably. I need a simple way, preferably better than looped

Re: Strange behavior with IF?

2004-02-16 Thread Diana Soares
) AS level, member.photo_level FROM member LEFT JOIN network ON (network.from_id=101 AND network.to_id=member.id AND network.level = member.photo_level) ORDER BY member.last_login DESC LIMIT 0,3 -- Diana Soares -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: Outer join question

2004-01-20 Thread Diana Soares
= dvd.actr_id and acto.acto_id = dvd.acto_id order by dvd.title; (I used to put (+) at the end of the outer join line, but don't think this will work in MYSQL - at least I don't see it in the manual.) Thanks in advance for your kind help and sorry for the wordy question! -- Diana

[Fwd: Re: Outer join question]

2004-01-20 Thread Diana Soares
for your kind help and sorry for the wordy question! -- Diana Soares -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: checking that any element from one group appears in another group?

2004-01-13 Thread Diana Soares
. Well, is there anything like above that I can use? -thanks, Eli -- Diana Soares -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: metric conversions

2004-01-12 Thread Diana Soares
You could do something like (don't copy and paste, this is just for you to have an ideia - i didn't understand your calculations with 0.063 and others...): SELECT IF (metric=cm, expression_in_centimeters, expression_in_inches) , ...other_fields FROM ... where metric is the name of the table

Re: Problems loading a TEXT field

2004-01-09 Thread Diana Soares
with belligerent nationalism. -- The American Heritage Dictionary Houghton Mifflin Company, 1983 -- Diana Soares -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: replication/binary log

2003-12-09 Thread Diana Soares
111 Dec 7 01:30 mw01-bin.036 drwxr-xr-x5 mysqlmysql4096 Dec 7 01:30 . -rw-rw1 mysqlmysql 63 Dec 7 01:49 master.info -rw-rw1 mysqlmysql861518654 Dec 8 17:53 mw01-bin.038 -- Diana Soares -- MySQL General Mailing List For list archives

Re: New to joins - this simple one doesn't work.

2003-12-09 Thread Diana Soares
simple - but then, as everyone keeps telling me, so am I. If you can help, thanks in advance. Iain. -- Diana Soares -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Need help with query. Please!

2003-12-05 Thread Diana Soares
Try: SELECT C.company_id, C.company_name FROM companies C LEFT JOIN company_group_intersect CG ON (C.company_id=CG.company_id AND CG.group_id='1') WHERE C.status='1' AND CG.company_id IS NULL -- Diana Soares On Fri, 2003-12-05 at 15:08, Robert Hughes wrote: I have the following 3 tables

Re: Fw: mysql request problem.

2003-12-03 Thread Diana Soares
where year='2003' and month='10'); Look at: from var and var_cd not in supposed to be: from var where var_cd not in -- Diana Soares -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: strange difference between a != b and (a b OR a b)

2003-11-20 Thread Diana Soares
The != does not belong to that list of comparision operators... Hope this helps! -- Diana Soares On Thu, 2003-11-20 at 16:12, [EMAIL PROTECTED] wrote: Description: a simple select on a large table does not use an indexed column when the WHERE clause uses a != b The same query

Re: String functions for GROUP BY clause

2003-11-12 Thread Diana Soares
If you're using MySQL 4.1, you have the GROUP_CONCAT(expr) function. If not, then... i think someone has already done an UDF about this... Search the archives..or see this: http://www.cwts.nl/buter/misc/my-mysql.html -- Diana Soares On Wed, 2003-11-12 at 08:56, Ciprian Trofin wrote

Re: tough sql joining and aggregate question

2003-10-16 Thread Diana Soares
I ensure to only get one of each? Distinct does not work. Travis -- Diana Soares -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Challenging query....

2003-10-16 Thread Diana Soares
| blew | +---+---+---+ You can do: SELECT @a:=0; SELECT @a:[EMAIL PROTECTED], blah, blew from table where blah 1; -- Diana Soares -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: LEFT JOIN help (or come and slap the newbie)

2003-10-15 Thread Diana Soares
JOIN city ON city.state_id = state.id LEFT JOIN zip ON zip.city_id = city.id LEFT JOIN group ON group.zip = zip.zip Hope this helps, -- Diana Soares On Tue, 2003-10-14 at 22:27, D. R. Hansen wrote: Uberdumb question - but I'm still enough of a newbie that this is giving me fits... I

Re: newbie select statement question

2003-10-10 Thread Diana Soares
me on this? I'm using PHP 4.2.2 and MySQL 3.23.54 btw. Thanks millions! Jordan -- Diana Soares -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Select Query-Display current month and last 11 months...

2003-10-06 Thread Diana Soares
Maybe like: SELECT something FROM tablename WHERE date_column DATE_SUB(CONCAT(YEAR(NOW()),'-',MONTH(NOW()),'-','01'), INTERVAL @n MONTH) @n is the number of months you want. If you want data from the current month, @n would be 0. -- Diana Soares On Mon, 2003-10-06 at 07:23, [EMAIL PROTECTED

Re: question about mysql backup

2003-09-08 Thread Diana Soares
are running on Linux (2.4.18) and we use mysql 4.014. Thanks, Harm de Laat Informatiefabriek The Netherlands -- Diana Soares -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: CREATE TABLE and CHECK Clause

2003-09-08 Thread Diana Soares
) thanx for your help. Kraan Deufe even more than Kojak ;) -- Diana Soares -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How to correct error code 1006

2003-09-05 Thread Diana Soares
changed the user's name from mysql to mysqladmin. I get the follow error when trying to create a new database: #1006 - Can't create database 'demo'. (errno: 13) Does anyone know the fix to this? -- Diana Soares -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: Help with #1111 - Invalid use of group function

2003-09-04 Thread Diana Soares
errno.- Invalid use of group function - I don't want to pull out any rows where the SUM of time_hours_worked is '0.00'... I would be most grateful if anyone has any suggestions Many thanks! Cory -- Diana Soares -- MySQL General Mailing List For list archives: http

Re: MySQL syntax question

2003-09-04 Thread Diana Soares
two fields from two tables and see if they match regardless of whether one is upper,lower,mixed case. Also see if table1.field1 is a partial match to another. So, JOHNATHAN would match Jon or Jonny. thanks, Darryl -- Diana Soares -- MySQL General Mailing List For list archives: http

Re: Adding up DATETIME field

2003-08-21 Thread Diana Soares
) NOT NULL default '', `id_sprache` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`lfdnr`), UNIQUE KEY `session` (`session`), FULLTEXT KEY `session2` (`session`) ) TYPE=MyISAM; -- Diana Soares -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: Rewrite

2003-07-24 Thread Diana Soares
AND groups.type='Privileged' AND groupmembers.memberid=users.id ORDER BY name And, it it possible to remove the case sensetivity of table names. Read the first item that appears in MySQL manual if you search for case sensitivity: http://www.mysql.com/doc/en/Name_case_sensitivity.html -- Diana Soares

Re: Dumping data

2003-06-25 Thread Diana Soares
getting corrupted data in the file. Thanks --- Rob ** Rob Cherry mailto:[EMAIL PROTECTED] +27 21 447 7440 Jam Warehouse RSA Smart Business Innovation http://www.jamwarehouse.com ** -- Diana Soares -- MySQL General Mailing List

Re: SQL statement dilemna

2003-06-25 Thread Diana Soares
for substitute appearances, one for starting appearances. Any pointers would be greatly appreciated, and if I'm asking an inappropriate question for the group please accept my apologies in advance. Many thanks Gary Broughton -- Diana Soares -- MySQL General Mailing List For list

UDF and mysql binary distr

2003-02-28 Thread Diana Soares
the source and compile it with .=rdynamic ? Thank you very much, -- Diana Soares - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

Re: left outer join

2003-02-28 Thread Diana Soares
Cherry mailto:[EMAIL PROTECTED] +27 21 447 7440 Jam Warehouse RSA Smart Business Innovation http://www.jamwarehouse.com ** -- Diana Soares - Before posting, please check: http://www.mysql.com

Re: How to Join tables in the right way

2003-02-27 Thread Diana Soares
p.id ) GROUP BY p.name But it has not the efeect I want... What is wrong? I hope you understood my problem (sorry for the bad English) and can send me your suggestions Thanks in advance Sorin Marti -- Diana Soares

Re: strange mysql syntax error

2003-02-20 Thread Diana Soares
: alter table xmlmd5 add index md5 (md5(10)); ERROR 1064: You have an error in your SQL syntax near 'md5(10))' at line 1 column definition of md5 is md5 varchar(32) Fix: when I use quoted version it is OK alter table xmlmd5 add index md5 (`md5`(10)); -- Diana

Re: How to grab the latest record in one query?

2003-02-20 Thread Diana Soares
| BEHOBEN | 1970-01-01 | 1970-01-01 |1 | 9 | +-+-+++--++ Either I'm stupid or it's impossible. Let's see which case is true. :) cheers ThX for any help... Chris -- Diana Soares

Re: How do I select 'all related' in a many-to-many relation?

2003-02-20 Thread Diana Soares
v3.23. Could anyone point me in the right direction? /mac -- Diana Soares - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

Re: How to simulate FULL JOIN with MYSQL

2003-02-19 Thread Diana Soares
it for the MySQL gurus or others that can help.. Michael Katzmann -- Diana Soares - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

Re: problem in connecting to DB

2003-02-18 Thread Diana Soares
this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Diana Soares - Before posting, please check: http://www.mysql.com/manual.php

Re: 'Disappearance of the mysql.sock when the computer is shut downand restarted'

2003-02-18 Thread Diana Soares
://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Diana Soares

Re: stuck with converting a query from a sub query

2003-02-18 Thread Diana Soares
') AND portlet.name not in ( SELECT portlet_fk FROM UserTabAssignment WHERE user_fk = 'guest' AND portal_FK = 'mysqlPortal' AND tabNumber = 0 AND subtabName = 'firstSubtab') thanks Alice Farbles -- Diana Soares

Re: How to move database from one directory to another

2003-02-17 Thread Diana Soares
change mysql server from /var/lib/mysql to new external drive? Any other thing I need care about? I look at the command mysqlhotcopy which only can copy existing database for backup purpose not for working database? Anybody know how to do it? Thanks a lot! zhu liu -- Diana Soares

Re: Show record number

2003-02-14 Thread Diana Soares
, PNumber ?? thanks jrt -- Diana Soares - 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

Re: Merge table limit

2003-02-11 Thread Diana Soares
Apps RD Cable and Wireless - -- Diana Soares - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

Re: tricky regrex and case case query

2003-02-11 Thread Diana Soares
for any help, -- MikemickaloBlezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(985)902-8484 MSN: [EMAIL PROTECTED] =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= -- Diana Soares

Re: optimizing left join query

2003-02-11 Thread Diana Soares
fear, if I rebel against my Lord, the retribution of an Awful Day (The Day of Resurrection) Al-Quran 6:15 http://docbook.sc-icc.org -- Diana Soares - Before posting, please check: http://www.mysql.com/manual.php (the manual

Re: sort problem

2003-02-10 Thread Diana Soares
Paris 15 A this time I'm doing this sql syntax : SELECT * FROM town ORDER BY town ASC How can I do it ? -- Diana Soares - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Re: Select question

2003-02-10 Thread Diana Soares
This is what is in the database. Bill 3620504670 John2630324846 Fred8740196242 This is what I want to be able to show: Fred 87 Bill 70 John 48 -- Diana Soares

Re: Help, Not sure my other email got through!

2003-02-10 Thread Diana Soares
to use a join in the select statement. ID1 ID2 11 22 33 This is what I want to be able to show: John 21 Fred 20 Bill 16 MySQL -- Diana Soares - Before posting, please check

Re: encrypted password

2003-02-05 Thread Diana Soares
archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Diana Soares - Before posting, please check: http

Re: order/group query

2003-02-05 Thread Diana Soares
://lists.mysql.com/php/unsubscribe.php -- Diana Soares - 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

Re: Problem with a query - help!!?

2003-02-04 Thread Diana Soares
new guy!! -- Diana Soares - 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] To unsubscribe

RE: mysql.sock is missing - Please....

2003-02-03 Thread Diana Soares
thought his mysql server was configured to have the sock file there. :-) Thanx, -- Diana Soares - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

Re: Fulltext Index

2003-02-01 Thread Diana Soares
index for 2 or more columns in a table will I be able to use it for a MATCH only against a single column (of the above) or do I have to create additional FULLTEXT indices for each of these columns? Thanks/h -- Diana Soares

Re: How can I start my mysql server with max_connections option

2003-02-01 Thread Diana Soares
.. -- Diana Soares - 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] To unsubscribe, e-mail [EMAIL

Re: Newbie Q: Booleans??

2003-02-01 Thread Diana Soares
://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Diana Soares

Re: # of connected user

2003-02-01 Thread Diana Soares
runs in server-client system, and each host of clients are different (i assume) I didn't understand this... Mustafa Yelmer Software Engineer +90 212 2128200-1228 [EMAIL PROTECTED] -- Diana Soares - Before posting

Re: [OT] linux novice cannot resolve apache-php-mysql linkage 2.

2003-02-01 Thread Diana Soares
-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Diana Soares - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Re: mysql.sock is missing - Please....

2003-02-01 Thread Diana Soares
mysql before reboot the linux sytem. What can I do to recover/reinstall/run the mysql server again? I didn't find mysql.server, but I do have mysql.server* on dir /usr/share/mysql. I'm running Mandrake 9 and Mysql-323.54a (rpm). Thank you in advance Pedro -- Diana

Re: Trying to update data in a table - getting an error

2003-01-21 Thread Diana Soares
), substr( ItemHSCode, 6, 2 ), substr( ItemHSCode, 9, 2 )) Thanks, Don -- Diana Soares - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

Re: Help with a select where an ID isn't in another table, but is avalid row.

2003-01-21 Thread Diana Soares
) -- Diana Soares - 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] To unsubscribe, e-mail

Re: Problem localhost connect

2003-01-20 Thread Diana Soares
: 'ERROR 2003: Can't connect to MySQL server on 'localhost' (111)' I tried with new, old and no password! So? -- Diana Soares - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Re: Table Update Help / Problem

2003-01-20 Thread Diana Soares
Mob: 0425 788-185 -- Diana Soares - 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: select query to give sum and distinct values

2003-01-20 Thread Diana Soares
://signup.getreal.co.uk For our email disclaimer please see the url below. http://www.getreal.co.uk/disclaimer.htm -- Diana Soares - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Re: root host privlidge

2003-01-17 Thread Diana Soares
Hi, Start the mysqld with --skip-grant-tables. This way the server will not use the privilege tables... Then alter the data as you want and do a mysqladmin flush-privileges (or reload) to restart using them. More info: http://www.mysql.com/doc/en/Privileges_options.html On Fri, 2003-01-17 at

Re: Problem with mysqlimport

2003-01-17 Thread Diana Soares
, this is my problem. Thanks for your immediate reply Thanks Regards, Shripal. - Original Message - From: Diana Soares [EMAIL PROTECTED] To: Shripal Shah [EMAIL PROTECTED] Sent: Friday, January 17, 2003 6:48 PM Subject: Re: Problem with mysqlimport Hi, What version of MySQL

Re: myisamchk warnings -- open tables

2003-01-15 Thread Diana Soares
that I might just plain be missing? Many thanks in advance! Jody Harris -- -- Diana Soares - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

RE: three table join

2003-01-15 Thread Diana Soares
and the optimizer). You need to think in terms of what would be equal to what between tables in the correct result row. So if you would do a secondary sub-select of SELECT fk from table2 where ... then you end up with a left join like above. -- Diana Soares

Re: help w/join condition

2003-01-15 Thread Diana Soares
PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Diana Soares - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Re: Thanks and SQL Syntax help

2003-01-13 Thread Diana Soares
/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Diana Soares

Re: install problem... (permissions?)

2003-01-13 Thread Diana Soares
://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Diana Soares

Re: MySQL Select SUM Function

2003-01-13 Thread Diana Soares
On Mon, 2003-01-13 at 14:11, Stevens, Ryan wrote: I understand the SQL statement in MySQL to be SELECT sum(column name) FROM table; but I would like to get a SUM of multiple columns. Is this possible?? Yes, you may use: SELECT sum(c1+c2) FROM table; or even: SELECT sum(table1.v +

Re: Starting MySQL

2003-01-10 Thread Diana Soares
this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Diana Soares - Before posting, please check: http://www.mysql.com/manual.php

Re: May I raise a question?

2003-01-09 Thread Diana Soares
) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Diana Soares - Before posting, please check: http

Re: mysql 4.0.8 crashes and refuses to restart after crash.

2003-01-09 Thread Diana Soares
-mpentium' 'CXX=gcc' -- Diana Soares - 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: Still Cannot Get MySQL To Run

2003-01-08 Thread Diana Soares
On Wed, 2003-01-08 at 04:55, CM Miller wrote: Have a new years resolution, to get MySQL to run Here are the errors that I keep getting... I don't understand what this is telling me? from /var/log 021214 19:13:21 mysqld started 021214 19:13:21 /usr/local/libexec/mysqld: Can't find

Re: Weird WHERE clause possible?

2003-01-07 Thread Diana Soares
the last name and the first name in two seperate fields. I can make an SQL statement like Select * from Students Where LastName Like Smith%;, but can I make something like SELECT * FROM Students WHERE (LastName, , , FirstName) AS Name LIKE Smith, J%; ? -- Diana Soares

Re: max_connect_errors wait_timeout problem?

2002-08-01 Thread Diana Soares
closing the connection, then it should increment its counter of connection_errors. It tells that someone opened a connection and did not close it. It's only an opinion. -- Diana Soares - Before posting, please check: http

Re: Query problem

2002-07-27 Thread Diana Soares
Hi, On Thu, 2002-07-25 at 20:40, Kevin wrote: Hello, I have a query that runs perfectly until one of the items has no value or is set to 0: SELECT item.*, color.Name AS COLOR, shapecode.Shape AS SHAPE, clarity.Name AS CLARITY FROM item, color, shapecode, clarity WHERE

Re: Need help with Tables/Attributes

2002-07-27 Thread Diana Soares
table test(ID int(4), Name varchar(20), Sex varchar(1)); Now I need to change the attribute NAME TO Full name, HOW? Please help, Thanking in Advance. Regards Nitesh -- Diana Soares - Before posting, please check: http

Re: Fw: Complex SQL assistance

2002-07-27 Thread Diana Soares
a certain criteria (i.e. field X = '1234') then update the record. If the record doesn't exist then insert it. For reasons too complex to go into at this stage using anything except SQL is not possible. Any and all suggestions welcome. -Corey -- Diana Soares

Re: mysql sub query

2002-07-27 Thread Diana Soares
CHECK set to N. Hi, Try this: SELECT ID,GRP,max(PRC) FROM tab_name WHERE GRP IN (1,2,3) and CHECK='N' GROUP BY GRP; Hope this helps, -- Diana Soares - Before posting, please check: http://www.mysql.com/manual.php

Re: Query problem

2002-07-27 Thread Diana Soares
' If the item.CLARITY_ID has no value or a value of 0 (which there is no defined value for in the clarity table), then the query fails. Can anything be done without adding more login in the code? Thanks -- Diana Soares - Before

Re: Mysqld crash

2002-07-26 Thread Diana Soares
Hi, just sending a reply in case that someone else has the same problem. I solved the problem by decreasing the key-buffer from 320M to 288M. On Wed, 2002-07-03 at 12:24, Diana Soares wrote: Hi, I have 2 machine dual-processor Pentium III, with 1G of memory. They have the same software

Re: Mysqld crash

2002-07-26 Thread Diana Soares
On Fri, 2002-07-26 at 18:43, Mike Wexler wrote: Diana Soares wrote: Hi, just sending a reply in case that someone else has the same problem. I solved the problem by decreasing the key-buffer from 320M to 288M. We tried that among many other things. It turns out that their is some

Re: Query problem..

2002-07-26 Thread Diana Soares
as done at the same time when the value x='' for every clientid.I have tried what you see but didin't help. SELECT clientid FROM table_name WHERE datedone = 'max(datedone)' and done = 'true' and x = '' group by clientid; I am new to all this, so any help would be usefull Thanks -- Diana

Re: inner join query don't work

2002-07-26 Thread Diana Soares
%' and Pengarang.Pengarang like '%$lukito%' and Subjek.Subjek like '%$computer%' than's a lot. -- Diana Soares - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

RE: mysqldump question

2002-07-24 Thread Diana Soares
/documentation/mysql/bychapter/manual_News.html#News-3.23.x It shows some release dates. -Original Message- From: Diana Soares [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 16, 2002 3:22 AM To: Bill Bernat Cc: [EMAIL PROTECTED] Subject: Re: mysqldump question On Tue, 2002-07-16

Re: mysqldump question

2002-07-16 Thread Diana Soares
with /tmp/dumps directory, 777 permissions, and it worked.) -- Diana Soares - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

RE: Mysql wil lnot load

2002-07-16 Thread Diana Soares
] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Diana Soares Websolut - Soluções Internet Email: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual

Re: select query

2002-07-15 Thread Diana Soares
'0.00' NOT NULL, PRIMARY KEY(article, dealer)); Thank You ! -- Diana Soares - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

Re: NATURAL JOIN

2002-07-15 Thread Diana Soares
first example worked because the only column used to join was the id (since you gave different names to the other column). -- Diana Soares - Before posting, please check: http://www.mysql.com/manual.php (the manual

Re: Help with Insert.. Select From... Query

2002-07-15 Thread Diana Soares
use: insert into rep (repid,submitid,lastactv,status) select 88,submit_idx2.submitid,now(),1 from submit_idx2 order by submit_idx2.submitid asc limit $var,10; where $var will be: * 0 for the first time you run the query, * 10 for the second time, * 20 for the third -- Diana Soares

Re: server_error description needed

2002-07-11 Thread Diana Soares
of error messages and error numbers in the file `Docs/mysqld_error.txt'. For me, those files are in: /usr/include/mysql/errmsg.h /usr/include/mysql/mysqld_error.h /usr/src/redhat/BUILD/mysql-3.23.50/Docs/mysqld_error.txt Is it possible perhaps in an sql query ? I think it's not possible... -- Diana

Mysqld crash

2002-07-03 Thread Diana Soares
handle_slave__FPv + 2309 (i don't understand what this means..) Thank you for reading this, i hope someone can give me a light. -- Diana Soares - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Re: left join and three ids problem

2002-04-26 Thread Diana Soares
) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Diana Soares Websolut - Soluções Internet Email: [EMAIL PROTECTED

Compile options

2002-02-12 Thread Diana Soares
Hi, Is there a way of knowing with wich options mysql was compiled ? Thanx, -- Diana Soares (sql) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

[Fwd: Compile options]

2002-02-12 Thread Diana Soares
-Forwarded Message- From: Diana Soares [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Compile options Date: 08 Feb 2002 15:35:57 + Hi, Is there a way of knowing with wich options mysql was compiled ? Thanx, -- Diana Soares (sql

Re: Help with MySQL: Bind on unix socket error

2002-02-12 Thread Diana Soares
and owner on /var/lib/mysql to root. I think that, at least, the owner of /var/lib/mysql should be mysql. This way, mysql can create the /var/lib/mysql/mysql.sock Hope this helps.. Also, be shure that there is no other mysqld process runnig. -- Diana Soares (sql

[Fwd: Compile options]

2002-02-11 Thread Diana Soares
-Forwarded Message- From: Diana Soares [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Compile options Date: 08 Feb 2002 15:35:57 + Hi, Is there a way of knowing with wich options mysql was compiled ? Thanx, -- Diana Soares (sql

Compile options

2002-02-08 Thread Diana Soares
Hi, Is there a way of knowing with wich options mysql was compiled ? Thanx, -- Diana Soares (sql) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Re: visualizing my queries

2002-02-06 Thread Diana Soares
query avoid putting another entry in author? I'll be using PHP for the front end. You can always use INSERT for the content table and REPLACE for the author table. -- Diana Soares (sql) - Before posting, please check: http

  1   2   >