If so, how is it working out? Are you taking advantage of the
64bit memory space?
Jeremy
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
[EMAIL PROTECTED] | http://jeremy.zawodny.com/
MySQL 4.0.15-Yahoo-SMP: up 31 days, processed 1,151,820,403 queries (426/sec. avg)
--
I have two servers - one serving a live site and once acting as a backup via
replication.
From our calculations site usage should be generating around 6 queries per second.
This is confirmed by the frequency of queries appearing in the master binlog, and by
increases in the 'questions' value
You're confusing the left/right sides of LEFT JOIN...
Using LEFT JOIN, it is the right table that is dependent on the left
table. All results from left table are selected.
So you may try:
SELECT state.name AS state , group.name AS group,
group.zip AS zip, city.name as city
FROM state
LEFT
Whenever you use select * MySQL will skip using index. For more
information, http://www.mysql.com/doc/en/MySQL_indexes.html .
Thanks,
Ram
mos [EMAIL PROTECTED] 10/15/2003 10:17:22 AM
I want to speed up a large query and I noticed if I do an:
Explain select * from LargeTable order by
Hi,
I inserted one record thr PHPMyAdmin - mem_pass field of member table set to xyz
using function 'PASSWORD'
Then trying to select the same - select * from member where mem_pass = PASSWORD('xyz')
- then it is not getting selected
I do not know why I am not getting the result. please help
On Wed, 15 Oct 2003 17:26:23 +0800
Manisha Sathe [EMAIL PROTECTED] wrote:
Hi,
I inserted one record thr PHPMyAdmin - mem_pass field of member table set to xyz
using function 'PASSWORD'
Then trying to select the same - select * from member where mem_pass =
PASSWORD('xyz') - then it is
Hi,
I tried to install mysql on PowerPC-LynxOS machine, and got into the
following issues. If some body can help me resolve this, it would be of
great help.
First I like to list the changes I did to compile mysql for PowerPC-LynxOS
using cross compilers in sparc-sunos.
Configure script changes
I have same problem ( ...timeouts.. variables are set 1000) - after 30 sec
connection dies. This look like problem in client software 4.0.15 version
(mysql, mysqlcheck,mysqldum...). When I used clients from 4.0.13 version,
problem disapeared.
(win distribution)
Regards
Jaroslav
-Original
Hi
Three questions from a Mysql newcomer
Syntax question:
Can a table in database A have a foreign key
relationship with a table in database B? (both INNODB,
both with appropriate indexes, etc)
Architecture question:
What is the rule-of-thumb to use use multiple
databases, rather
Hi
A group_id cannot be both 1 AND 3, but it can be 1 OR 3.
Try OR
Yes. I know that group_id can't be both 1 and 3 at the same time. This is
exactly
my problem. How to find a record that belongs to both groups 1 AND 3?
If I use OR here, I get also records that only belong to group 1 or only
I am running the command line in two modes. In one I pipe to it in an
application with arguments -s -n -N -r; and I can send multiple queries in
one write to the mysql command line too.
I then run mysql command tool in the linux shell with the same parameters and
I cannot submit multiple
Hi all,
Looking back over the eWeek benchmark that's linked to from www.innodb.com
(where MySQL is a match for Oracle), I made a few observations.
Firstly, both MySQL and Oracle achieved basically identical performance
levels. This puzzles me as many tests I have seen online show MySQL totally
I believe I tried that -- but when I did (and I just repeated it with the
same result) mysql effectively hangs (i.e. the query takes interminably
long -- I let it run for 20 minutes before killing it).
So should I be looking at an indexing issue? Right now the only things
indexed in the
2. Grants aren't working.
Almost for each db we have the grant I did is something like :
grant all on db.* to 'user'@'%.domain.com' identified by 'password';
So, I end up with a user with no global privilege in the user table,
and
a
entry in the db table with all privs.
Background of problem:
I have lists of information that need to be ordered manually.
Example:
[tblList]
ID - TYPE - POS
1 - Name - 1
2 - Company - 2
3 - Website - 3
that would be the actual table structure and its data, displayed on a
website.
Now if a user decides
mos [EMAIL PROTECTED] wrote:
I want to speed up a large query and I noticed if I do an:
Explain select * from LargeTable order by IndexCol1
it always has Extra Using FileSort, which means it is physically sorting
the result set.
I've tried different tables and sorted on different index
* Jouni Hartikainen
Hi
* someone else
A group_id cannot be both 1 AND 3, but it can be 1 OR 3.
Try OR
* Jouni Hartikainen
Yes. I know that group_id can't be both 1 and 3 at the same time. This is
exactly my problem. How to find a record that belongs to both groups 1
AND 3? If I use OR
* D. R. Hansen
At 03:51 AM 10/15/03, Diana Soares wrote:
You're confusing the left/right sides of LEFT JOIN...
Using LEFT JOIN, it is the right table that is dependent on the left
table. All results from left table are selected.
So you may try:
[...]
I believe I tried that -- but when I did
Need to find out which rows from select 1 are not present in select 2,
but is it possible to make som kind of union that only returns the
overlapping rows from the two selects?
Sincerely
Victor
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
I need to find out, using a join, which corresponding rows in a union
that is missing. But it is among a certain subselect I want to do
this, that is, among the rows where the column lang = 'uk' for
example.
The two tables looks like following:
+---++---+
| id |
for example:
Table1 contains: A and B and C
Table2 contains: B and C and D
all varchars
The query:
select A, B, C, '' as D from Table1
UNION
select '' as A, B, C, D from Table2
if the values are no varchar but for example smallints then you replace the
'' with 0 or whatever wich value (eg NULL).
If I'm right you want to do a left join.
For example:
Table1:
Id value
1 100
2 200
3 300
Table2:
Id RefId OtherValue
1 1 9000
2 1 1
3 2 8000
If you do this:
select
Hello,
I've got a typo3 database running on mysql on a redhat 9 machine. The
database was working fine for several weeks, and now all of a sudden I
can no longer log in. I tried creating new users through phpMyAdmin, and
I still am unable to login. Is it possible to lock a database?
Anything else
* Tofu Optimist
Three questions from a Mysql newcomer
Syntax question:
Can a table in database A have a foreign key
relationship with a table in database B? (both INNODB,
both with appropriate indexes, etc)
Yes, but I suspect that you really meant foreign key constraints?
Constraints
Of course,
But you still can see the table structure???
Hans
At 16:05 15-10-03 +0200, you wrote:
2003-10-15 kl. 15.51 skrev Hans van Dalen:
Table1 contains: A and B and C
Table2 contains: B and C and D
all varchars
The query:
select A, B, C, '' as D from Table1
UNION
select '' as A,
Hi list,
I have the following problem and here is the message that displays the
console when I try to connect
Warning: Can't create a new thread (errno 11). If you are not out of
available memory, you can consult the manual for a possible OS-dependent
I'm using linux, Red Hat 7.3 Linux version
[EMAIL PROTECTED] wrote:
I've got a typo3 database running on mysql on a redhat 9 machine. The
database was working fine for several weeks, and now all of a sudden I
can no longer log in. I tried creating new users through phpMyAdmin, and
I still am unable to login. Is it possible to lock a
At 07:47 AM 10/15/2003, you wrote:
mos [EMAIL PROTECTED] wrote:
I want to speed up a large query and I noticed if I do an:
Explain select * from LargeTable order by IndexCol1
it always has Extra Using FileSort, which means it is physically sorting
the result set.
I've tried different tables
How does one restore a mysql database if it crashes in
the middle of a large operation?
RB Not sure what you mean...
What if i on purpose turn off the computer when mysql is in the middle of
transaction execution ? Will the server on restart automatically
rollback the crashed transaction ?
Did you get any error messages?
Oh, sorry, forgot that part. No, it refreshes the screen as though the
name or password were incorrect. I've tried creating new users into the
table, but still does the same thing.
--
Jody Cleveland
([EMAIL PROTECTED])
--
MySQL General Mailing List
For list
I am currently testing this on a new dual 2GHz G5 with 4GB of RAM.
Seems pretty nice so far. I've loaded up a copy of our production
database (4GB of data for real estate web sites) and moderate property
search queries of ours run much faster than on our dual G4 MDD
PowerMac. I guess we're
At 17:26 +0800 10/15/03, Manisha Sathe wrote:
Hi,
I inserted one record thr PHPMyAdmin - mem_pass field of member
table set to xyz using function 'PASSWORD'
Then trying to select the same - select * from member where mem_pass
= PASSWORD('xyz') - then it is not getting selected
I do not know
In the last episode (Oct 15), mos said:
At 07:47 AM 10/15/2003, you wrote:
mos [EMAIL PROTECTED] wrote:
I want to speed up a large query and I noticed if I do an:
Explain select * from LargeTable order by IndexCol1
it always has Extra Using FileSort, which means it is physically
In the last episode (Oct 15), Gavin Foster IFP said:
From our calculations site usage should be generating around 6
queries per second. This is confirmed by the frequency of queries
appearing in the master binlog, and by increases in the 'questions'
value of 'show variables' on the backup
* DeBug
How does one restore a mysql database if it crashes in
the middle of a large operation?
RB Not sure what you mean...
What if i on purpose turn off the computer when mysql is in the middle of
transaction execution ?
Then someone should smack your fingers...! ;)
Will the server
* v0idnull aka Alex Dow.
Background of problem:
I have lists of information that need to be ordered manually.
Example:
[tblList]
ID - TYPE - POS
1 - Name - 1
2 - Company - 2
3 - Website - 3
that would be the actual table structure and its data, displayed on a
I've tried this on MySQL 4.0.15 and 4.1.0-alpha, with
the same result.
I have the following table A:
++---+--+
| id | value | type |
++---+--+
| 1 | 6 | a|
| 2 | 2 | b|
| 3 | 5 | b|
| 4 | 4 | a|
| 5 | 1 | c|
| 6 |10 | d
Wow, new dual processor G5... behaviordrool/behavior
How are the bulk operations performing?
-Original Message-
From: Gabriel Ricard [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 15, 2003 11:05 AM
To: [EMAIL PROTECTED]
Subject: Re: Anyone using MySQL 4.x on Apple's G5?
I am
* Ana Holzbach
I've tried this on MySQL 4.0.15 and 4.1.0-alpha, with
the same result.
I have the following table A:
++---+--+
| id | value | type |
++---+--+
| 1 | 6 | a|
| 2 | 2 | b|
| 3 | 5 | b|
| 4 | 4 | a|
| 5 | 1
mysql doesn't support anything called rollback upto 4.0
Nitin
- Original Message -
From: Roger Baklund [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: debug [EMAIL PROTECTED]
Sent: Wednesday, October 15, 2003 8:37 PM
Subject: Re: assorted: foreign keys, mult databases, and crashes
*
I have just recently compiled Mysql 5.0 onto my redhat linux box, and
have been trying to set up some store procedures, but have yet to be
able to figure out how. Can anyone help me on this on how to go about
creating a stored proc in Mysql 5.0??
Any help or suggestions would be great.
Hello:
I want to provide free text searching on my database across numerous fields.
The question is, is it better to use a freetext field, or pattern matching and
or-ing the fields I want to search.
What scares me off of Freetext is that I only have about 40 records, they all
relate to a
I have just recently compiled Mysql 5.0 onto my redhat linux box, and
have been trying to set up some store procedures, but have yet to be
able to figure out how. Can anyone help me on this on how to go about
creating a stored proc in Mysql 5.0??
Any help or suggestions would be great.
* Nitin
mysql doesn't support anything called rollback upto 4.0
This is not correct.
The concept of rollback is related to transactional table types, and both
InnoDB and BDB are available in the 3.23 version of mysql.
The first mention of rollback I could find in the manual was 3.23.17:
URL:
I have a mysql 3.23 running under win98. I also have a database with a largeblob,
which has a jpeg image in it.
Now I am trying to upload this to a free server using the following command to export
the table:
bin/mysqldump -u user --password=mypass mydatabase mytable dumpdir\mytable.sql
The
At 11:10 -0500 10/15/03, Terry Cheryl Haimann wrote:
I have a mysql 3.23 running under win98. I also have a database
with a largeblob, which has a jpeg image in it.
Now I am trying to upload this to a free server using the following
command to export the table:
bin/mysqldump -u user
When you install development test releases (pre-alpha) you are pretty
much on your own... Unless any documentation was included with the
download, the only other thing around is the blurb on mysql.com
http://www.mysql.com/downloads/mysql-5.0.html
On Wed, 2003-10-15 at 10:55, Josh Wilson wrote:
For the free web server, the transfer was web based using MyPHPAdmin.
To test it on my RedHat 8.0 box(my home network server,) I copied the file to my Samba
directory with Windows Explorer
Then I switched over and signed on and did the import.
On Wed, 15 Oct 2003 11:37:32 -0500, Paul DuBois
Are you attempting any sort of editing of the exported file?
We routinely dump our production database, which includes several tables
that hold TIF images, with no problems at all. In fact, we'll also transfer
data between servers with a command like:
Mysqldump --add-drop-table databasename
I just loaded (LOAD DATA INFILE ...) the main property table (MyISAM
type) for our database, which contains about 412,000 records. It took
167.79 seconds to load the data at about 2,456 records per second. The
table has 124 fields and 16 single-column keys. The records are around
900B - 1KB
Wouldn't code need to be added for mySQL to take advantage of memory
mapping in a 64 bit system? I was under the impression that mysql in its
current form has specific code to emulate the behavior thus the problem
of memory mapping at high levels.
- Dathan Vance Pattishall
- Sr. Programmer and
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
---Original Message-
--From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
--Sent: Wednesday, October 15, 2003 8:09 AM
--To: [EMAIL PROTECTED]
--Subject: Fulltext vs
* Mike
I want to provide free text searching on my database across
numerous fields. The question is, is it better to use a freetext
field, or pattern matching and or-ing the fields I want to search.
What scares me off of Freetext is that I only have about 40
records, they all relate to a
Hello,
We're building a Red Hat cluster server for MySQL. Are there any gotchas,
or any documentation I should read before setting up something like this?
For starters, can I make MySQL believe it's proper hostname is that of the
service-IP (that IP which is moved along with the service
Yes, that seems to be part of the problem. I still seem to be loosing some images
though.
And how can I upload to PHPMyAdmin without altering the comments that mysqldump
creates.
Terry
On Wed, 15 Oct 2003 12:05:19 -0500, Christensen, Dave wrote:
Are you attempting any sort of editing of
Roger:
Thank you for your reply, it is right on the money. I will try pattern
matching first and see how that works. I don't mind the extra
programming, and I don't expect our user base to grow significantly.
Thanks again
Mike
--
MySQL General Mailing List
For list archives:
Help,
Guys I have done this before but it is not working for me when I try to
do some
inserts via a file from the command line
c:\mysql mydb myfile.sql
ERROR 1044: Access denied for user: '@localhost' to database 'mydb'
I am logged in as administrator on my W2K and I have granted ALL
privileges
On Wed, Oct 15, 2003 at 12:14:58PM -0600, Matt Sturtz wrote:
For starters, can I make MySQL believe it's proper hostname is that of the
service-IP (that IP which is moved along with the service failover to the
active node)? This looks important because the bin-log filenames, as well
as the
On Wed, Oct 15, 2003 at 11:02:12AM -0700, Dathan Vance Pattishall wrote:
Wouldn't code need to be added for mySQL to take advantage of memory
mapping in a 64 bit system? I was under the impression that mysql in its
current form has specific code to emulate the behavior thus the problem
of
On Wed, Oct 15, 2003 at 09:37:29AM +0100, Gavin Foster IFP wrote:
An example from just after restart (using myTop in 'm' mode showing
number of queries executed each 1 second interval):
Dan has your answer on this. I'm just amazed that anyone uses the 'm'
feature. I added it mostly as a
On Tue, Oct 14, 2003 at 02:13:35PM -0700, Dathan Vance Pattishall wrote:
Does thread_concurrency work for x86 Linux systems?
I've never found it to help in the systems I've tweaked. Perhaps
someone else has?
Is there a particular problem you're trying to fix, or are you just
curious?
Jeremy
Did not workd, I get an error
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using
password: NO)
I can log in as -u administrator when I use the -p option. I need to
make it work
from command line because I am planning to put this command in
a script to make it automatic to insert
On Wed, Oct 15, 2003 at 11:04:47AM -0400, Gabriel Ricard wrote:
I am currently testing this on a new dual 2GHz G5 with 4GB of RAM.
Seems pretty nice so far. I've loaded up a copy of our production
database (4GB of data for real estate web sites) and moderate property
search queries of ours
On Tue, Oct 14, 2003 at 10:49:16AM -0700, Dathan Vance Pattishall wrote:
I wrote a quick PERL script to give me the status of a table of a
particular database or queries in general on a db server.
71 | 2958 | System lock | e115 | messages |
REPLACE INTO antispam
Nestor Florez [EMAIL PROTECTED] wrote:
Help,
Guys I have done this before but it is not working for me when I try to
do some
inserts via a file from the command line
c:\mysql mydb myfile.sql
ERROR 1044: Access denied for user: '@localhost' to database 'mydb'
I am logged in as
http://www.mysql.com/doc/en/Option_files.html
Check the example halfway down the page, it shows how you can supply a
password through your my.cnf file.
I can log in as -u administrator when I use the -p option. I need to
make it work
from command line because I am planning to put this
Quoting Jeremy Zawodny [EMAIL PROTECTED]:
On Wed, Oct 15, 2003 at 09:37:29AM +0100, Gavin Foster IFP wrote:
An example from just after restart (using myTop in 'm' mode showing
number of queries executed each 1 second interval):
Dan has your answer on this. I'm just amazed that anyone
How could I write a statement that uses something like 'OR' as a case. Like
this:
SELECT * FROM list WHERE name = '$this1' OR name = '$this2' OR name =
'$that1'
?
Thanks for any help,
-Mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
You can do it exactly like that, or you could use the IN() syntax if
you have a large number of values to check.
SELECT * FROM list WHERE name IN('$this1', '$this2', '$this3')
- Gabriel
On Wednesday, October 15, 2003, at 04:16 PM, Mike At Spy wrote:
How could I write a statement that uses
Believe it or not I tried
mysql -p administrator -p pwd mydb myfile.sql
and it would not worked, but when I got rid of the space it work
mysql -uadministrator -upwd mydb myfile.sql
I did not think that the spaces after the '-u' and the '-p' matter
Thanks,
Nestor :-)
Nestor A. Florez
---Original Message-
--From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]
--Sent: Wednesday, October 15, 2003 12:16 PM
--To: Dathan Vance Pattishall
--Cc: [EMAIL PROTECTED]
--Subject: Re: 4.0.15 skip-external-locking
--
--On Tue, Oct 14, 2003 at 10:49:16AM -0700, Dathan Vance Pattishall
In the last episode (Oct 15), Mike At Spy said:
How could I write a statement that uses something like 'OR' as a
case. Like this:
SELECT * FROM list WHERE name = '$this1' OR name = '$this2' OR name =
'$that1'
Exactly like you wrote it. You can also use WHERE name IN ('this1', 'this2',
Is there a way to turn on the General Query Log feature on a per database
level, or do I have to turn it on for every database? If so, is there an
article available? I've checked the MySQL documentation and it looks like
you just turn it on when the daemon starts - in that case, I'm assuming
At 13:15 -0700 10/15/03, Nestor Florez wrote:
Believe it or not I tried
mysql -p administrator -p pwd mydb myfile.sql
and it would not worked, but when I got rid of the space it work
Yes, that's how it's supposed to work:
http://www.mysql.com/doc/en/mysql.html
mysql -uadministrator -upwd mydb
At 16:39 -0400 10/15/03, - = James = - wrote:
Is there a way to turn on the General Query Log feature on a per database
level, or do I have to turn it on for every database? If so, is there an
article available? I've checked the MySQL documentation and it looks like
you just turn it on when the
What amount of time is reasonable to expect for indexing an FK int field on
a simple table with about 30K records. It's running on my learning
machine -- an aging Pentium 5/133 box running RH 8 which is ordinarily
quite fast enough for my purposes. It's been running about six hours now,
and
New to the list . . .
Running MySQL Server 3.23.58-1.72 on RedHat Enterprise AS. System has
four 3GHz processors and 6GB RAM.
I need some advise on what would be best way to approach this problem.
This system is using snmpcollect to collect network statistics from
about 1500 devices. The
Mahesh,
The best advice, from what I've heard around the list is to base your decision on this
based on your filesystem. Some filesystems handle large # of files well (1 db, many
tables) some don't. Some handle many directories well (many db's 1 tbl each), some
don't (ala your example).
Whats the goal with the Data? If it is graphing it then go with MRTG
with RRDtool, which will keep about 550 days of SNMP data and produce
graphs
displaying a daily, weekly, monthly and yearly timeframe... Could do
1500 devices with probably less than 10 Gigs of space...
You could then load the
We've had problems with a production database having indexes getting
corrupt. There are about 17 million records (500,000 new records a day)
in the table (MyISAM) and we run a delete script against it every night
to delete old data so the table doesn't get too big. We are running
mysql 3.23.56
On Wednesday, October 15, 2003, at 03:10 PM, Jeremy Zawodny wrote:
I'd be interested to know if you can get a test running that uses
either a key_buffer or an innodb_buffer_pool in the 3.5GB range.
Interestingly enough, I can't seem to get MySQL to use more than 2GB of
RAM.
I get errors like
Hi Dan,
133MHz huh? :-) Well, how large is the table? Huge rows? How many other
indexes are on the table and on how many columns? Are those columns
large? If you had a full-text index on a large column, for example, it
could take very long on that system, especially if you're using 3.23.
Hard
Give this more thought. I think you have more options that the two you
proposed.
With really large tables, you can collect data in them for a fixed time
period (monthly) then run a batch that removes the data for the time period
after moving it to an archive table.
Try making a staging table
I am trying to do an aggregate query, but having some problems and here
they are simplified:
Table1
date1
grouper1
x
Table2
date2
grouper2
y
Query is something like this:
SELECT SUM(x) as sum_x, SUM(y) as sum_y
FROM Table1
LEFT OUTER JOIN Table2 on grouper2 = grouper1
(date2 = '2003-07-01
okay this is strange. every time i try to start mysql via WinMySQLadmin, i get the
error message in the MyODBC box containing the following error:
Not Found
Driver 3.51 Not Found
ive uninstalled completly and reinstalled mysql twice and i cant seem to get mysql
running again. i even uninstalled
Gabriel Ricard wrote:
On Wednesday, October 15, 2003, at 03:10 PM, Jeremy Zawodny wrote:
I'd be interested to know if you can get a test running that uses
either a key_buffer or an innodb_buffer_pool in the 3.5GB range.
Interestingly enough, I can't seem to get MySQL to use more than 2GB
of
I'm trying to upgrade my KDE setup but it fails on a dependency for
libmysqlclient.so. I've looked at all the MySQL rpm files and none of
them seem to provide this file. Does anyone know where this one comes from?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
At 20:03 15/10/2003 -0500, .eric wrote:
Hi,
okay this is strange. every time i try to start mysql via WinMySQLadmin, i
get the error message in the MyODBC box containing the following error:
Not Found
The above should be for drive MyODBC 2.50
Driver 3.51 Not Found
Well on my machine the above
On Wed, Oct 15, 2003 at 10:46:59PM -0400, Randy Chrismon wrote:
I'm trying to upgrade my KDE setup but it fails on a dependency for
libmysqlclient.so. I've looked at all the MySQL rpm files and none of
them seem to provide this file. Does anyone know where this one comes from?
Probably a
I know this is a little off-topic, but I have been approached to do some
consulting to move an ISAM based app to MySQL. The potential customer is
asking an hourly rate but as I have not done MySQL work as a consultant I am
not sure what to charge.
Any Ideas?
Thanks,
Mike Hillyer
www.vbmysql.com
Jeremy Zawodny wrote:
On Wed, Oct 15, 2003 at 10:46:59PM -0400, Randy Chrismon wrote:
I'm trying to upgrade my KDE setup but it fails on a dependency for
libmysqlclient.so. I've looked at all the MySQL rpm files and none of
them seem to provide this file. Does anyone know where this one
For everyone who helped, THANK YOU!!
For anyone who might be interested, here's what finally did the trick and
is essentially giving me what I need:
CREATE TEMPORARY TABLE temptable
SELECT state.name AS state , group.name AS group,
group.zip AS zip, city.name AS city
FROM city, group, zip
LEFT
I ended up stopping and restarting MySQL -- which cleared up the
problem. Index creation took around a minute.
Dan
At 05:38 PM 10/15/03, Matt W wrote:
Hi Dan,
133MHz huh? :-) Well, how large is the table? Huge rows? How many other
indexes are on the table and on how many columns? Are those
Hi!
Haydies == Haydies [EMAIL PROTECTED] writes:
Haydies Access is not a Database, its a kiddies toy.
Haydies You can just as easlily make your reports using crystal reports or any thing
Haydies else like that if you really want to, or PHP/ASP
Haydies Now, please, for suggesting
Hi
From: Roger Baklund [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Yes. I know that group_id can't be both 1 and 3 at the same time. This
is
exactly my problem. How to find a record that belongs to both groups 1
AND 3? If I use OR here, I get also records that only belong to group 1
or only
Mike At Spy wrote:
How could I write a statement that uses something like 'OR' as a case. Like
this:
SELECT * FROM list WHERE name = '$this1' OR name = '$this2' OR name =
'$that1'
?
Thanks for any help,
-Mike
u just like that looks good to me.
--
MySQL General Mailing List
For list
96 matches
Mail list logo