cated on a MacBook running OS X 10.8. The MySql Server is
running.
Joe
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
your help and suggestions.
Joe
I also tried mysql_tzinfo_to_sql /usr/share/zoneinfo > sqlLines with the following Terminal output:
Terminal Saved Output 10
Description: Binary data
-bash: sqlLines: Permission deniedJoeBegin forwarded message:From: Joe Kosinski <joj...@gmail.com>Subject: Fwd: mysql_tzinfo_t
the command drop down menu of the Shell menu.
Are there any other suggestions on what I should do to populated the tables?
Joe
>
>
> Joe
>
> Begin forwarded message:
>
>> From: shawn green
>> Subject: Re: Fwd: mysql_tzinfo_to_sql
>> Date: April 5, 201
forwarded message:From: "Wm Mussatto" <mussa...@csz.com>Subject: Re: Fwd: mysql_tzinfo_to_sqlDate: April 5, 2013 5:09:15 PM EDTTo: mysql@lists.mysql.comOn Fri, April 5, 2013 13:19, Joe Kosinski wrote:I also tried mysql_tzinfo_to_sql /usr/share/zoneinfo > sqlLines with thefollow
info_to_sql previously nothing worked.
Terminal Saved Output 6
Description: Binary data
JoeBegin forwarded message:From: shawn green <shawn.l.gr...@oracle.com>Subject: Re: mysql_tzinfo_to_sqlDate: April 5, 2013 1:29:50 PM EDTTo: Joe Kosinski <joj...@gmail.com>Hi Joe,On 4/5/2013 1:26 PM, Joe
?
Here is the text from my last terminal where I tried to run the which command.
Joe
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
I tried the use mysql; for my session. Here is the result:
Terminal Saved Output 7
Description: Binary data
JoeBegin forwarded message:From: shawn green <shawn.l.gr...@oracle.com>Subject: Re: Fwd: mysql_tzinfo_to_sqlDate: April 5, 2013 1:58:01 PM EDTTo: Joe Kosinski <joj...@gmail.c
>Jan Steinman wrote
>If not, how 'bout the best of both worlds: create a UNIX (or perl) script that
>loops
>through the country names and creates an SQL script? That would be fast
>entering AND fast
>performing!
Good suggestion. But I am a perl/unix illiterate. However I may learn
in them future
ange. Probably I could convert empty cells to NULL
and then use 'IS NOT NULL' condition as an alternative (this works
now).
Yes, I've now removed back ticks now, but it seems I need to use
single quotes for '${x}'-without the single quotes I get error
messages.
On Thu, Apr 5
Thanks to Rick I would go for a single table. I tried the following,
but hasn't been successful yet. First I created one 'master' table for
one country, with a country column (ctry) as Rick suggested, then I
tried to use the loop suggested by Johan to insert the records for
each of the remaining co
Thanks. I was looking for a loop--not to gain speed but to reduce the
length of my script file:) I'll try and hopefully it will work!
J
On Wed, Apr 4, 2012 at 12:16 PM, Johan De Meersman wrote:
> - Original Message -
>> From: "joe j"
>>
>> So what
ok. here's what I am trying now. First create a table with the code
below with a list of countries that have the two person names I want.
CREATE TABLE `table_new` SELECT t1.country
FROM `table_old` as t1
JOIN
`table_old` as t2
USING(country)
JOIN
`table_old` as t3
USING(country)
WHERE (t2.`person_n
Thanks, but I don't see how it will work. Am I missing something?
On Tue, Jun 7, 2011 at 5:24 PM, Willy Mularto wrote:
> Why not GROUP BY?
>
>
>
> On Jun 7, 2011, at 10:06 PM, joe j wrote:
>
>> Dear all,
>>
>> I wish to create a new table from a tabl
(table_old.country)
IN (SELECT DISTINCT (table_old2.`country) FROM table_old AS table_old2));
I know I can do this by creating two additional tables, but was
wondering if there was a direct way.
Best,
Joe.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Hello MySQL-users list,
We are having an issue with replication and binlog files and I was hoping that
this list could shed a little light on the issue for us. We have a pair of
5.1.41-community MySQL servers. We attempted to restore from the slave server,
and in the process I zeroed out the my
Hello all,
My organization has a dedicated MySQL server. The system has
32Gb of memory, and is running CentOS 5.3. The default engine will be InnoDB.
Does anyone know how much space should be dedicated to swap?
Thanks!
on what you had defined before.
>
> Backup first though!
>
> Walter
>
> On Wed, Aug 26, 2009 at 03:33, Joe
wrote:
> > I'm trying to get back to an earlier state where we started
> > mysqld withOUT --skip-grant-tables but the root user had no
> > password
I'm trying to get back to an earlier state where we started
mysqld withOUT --skip-grant-tables but the root user had no
password. Yes, insecure, but we're in restoration mode here.
How do I reset/revert the root password to no password without
running with --skip-grant-tables?
Thanks in advan
at flag, I only see the 'information_schema'
DB.
Any suggestions as to where I look from here?
On Tuesday 25 August 2009 @ 18:17, Walter Heck - OlinData.com
wrote:
> Hey Joe,
>
> stop the server, start it with --skip-grant-tables, change the
> root entry in mysql.user to y
We have an inaccessible MySQL v5.0.45 DB (w/Innodb) we really
need some help regaining access to. While attempting to
adjust/add remote user access, we accidentally did the
following:
use mysql;
update user set host = 'SomeBogusIP' where user = 'root';
Now, we can't get into the DB to fix
Hello MySQL users,
My company is planning to upgrade from MySQL 5.0.51a to a more
recent version. Which version of MySQL offers the best balance between
stability and currency? Is there a discussion of the tradeoffs involved between
different recent version that I could be direc
On Fri, Jan 30, 2009 at 8:13 PM, will wrote:
> ok, cool. I was not sure if I could use logrotate with the mysql logs.
> Is it safe to delete what I have there at the moment? I need to free
> up some disk space.
>
this is what logrotate run before and after
[ -e /var/lock/subsys/mysqld ] && /bin/
I am trying to develop an db app w/ OO base as the front end to mysql
db that is running on the web in a shared hosting environment using
jdbc as the connector.
The problem is if I let OO base sit for a few minutes it looses the
connection to the db and I have to restart OO base to get it to
recon
UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;
FLUSH PRIVILEGES ;
$ mysql -h mynewserver -u testuser -p
Enter password:
ERROR 1045 (28000): Access denied for user 'testuser'@'myoldserver'
(using password: YES)
On Sat, Oct 25, 2008 at 1:40 PM, Joe Auty <[EMAIL PROTECT
Adam Gerson
Assistant Director of Technology
Apple Certified System Administrator (ACSA)
Columbia Grammar and Prep School
phone. 212-749-6200 ex. 321
fax. 212-428-6806
[EMAIL PROTECTED]
http://www.cgps.org
Public key - subkeys.pgp.net
--
Joe Auty
NetMusician: web publishing software for mus
e max function are apparently being mixed up.
On Sat, Jun 21, 2008 at 12:00 AM, Perrin Harkins <[EMAIL PROTECTED]> wrote:
> On Fri, Jun 20, 2008 at 10:50 PM, Joe Pearl <[EMAIL PROTECTED]> wrote:
> > I want to get back only the most recent entry for each person and I don't
> &
-00|
| Mary | 2 | PA | 2007-01-15|
| Sally | 1 | OH | 2007-03-15|
+---+-+--+---+
Why am I getting the wrong location for Jim? It should be "PA".
This is on a Mac.
joe.
813.528.3859
My LinkedIn profile: http://www.linkedin.com
n R.
R:
http://www.r-project.org/
PL/R:
http://www.joeconway.com/plr/
HTH,
Joe
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
create table foo
(aa varchar(20),
id integer,
cc varchar(20));
delimiter |
create trigger foo_ins before insert on foo
for each row
begin
set new.aa = concat(new.cc,'-',new.id);
end; |
delimiter ;
insert into foo (cc,id) values ('www',1);
select * from foo;
-Original Message
Bubble bubble bubble
-Original Message-
From: Krishna Chandra Prajapati [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 05, 2007 9:48 PM
To: Jeff Mckeon
Cc: MySql
Subject: Re: REPLICATION
Does any body has tried this
On Dec 6, 2007 10:08 AM, Krishna Chandra Prajapati <[EMAIL PROTEC
Your missing your data type for the spdate_updated attribute
CREATE TABLE tbl_spdate(
spdate_ID int NOT NULL PRIMARY KEY AUTO_INCREMENT , spdate_date date NOT
NULL , spdate_notes varchar( 100 ) , spdate_created timestamp default 0,
spdate_updated timestamp default CURRENT_TIMESTAMP ON UPDATE
CURRE
--+-+
| CustomerID | TimeCreated |
++-+
| 4 | 1992-11-28 08:13:09 |
| 5 | 1987-11-28 08:13:09 |
++-+
-----Original Message-
From: gunwant walbe [mailto:[EMAIL PROTECTED]
S
Try it and see where the data goes. It amazing how much you learn by doing
it.
The first problem that you will see is the PK and unique keys in
partitioning have to have the partition key as part of the index. So your
PK would have to be CustomerID, TimeCreated
-Original Message-
From
U might want to try seting you index to calldate, disposition
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 25, 2007 10:03 PM
To: Edoardo Serra
Cc: mysql@lists.mysql.com
Subject: Re: MyISAM vs InnoDB - Index choice and Huge performance differ
I need to update a table with the contents of a CSV file regularly, I've
used mysqlimport to load all the initial data, but I have a problem with
using it for updates. The data in the CSV file does not contain all of the
data in the table, there is a field that is updated by another application
as
e to be similar between versions. I thought originally that
performance may have suffered starting in 4.1 because of the
localization overhead, but 5.0 has a much more dramatic performance
drop. Are there any settings I should tweak? We do not have any plans
to use any of the new features in 4.1 or 5.0
lation? If it is special, where can it be found?
Thank you for your help.
Joe.
-Original Message-----
From: Joe Herman [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 27, 2005 12:21 AM
To: mysql@lists.mysql.com
Subject: Newbie question: How to import data into a table?
Hello folks,
Hello folks,
What is the best way to import an excel spreadsheet, or text file for
that matter into a table?
Is there a way to do this with PHPMyAdmin?
Thank you so much for your kind help.
Joe
experience of users on this list, can anyone tell me what
they prefer and why? What do most people use here?
Joe.
Hello, I am just starting with MySQL and PHP, but this discussion about
innodb has rather piqued my interest. Can someone please give a brief
explanation as to what it is.
Cheers,
Joe.
Thanks for your reply.
I've done what you said. Unfortunately I get the message in the CMD
Window:
'MYSQLADMIN' is not a recognized as an internal or external command.
Can you tell me what this means? I did run the installer earlier. Thank
you.
Joe.
-Original Message-
F
ll me what I need to do to get MySQL to work?
Right now I am just trying to set things up so that I can start learning
PHP. Please help.
Thank you.
Joe Herman
New York City
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[
ce for id(OG012), but vendor b has
minimal rating then vendor c.
Many thanks,
Joe.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
NULL| Query | 0|
NULL | show processlist |
+-+--+---+-+-+--+--+---+
(obviously this was from a snapshot of the one that takes 4x as long to
run)
-Joe
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
running stably. I
ran into some libc issues with Ubuntu already, as seen here:
http://bugzilla.ubuntu.com/show_bug.cgi?id=11730
However I've compiled my own replacement libc with patches applied to
fix the issues, which I will make available to all. Except for this
memory problem, the machi
--------+
135 rows in set (0.01 sec)
Thanks,
-Joe
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
---+-+--++--++-+
5 rows in set (0.00 sec)
Any help or direction to bring this would be appreciated (even if it's,
hey! You sound like you've got a problem, open a support case)
Thanks,
-Joe
Server version 4.0.23-standard
I put something out on the general forum. Perhaps I could try the
general list. Thanks for your help.
Joe Garry
Software Engineer
US Biometrics
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 02, 2005 4:09 PM
To: Joe Garry
Cc
>
+-++-+
| max(close_date) | symbol | name|
+-++-+
| 2004-10-05 | aa | cmptrhw |
| 2004-10-05 | bb | biotech |
| 2004-10-05 | cc | biotech |
+-++---
How about
select close_date, symbol, name
from TD
where symbol in () limit 1
ORDER BY close_date desc
Jeff Mathis <[EMAIL PROTECTED]> wrote:
hello query gurus.
we have a table TD with the following columns:
close_date
symbol
name
close_date is just a date field
there is a unique constr
roll it back, it will
negate all changes (inserts, updates, deletes) that occurred within the transaction.
Hope that helps, not sure I'm understanding your question.
Regards,
Joe Audette
Stuart Felenstein <[EMAIL PROTECTED]> wrote:
This maybe somewhat of a silly question.
Scenar
ecure your connection string as it is
sent accross the local network unless they upgrade the db to a version that supports
secure connections.
Sorry I can't be of more help.
Best Regards,
Joe
Thomas Trutt <[EMAIL PROTECTED]> wrote:
Hi Joe,
My understanding is, and please don't quit
y have a MySQL database on your network
that is lower version than 4 then how do the other apps connect to it securely? Or is
your app the only one that needs this level of security and other app can transmit to
the db in clear text?
Joe Audette
Thomas Trutt <[EMAIL PROTECTED]> wrote:
Thanks
connection string encrypted in a config file for your app
then decrypt it before you connect. You'd have to use an encryption that can be
decrypted with a key.
Checkout the System.Security.Cryptography.DESCryptoServiceProvider class
Hope that helps,
Joe Audette
Thomas Trutt <[EMAIL
Does the mysql server return to the client (DBI in this case) the query
execution time? If so, how do I retrieve it?
Thanks,
Joe
--
Joe McGuckin
ViaNet Communications
994 San Antonio Road
Palo Alto, CA 94303
Phone: 650-213-1302
Cell: 650-207-0372
Fax: 650-969-2124
--
MySQL General
If I perform a fulltext search for 'foo', it won't match text like
'foo, inc'.
Why?
Mysql 3.23.52
--
Joe McGuckin
ViaNet Communications
994 San Antonio Road
Palo Alto, CA 94303
Phone: 650-213-1302
Cell: 650-207-0372
Fax: 650-969-2124
--
MySQL Gene
Hi,
Is this possible to set a timeout value for mysql_query() call?
Regards,
- Joe
mp_option_short_max,count(if(lmp>0,lmp,null)) as Freq_plus,
count(if(lmp<0,lmp,null)) as minus
from DB1.t6
group by year, month, source, sink, class_type;
drop table if exists DB1.t6;
end;
I appreciate any suggestions.
Thank you
Joe
--
MySQL General Mailing List
For list archives
MYSQL new feature
The aggregating functions std and variance calculate
the population standard deviations and variance. I
work extensively with datasets doing statistical
analysis. Many times it is faster and more efficient
to perform the basic univariate statistics on the
server but I need the
;reset query cache', throughout the night? Is a query
cache of 512M beyond the recommended size? I wouldn't have expected it
to take 25 seconds to clear out a single table's query cache, is this
possible?
Thanks,
-Joe
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
_size=512M
set-variable= join_buffer_size=512M
set-variable= sort_buffer=512M
query_cache_size= 512M
The system has 4gigs of memory, recently reduced from 8 gigs to try to
work around a separate problem, and we're running the 2.4.26 linux
kernel on a quad cpu x86 machine.
Any thoughts? What kind of internal locks might be generated? Is there
another command I can run to get the status of those queries that are
hanging? It shows 'None' for the state (NULL), I've never seen a
process state be NULL if it was *doing* something. Would running show
processlist from the Mysql client work better than my python script? I
have cause to believe (but not proof!), that this 'INSERT' is the first
INSERT that table has seen since the batch inserts, but it is *not* the
first insert the entire database server nor that database has seen since
the overnight inserts. (and as mentioned before, it is NOT an insert
into the table that saw all the inserts earlier). This server is the
master in a master/slave configuration.
Any assistance would be appreciated!
-Joe
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
InnoDb doesn't support full text indexes on text columns so if you need to search text
fields you may want ot use MyISAM. It is perfectly ok to have a mixture of InnoDB and
MyISAM in a single database so you can make your decision on a table by table basis.
Joe
Stuart Felenstein &l
major mysql release, how can I delete
these log files now? Even if I delete them off disk, they are still
referenced in the 'relay-bin.index' file. Presumably I'm not allowed to
update that file on a live slave...
Ideas?
-Joe
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi, I use BK to download a snap shot of mysql-4.1. On make test, it said failed at
ps_2myisam. What am I doing wrong?
I am using the BUILD/compile-pentinum-max script to build mysql. I change the setting
to disable openssl and berkeley-db and change prefix to /usr/local/mysql-cluster
Best regar
Hi, may I know of the current MySQL python library supports MySQL cluster or not?
Regards,
- Wong
not seen the slave stop.
So I would believe that we are running into bug:
http://bugs.mysql.com/bug.php?id=1858
on the 3.53.57/3.53.58 line of code. The bug was already fixed on the
4.0.x line of code, but presumably a patch needs to be made to the
3.53.x line of code aswell.
As for the rest of my
ack up the entire slave, run it forward through the logs,
and restore the slave back exactly to it's previous point, and run it
through the logs again. See if it dies in the same places or if it's
somewhat random.
-Joe
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ter-password=zzz
master-port=3306
set-variable = max_allowed_packet=16M
set-variable = max_connections=2000
set-variable = max_connect_errors=9
set-variable = table_cache=256
socket=/tmp/xyz-slave.sock
bind-address=yy.yy.yy.yy
Any help would be appreciated,
Thanks,
-Joe
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
EMAIL PROTECTED]>
Sent: Wednesday, June 23, 2004 4:10 PM
Subject: Re: question on auto increment field
> Scott Haneda <[EMAIL PROTECTED]> wrote:
> > on 06/23/2004 12:14 AM, Joe Wong at [EMAIL PROTECTED] wrote:
> >
> >> If it possible to limit the max value of an
Hi,
If it possible to limit the max value of an auto increment field to say, ,
and how to do it? I am using MySQL 4.0.18.
Regards,
-- Wong
>Description:
Every time I restart the database engine it loses grant entries, and I have
to manually reenter them by hand. Why aren't there rows finding their
way to disk?
>How-To-Repeat:
Add some grants, restart the database.
>Fix:
I don't know of a fix.
webhost who allow
the Innodb table type?
Many thanks
Joe
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I have MySQL 3.23.41 running on an Apache server with Red hat. it's hosted at EV1
(formerly Rackshack) but they do not provide any support for the server.
I'd like to upgrade to the latest MySQL. Does anyone know of a bulletproof,
step-by-step, online guide to doing this? Perhaps a reasonable p
could programmatically compensate the US
time zone by adding the hours to make up the BSTis there any neater way
of doing this, as this solution would involve some hard coding.
Kind regards
Joe
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
I have a database
setup for replication. I used mysqldump --opt db > db.dmp to do the
initial backup of the primary database (after doing a flush tables with read
lock in a seperate session).
I checked the dump
file, and all drop table create table statements are in the file. When I
did a
Phpbb uses an md5 hash to store the passwords. You can use the mysql md5
function or php's to encrypt them. To verify md5 the supplied password
and match against the table.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[E
I am having a major issue with a bulletin board I run. We put the site up
and after a week or binaries just start segfaulting. The mysql database
also gets constantly corrupted. The longer the box is up the more
frequent the corruption is. It can be repaired with myisamchk.
We have been on two
Hi
Are there any plans to have triggers introduced into MySQL?
Regards
Joe
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
I want to store a .txt file in a table in a MySQL database, typically what
is the best type of data type/ column to use for this. The .txt will not
exceed 100K.
Thanks
Joe
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
in the WHERE clause, that we can
use in the select clause. Probably not ANSI, but MySQL isn't shy about that.
--
Joe Rhett Chief Geek
[EMAIL PROTECTED] Isite Services, Inc.
--
MySQL General
can search for all records that have the values in my comma
delimited list.using the one where clause?
Thanks for your patience...I could not find this in the documentation.
Regards
Joe
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
?
or must I drop the column and then add it using the new data type.
I would loose my data by dropping the column.
(I can extract the data and repopulate the table (with the new data type
field) if necessary but would like to avoid this)
any ideas?
Regards
Joe
--
MySQL General Mailing List
For
instances of user particular databases.
Any guidance would be greatly appreciated.
Regards
Joe
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
http://www.mysql.com/doc/en/example-AUTO_INCREMENT.html
this should sort you out..
Regards
Joe
-Original Message-
From: Amit Wadhwa [mailto:[EMAIL PROTECTED]
Sent: 01 April 2004 23:33
To: [EMAIL PROTECTED]
Subject: question on autoincrement
Hi All,
I was wondering if there was a way in
become an issue.
Many thanks for your patience
Joe
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
in folder where MySqlAdministrator is installed and
it fixed it. I found it in a folder related to MS Outlook. Hope that
helps, if you don't find it let me know and I'll send you mine.
Best Regards,
Joe Audette
database_1 and it worked ok with the original back up of
database_1.
While this all worked fine.is there a more elegant way of backing up and
then restoring a database?
many thanks
Joe
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
some of the sample
mysqldump commands given in the documentation, but all have resulted in
syntax errors.
See below
Any advice or pointers would be greatly appreciated.
many thanks for your patience
Joe
nuatech_1 is the name of my database
nuatech is my password set up for the root user
I want
thanks
Joe
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
= (return values got from above + New Increment)
where
Any help would be greatly appreciated
many thanks
Joe
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
this
table?
Kind Regards
Joe
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
tname
FROM `tree` AS t1
LEFT JOIN tree as t2
ON t1.parentname=t2.name
LEFT JOIN tree as t3
ON t2.parentname=t3.name
WHERE t3.name='AZ';
Gets me
MonumentApache
Statue Apache
But not the nodes with names Apache, Navajo, Mohawk
Can anyone tell me the correct syntax to pick a node in the tree and get
everything logically below that node in the heirarchy?
Thanks
Joe Mellon,
[EMAIL PROTECTED]
, and before performing any inserts, either update the
corresponding row in the insert lock table or select it for an update.
joe
On Tue, 2004-01-20 at 10:01, Zeltser, Alex wrote:
> Hi Chris,
>
> Thanks for the response and the suggestions. Doesn't SERIALIZABLE level just add
>
It looks like having a multiple-column index would help more than having
a number of individual indices, at least for the example query. An
index on (termid, docid, whichpara, offset) might work better than just
having one on termid.
joe
On Thu, 2004-01-15 at 10:53, Gregory Newby wrote:
>
just that it's easier to separate out
changes that need to be made to production databases during the upgrade
versus changes that need to be made to code using the new system.
--
Joe Rhett Chief Geek
[EMAIL PROTECTED]
es about result changes relative to character set implementations.
--
Joe Rhett Chief Geek
[EMAIL PROTECTED] Isite Services, Inc.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To uns
pollution');
> >+--+
> >| count(*) |
> >+--+
> >| 100 |
> >+--+
> >1 row in set (0.03 sec)
>
> How many do you get with
>
> SELECT COUNT(*) FROM Notices WHERE MATCH (Text) AGAINST
,
Joe Johnson
Airlink Systems
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Matt W wrote:
I guess you'll have to see if it's fixed in the next release (4.0.17).
Any clue as to when 4.0.17 will be released?
Joe
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
1 - 100 of 282 matches
Mail list logo