Thanks so much Brent, this is what I was looking for.
However, what do I do when I get to 'Z'?
I looked here, and now I am really confused:
http://www.mysql.com/doc/en/Comparison_Operators.html
It seems to say that BETWEEN returns a rowcount as well?
I am guessing that these all return
Oh, well, chalk it up to experience. RLIKE is what works the way I want. DOH!
Thanks,
--Scott Brown
At 12:34 PM 10/30/2003, you wrote:
Thanks so much Brent, this is what I was looking for.
However, what do I do when I get to 'Z'?
I looked here, and now I am really confused:
The BETWEEN operator works like and greater and less than search.
So, you can do the exact same query like this:
SELECT * FROM sometable WHERE surname='A' AND surname'D'
MySQL may actually optimize them the same way, but using BETWEEN is
more readable.
To include 'Z', just do a greater than
Hi,
No, col BETWEEN 'A' AND 'D' is not the same as col = 'A' AND col 'D'.
BETWEEN is equivalent to col = 'A' AND col = 'D'. One will include
cols that equal 'D' and the other won't. :-)
Matt
- Original Message -
From: Brent Baisley
Sent: Thursday, October 30, 2003 3:12 PM
Subject: Re
Easy, use:'select * INTO OUTFILE full path and file name
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY ''
LINES TERMINATED BY \n from user where race='chinese' and
state='US'Nitin- Original Message -
From: Pey Ling [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, October 28, 2003
Hi, how to write this :full path and file name? can i copy it to my local
pc rather than the server?
best regards,
Pey Ling
From: Nitin [EMAIL PROTECTED]
To: Pey Ling [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, October 28, 2003 5:09 PM
Subject: Re: please help out
Easy, use:'select
-
From: Pey Ling [EMAIL PROTECTED]
To: Nitin [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, October 28, 2003 3:31 PM
Subject: Re: please help out
Hi, how to write this :full path and file name? can i copy it to my
local
pc rather than the server?
best regards,
Pey Ling
From
Now, how can I save only these 1000++ data into a file in my pc?
Normaly you should get the data into a file with that
something you sent the query to mysql with. What is that
something in your case?
Regards,
TomH
--
PROSOFT EDV-Lösungen GmbH Co. KG
Geschäftsführer: Axel-Wilhelm Wegmann
AG
]
: Cc: [EMAIL PROTECTED]
: Subject: Re: Need help constructing query ...
:
:
: - Original Message -
: From: Daniel Clark [EMAIL PROTECTED]
: To: [EMAIL PROTECTED]
: Cc: [EMAIL PROTECTED]
: Sent: Tuesday, October 21, 2003 2:33 PM
: Subject: Re: Need help constructing query
Hi, I have a table full of logged urls and ip addresses. The following
query returns all the urls and the number of requests. How would I
modify it to return unique requests based on distinct ip addresses?
select url, count(*) as pageviews from table group by url order by
pageviews desc
- Original Message -
From: Daniel Clark [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, October 21, 2003 2:33 PM
Subject: Re: Need help constructing query ...
: Hi, I have a table full of logged urls and ip addresses. The following
: query returns all
Then I think you want
SELECT url, COUNT(DISTINCT ip_address)
FROM tablename
GROUP BY url;
-Original Message-
From: John Kelly [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 21, 2003 3:45 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: Need help constructing query
: -Original Message-
: From: John Kelly [mailto:[EMAIL PROTECTED]
: Sent: Tuesday, October 21, 2003 3:45 PM
: To: [EMAIL PROTECTED]
: Cc: [EMAIL PROTECTED]
: Subject: Re: Need help constructing query ...
:
:
: - Original Message -
: From: Daniel Clark [EMAIL PROTECTED
you can create a temporary table (as del_temp_table) by this select command:
SELECT faqcat.cat FROM faqcat LEFT JOIN article ON faqcat.cat = article.cat
WHERE article.cat IS NULL;
then delete them:
DELETE FROM faqcat USING faqcat, del_temp_table WHERE faqcat.cat =
del_temp_table.cat ;
I hope
Darryl,
At first blush, I would try something like:
DELETE faqcat
FROM faqcat LEFT JOIN article
ON faqcat.cat = article.cat
WHERE article.cat Is Null;
I vaguley remember MySQL implementing syntax permitting users to remove data
from one or more tables. I think this might be your ticket.
Use the LIMIT clause in mysql instead of TOP clause for access and mssql.
Luck !
- Original Message -
From: Wajih-ur-Rehman [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, September 22, 2003 12:22 PM
Subject: plz help
I have this statement that works perfectly fine in Access
-
From: Catalin PLACINTA [EMAIL PROTECTED]
To: Wajih-ur-Rehman [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, September 22, 2003 2:33 PM
Subject: Re: plz help
Use the LIMIT clause in mysql instead of TOP clause for access and mssql.
Luck !
- Original Message -
From: Wajih-ur-Rehman
Patrick Shoaf [EMAIL PROTECTED] wrote:
I have a table name product defined as follows:
Item_Code
Item_Size
Item_Color
Item_img
Description
Cost
Retail_Price
Category
and other non-essential items, such as qty based on code,size,color
The data is as follows:
j2400 S BLK
I loaded MySQL 4.1, but now the text is gibberish in the Group_Concat field
SELECT Cat_Item_Img,Cat_Price,Product.Item_Code,GROUP_CONCAT(Item_Size
SEPARATOR ;) as sizes,Item_Img,
Description,Category,Retail_Price,Short_Desc,Product.Item_Color
FROM Cat_Items,Product
WHERE cat_code =BoltTech and
- Original Message -
I would use MySQL CC (command center, I think...)... I seem to remember
someone mentioning that mysql gui is discontinued...
CC is available from the mysql.org site, and is very easy to install on
windows xp (it's on my laptop...)
/originalmessage
I second that.
I would use MySQL CC (command center, I think...)... I seem to remember someone
mentioning that mysql gui is discontinued...
CC is available from the mysql.org site, and is very easy to install on windows xp
(it's on my laptop...)
-Original Message-
From: Liwen Han [mailto:[EMAIL
Dan Greene wrote:
I would use MySQL CC (command center, I think...)... I seem to remember someone
mentioning that mysql gui is discontinued...
You remember right, the MySQL GUI IS discontinued. Why it is still
availiable for download, ask MySQL
Jakob
^--
To Unix or not to Unix. That is
: [EMAIL PROTECTED]
Sent: Monday, September 01, 2003 6:18 AM
Subject: Re: Need help with oracledump (contributed program)
On Mon, Sep 01, 2003 at 01:03:48PM +0100, Jim Smith wrote:
I'm trying to figure out how to use the contributed program
oracledump in an environment where I don't have
PROTECTED]
Subject: Re: Need help with oracledump (contributed program)
On Mon, Sep 01, 2003 at 11:09:02AM -0700, Martin Gainty wrote:
Doug
I copied this from an SAP integration with Orace site
http://saphelp.cob.csuchico.edu/OraHelp/Darwin36/inst36fhp/htm
l/5-odbc.htm
5.5.3 tsnames.ora
On Tue, Sep 02, 2003 at 12:25:35PM +0100, Jim Smith wrote:
A TNSNAMES file isn't going to help unless you have the Oracle
client software installed. If you had the software, you would
already have a tnsnames file.
Thanks all for your help. I've found a free java-based application
I'm trying to figure out how to use the contributed program
oracledump in an environment where I don't have a login to the *nix
host running Oracle. All my connectivity to the Oracle host is via
port 1521 and JDBC.
The oracle dump command seems to be looking for a SID in a file called
On Mon, Sep 01, 2003 at 01:03:48PM +0100, Jim Smith wrote:
I'm trying to figure out how to use the contributed program
oracledump in an environment where I don't have a login to the *nix
host running Oracle. All my connectivity to the Oracle host is via
port 1521 and JDBC.
The oracle
.
*OracleDump is performed by (SID=ORCL)*
Keep us apprised to your progress...
Marty Gainty
- Original Message -
From: Doug Poland [EMAIL PROTECTED]
To: Jim Smith [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, September 01, 2003 6:18 AM
Subject: Re: Need help with oracledump (contributed
Are your tables indexed? http://www.mysql.com/doc/en/MySQL_indexes.html
Saqib Ali
-
http://www.xml-dev.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Absolutely! I have multiple indexes. I think it might be a problem with ODBC
Are your tables indexed? http://www.mysql.com/doc/en/MySQL_indexes.html
Saqib Ali
-
http://www.xml-dev.com
-
Visit CARMEL MUSIC ENTERTAINMENT website
When following query is pulled up, it takes about whole 1-2 minutes to come up.
inquiries table has 17000 records, contacts has about 7000,
individual_contacts has about 16000.
It has gotten worse once I upgraded to 4.0 and latest MyODBC.
Clients are separate machines (mix of Win98 and WinXP).
: Wednesday, August 20, 2003 2:52 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: Need help optimizing query, awfully slow on only
2 records
When following query is pulled up, it takes about whole 1-2
minutes to come up. inquiries table has 17000 records,
contacts
Query takes 3.4 seconds to run on the server, but it takes 1-2minutes to run via
MyODBC 3.51.06 using passthrough (Access97 is the front end, but it has query
type that allows bypass of Access interpretation.
Two Questions:
Is the same query running directly on the linux server thru mysql is
To: Michael S. Fischer
Cc: [EMAIL PROTECTED]
Subject: RE: Need help optimizing query, awfully slow on only
2 records
Result of EXPLAIN is:
table|type|possible_keys|key|key_len|ref|rows|Extra
inquiries|ALL|contact_id| | | |8253|Using filesort
individual_contacts|eq_ref
]
Sent: Wednesday, August 20, 2003 3:14 PM
To: Michael S. Fischer
Cc: [EMAIL PROTECTED]
Subject: RE: Need help optimizing query, awfully slow on only
2 records
Result of EXPLAIN is:
table|type|possible_keys|key|key_len|ref|rows|Extra
inquiries|ALL|contact_id| | | |8253
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: Need help optimizing query, awfully slow on only
2 records
When following query is pulled up, it takes about whole 1-2
minutes to come up. inquiries table has 17000 records,
contacts has about 7000, individual_contacts has about
I'd cross post to the mysql-java/jdbc mailing list... Most likely you
need to modify mysql config to allow larger packet sizes.. search the
list archive/website for max_allowed_packet info..
On Fri, 8 Aug 2003, Ma Mei wrote:
Dear administrator,
Now I have a quesion and want to get your help.
So you want to group by the customer, but only show those gorupings with
a count 5.
That means you want to apply your restriction after the GROUP BY. Thus,
the clause goes into the HAVING area.
Try:
Select count(*), cust.id
from cust
where cust.time UNIX_TIMESTAMP(DATE_SUB(NOW(),interval 1
Thanks, that did it!
Jeff
-Original Message-
From: Kevin Fries [mailto:[EMAIL PROTECTED]
Sent: Monday, August 04, 2003 3:05 PM
To: Jeff McKeon; [EMAIL PROTECTED]
Subject: RE: Query Help
So you want to group by the customer, but only show those
gorupings with a count 5
SELECT [field list] FROM archivetable,currenttable WHERE
archivetable.username=currenttable.username
notes: can use join,left,right,select inside select aka subselect check
the manual for detail
Regards,
--
Aftab Jahan Subedar
Software Engineer
Subedar Technologies
Subedar Baag
Bibir Bagicha
Hi,
On Fri, Aug 01, 2003 at 11:55:36PM +0800, Jaime Teng wrote:
Now, I have two of these tables (archivetable,currenttable).
My problem is how do I perform a single query such that I get
results from these two tables:
mysql select * from archivetable,currenttable;
* Jaime Teng
[...]
Now, I have two of these tables (archivetable,currenttable).
My problem is how do I perform a single query such that I get
results from these two tables:
mysql select * from archivetable,currenttable;
+++-+-+
Iulian,
this is in the manual. Look at
Database Administration
Localisation
Character arrays
Regards,
Thomas Spahni
On Wed, 30 Jul 2003, Primaria Falticeni wrote:
I can copy the latin2.conf into new one, but I need to know what each code
from the conf file represents and
I can copy the
latin2.conf into new one, but I need to know what each codefrom the conf
file represents and how can I obtain the relation from thesecodes and the
chars.So that's two problems:1) Can I use asc function or what function I
need to know to obtain thecodes from the chars?2) How
Hi!
On Jul 28, Primaria Falticeni wrote:
Hello,
Simply I made a table with romanian characters aAsStT. I tried to
sort it, in fact to order it in a query.
How can I do this? Please give me an example at how can I change the
latin2.conf in a romanian one to fairly sort the chars
Estoy tomando el sol
.
q
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Estoy tomando el sol
.
q
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Try this
SELECT DISTINCT t1.user, 'true/false' = CASE WHEN (t2.user IS NULL )
THEN 1 ELSE 2 END
FROM tableOne AS t1 LEFT OUTER JOIN tableTwo AS t2 ON t1.user = t2.user
-Original Message-
From: Debusal [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 23, 2003 2:58 PM
To: [EMAIL
At 11:02 -0500 7/24/03, Chuck Barnett wrote:
Hi I'm looking to create a query that will look through my previous orders
and create a table of what items have sold with what products.
My current table that holds the order details is set up like this.
orderID, productID, quantity.
I see an order ID
[snip]
Hi I'm looking to create a query that will look through my previous
orders
and create a table of what items have sold with what products.
My current table that holds the order details is set up like this.
orderID, productID, quantity.
Any suggestions would be appreceiated.
[/snip]
You
* Chuck Barnett
Hi I'm looking to create a query that will look through my previous orders
and create a table of what items have sold with what products.
My current table that holds the order details is set up like this.
orderID, productID, quantity.
Any suggestions would be appreceiated.
---Original Message-
--From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
--Sent: Thursday, July 24, 2003 12:53 PM
--To: [EMAIL PROTECTED]
--Subject: SQL Help...
--
--After some searching around different books/manuals/google I still
can't
--seem to figure out how do to this. What I have
At 02:52 PM 7/24/2003, you wrote:
After some searching around different books/manuals/google I still can't
seem to figure out how do to this. What I have is a table with 4 cols
(task, resource, department, priority) and what I want to do is be able to
select distinct resources and list what their
I looked at the group by option already and I dont think it will do what I
need it to do. I say this because it will only group things in the
priority/task/whatever but that still leaves options for duplicate
resources. Yes, it would get rid of the dup. resources per priority, but
not for the
Try:
select task, resource, department, max(priority)
from table
group by task, resource, department
Regards,
Ulises
-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Enviado el: Jueves 24 de Julio de 2003 02:53 PM
Para: [EMAIL PROTECTED]
Asunto: SQL Help...
After
That works great. =D
Knew it shouldn't be that difficult, thanks a bunch.
And it actually works with the Priorities being in text form to (low, med,
hi).
-Nick
At 02:52 PM 7/24/2003, you wrote:
After some searching around different books/manuals/google I still can't
seem to figure out how do to
To: Dathan Vance Pattishall
Cc: [EMAIL PROTECTED]
Subject: RE: SQL Help...
I looked at the group by option already and I dont think it will do what I
need it to do. I say this because it will only group things in the
priority/task/whatever but that still leaves options for duplicate
resources. Yes
PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 24, 2003 4:41 PM
To: Dathan Vance Pattishall
Cc: [EMAIL PROTECTED]
Subject: RE: SQL Help...
I looked at the group by option already and I dont think it will do what I
need it to do. I say this because it will only group things
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tue, 22 Jul 2003, Petre Agenbag wrote:
Is there ANYONE that can help me with a my.cnf for a large site for
version 3.23.56, or even just where I can download one? I am trying to
download that version and then get my own, but the dl times out...
Lenz
Thanks for the reply, will go to the link immediately.
I would just like to clarify something:
I have 3.23.56 , your's is 4.x, does it matter?
I should obviously just leave out the stuff that is not relevant like
InnoDB support etc...
CAn you give me possibly pointers to the absolute
Try with :
SELECT tparts.name,
a.name,
b.name,
tmovement.quantity
FROMtmovement inner join tparts on (tmovement.part_id = tparts.Id)
inner join twarehouse a on (
tmovement.incoming_id = a.Id )
Hi
This is working...
Thank You
Zoltan
- Original Message -
From: Cabanillas Dulanto, Ulises [EMAIL PROTECTED]
To: MYSQL Lista [EMAIL PROTECTED]
Sent: Friday, July 18, 2003 10:54 PM
Subject: RE: SELECT help
Try with :
SELECT tparts.name,
a.name
At 15:15 -0500 7/18/03, Kyle Goetz wrote:
hey, i'm new to mySQL...this meaning that i have tried ~1 times to
install it and get it working over the past few weeks...and it always gives
me the same error (scroll further down to see it) despite following the
manual's windows installation exactly
You're describing an adjacency list model, which is the most obvious
structure but arguably not the best.
Another data structure for this kind of thing is described at:
http://groups.google.com/groups?selm=%230%23O0OiFBHA.1932%40tkmsftngp04;
oe=UTF-8output=gplain
Cheers,
Jim
-Original
Hiya. I take it you mean ancestors rather than descendants.
For finding descendants I've been using tables like this:
ID ParentIDLineage
1000/100
101100/100/101
102100/100/102
103101/100/101/103
104103
At 17:42 -0500 7/6/03, Greg Donald wrote:
my coulmn (id) is an auto_increment coulmn and lets say that i have 100
entries, so the problem is that when i delete all entries on my table, the
column (id) starts from 101 ,shouldn't is starts from 1 again!
please i need help with this
Use truncate
At 4:20 -0500 7/7/03, Anthony Scism wrote:
I am relatively new at this, but is there any way to perform the
following:
| obs_date | date | YES | | NULL |
|
| obs_time | time | YES | | NULL |
|
| object | varchar(40) | YES | | NULL
Hi Antony,
Eventually key is a reserved word ?? ;-)
nice one !!
Best regards
Nils Valentin
Tokyo/Japan
2003 7 7 18:20Anthony Scism :
I am relatively new at this, but is there any way to perform the
following:
| obs_date | date | YES | | NULL |
|
| obs_time
:
Thank you very much, I should have thought of that.
-Original Message-
From: Nils Valentin [mailto:[EMAIL PROTECTED]
Sent: Monday, July 07, 2003 4:34 AM
To: Anthony Scism; [EMAIL PROTECTED]
Subject: Re: need help with select statement
Hi Antony,
Eventually key is a reserved word
You must create the key (sku), it is not created for you.
Tom Gazzini wrote:
I would appreciate some help with a problem. I'm trying to create two
tables that have referential integrity.
If I try and create the following table it works fine:
CREATE TABLE book
(
sku INT
) TYPE=INNODB;
However,
Please ignore my last email. I made a nauseatingly dumb error in the
book table (sku should be CHAR(14), not INT).
The only help I need is to get some sleep.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
I'm new, too, so someone correct me if I'm wrong, but...
if you make it an ENUM field in a table you can store it using the
value in the selection, retrieve it as the same value, and still get
all the advantages of numeric storage.
Todd
On Sunday, July 6, 2003, at 02:38 PM, Dan Cox wrote:
Another option is to have another table with the item name and number
using that as a lookup table.
IMHO it all depends on the data if the select is static (or rarely
changes) an enum would be best. If is changes a lot then I would use
another table to store it in.
-Michael
I protect you,
my coulmn (id) is an auto_increment coulmn and lets say that i have 100
entries, so the problem is that when i delete all entries on my table, the
column (id) starts from 101 ,shouldn't is starts from 1 again!
please i need help with this
Use truncate table, it will reset the auto_incement.
Is there any way to seed a column set to autoincrement? Say I wanted it to
begin at 1.
- Original Message -
From: Greg Donald [EMAIL PROTECTED]
To: wael fareed [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Sunday, July 06, 2003 4:42 PM
Subject: Re: need help
my coulmn (id
Is there any way to seed a column set to autoincrement? Say I wanted it to
begin at 1.
alter table table_name auto_increment = 1;
--
Greg Donald
http://destiney.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Sean Berry [EMAIL PROTECTED] wrote:
I need to know how to be able to read in data from to mysql from two different
places. For example from /usr/local/mysql and /usr/local/data
You can use symlinks:
http://www.mysql.com/doc/en/Symbolic_links.html
--
For technical support
anders thoresson schrieb:
I'm building a planning system for a newspaper. Article ideas are
defined as articles with no deadline, no publication date or no reporter
assigned. I wan't to show all entries from table un_article that matches
those three criterias.
I have three tables:
CREATE
Syamsul Arifien [EMAIL PROTECTED] wrote:
I have :
call to undefine function mysql_connect() atphp line
that's the message..
First of all, please, answer to the mailing list, not to me directly.
This error means that PHP isn't compiled with MySQL support.
--
For technical support
On Fri, Jun 27, 2003 at 09:05:48AM -0400, Moulder, Glen wrote:
G'day all,
Having trouble with SUM, could use a hand. I inherited a table, Funds_Recd that
looks like this:
ID Job Sub Task Amt
1A01 A1910,001.00
102 B53 A201 79.47
213 X99 L8838,289.02
Hi Fred, group,
I wrote--
I'm trying to get just a total of the funds amount for a
Job, Sub and Task like this --
SELECT Jobs.Job, Jobs.Sub, Jobs.Task, sum(Funds_Recd.Amt) AS Amount
FROM Jobs, Funds_Recd WHERE Jobs.Job=Funds_Recd.Job and
Jobs.Sub=Funds_Recd.Sub and
Syamsul Arifien [EMAIL PROTECTED] wrote:
Hi ...
I hv problem...
I can't conec to my MysqlSvr with mysql_connect() in my php script..
anybody knows?
What error message did you get?
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by
Hi Ted,
I believe you are looking for UPDATE . (no WHERE clause).
Warning: This will update ALL fields within a column.
INSERT... will insert a single datarecord, while UPDATE... will change a value
of a single field usually, but without WHERE clause it will update ALL fields
in a
I got it to work, if anyone's interested (see message below). Here is the
SQL:
DROP TABLE IF EXISTS ProgramRoyalties;
CREATE TEMPORARY TABLE ProgramRoyalties
SELECT UtilityID, max(Royalty) as MaxRoyalty
FROM royalties
GROUP BY UtilityID;
SELECT u.UtilityID, u.UtilityIcon, u.UtilityName,
As this is really a PHP specific question, you may get a better response on the PHP
general mailing list at http://www.php.net/mailing-lists.php
Anyway, if my limited experience in PHP serves correctly, you may need to call
echo(mysql_error()); near the potentially troublesome code.
Regards,
there. When I
upgraded to 4.0.12 I just moved the data folder from the old installation to
the new installation.
-Original Message-
From: Becoming Digital [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 12, 2003 1:53 AM
To: [EMAIL PROTECTED]
Subject: Re: Need help with an update
The OS upgrade
I have no idea. sorry.
Sibananda Sahoo wrote:
Thanks for your reply. Could you please tell me is it
possible to achieve foreign key constraint in MySQL
3.23.56.
Rgds,
Sibananda
--- Jeff Mathis [EMAIL PROTECTED] wrote:
i'm not an expert by any means :)
but, you do need indexes
]
Subject: Re: need help
I have no idea. sorry.
Sibananda Sahoo wrote:
Thanks for your reply. Could you please tell me is it
possible to achieve foreign key constraint in MySQL
3.23.56.
Rgds,
Sibananda
--- Jeff Mathis [EMAIL PROTECTED] wrote:
i'm not an expert by any means :)
but, you
The OS upgrade probably just over-wrote the old MySQL install. Hopefully it
left the files intact and you can import them as described in the manual.
FWIW, MySQL is at v4.0.13 and some major improvements came with v4. You might
want to consider reading the upgrade section of the manual, too. ;)
:-) I think the first issue is to make sure that the server is running.
Typically the 'sock' file issue will solve itself if the server is running.
-Original Message-
From: Ernesto Silva [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 10, 2003 12:38 AM
To: [EMAIL PROTECTED]
Subject: Re
i'm not an expert by any means :)
but, you do need indexes on both the primary key and the foreign key.
you've got one on foo_id, but you also need on on foo_value.
check the lists for more information. there's been plenty of discussion
lately ...
good luck
Sibananda Sahoo wrote:
Dear Sir
You have several options, here is, I think, the easiest:
First you need to locate the sock file. The location depends on the
distribution (in my system is in /tmp). Use find / -name mysql.sock. On
some distributions the name can be slightly different, for example
mysqld.sock.
Then create a
Try using 'max_allowed_packet=16M' instead of your current value. You may also
find help by reviewing the below.
http://www.mysql.com/doc/en/Packet_too_large.html
Is there a reason you are including the BLOBs in the database instead of just
linking via it? I know it's generally considered
Stewart,
Yesterday I posted the message listed below. I have some more information.
We have found the command that pushes our database over the edge! It is:
SHOW VARIABLES;
All other db commands work (such as SHOW VARIABLES %a;) except for:
SHOW VARIABLES %
This should be SHOW
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
TRANTER,STEWART (HP-Germany,ex1) wrote:
| Hello Everyone,
|
| Yesterday I posted the message listed below. I have some more
information.
| We have found the command that pushes our database over the edge!
It is:
|
| SHOW VARIABLES;
|
| All other db
:[EMAIL PROTECTED]
Sent: 03 April 2003 15:00
To: TRANTER,STEWART (HP-Germany,ex1)
Cc: '[EMAIL PROTECTED]'
Subject: Re: Please HELP!!! Re: Database Core Dumps
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
TRANTER,STEWART (HP-Germany,ex1) wrote:
| Hello Everyone,
|
| Yesterday I posted the message
PROTECTED]
Subject: Re: Help with 4.0.12 on WinXP
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Dan Cumpian wrote:
| Hello,
|
|
|
| I am having the following problem that I've been able to consistently
| replicate:
|
|
|
| I am using code written in Delphi with Zeos Database components and am
mysql select solution
- from os_table os, solutions_table solutions
- where os.os_id = solutions.os_code
- and os.os_id = 8;
-ms
-Original Message-
From: John Hoskins [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 02, 2003 10:41 AM
To: [EMAIL PROTECTED]
Subject: select
Not quite that simple, Plese read the last of the original post. I need
all solutions that have the 4th bit on, so 8,15,24,31...255 all have the
4th bit in combination with other bits.
On Wed, 2 Apr 2003, Michael Shulman wrote:
mysql select solution
- from os_table os, solutions_table
sec)
mysql select * from t where mod(i,4) = 0;
+--+
| i|
+--+
|4 |
|8 |
+--+
2 rows in set (0.00 sec)
-Original Message-
From: John Hoskins [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 02, 2003 11:34 AM
To: Michael Shulman
Cc: [EMAIL PROTECTED]
Subject: RE
801 - 900 of 1409 matches
Mail list logo