On Feb 17, 2014, at 12:36 PM, Roy Lyseng wrote:
> Try... `ip` IN (SELECT ip FROM temp_ip)
Wow! Only 1 second to return the results now!! That's 15x faster!!!
> Each subquery needs to be a complete SELECT query.
That's good to know. I figured that since temp_ip referenced a
co
On Feb 17, 2014, at 10:17 AM, Roy Lyseng wrote:
> please try filtering with a subquery that locates ip addresses with more than
> 1 attempt:
Hi Roy,
That did it! Thank you so much!!! Now I just need to study that IN
clause to see what's going on there.
> If this is too slow, you may
On Feb 12, 2014, at 6:30 PM, Larry Martell wrote:
> Try adding a having clause, e.g.:
>
> SELECT `ip`,`page`,`url`,`time_stamp`
> FROM `ip_addresses`
> WHERE (`time_stamp` BETWEEN date_add( CURDATE(), INTERVAL -1 DAY ) AND
> CURDATE() - INTERVAL 1 SECOND)
> AND TRIM(`referrer`) LIKE ''
> HAVING C
Hello,
I have the following SQL statement that I'd like to add to. It's used
to create a report that's emailed to me showing hits to our site that didn't
provide a referrer. However, I only want to report on multiple hits from the
same IP address - not just a single hit by someone.
d for Solaris 2.x, 9
and
10, Windows XP, and Mac OS X 10.4, and almost certainly others.
HTH,
Dan
On 2/20/07, Chris White <[EMAIL PROTECTED]> wrote:
>
> Sun, Jennifer wrote:
> > Any answers for the question below ?
> >
> > Is there a DST patch for MySql
Any answers for the question below ?
Is there a DST patch for MySql 4.0.20? Thanks.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, February 09, 2007 9:30 AM
To: mysql@lists.mysql.com
Subject: MySQL Daylight Savings Time Patch
Is there a DST patch
My commands are as follows:
%ssh -L 8080:localhost:3306 remote_server_ip
%mysqldump -u user_name --port=8080 --compact --quick --all-
databases > dumpfile
Depending on the "user_name" it either fails or dumps my local data.
It doesn't even use --port
Regards,
Mich
mresults . "");
Thanks
Jenn
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Saturday, May 21, 2005 1:56 PM
To: Jennifer Fountain
Cc: mysql@lists.mysql.com
Subject: Re: Query Issue on Large DB
Hi,
have you a query sample + show create table + show in
as to what I am missing? Thanks for any information!
Kind Regards,
Jennifer Fountain
Systems Administrator/Security
R&B Distribution
3400 E Walnut Street
Colmar, PA 18915
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.c
#x27;
When I login to server, do 'flush logs' in command line, got error ' ERROR
1105: Unknown error '
Anyone has idea on how to resolve this issue, please share with us. Thanks.
Jennifer
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
-- Original message --
From: -{ Rene Brehmer }- <[EMAIL PROTECTED]>
> Task at hand: deleting or selecting (same difference) several numbers of
> records using only 1 query.
>
> My first version simply looped through all the ticked off IDs and ran a
> single query
-- Original message --
From: none none <[EMAIL PROTECTED]>
> Perhaps you did'nt grant access to for your home workstation IP
> address to have permission to log into the mysql server? Check out the
> grant command:
>
> http://dev.mysql.com/doc/mysql/en/GRANT.html
I
-- Original message --
From: Tom Crimmins <[EMAIL PROTECTED]>
>
> $ mysqldump -u root -p govern > test.sql
> Enter password:
> mysqldump: Got error: 1017: Can't find file: './govern/VT_SY_LANGUAGE.frm'
> (errno: 24) when using LOCK TABLES
>
perror says 24 is too m
-- Original message from Richard Whitney <[EMAIL PROTECTED]>:
--
> Hello!
>
> I have situation where I need to find the next autoindex of a table - not just
> max(field) because the next autoindex may not jive with the number created by
> max(field)
http://dev.mysql.
me now...
Is there anyone else on this list who has looked at this issue or can
point me in the direction of more information about it?
thanks a bunch,
jenni
--
Jennifer Snyder
Database Administrator
Tribe Networks, Inc.
www.tribe.net
--
MySQL General Mailing List
For list archives: http://list
Thanks Marc,
What version of myisam table you are talking about? We are on 4.0.20, when I ran the
big table query, I tried to insert to it twice without any issues.
The -q worked good for mysql client. Thanks.
Jennifer
-Original Message-
From: Marc Slemko [mailto:[EMAIL PROTECTED
0:37 AM
To: [EMAIL PROTECTED]
Subject: RE: tuning suggestion for large query
At 04:13 PM 9/1/2004, Sun, Jennifer wrote:
>Thanks Mike.
>Seems like even with handler, the big query process is still consuming all
>my RAM and swap and being killed with error
>'VM: killing process my
The command is issued from mysql command line. Is there any parameters or options I
can use without locking the table?
-Original Message-
From: Marc Slemko [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 02, 2004 2:24 PM
To: Sun, Jennifer
Cc: [EMAIL PROTECTED]
Subject: Re: tuning
Thanks Mike.
Seems like even with handler, the big query process is still consuming all my RAM and
swap and being killed with error
'VM: killing process mysql
__alloc_pages: 0-order allocation failed (gfp=0x1d2/0)'
I would like to find a startup parameter either for client or server to limit per
Hi,
We have a job that do 'select * from big-table' on a staging mysql database, then dump
to data warehouse, it is scheduled to run once a day, but may be run manually. Also we
have several other small OLTP database on the same server.
When the big job run, it would use all the physical mem and
Not being an MSSQL expert, I don't know what MM does, and since you did not specify
what type of conversions you wish to perform, I can't say exactly which function would
suit your needs, but here is a link to the manual page that lists all date and time
functions --
http://dev.mysql.com/doc/my
them. If you're looking for names where -any- of them
can have 'ja' in them, use the OR.
Jennifer Horne
Panda Voice Systems Inc.
1.888.767.2632 ext 23
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, March 22, 2004 9:41 AM
To: [EMAIL PRO
places
online, but can't seem to find the solution.
Thanks in advance for any assistance,
Jen
Jennifer Horne, Software Developer
[EMAIL PROTECTED]
Panda Voice Systems Inc.
1.888.767.2632 ext 23
I have recently re-entered the job market and I was wondering if anyone has
found that having certification really helps in landing a position. If so,
which cert do you have?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/
> 2 index on this table:
> - one unique index on user_id and att_id (pk)
> - one index on att_id and user_id.
>
> I need to have the following query:
>
> select value from user_att where att_id = ? and value like '?'
> (no wildcard)
> 1. when I do a explain, this query use the second index. But,
> Is there some way to do something like:
>
> SELECT * FROM tables WHERE name = "table_name";
>
> And get a result I could test for truth, and thus run my script?
Show tables like 'table_name';
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:htt
> I then try to connect to the server from a remote location and get
> ERROR 1130: Host 'xxx.yyy.zzz' is not t allowed to connect to
> this MySQL server
> which is normal since i did not create a user yet
>
> I do this:
> GRANT ALL PRIVILEGES ON *.* TO stew@'%' IDENTIFIED BY '123' WITH
> GRANT OPTI
> When I run a query that has a timestamp field, How can I query on just the
> date. Time stamp puts in the min, hour, and sec. All I need is the year,
> month, and day.
>
> SELECT * FROM table_name WHERE date = '2003-08-25';
select * FROM table_name WHERE DATE_FORMAT(date,'%Y-%m-%d') = '2003-08
> I have 2 tables used for an online calendar...
>
> first table fields: primary_key , start_date, event_name,
> event_description
> second table fields: primary_key, end_date
>
> Tables fields are shortened and can't be changed.
>
> My second table only contains events that have a end date. I want
> > A crash was recreated by running a specific query.
>
> Oh.
>
> You didn't mention crashes in your first note. That changes
> everything.
Sorry, I'm a dork. Buy crash I mean "all new connections getting stuck in
authentication mode." As the day w
> > One of my coworkers insists that this is due to corrupt indexes, stating
> > that if an index points to a location outside of the record set
> mysql gets
> > confused and hangs.
>
> Does he have any evidence whatsoever for that? I'm 99% sure he's
> wrong--at least in *our* cases. :-)
A crash
> Setting skip-name-resolve will avoid this code path and the bug. It
> looks like some DNS funkyness...
>
I've implented this and so far I can't get the box to hang in authentication
no matter how mean I am to it. I feel so dumb, for not thinking of this
before, I swore I had already done it ab
I have a stand alone database server. It is a RAID5 running mySQL 3.23.55
on FreeBSD 4.1 and has 768MB of RAM, I'm not sure on the processor speed,
but I think it's a P3 1GHz. It has several tables with 20-40 million rows
and a ton of smaller tables with less than 1 million rows. All tables are
> Ok, I know it WAS there because we have two similar tables that should
> contain sister records. One table has a record the other doesn't so it
> had to have been deleted. I need to find out WHEN it was deleted.
>
> How do I create a log of record deletes?
>
If you keep the update log or the
> I am running php 4.2.2 and mysql 3.23.54.
This is a PHP question, not mySQL.
> This is my query:
>
> $sql = "SELECT MAX(esn) FROM address"; // line 37
> $max_esn_result = mysql_query($sql) or print mysql_error(); // line
> 38
> $max_esn = mysql_result($max_esn_result,$i,"esn
> > Worked like a charm! I couldn't find anything about this in
> > MySQL docs
> You have to search for 'string functions' to find it. Problem is that a
> search for REPLACE will bring up the REPLACE syntax, not the REPLACE()
Or you can look at the function index
http://www.mysql.com/doc/en/Funct
>what would be causing the error:
>
> SELECT certificate.cert_num, master_info.uid
> FROM certificate
> JOIN master_info ON ( certificate.uid = master_info.uid )
> LEFT JOIN endorsements ON ( certificate.cert_num =
> endorsements.cert_num )
> WHERE certificate.active = 1
> AND certificate.referred
> I am changing a database and changing the user and password of an
> existing
> database. when I enter the line.
>
> mysql> insert into user (host, user, password) values ('localhost',
> 'newuser', password ('newpswrd'));
>
> the error 1062: Duplicate entry 'localhost-newuser' for key 1
> mysql>
> One should always use the
> LAST_INSERT_ID() or after an insert, select max(id) from myTable.
Select max(id) from myTable should never be used to get the last insert id.
On a high traffic table you are not guaranteed it will be the ID for the
record you just inserted, another could have been in
> After I set starttime to now(), anytime I run another update query against
> the row starttime changes to a new value.
If starttime is the timestamp data type, and the first timestamp in the row,
it will automatically update every time you update the row. This is not a
bug, it is expected behav
>Could you please advise me on how to export data in
> LINUX/MySQL table
> for web publishing?
If you need the data in a mysql table displayed in an HTML table, a quick
and dirty way to get a static file is to run this from the command line...
#mysql -uroot -p -H -e"SELECT * FROM Employee"
They are only sending one. It is proper form when replying to reply to both
the sender and the list. Since you are on the list you are getting the list
copy as well as the copy sent directly to you.
I think their problem was the fact that you admitted you were just asking
(vauge) questions becau
Because you are using a float. There has been much discussion of this on
the list, search the archives. Floats aren't so good if you need your math
to be right.
http://www.mysql.com/doc/en/Column_types.html
> -Original Message-
> From: LeTortorec, Jean-Louis [mailto:[EMAIL PROTECTED]
>
You can rename a table by using the alter syntax
http://www.mysql.com/doc/en/ALTER_TABLE.html
ALTER TABLE tbl_name RENAME [TO] new_tbl_name
> -Original Message-
> From: Mark Wilson [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 31, 2003 4:41 PM
> To: Mysql Mailing List
> Subject: Rename/C
Why the join? Why not just "select p1.email, count(*) as occurances from
table p1 group by p1.email having occurances > 1"? Am I missing something?
> -Original Message-
> From: Andy Eastham [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, April 01, 2003 12:29 PM
> To: [EMAIL PROTECTED] Mysql.
-
From: trashMan [mailto:[EMAIL PROTECTED]
Sent: Monday, March 31, 2003 2:20 PM
To: 'Jennifer Goodie'; [EMAIL PROTECTED]
Subject: R: Replication don't work.
The binlog and the pos are the same in master and slave !
Webserver-bin.008 pos 73
Ehmm...i don't know how to sav
Just my two cents
> -Original Message-
> From: Seth Brundle [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 31, 2003 3:29 PM
> To: David Brodbeck; [EMAIL PROTECTED]
> Subject: Re: Could we make this a web discussion forum?
>
>
> > > I really hate on-line forums. They're difficult to track
31, 2003 2:04 PM
To: 'Jennifer Goodie'; [EMAIL PROTECTED]
Subject: R: Replication don't work.
The error.log on the master dont' report anything...
MySql: ready for connections
Other info
>Show master status;
***
Headeransw
It the master actually writting to the binlog? What does the master say
when you run SHOW MASTER STATUS? Is the size of the binlog growing?
-Original Message-
From: trashMan [mailto:[EMAIL PROTECTED]
Sent: Monday, March 31, 2003 1:29 PM
To: [EMAIL PROTECTED]
Subject: Replication don't wo
>I've tried it both as fixed (char) and variable (varchar). Interestingly
>when I set is as char when building the table, MySQL changes it to varchar
>sometimes (but not always).
It will change a char to varchar if there is another column of variable size
in the table.
--
MySQL General Mailing
That would grant the user select on everything in every database no matter
what host they are coming from. He wants to only grant on specific tables,
and did not mention anything about allowing from all hosts.
To answer the original question, I have tried a lot of different ways, but
the only sol
I don't use Dreamweaver so I have no clue what the interface is like. But
basically the php function mysql_connect or mysql_pconnect will be somewhere
in the page. It takes the username, host, password ect. as arguments. You
script might be set up with variables that hold these defined at the to
You said that you changed the password to the password you wanted, but in
all the examples you are trying to access the server without a password.
Try using the -p flag so it prompts you for your password, then type in
whatever you set the password to be.
-Original Message-
From: katherin
ALTER TABLE table_name DROP col_name
http://www.mysql.com/doc/en/ALTER_TABLE.html
So...
mysql> use hitcounter;
mysql> ALTER TABLE info DROP count;
Assuming info is the table name and count is the column you'd like to drop.
-Original Message-
From: Wileynet [mailto:[EMAIL PROTECTED]
Sent
You don't.
http://www.mysql.com/doc/en/Fulltext_Search.html
There was a discussion on this mailing list last week or the week before on
when innoDB support would be implemented. I'm too lazy to look it up, you
should search the list archives for it.
-Original Message-
From: Sidar Lopez C
Probably a permission problem. If it cannot read the file it cannot import
it.
monster> perror 13
Error code 13: Permission denied
-Original Message-
From: James E Hicks III [mailto:[EMAIL PROTECTED]
Sent: Monday, March 24, 2003 11:48 AM
To: Mysql
Subject: mysqlimport: Error: Can't get
On a linux box you do not have to stop everything like on Windows. We
always leave our current version running, install the upgrade in a new
location with a new data dir (a snapshot of the live one). We run the new
install on a different port than the live install so we can test it and what
not b
I wouldn't run 3.23.51, there have been major security patches since then.
I always mess up the byte math, but it looks to me like you have 2 gigs of
ram in your box and you are allocating 2.3 gigs to mysql. With 263
connections you would have been using about 1.4 gigs, if you have anything
else r
It is not strange, it is expected behavior. A browser can only handle so
many lines of html before getting all wonky. Running a query that takes
over 5 minutes to run in a web application is a bad idea, no one is going to
want to sit there and wait for it and if there is no output for an extended
It says in the change log that it added the port to make it easier to see
where the connection is coming from. 146.101.143.72:48753 gives you a lot
more information than "host1"
>From the release announcement --
* `SHOW PROCESSLIST' will now include the client TCP port after the
hostname to m
What does it say when you run SHOW MASTER STATUS on the master? Are you
sure the slave is the problem and not the master?
-Original Message-
From: trashMan [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 13, 2003 7:29 AM
To: [EMAIL PROTECTED]
Subject: Replication error
Please.seven
Database name goes after options. It is showing you the help page because
it does not understand what you are passing to it. It's kind of saying
"Here, look at this, this is how I work, follow these directions they might
help you out."
-Original Message-
From: Anil Garg [mailto:[EMAIL PR
able.
Can anybody tell me how I can fix this problem?
Thanks very much
Jennifer
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To re
What language are you using? As far as I know Apache doesn't connect to
databases, you have to use a programming language to do that. I'm guessing
you are using PHP and you have possibly upgraded it without compiling in
mysql support.
-Original Message-
From: Henning Olsen [mailto:[EMAIL
It does not sound like your data is properly normalized. You might want to
take a look at the way you have things set up, this sounds like it cause
problems later on.
-Original Message-
From: Danny [mailto:[EMAIL PROTECTED]
Sent: Monday, February 24, 2003 1:54 PM
To: [EMAIL PROTECTED]
Sub
SHOW TABLES;
Then treat the output as a normal result set.
see the manual for more about SHOW syntax
http://www.mysql.com/doc/en/SHOW.html
-Original Message-
From: Jeff Pearson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 20, 2003 2:31 PM
To: [EMAIL PROTECTED]
Subject: List of Tabl
>Yes. You can use INSERT INTO select from ..
>> If this matters, I will be doing this in 2 different applications. 1
>> database is MySQL, and the other is MS Access.
Not if the two tables are on different database servers. But maybe I'm
reading that wrong and the application is just being de
You could have PHP escape it for you. Look into the addslashes function.
It adds slashes to escape characters.
http://www.php.net/manual/en/function.addcslashes.php
If your server has magic quotes turned on it will automatically escape
characters, but it is not a good idea to rely on that.
If yo
This is probably a dumb question, but are you running all the queries in
eod_stocks? I ran all the queries and they worked fine. I undotted the
select though because my database was not called eod_stocks. Since you did
not include the part where you select the database to run these queries in,
o
Are you referring to the data type SET or the Command SET? The manual page
you point to is talking about the data type, but usually when seen in an
insert it is the Command. I can't recall seeing the datatype referred to in
an INSERT, but maybe my brain isn't fully on yet today.
http://www.mysql.
A Left join using IS NULL will work. You can get the syntax and see an
example in the manual
http://www.mysql.com/doc/en/JOIN.html
>From the maunal...
If there is no matching record for the right table in the ON or USING part
in a LEFT JOIN, a row with all columns set to NULL is used for the righ
Read the section in the manual about timestamps, this is expected behavior,
it is how it is supposed to work.
http://www.mysql.com/doc/en/DATETIME.html
The TIMESTAMP column type provides a type that you can use to automatically
mark INSERT or UPDATE operations with the current date and time. If yo
PHP is server side, javascript is client side, they do not interact with
each other. PHP gets parsed by on the server before the page is rendered,
javascript is interpreted by the browser. You can either have PHP generate
the javascript or just put it in the page. Rollovers have nothing to do
wi
The problem is probably in either your PHP or HTML, not MySQL. It is common
to store mutliple words separated by a whitespace in varchar and text
fields.
-Original Message-
From: Anna Noel Leavitt [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 30, 2003 8:40 AM
To: [EMAIL PROTECTED]
Su
on
while you are running your reports?
Is the production server tuned for the type of complex queries you are
running?
-Original Message-
From: Mary Stickney [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 30, 2003 12:02 PM
To: Jennifer Goodie; [EMAIL PROTECTED]
Subject: RE: timing
>They run in 8 minutes on my test server , about 4 minutes each. Printing to
>a PDF driver.
>On the Production Server they take HOURS to run and print.
The production server is probably trying to do other stuff at the same time,
making your reports slower. A machine with one active connection wi
Try a straight join with the cases table first. You have to play with your
queries to get the best results.
Creating a temporary, as you mentioned, table might be a very good option in
this case, but you need to make sure that your programming takes into
account that your page might be hit more t
Your joins are probably not using indexes and the tables could be joining in
an inefficient order. Try running an explain on your query to see how it is
being done.
-Original Message-
From: Steve Quezadas [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 21, 2003 1:31 AM
To: [EMAIL PROT
Are you creating new tables or importing from an old application? If you
are building something from scratch it is a really really bad idea to use
spaces in the names or start putting in special characters, you're just
making more work for yourself, and anyone that works on the application
after y
Does the box have PHP installed and configured to use MySQL?
I wouldn't go with the php3 extension, as it is outdated, PHP4 has been
stable for a while.
-Original Message-
From: Will Standley [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 16, 2003 3:14 PM
To: [EMAIL PROTECTED]
Subjec
>My feeling is that MySQL shouldn't allow reserved words / characters
>like this, whether they are in quotes or not.
...
>Does anyone know the logic behind allowing reserved words when inside
>quotes like this? It clearly causes problems - especially for people
>using GUIs - and these people will b
MySQLCC probably uses the backtick (`) to escape stuff so it issued
UNIQUE KEY `IDX_Postcode-Location` (Postcode,Location)
and not
UNIQUE KEY IDX_Postcode-Location (Postcode,Location)
It has been mentioned on the list a few times in the last couple months that
if you escape strings containing hyph
Sounds a lot like the grape blends in different wines question posted last
week. :)
You'll need a cross ref table with a one to many relationship and possibly a
field that says what the person did.
like
| SongID | ComposerID | Role |
++-++
|1 | 1 | P
I am not a guru, but I figured I'd try to answer anyway. It needs an extra
bit because it has NULLs. I think it uses the bit to mark if the field is
NULL or not, but I've been known to be wrong.
http://www.mysql.com/doc/en/Data_size.html
-
Dear gurus,
here's my final stupid question
>can anyone point me to a reference regarding the Com_ status information
What exaclty do you mean? http://www.mysql.com/doc/en/SHOW_STATUS.html
states that the com_ is just how many times the command has been
issued. So if com_select = 34021 there have been 34021 selects issued to
the
Blend will be a cross reference with a one to many relationship
This is very simplified but an example of your data could be:
Select * from Wine;
++--+
| WineID | WineName |
++--+
| 1 | XYZ |
++--+
Select * from Grape;
+-+
>Did you already announce this several days ago?
Once last Monday and once in November, but isn't this the
messageboard-announce-spam list? :)
I'd hate to think a list called mysql is for questions about SQL and mysql
and not useless announcements about personal sites.
--
>ERROR 7: Error on rename of '.\helpdesk\call_information.MYI' to
>'.\helpdesk\#sql2-b90-81.MYI' (Errcode: 13)
>Any ideas on why I would get this??
Errorcode 13 is permission denied or file not found. Either
.\helpdesk\#sql2-b90-81.MYI exists and your mysqld user does not have
permission to over
HTML doesn't just see a URL and automatically make it a hyperlink it is not
"helpful" like MS products. So what you are seeing is expected behavior. I
would alter the while loop to look like this...
while ($row = mysql_fetch_array($resultID)){ #fetch_array adds little
overhead and gives you an
>Imagine an ISP giving every customer write privileges for the mysql/bin
directory ... ;-/
Why would they have to do that? The file does not need to be in that
directory. In order to use LOAD DATA INFILE without LOCAL the file just
needs to be somewhere on the server that mysqld is running on and
I bet the answer Paul DuBois was nice enough to post yesterday evening when
you asked this same exact question still applies.
You might want to search on your previous thread.
http://marc.theaimsgroup.com/?l=mysql&m=104198809410342&w=2
-Original Message-
From: Beogradjanin [mailto:[EMAIL
Are you using indexes on your tables? This does not sound like a mysql bug,
but rather a problem with your table structure or query. I have seen much
more complicated joins work on much larger tables without any problem, as I
am sure many people on this list have as well. You should run an expla
It would be helpful if you posted that error. You can get it by changing
the die to
$queryr = mysql_query($query) or die(mysql_error());
Without knowing the error, you problem will be harder for everyone to debug.
-Original Message-
From: Nuno Lopes [mailto:[EMAIL PROTECTED]]
Sent: Mon
http://www.mysql.com/doc/en/CREATE_INDEX.html
you key needs a length, not your field.
index (hashsum(length)) # for quick lookups
-Original Message-
From: David T-G [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 30, 2002 1:53 PM
To: mysql users
Subject: indexing a blob
-
With the same user? It sounds like you might want to read the documentation
on GRANT and permissions. It is always a good idea to try the documentation
before asking questions on the list.
http://www.mysql.com/doc/en/User_Account_Management.html
-Original Message-
From: Gary Hostetler
Problem is not in the connecting it is in the mysql_select_db as you are
denied access to the database, not the server. Your permissions might be
off or the php might not be right. It would be helpful if you posted more
of your code.
-Original Message-
From: Gary Hostetler [mailto:[EMAIL
Have you tried optimizing your query? It is more likely that the problem is
a poorly optimized query and/or poorly tuned server than it is mySQL. Joins
will be slow if you do not take the time to figure out the best way to do
what you are trying to accomplish. Forcing the table order can really
It sounds like you need to edit your hosts.allow file to allow from the IP
you want to connect from.
add either
mysqld : ###.###.###.### : allow
or
mysqld : all : allow
I'm not a sysadmin though, so you might want to do a search on the proper
way to do this.
-Original Message-
From: Kr
ORDER BY col [ASC|DESC]
http://www.mysql.com/doc/en/SELECT.html
-Original Message-
From: Mike(mickako)Blezien [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 12, 2002 11:45 AM
To: MySQL List
Subject: Sorting Results
Hello all,
Is there away, within the sql query, to sort the query r
select name, SUM(count) from stats group by name;
-Original Message-
From: news [mailto:[EMAIL PROTECTED]]On Behalf Of Max Clark
Sent: Wednesday, December 11, 2002 4:05 PM
To: [EMAIL PROTECTED]
Subject: Newbie - group and tally help
Hi-
I am trying to write a sql query that will select,
1 - 100 of 128 matches
Mail list logo
