 | | | MySQL General | | Grant Giddens wrote
> I have a new project I 'm working for and I was
> wondering if anyone could help me optimize my selects
> for speed. I have a table with about 500 000 entries.
> The table Hi
MySQL Query Browser 1.1.2 and MySQL Administrator 1.0.15 have been
released.
MySQL Query Browser is a GUI query shell intended to allow
execution of SQL queries from a Web browser alHave you tried connecting with this user directly from the MySQL monitor?
Hathaway Scott L wrote
>I have a server that is Windows 2003 server. It is running php from IIS
>6. I access the laStuart Felenstein wrote
> >I 'm storing telephone number (US) in 10 digit
> >varchars. If I want to do a search on just the area
> >code is there a way to limit it to just the first 3
> >digits of tFix your mysql privileges
http //dev.mysql.com/doc/mysql/en/GRANT.html
DVP
----
Dathan Vance Pattishall http //www.friendster.com
> -----Original Message-----
> From Hossain AshfBgs wrote
[...]
> I have a db which has among others (including text fields) a timestamp
> field and a counter field.
>
> I want to make statistics from them doing sum()s with conditions
> Isn 't that technically multiple queries?
In mysql an insert inserts into one table. That 's it.
-Eric
On Wed 1 Dec 2004 15 50 15 +0100 ***ADI*** <adi@(protected) > wrote
> in MS SFredrik Carlsson wrote
> Hi list
>
> I have a question regarding mysql and innodb.
> My current setup uses myisam and the db size is about 1.6 GB with two
> table that each have about 500k ro
----- Original Message -----
From "angie ahl " <angie.ahl@(protected) >
To <mysql@(protected) > <perl@(protected) >
Sent Wednesday December 01 2004 9 26 AM
Subject Unicode (utf8) and MYou might want to consider the following site and collection of s/w....
http //www.apachefriends.org
I have successfully installed XAMPP on both Windoze & Linux from their
downloads.
On WeI 'm creating a search form the query is dynamic.
Meaning user can select 1 or all options.
All options translates to about 40 "where " statements
including 1 -3 full text searches.
Is this tooHello.
In most cases if A B .. are in different charsets you 'll get an error.
Use SET NAMES CONVERT() or CAST() functions introduced to
convert everything to the same single charset. BecaI think you need to have root privileges (ALL) on the
table to run REPAIR TABLE since this is a disaster
recovery sql command. It works only for MyISAM tables
in MySQL. I don 't think it is supportelakshmi.narasimharao@(protected) wrote
> I need to get all the details of an employee whose salary is the lowest.
> I can do like this in Oracle
>
>
> select * from emp where id (select min(id4.0.18 does not support subqueries. You need 4.1 for that. In 4.0.18
you 'd write this as a JOIN
SELECT t1.* FROM table t1
JOIN table t2 ON t1.id t2.id
WHERE t2.one 4
By the >Thanks for your inputs Eric.
>I tried this but it couldn 't give me any insight abt
>how can optimize this
>for space saving of temp tables.
>Maybe I am not expert enough to interpret this
outpI can do a telnet host.com 3386 and get a answer back from mysql. Is the
only way to turn off remote access like this with a router and limit the
ports or is there some setting in mysql that will Ady
----- Original Message -----
From "Ady Wicaksono " <ady.wicaksono@(protected) >
Newsgroups mailing.database.myodbc
Sent Wednesday December 01 2004 6 43 AM
Subject Adding Foreign Key
Dan Sashko wrote
> Hi anyone has suggestions what changes to make to allow this query to
> run faster?
>
> SELECT domain FROM tbl_1
> WHERE
> id > 0 and id < 20000
> domain "12.221.190.11To answer your question we need to pretend to be your MySQL server for a
second. You appear to be posing the following question to your server
SELECT playlist.name as playlist_name
arHow so? Is there something you didn 't understand? Peter 's solution is the
right idea. You need to join the groups table to the users table once to
get the creatorname and again to get the ownerAjay
Could you send the error messages (.err file in the mysql dir)
and your my.cnf file?
Ronan
--
MySQL General Mailing List
For list archives http //lists.mysql.com/mysql
To unsuOn Tuesday 30 November 2004 01 36 pm Steve Grosz wrote
> I had installed MySql on Win2003 and when I check the 'server
> information ' page it shows a IP of 127.0.0.1. The IP of the server has
Graham Cossey wrote
> Am I missing something?
>
> Will this not do the trick
>
> SELECT DISTINCT member_id
> FROM table
> WHERE specialty_id IN(6 33)
That would return any member_id witLynn
----- Original Message -----
From "Lynn Bender " <lynn@(protected) >
Newsgroups mailing.database.myodbc
Sent Tuesday November 30 2004 9 22 PM
Subject MySQL support for AMD64
Gleb Paharenko wrote
>Hello.
>
>
>
>There is a variable sort_buffer which you can set with -O sort_buffer xxxM or in my.cnf.
>
>
>
>
> >myisamchk -o -p -f --sort_key_blocks 512M - -key_
Thomas McDonough wrote
> I 'm trying to set all the values of column 'map ' to the value of
> column ML and '.png '. My intuition and an extensive reading of the
> manual and mail archives tIs there anyone who has EXTENSIVE sql experience that is available for
consulting? This is a short term opportunity for a single project. Maybe an
couple hours tops to assist in some COMPLEX queries tHello.
There is a variable sort_buffer which you can set with -O sort_buffer xxxM or in my.cnf.
matt_lists <matt_lists@(protected) > wrote
> Are these critical errors? It keeps on
|
|
|
