Hey Neil,
Why not just store it as a TINYINT, that's what I do when I only care
about 0 or 1 values?
On Wed, May 22, 2013 at 2:19 PM, Neil Tompkins neil.tompk...@googlemail.com
wrote:
Hi Shawn
I plan in installing the latest MySQL version tomorrow. Does MySQL not
support Bool eg true
In your my.conf or configuration file look for an attribute that says
LOG_SLOW_QUERIES , that should point to the path of your slow query
log.
On Tue, May 8, 2012 at 10:19 AM, abhishek jain
abhishek.netj...@gmail.com wrote:
Hi
Thanks,
Where can i find query log for previous one,or i have to
My plan B was basically what Rick and Claudio said. Check your my.conf
file for this variable LONG_QUERY_TIME . That determines how long a
query will run before it's considered slow. You may need to adjust
that setting, but that will just get rid of the symptom and not the
problem at hand.
Do you see a MySql icon under System Preferences Other ? That's how
I start MySql on my Mac.
On Wed, Feb 29, 2012 at 9:05 AM, Elim Qiu elim@gmail.com wrote:
*I downloaded **Mac OS X ver. 10.6 (x86, 64-bit), DMG Archive, installed to
my pretty clean os x 10.6.8 (snow leopard) after (1st
I have version 5.5.17 MySQL Community Server (GPL) on my Mac.
On Wed, Feb 29, 2012 at 9:36 AM, Elim Qiu elim@gmail.com wrote:
The vertion of MySQL that I cannot start is 5.1.61 (the only one for 5.1*
mac at mysql.com)
On Wed, Feb 29, 2012 at 7:05 AM, Elim Qiu elim@gmail.com wrote:
What is in the mysql error log?
On Wed, Feb 29, 2012 at 7:20 AM, Darryle Steplight
dstepli...@gmail.com
wrote:
Do you see a MySql icon under System Preferences Other ? That's
how
I start MySql on my Mac
If you are going to use su to officially switch to the root users
just make sure you do su - with the dash.
On Wed, Feb 29, 2012 at 2:10 PM, Reindl Harald h.rei...@thelounge.net wrote:
Am 29.02.2012 19:20, schrieb Larry Martell:
Is the sudo succeeding? If it is, then there's no reason you
Hi Johan,
I think you probably want something like this. Give the following a shot.
SELECT *
FROM table1
LEFT JOIN table2
ON table1.ID = table2.subID
LEFT JOIN table3
ON table1.ID= table3.subID
On Thu, Apr 28, 2011 at 9:41 AM, Johan De Meersman vegiv...@tuxera.be wrote:
Hey there,
-
@Joao - I'm currently building a database out right now that has this
scenario. One field can be the primary key, that has a purpose for holding
the record id, another field can hold the value. Let say there are two
fields, id, s_id. Initially, you insert a record and `id` is now 100 and you
Hi Vicor,
Look into INSERT ON DUPLICATE or REPLACE statements. You need to
have a primary key or unique key for these too work.
On Sun, Jul 26, 2009 at 1:11 PM, Victor Subervivictorsube...@gmail.com wrote:
Hi;
I would like to test the following:
update maps set map where site=mysite;
to
You might have to change the collation you are currently using to one
that best match the language of those weird accents you are referring
too. That's part of the reason you may be getting unexpected results
with your ORDER BY statement. Also, can you show us your select
statements?
On Fri, Jul
Can you show us the output of DESCRIBE score and SHOW INDEX FROM score?
On Wed, Jul 15, 2009 at 6:44 PM, Tachu®tachu1+my...@gmail.com wrote:
I'm having random query slowness that i can only reproduce once. My main
question is that the query runs faster the second time around but i dont
have
Hi Elim,
I didn't test it out but it sounds like you want to do this
SELECT * FROM group_members GROUP BY head_id, member_id ORDER BY name
ASC .
On Thu, Jul 16, 2009 at 1:20 AM, Elim PDTe...@pdtnetworks.net wrote:
My table group_member looks like this:
+---+---+-+
|
1. Don't use SELECT *. Only grab the cols that you only need. Also
make sure you have an index on min_position and max_position. After
that if your query isn't faster please show us the output of running
EXPLAIN select * from table_name where start_postion between
min_postion and
max_postion .
| index_seq_start |
5 | NULL | 90886 | Using where |
++-+-+---+-+-+-+--+---+-+
index_seq_start is the index on start_postion,
2009/7/13 Darryle Steplight dstepli...@gmail.com
1. Don't use SELECT *. Only grab
wrote:
sorry fo that, but i really need all cols in the table, i think the problem
maybe caused by one of the col which is text type, each record of this col
has 2000 characters. this makes the size of record more biger.
2009/7/13 Darryle Steplight dstepli...@gmail.com
You are still doing SELECT
Select user_id from user where key1=value and
key2=value2 and key3=value2 GROUP BY user_id
is faster than
Select distinct user_id from user where key1=value and
key2=value2 and key3=value2;
2009/6/18 周彦伟 yanwei.z...@opi-corp.com:
Hi,
I have a sql :
Select distinct
pull the plug for the mains and save energy.. It's still early, but
it was only a matter of time before people on this list start typing
what I was thinking. But for starter, check out http://shiflett.org/
and read his Essential PHP Security book.
On Fri, Jun 19, 2009 at 10:03 AM, walter
Of course I'm assuming you are using PHP.
On Fri, Jun 19, 2009 at 10:28 AM, Darryle Steplightdstepli...@gmail.com wrote:
pull the plug for the mains and save energy.. It's still early, but
it was only a matter of time before people on this list start typing
what I was thinking. But for
Hi Artem,
There can be many malicious factors at play here, but if you are
not using an index then definitely create on now. It will obviously
help you with option 1 and you can still benefit from it with option
2. If you don't have an index, MySQL has to search for you data row by
row which
Hi PJ,
Try adding innodb_force_recovery = 4 to the mysqld section of your
config file before restarting the server.If you can dump your tables
using 4 then only some data on corrupt individual pages is lost. If
you have to use innodb_force_recovery = 6, that means your db pages
are left in an
Uma,
I apologize in advance if this is redundant ,because I did not
click on any of Ewen's link. Nonetheless, this is the approach I would
take.
start your mysql server with different --character-set-server and
---collation-server options
Type SHOW COLLATION; in your mysql shell to determine
Hi Daevid,
You can always stop the query by running
SHOW PROCESSLIST;
from the command line or your MySql Admin tool. The above command will
show you all of the queries that are currently running along with
their PID# and state. Find the query your want to stop, and run the
following command
Hi Per,
Maybe you need to beef up your CONNECT_TIMEOUT setting in your .my.cnf
file. Are these queries appearing in your slow query logs?What is your
LOG_QUERY_TIMES set too?
Here are some other settings you may want to play around wtih
CONNECT_TIMEOUT
INTERACTIVE_TIMEOUT
WAIT_TIMEOUT
Moon,
I'm not sure exactly what you are trying to do, but why don't you
just serialize() or json_encode() your data into a column?
On Tue, Mar 10, 2009 at 9:35 AM, Moon's Father
yueliangdao0...@gmail.com wrote:
Thanks for your fast reply.
Then only temporary table can simulate array
Hi Rene,
Just a head's up. You might want to keep your username/password
credentials private.
On Tue, Mar 10, 2009 at 10:16 PM, René Fournier m...@renefournier.com wrote:
OK, I've managed to do the same thing with just the mysql command line
program:
mysql -h 192.168.0.224 -u root
High Performance MySql Optimization, Backups, Replication, and more
2nd Edition . Got a problem, pick a chapter and read the solution.
This book is awesome, I'm confident you will find what you are looking
for :) .
On Thu, Mar 5, 2009 at 12:30 PM, Stephen Edberg sbedb...@ucdavis.edu wrote:
I've
Are you trying to do an Insert On Duplicate Key? Do ou want to insert
a new row if it doesn't already exist or update one if it does?
On Mon, Mar 2, 2009 at 4:09 PM, sam rumaizan samc...@yahoo.com wrote:
Are you talking about Length/Values1
--- On Mon, 3/2/09, Gary Smith g...@primeexalia.com
Hi PJ,
Could it be that you have //include (lib/db1.php); commented
out? Try uncommenting that line and see what happens. The error
message will always print because the query is never executing
properly if you have the db connections file commented out.
On Thu, Feb 26, 2009 at 12:28 PM, PJ
ok, well if that's the case then do this
$db = mysql_connect('biggie', 'user', 'password', 'test');
That should fix the problem.
On Thu, Feb 26, 2009 at 12:46 PM, PJ af.gour...@videotron.ca wrote:
It is commented out because I am using mysql_connect
I don't think it would be good to use
Hi PJ,
$db_host = 'biggie';
$db_user = 'root';
$db_pass = 'gu...@#$';
$db_name = 'biblane';
Everyone here is trying to help you and that's cool, but EVERYONE on
this list may not be so nice. The above credentials is definitely the
type of information you want to keep private, unless you
-0500, Darryle Steplight wrote:
Hi PJ,
$db_host = 'biggie';
$db_user = 'root';
$db_pass = 'gu...@#$';
$db_name = 'biblane';
Everyone here is trying to help you and that's cool, but EVERYONE on
this list may not be so nice. The above credentials is definitely the
type of information
Jeff,
For starters, it looks like you need a value for VARCHAR. Try the
same statement but with VARCHAR(255) .
On Fri, Feb 20, 2009 at 1:17 AM, Jeff Murdock jeff_murd...@yahoo.com wrote:
This is on a Mac OS X (v10.5.6) system in case that matters.
1. - MySQL Administrator Help button
Hi Ryan,
MySql does have regular expressions. See Link
http://dev.mysql.com/doc/refman/5.0/en/regexp.html
On Thu, Sep 11, 2008 at 9:52 AM, Ryan Stille [EMAIL PROTECTED] wrote:
From looking at the MySQL 5 docs, it doesn't look like there is any way to
select a column with a regular expression
Hi G,
There is nothing weird about your results. When you do a Count(*)
without a GROUP BY(someColumn) you are essentially asking MySQL how
many rows are present in the table. But when you do use Group By
someColum , you are asking MySql how many rows do I have of
someColumn . It's just a
Hi Brian,
Try this.
SELECT SUM(mi.calories) FROM Meal_Items as mi, People as P, Meals as
m WHERE p.Person_ID = '5' AND p.Person_ID=m.Person_ID AND m.Date =
'2009-09-04' AND m.Meal_ID = mi.Meal_id GROUP BY p.Person_ID
Hi Gerald: This part is throwing me off ON People.Name=Meals.Name .
But I
Hi Anada,
I recommend MySQL Database Design and Tuning by Robert Schineider. It
covers everything from benchmark testing to Innodb Performance
Enhancements. I'm 85% done with the book myself. It shows and explains
good command-line and MySql Admin tool examples. The techniques
discuss in this
Hi Michael,
Try placing the following at the top of your PHP code:
ini_set('error_reporting', E_ALL | E_STRICT);
ini_set('display_errors', 'On');
What error messages do you see on your page?
On Tue, May 6, 2008 at 12:07 PM, Jerry Schwartz [EMAIL PROTECTED]
wrote:
In general, if I have a
38 matches
Mail list logo