the new user's access. In the commands below, I
used my name as for user and database names:
CREATE DATABASE steve_db;
GRANT ALL PRIVILEGES ON steve_db.* TO steve@localhost
- IDENTIFIED BY steve_pw;
FLUSH PRIVILEGES;
All commands worked successfully.
To figure out what I did wrong, I need to know
I'm building a mail system with Dovecot, Postfix and Mailman with
MySQL. I have the other three products installed but not yet
configured. I'll do that after I get MySQL running.
The documentation at
http://dev.mysql.com/doc/mysql-repo-excerpt/5.6/en/linux-installation-yum-repo.html
was
To what list should I post with a post-installation config and startup
question?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
On Tue, 23 Jun 2015 14:51:48 -0400, you wrote:
On 6/23/2015 10:59 AM, Steve Matzura wrote:
I'm building a mail system with Dovecot, Postfix and Mailman with
MySQL. I have the other three products installed but not yet
configured. I'll do that after I get MySQL running.
The documentation
anything.
Is there some sort of tool that allows me to check for repetitive queries?
- Steve
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
We just upgraded our mysql from 5.0.32 on debian lenny, to 5.1.49 on
debian squish.
I wasn't told that it was doing an incremental version upgrade, i was
under the impression it was just going from 5.0.32 to 5.0.8x.
Anyways, I am getting some weird issues now, that is filling up the
syslog, and
!
Steve.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
key? so the 3 fields
he's inserting, are part of a multi-field key... but to me, it looks
like the characters are not being seen, or converted to a UTF-8 style
format, rather than the chinese (korean/japanese) character set.. ?
maybe?
sorry if i am out of line here...
Steve.
--
MySQL
'server_id' corresponds to what
server ip address.
Just trying to think of other solutions on why the OP would want this
data...
Steve
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
used InnoDB for large logging tables and what the performance has been?
Steve Musumeche
CIO, Internet Retail Connection
st...@internetretailconnection.com
1-800-248-1987 ext 802
On 2/4/2011 11:29 AM, Andy Wallace wrote:
Greetings, all...
I'm having an issue with a SELECT in our system. We have
On 1/25/2011 8:00 AM, Robinson, Eric wrote:
your whole solution is crippled because why in the world are
you killing your salves and reinit them without any reason daily?
There is a very good reason: it is the phenomenon of row drift. The
master and slave can appear to be in good sync, but
noticed you have index_articles_on_newsletter_id as
well as index_articles_on_newsletter_id_and_created_at. The first index
is redundant, the second index will take care of it. This will slow
down your INSERT/UPDATE/DELETE queries to some degree.
Steve
--
MySQL General Mailing List
For list
is not
deterministic. If there are multiple rows per album_id, any one of
those rows could provide the updated_at column that you're then using to
order by. What you probably want is to select (and order by) the
max(updated_at).
Steve
--
MySQL General Mailing List
For list archives: http
On 1/17/11 9:52 AM, Jerry Schwartz wrote:
[JS] I don't understand how an index on a timestamp would help. Theoretically,
each record could have a unique value for the timestamp; so the index would
have an entry for each record. Would MySQL really use that in preference to,
or in combination
is this:
SELECT COUNT(*) AS num FROM alerts WHERE stamp DATE_SUB(NOW(),
interval 300 second) AND devid=244;
With this query, MySQL will run DATE_SUB() once, and then use the index
on stamp (which I assume you have) to narrow down the result set.
Steve
--
MySQL General Mailing List
For list archives
? would symlinking the file to another db make any difference
(or is that even possible)?
any insight would be appreciated, or even any ideas on what I may do to
increase the performance, or even how to measure where the issue could
be would help as well.
Steve
--
MySQL General Mailing List
of measuring your raw i/o performance, but
first we should determine how your data is being stored.
- michael
On Thu, Jan 13, 2011 at 2:44 PM, Steve Staples sstap...@mnsi.net wrote:
Hello,
I've been noticing a little lag in my application lately, it seems as
if 1 table in 1 database
On 1/13/11 1:21 PM, Steve Staples wrote:
table type is MyISAM, it is a customer_account table, which holds the
email address, and the customer_id field, the queries that are
constantly being queried is select customer_id from customer_account
where customer_email = 'email address' and `status
On Thu, 2011-01-13 at 13:51 -0700, Steve Meyers wrote:
On 1/13/11 1:21 PM, Steve Staples wrote:
table type is MyISAM, it is a customer_account table, which holds the
email address, and the customer_id field, the queries that are
constantly being queried is select customer_id from
On 1/13/11 2:13 PM, Steve Staples wrote:
On Thu, 2011-01-13 at 13:51 -0700, Steve Meyers wrote:
On 1/13/11 1:21 PM, Steve Staples wrote:
table type is MyISAM, it is a customer_account table, which holds the
email address, and the customer_id field, the queries that are
constantly being
On 1/13/11 3:51 PM, Reindl Harald wrote:
Are you sure that the lags are really the query and not the connection?
I have seen on a windows server with ipv7 large lags because mysql
treid by every connect to make a dns-reverse-lookup first on ipv6
and after fail ipv4
skip-name-resolve in the
On 1/11/11 9:31 AM, Simon Wilkinson wrote:
select users.id from users where users.id in (select newletters.user_id from
newletters left join articles on newletters.id = articles.newsletter_id
where articles.newsletter_id is null);
I think this would do what you require:
SELECT
u.id AS
honestly, but it does apear that forumid_2 is a better choice
based on the key_len and rows that the explain shows...
Steve
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Ok, been googling all morning, and keep getting the same post (on
multiple different sites).
Is there a way, where i corrupt a table purposely? I've tried playing
with the .MYD file, and yeah, it marks it deleted under the check
routine, but the table is still readable/writable, just doesn't
}
quick; ?
the quick repair has alsways worked for me, and it takes like 20minutes,
to 1hr+ to repair the tables, but should I do somethign different?
if i can run the mysqlcheck -AF say daily, and it would pick up any
issues that would be great...
any ideas/thoughts would be welcomed.
Thanks
Steve
the user and password set up fine, but it does not grant any
privileges. It is probably an easy fix that I am just missing, but I would
appreciate your help.
Thanks,
--
Steve Marquez
Marquez Design
e-mail: smarq...@marquez-design.com
web: http://www.marquez-design.com
phone: 479-648-0325
Google has not been kind to me on this one, so I figured I would ask
here...
how can I select with NICE options, so that it doesn't KILL my server,
or any other queries...
Do you understand what I am asking?
Steve
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
What about:
select `id`, `column1` as 'column2', `column2` as 'column1';
Steve
On Wed, 2010-09-22 at 13:06 -0500, Johnny Withers wrote:
Couldn't you just rename the columns?
JW
On Wed, Sep 22, 2010 at 11:53 AM, Rolando Edwards
redwa...@logicworks.netwrote:
I ran these commands
on Ubuntu 9.10 (it
wants to uninstall wine to upgrade to 10.04, so for now i am not
upgrading)
Steve
-Original Message-
From: Carlos Mennens [mailto:carlosw...@gmail.com]
Sent: Tuesday, September 14, 2010 9:03 AM
To: MySQL
Subject: Capitalize Input via Auto Complete?
I am new
that goes and 'shows' the tables, and if
it fails, then repair it (or report it back to me via email or
something).
Any ideas on a way to automate something that is efficient and quick?
Steve
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
From what I read, it puts a lock on the tables (read lock). the tables
in one of the databases are continuously being written/read/updated, so
I dont want to lock them if at all possible.
Are there any other ways?
Steve
On Mon, 2010-09-13 at 15:11 +0100, a.sm...@ukgrid.net wrote:
Why not use
missed the joke here, or missed something...
Steve.
On Thu, 2010-09-09 at 18:02 -0400, George Larson wrote:
We do nightly backups at work just by taring the mysql directory. In
my environment, that is /var/lib/mysql.
Like this:
service mysql stop
cd /var/lib/mysql
rm -rf *
tar zxvf
the users of this database
access to it, as well, if I were to change this function, i have to go in,
and manage every user that would be attached to it, to allow to use it
again.
I've tried '%'@'%', and I get the error that this user does not exist.
Any help? Is it possible?
Steve.
--
MySQL
Hi there.
I was reading last week (and of course, i can't find it now) something about
'nicifying' a query, so taht it doesn't lock the table...
How is this done? I've read so much stuff lately, that i can't find it for
the life of me, and google is not being my friend :(
Steve.
--
MySQL
[mailto:vegiv...@gmail.com] On Behalf Of Johan De
Meersman
Sent: February 8, 2010 10:01 AM
To: mysql@lists.mysql.com
Subject: Re: MyISAM no table lock
On Mon, Feb 8, 2010 at 3:37 PM, Steve Staples sstap...@mnsi.net wrote:
Hi there.
I was reading last week (and of course, i can't find it now) something
) i get the error...
I am in the midst of removing the combined unique primary key, to see if
that is the culperate or not, but if anyone has any ideas, i am eager to
listen :)
Steve.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
when we do go to a master/slave setup?
Once i finish moving data around, i can remove the old tables that i am
moving them out of, so I don't really see a huge issue with dumping them, i
just want to make sure.
Thanks in advance!
Steve Staples.
--
MySQL General Mailing List
For list archives
Silly me sees that there is an 'expire_log_days' in the my.cnf
But again, if i was to purge everything but the last day or 2... running
this command i found:
PURGE BINARY LOGS BEFORE DATE_SUB(NOW(), INTERVAL 2 DAY);
From the MySQL command line, will this be ok?
Steve.
-Original Message
.
I'd recommend spending some time reading the documentation for
autoincrement fields and the last_insert_id() function.
- sbe -
--
++
| Steve Edberg edb...@edberg-online.com
Silly question here...
But can I have multiple definers for a stored proc, rather than allowing
`us...@`%`? basically, I want to only allow 1 user name, but from only 2
or 3 IP's.
My Googleing didn't turn up anything of use, so now, I am here asking :)
Thanks in advance!
Steve Staples
federated tables yet...
- steve
--
++
| Steve Edberg edb...@edberg-online.com |
| Programming/Database/SysAdminhttp://www.edberg-online.com
where p.Category = 'prodCat2';
- s
--
++
| Steve Edberg edb...@edberg-online.com |
| Programming/Database/SysAdminhttp://www.edberg-online.com
, which does not exist I only found a *.cnf
file at
/usr/local/mysql-5.4.3-beta-osx10.5-x86_64//mysql-test/suite/ndb/my.cnf
To be followed ... and congratulations to the MySQL Team for the quality of
this 5.4 beta version which looks yet great :)
Regards,
Steve
2009/11/29 Steve Pincaud
be the ETA for GA
and to get beta versions (the mysql-5.4.3-beta is supported only on
osx10.5-x86_64) ?
Thanks,
Steve
http://dev.mysql.com/downloads/mysql/5.4.html#macosx-dmg
http://dev.mysql.com/doc/mysql-macosx-excerpt/5.4/en/mac-os-x-installation.html
http://bugs.mysql.com/bug.php?id=46999
http
be handy if you were
dealing with something more complex than a simple range.
- steve
--
++
| Steve Edberg edb...@edberg-online.com |
| Programming/Database/SysAdminhttp
,concat(thing3,thing4)
as thing5 from bar where thing4 like 'baz%' order by thing1 desc
You could create a TEMPORARY table if needed (CREATE TEMPORARY
TABLE...). Assuming version 5.0:
http://dev.mysql.com/doc/refman/5.0/en/create-table.html
- steve
At 3:29 PM + 10/27/09, Olga Lyashevska wrote:
On 27.10.2009, at 15:11, Steve Edberg wrote:
At 2:59 PM + 10/27/09, Olga Lyashevska wrote:
Dear all,
I run a query and I try to save results as a table. On the results
of this first query I want to run yet another query (perhaps a
few
/refman/5.0/en/optimize-table.html
Using EXPLAIN
http://dev.mysql.com/doc/refman/5.0/en/using-explain.html
http://dev.mysql.com/doc/refman/5.0/en/explain.html
MySQL system variables
http://dev.mysql.com/doc/refman/5.0/en/mysqld-option-tables.html
steve
--
MySQL General Mailing List
(information_schema only exists in MySQL = 5.0, methinks). Manual references:
http://dev.mysql.com/doc/refman/5.0/en/show-table-status.html
http://dev.mysql.com/doc/refman/5.0/en/information-schema.html
- steve
--
+--- my people are the people
time a record is inserted or updated. Then the other
applications can simply select records with timestamp
last_poll_time.
steve
--
+--- my people are the people of the dessert, ---+
| Steve Edberghttp://pgfsun.ucdavis.edu/ |
| UC
an error and did
not insert. I don't know what version you're running, perhaps this
does not apply to you. For more info:
http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html
http://dev.mysql.com/doc/refman/5.0/en/enum.html
- steve edberg
At 2:00 PM -0800 3/6
that one db as the back end.
Steve.
On Wed, Jan 28, 2009 at 6:14 PM, Robert D. Crawford rd...@comcast.netwrote:
Hello, Olaf,
Stein, Olaf olaf.st...@nationwidechildrens.org writes:
the import of the dump will not remove your other tables unless there
is a naming conflict, then the table
Andy,
I just had an interesting experience you might also find interesting. I
rarely have to do restores, also (MySQL is very solid), but I just upgraded
my (only) MySQL server. At the same time I upgraded the MySQL release from
5.0.45 to 5.0.67. While testing my procedure (which was a piece of
script. Please be more specific.
Steve.
'localhost' (e.g. wordpress).
Steve.
On Tue, Dec 9, 2008 at 11:58 AM, Götz Reinicke
[EMAIL PROTECTED] wrote:
Hi,
over the last couple of years our infrastructure rose as we needed and
now we are thinking about the next steps as the access to the servers
grows.
Currently we run a couple
) that might
reduce the load sufficiently.
steve
--
+--- my people are the people of the dessert, ---+
| Steve Edberghttp://pgfsun.ucdavis.edu/ |
| UC Davis Genome Center[EMAIL PROTECTED] |
| Bioinformatics
] or the upcoming
ZFS+crypto [4] to store your tables. To minimize the performance
impact, you should keep your index files on a non-encrypted volume if
possible.
steve
[1]
http://dev.mysql.com/doc/refman/5.1/en/roadmap.html
Also couldn't find anything on the mysql-internals list
(http://marc.info
Hello Moon's Father,
That would be great..if it was in english ;)
Hi.
Here are some of my tests on Centos 5.0.
http://blog.chinaunix.net/u/29134/article_71956.html
On Fri, Nov 21, 2008 at 3:49 AM, Ronan Lucio [EMAIL PROTECTED]
wrote:
Hi,
Does anybody has a tip to install a MySQL
I'm trying to get used to visually mapping out my db design using the SqlYog
SchemaDesigner.
Once I have the PK/FK setup, how can I export that design to SQL code to
create the tables, etc??
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Ok, I'm a little new a this, so be gentle!! :)
I was looking into the InnoDB engine for some tables I have, and would like
to use the PK/FK on some of the data.
It appears that the PK/FK is mainly used for updating/deleting data,
correct? I can't use it to retreive data from multiple tables
.
Steve
|
+--++
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_results| latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
+--++
6 rows in set (0.00 sec)
steve
Does the system in question have some type of /tmp cleaner script that
might be removing the socket file? Check /etc/crontab and root's crontab
(crontab -l)
Steve
Greetings,
I am trying to enter this information into a database called cms_md, with a
table called sections.
INSERT INTO sections (order,edit,remove,section,type) VALUES
('blah','blah','blah','blah','blah');
I am getting an error whenever I use this.
--
Steve M
Thanks,
Here it is:
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to use
near 'order,edit,remove,section,type) VALUES
('blah','blah','blah','blah','blah')' at line 1
--
Steve M.
on 1/15/08 3:06 PM
Thank you so much, that worked!
--
Steve M.
on 1/15/08 3:17 PM Rolando Edwards ([EMAIL PROTECTED]) wrote:
ORDER is a reserved word in standard SQL
Example : SELECT FirstName,LastName FROM Names ORDER BY LastName,FirstName;
If the column name in the table is ORDER, then put backquotes
-03 19:36:54 23
matt2007-10-04 19:37:09 67
steve 2007-10-03 19:36:35 50
steve 2007-10-04 19:36:54 12
steve 2007-10-05 19:37:21 5
If I want the second date for each name in the table, how would I go
about doing that? I've found it easy to get the first date for each
if nothing
else. It could well be your problem if you are referring to the
database 'FooBar' as 'FOOBAR' and MySQL is running on a *nix platform.
steve
--
+--- my people are the people of the dessert, ---+
| Steve Edberghttp
I am running a MySql server, ver. 4.1.7-max on a P3 with 512meg of RAM.
It has been running fine for the past year, nice and quick. Now it seems
like its running slowly. Is there a tool to test the db and/or install and
see if there are any problems???
Or would upgrading help?
Anyone have
, I restored the mysql database, but cannot restore
the information_schema database (I have no permission to do this even as the
root DB user).
Can anybody shed some light on this?
Thanks in advance...steve o
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
for more information.
steve
At 6:29 PM +0200 7/23/07, Mogens Melander wrote:
Try this:
# mysqldump -d DBNAME tables.sql
--no-data, -d
Do not write any row information for the table.
This is very useful if you want to dump only
the CREATE TABLE statement for the table.
On Mon, July
is pretty reasonable. It all depends on your query
index design (make friends with the EXPLAIN command). If you go
through the mailing list archives, you'll find numerous people with
multiple tables with billions of records.
steve
--
+--- my people are the people
words to compute valid relevances.
steve
--
+--- my people are the people of the dessert, ---+
| Steve Edberghttp://pgfsun.ucdavis.edu/ |
| UC Davis Genome Center[EMAIL PROTECTED] |
| Bioinformatics
Column_name: c2
Collation: A
Cardinality: NULL
Sub_part: NULL
Packed: NULL
Null: YES
Index_type: BTREE
Comment:
2 rows in set (0.00 sec)
steve
--
Chris W
KE5GIX
Protect your digital freedom and privacy, eliminate DRM, learn more
at http://www.defectivebydesign.org
a close-to-balanced tree.
Lastly, I store a hash of the document itself in the database as
well. This allows me to detect if duplicate files are uploaded, and
to determine if a previously-uploaded file has been corrupted in some
way.
steve
--
+--- my people are the people
How about your disk space? I had a similar problem on a large table and
it ended up being caused by filling up the disk.
Steve Musumeche
CIO, Internet Retail Connection
[EMAIL PROTECTED]
Octavian Rasnita wrote:
From: Steve Edberg [EMAIL PROTECTED]
Sometimes I see that some tables from my
system crashes I haven't lost any data; a repair
table and index rebuild fixed things.
steve
--
+--- my people are the people of the dessert, ---+
| Steve Edberghttp://pgfsun.ucdavis.edu/ |
| UC Davis Genome Center
I believe it would revert back to the settings in your my.cnf file. If
you want the change to be permanent, then set it there.
Steve Musumeche
CIO, Internet Retail Connection
[EMAIL PROTECTED]
Bing Du wrote:
Hi,
We're running mysql 4.1.20. If I understand the manual correctly, I can
unique index01
(videourl,userid);
Indexes/keys do not have to be unique unless they are primary or
defined as unique.
steve
--
+--- my people are the people of the dessert, ---+
| Steve Edberghttp://pgfsun.ucdavis.edu/ |
| UC
to do...i need it to be unique.
You can disregard this; again, didn't read the original message
closely enough. This would indeed create a non-unique index.
steve
thanks,
jerad
On Mar 13, 2007, at 4:55 PM, Steve Edberg wrote:
At 4:36 PM -0700 3/13/07, jerad sloan wrote:
thanks.
i
current_timestamp
See
http://dev.mysql.com/doc/refman/5.0/en/timestamp-4-1.html
- steve
--
+--- my people are the people of the dessert, ---+
| Steve Edberghttp://pgfsun.ucdavis.edu/ |
| UC Davis Genome Center
-problems.html
InnoDB problems:
http://dev.mysql.com/doc/refman/5.0/en/innodb-troubleshooting.html
steve
PS. This may be an obvious question, but: are you sure data loading
was finished before running the select count(*) and select max(id)
queries?
--
+--- my people
an
alter table tablename auto_increment=1
statement. See
http://dev.mysql.com/doc/refman/5.0/en/example-auto-increment.html
for more info.
steve
--
+--- my people are the people of the dessert, ---+
| Steve Edberghttp
://www.cdm.org/
Never been there, though, so I can't vouch for it. Interested in
aviation/space?
http://www.moffettfieldmuseum.org/
http://www.nasa.gov/centers/ames/home/exploration.html
http://www.hiller.org/
steve, museum nerd
At 10:16 AM -0500 1/30/07, Jerry Schwartz
://dev.mysql.com/doc/refman/5.0/en/using-system-variables.html
- steve
--
+--- my people are the people of the dessert, ---+
| Steve Edberghttp://pgfsun.ucdavis.edu/ |
| UC Davis Genome Center[EMAIL PROTECTED
and I
will call you. If it goes the way they want, we will have to have
all servers, frontend, middleman and backend setup within about 6
weeks if possible.
Thanks
Steve
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
and see that it will do everything that I need for
other things too. I like that it can do a type of CVS for a database
too. A couple of long term projects that I am on could really use
something like that.
Thanks
Steve
At 05:45 AM 9/29/2006, COS wrote:
Hi,
Look at DBTools Manager Enterprise
the data to a numeric format so I can use
MySQL's numeric sorting?
I can't change the field's data type because it also needs to be able to
hold textual data. Thank you for your help.
--
Steve Musumeche
CIO, Internet Retail Connection
--
MySQL General Mailing List
For list archives: http
)' at line 1
Steve Musumeche
CIO, Internet Retail Connection
[EMAIL PROTECTED]
Douglas Sims wrote:
You can use CAST or CONVERT to see the data as a numeric type.
If the table is very big and you're going to be querying it intensely,
you might want to create a separate column to store
Dan,
Thank you, that works! FYI, you can treat the field like a number,
including sorting, numeric functions, etc.
For example,
select * from table order by (text_field+0.0)
Steve Musumeche
CIO, Internet Retail Connection
[EMAIL PROTECTED]
Dan Nelson wrote:
In the last episode (Sep 28
Is there a program out there that I can use to compare two
databases? Just the structure, not the content.
Thanks
Steve
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
, which is
unique.
Check mysql manual for more info on syntax of insert command.
steve
--
+--- my people are the people of the dessert, ---+
| Steve Edberghttp://pgfsun.ucdavis.edu/ |
| UC Davis Genome Center
Select DISTINCT(lat_long_field) from table where...
Steve Musumeche
CIO, Internet Retail Connection
[EMAIL PROTECTED]
Brian Dunning wrote:
Many different records will be returned though, I just don't want any
dupes where both lat/lon is the same.
:)
On Sep 12, 2006, at 12:20 PM, Hiep
You could try using CONCAT:
select distinct(CONCAT(lat, long)) from table where ...
Steve Musumeche
CIO, Internet Retail Connection
[EMAIL PROTECTED]
Brian Dunning wrote:
Lat lon are two different fields. Either can be duplicated, but not
both.
On Sep 12, 2006, at 12:33 PM, Steve
Select COUNT(*) as num_entries, url from table WHERE num_entries1 GROUP
BY url
Untested, but the concept should work for you.
Steve Musumeche
CIO, Internet Retail Connection
[EMAIL PROTECTED]
Peter Van Dijck wrote:
Hi all, a though query problem for me...
I have a table with 2 rows
Greetings,
Does anyone know how I can set up my shell so that the mysql command works
without navigating to the directory? I am using Mac OS 10.2.8 and 10.4
shell mysql u name p
??
Thanks,
--
Steve Marquez
at the information_schema
database; it might have everything you need already:
http://dev.mysql.com/doc/refman/5.0/en/information-schema.html
steve
--
+--- my people are the people of the dessert, ---+
| Steve Edberghttp://pgfsun.ucdavis.edu
If you are manually editing the grant tables, don't forget to FLUSH
PRIVILEDGES after you add the new tables.
Steve Musumeche
CIO, Internet Retail Connection
[EMAIL PROTECTED]
Chris Jones wrote:
Thanks for that. Will create the two tables ahead of time which won't
affect the existing
performance/speed penalty (that is, do
mysqldump | bzip2 outputfile.bz2).
Try 'man gzip' and 'man bzip2' for more info.
steve
--
+--- my people are the people of the dessert, ---+
| Steve Edberghttp://pgfsun.ucdavis.edu/ |
| UC
I use EMS MySQL Manager. You can buy it here:
http://www.sqlmanager.net/en/products/mysql/manager/buy
No, I am not affiliated with them, but I use the product everyday and I
love it.
Steve Musumeche
CIO, Internet Retail Connection
[EMAIL PROTECTED]
Pooly wrote:
Hi,
MysqlCC not being
1 - 100 of 1070 matches
Mail list logo
