XML support is
so very tempting.
Thanks.
Jeff Levy
Software Design
Meta-Craft Creations
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive
only be accessed by them and couldn't be squashed (or
even accessed) by other departments.
Just a thought!
jeff
--
Hey All,
On Redhat Linux is there an easy way to have an ISP style setup where each
user has their own database directory?
Long story short, we have to implement
Try this:
http://www.devshed.com/Server_Side/MySQL
-
Hi,
I am just a starter. Anyone can suggest me good web resources for learning
SQL command that I can
use (compatible) with mySQL ?
I read from www.mysql.com documentation, but it's not complete ...
Well, if you
to the directory that contains php.exe.
In other words, you have to tell IIS to parse .php files with php.exe.
Hope that helps!
Jeff
**
Hi guys, I hope you can show me where I am going wrong.
I have ASP working with MySQL I have recently tried to install PHP. I
) = 'TSV'
AND BA_DATE = DATE_FORMAT('2003-25-2', '%y-%d-%m')
But still 0 rows... D'OH... What am I missing here? Thanks for any
help... I would hate to have to tell the boss we're going back to
VB-ADO-MSAccess ;-)
Jeff
-
Before
Yes Paul, that's what I meant.
See, even confusing myself now ;-)
The field is datetime as the time is used in other functions...
Would I be better using 2 separate fields?
Jeff
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
To: Jeff [EMAIL PROTECTED]; MySQL List [EMAIL
Thanks guys,
Appreciate the help. Kinda makes sense now ;-)
Jeff
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
To: Benjamin Pflugmann [EMAIL PROTECTED]; Jeff
[EMAIL PROTECTED]; MySQL List [EMAIL PROTECTED]
Sent: Thursday, March 06, 2003 9:32 AM
Subject: Re: Syntax confusion
,
Jeff
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL
for the month of June. What is the best way to
search? Do I need to separate the date into different columns (day, month,
year)? I have tried wildcard searches, but they seem to do an entire table
scan and are very slow.
Thanks,
Jeff
Anyone know if it's possible to do replication from more than one
database?
Example:
System A: Database 1
System B: Database 2
System C: Replication of SYSA:DB1, Replication SYSB:DB2
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
Does anyone know if it's possible to replicate to a single slave from
different databases on different masters?
For instance:
M1:dbAM2:dbB
\ /
rep rep
\ /
Slave
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Sorry for the top post, just saying thanks, that's what I thought
Back to the drawing board...
Jeff
-Original Message-
From: David Griffiths [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 01, 2006 18:13
To: mysql@lists.mysql.com
Cc: [EMAIL PROTECTED]
Subject: Re
tar'ing a
file while mysql has it open?
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
to the /data/ prior to restarting
mysql
2) should I move the binlog index as well?
3) will moving the binlog location throw the slaves off?
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
way to have this work? Someone on another msg board told me
to look at Auto_increment_increment and Auto_increment_offset to
accompish this but I don't see anything like that in the MySQL docs.
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
like '%venu%'
jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
-Original Message-
From: VenuGopal Papasani [mailto:[EMAIL PROTECTED]
Sent: Monday, March 13, 2006 11:48
To: Jeff
Subject: Re: Help regarding a simple query
Hi Jeff,
This is venu again.Last mail i did not include a constraint that is
what irritating me most.Actually if i got venu-kkk
a minute. Does
anyone know of any way I can log these connections or some other way of
catching it in progress from myslq so I can figure out which website is
causing it and then go correct the code?
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
is, I can't find the rpm or source for the MySQL-shared-compat
for 4.1.13 (or any other version for that matter).
Anyone know where I can get my hands on the correct RPM? Are they
hidden somewhere on the MySQL site?
Best regards,
Jeff
--
MySQL General Mailing List
For list archives: http
Thanks!
Jeff
-Original Message-
From: Jason Pyeron [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 26, 2005 3:03 PM
To: mysql@lists.mysql.com
Subject: Re: Mysql-shared-compat for 4.13
you can find what you need here:
http://public.pdinc.us/rpms/mysql
please email
Does anyone know if there are any problems replicating from a master
database on version 4.0.16 to a slave running version 4.1.13?
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
, you MUST use the /usr/bin/mysqlbug script!
Starting MySQL...[FAILED]
Anyone have this problem and know how to fix it???
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
:
Seconds_Behind_Master: NULL
Any ideas as to what is locking it up?
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
,
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
-Original Message-
From: Dan Nelson [mailto:[EMAIL PROTECTED]
Sent: Friday, September 16, 2005 11:34
To: Jeff
Cc: mysql@lists.mysql.com
Subject: Re: Circular Replication
In the last episode (Sep 16), Jeff said:
Does anyone use circular replication with MySQL 4.x
-Original Message-
From: Jeff McKeon
Sent: Friday, September 16, 2005 13:19
To: Devananda
Cc: mysql@lists.mysql.com
Subject: RE: Circular Replication
-Original Message-
From: Devananda [mailto:[EMAIL PROTECTED]
Sent: Friday, September 16, 2005 11:55
To: Jeff
Cc
:
A - B - A
Is it necessary to start the servers with --log_slave_updates?
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
-Original Message-
From: Devananda [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 20, 2005 17:13
To: Jeff
Cc: mysql@lists.mysql.com
Subject: Re: Circular Replication
Jeff wrote:
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday
-Original Message-
From: Bruce Dembecki [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 20, 2005 23:05
To: Jeff
Cc: mysql@lists.mysql.com
Subject: Re: Circular Replication
On Sep 16, 2005, at 11:07 AM, Jeff wrote:
There shouldn't be a problem if:
server A is ver 4.0
returns
*** 120. row ***
Variable_name: timezone
Value: IST
I'm sure I've missed something simple here but what?
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
from A - B - A (circular
replication) when A had Table1= InnoDB and B has Table1=MyISAM?
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
-Original Message-
From: Warrick Wilson [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 22, 2005 12:09
To: mysql@lists.mysql.com
Subject: Web-based reporting tool?
This seems to be a common question, but answers aren't that common...
What are people using as a web-based
-Original Message-
From: Bruce Dembecki [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 22, 2005 11:41
To: Jeff
Cc: mysql@lists.mysql.com
Subject: Re: MyISAM to InnoDB
You will need to make sure you have innodb configured in the my.cnf
file and you have enough space built
-Original Message-
From: Sujay Koduri [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 22, 2005 15:23
To: mysql@lists.mysql.com
Subject: Avg row length is varying a lot from oracle to MySQL
hi ,,
we are converting our oracle DB to MySQL DB. One problem i
see is that the
overhead so generally take your
calculated row size and multiply by 1.1.
sujay
-Original Message-
From: Jeff [mailto:[EMAIL PROTECTED]
Sent: Friday, September 23, 2005 1:12 AM
To: mysql@lists.mysql.com
Subject: RE: Avg row length is varying a lot from oracle to MySQL
-Original
-Original Message-
From: Devananda [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 22, 2005 16:14
To: Jeff
Cc: mysql@lists.mysql.com
Subject: Re: MyISAM to InnoDB
Jeff wrote:
True, is there a way to tell a slave to not replicate
certain queries
like alter table
-Original Message-
From: Devananda [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 22, 2005 19:03
To: Jeff
Cc: mysql@lists.mysql.com
Subject: Re: MyISAM to InnoDB
Jeff wrote:
-Original Message-
From: Devananda [mailto:[EMAIL PROTECTED]
Sent: Thursday, September
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, September 23, 2005 09:40
To: Jeff
Cc: mysql@lists.mysql.com
Subject: RE: MyISAM to InnoDB
Sorry to butt in but I wanted to make sure you didn't do
actually do what
you proposed to do, yet
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, September 23, 2005 10:25
To: Jeff
Cc: mysql@lists.mysql.com
Subject: RE: MyISAM to InnoDB
Jeff [EMAIL PROTECTED] wrote on 09/23/2005 09:57:06 AM:
-Original Message-
From: [EMAIL
14K Sep 12 11:50
#sql-7c1c_217c.frm
-rw-rw1 mysqlmysql1.8G Sep 12 11:54
#sql-7c1c_217c.MYD
-rw-rw1 mysqlmysql 92M Sep 12 12:09
#sql-7c1c_217c.MYI
Anyone ever see something like this before? Are they files for a temp
table maybe?
Jeff
--
MySQL
Jeff wrote:
Had problem with our database this weekend, apparently an
app did an
insert query that was huge size wise and this totally boogered up
replication downstream. Also I cant read past that point in the
binlog using mysqlbinlog on the master server. It complains
But what happens if the ibdata2 fills up to the max of 2G?
I've got 50 gig available on the partition where the db data is stored.
Is there anything else here that looks incorrect?
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
-Original Message-
From: Sujay Koduri [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 28, 2005 11:04
To: Jeff; mysql@lists.mysql.com
Cc: [EMAIL PROTECTED]
Subject: RE: MyISAM to InnoDB
If you think your storage requiremnets will increase in
future, try to estimate how
-Original Message-
From: Devananda [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 28, 2005 13:06
To: Jeff
Cc: mysql@lists.mysql.com
Subject: Re: MyISAM to InnoDB
Jeff wrote:
Cut orignal thread because it was too long
The system is only used as a database server
-Original Message-
From: Devananda [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 28, 2005 13:06
To: Jeff
Cc: mysql@lists.mysql.com
Subject: Re: MyISAM to InnoDB
Jeff wrote:
Cut orignal thread because it was too long
The system is only used as a database server
Jeff wrote:
Ugh...
mysqladmin -uroot -ptelaurus processlist | grep -c Sleep
And it returned 200 sleeping connections, all persistant
connections
from our app servers and 4 threads_running
Also a show status gave me a max_used_connections of 236.
If that's the case
-Original Message-
From: Devananda [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 29, 2005 14:56
To: Jeff
Cc: mysql@lists.mysql.com
Subject: Re: MyISAM to InnoDB
Jeff wrote:
Well the applications with persistant connections is a
touchy subject.
Our apps send
the local system, fails until I actually
create another grant record for [EMAIL PROTECTED]
It's not a huge problem but I'd like to understand it better.
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
that server. I guess
that could be easily spoofed though.
In any event, thanks for a thorough answer, at least I know the behavior
is truly by design.
Jeff
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 12, 2005 09:53
To: Jeff
Cc: mysql
Hey all,
I need to do some repairs on a replication master/slave and can't
remember the command to turn off bin logging on the master for a single
session.
Set session log_bin = off;
Just returns an error: ERROR 1193: Unknown system variable 'LOG_BIN'
MySQL ver 4.1.13
Thanks,
Jeff
',unix_timestamp(now()),'[EMAIL PROTECTED]
[EMAIL PROTECTED]','Medium','Open',unix_timestamp(now()),'Jeff
McKeon','Jeff McKeon','','','ks5hslajdfasd','1','[EMAIL PROTECTED]')
The error:
You have an error in your SQL syntax near
'from,department,subject,body,lastaction,lastpost,priority,status,create
d
Nevermind, found that usig `from` works.
Jeff
-Original Message-
From: Jeff [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 29, 2005 11:43
To: mysql@lists.mysql.com
Subject: Insert query problem
All,
I can't get this query to run, it keeps compaining
for Avg_row_length or even what the measurement is. Bytes?
Columns?
Any help is much appreciated.
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
-Original Message-
From: Michael Stassen [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 08, 2005 14:34
To: Jeff
Cc: mysql@lists.mysql.com
Subject: Re: Alter MyISAM table to adjust max_rows and Avg_row_length
Jeff wrote:
I've got a table that just hit the 4gig limit
.
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
. While the
tables are flushed with read lock, what becomes of all the Insert,Update
and delete queries that come in via replication? Will they be applied
after the backup is done and the tables unlocked?
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
(there are
downstream servers doing one way replication off of server B) and then
replicated back to A?
Just having a brain fart here...
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
-Original Message-
From: Dominik Klein [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 18, 2006 11:06
To: mysql@lists.mysql.com
Subject: Re: Multi master replication question
Replication setup:
A - B - A
|
C
One thing I can't remember is do I have to set an
:submitter ID
Originator: Jeff
Organization:
organization of PR author (multiple lines)
MySQL support: [none | licence | email support | extended email support
]
Synopsis:synopsis of the problem (one line)
Severity: [ non-critical | serious | critical ] (one line)
Priority
query directly? The only other option I guess I
have is to run a mass update on a field then doing the normal order but doing
three updates just to make one select work seems kind of unfortunate :(
Jeff
originally wanted
to use mySQL as the part that did this processing as opposed to outputting the
results then sorting an array.
Jeff
From: 卢钧轶 [mailto:cenal...@gmail.com]
Sent: Sunday, October 25, 2009 1:19 AM
To: Jeff
Subject: Re: Using IF in a query to set a variable then sort on said variable
An additional field is pretty much impossible since that case would change
throughout the day unfortunately. But thank you all for your assistance, will
do some testing.
Jeff
-Original Message-
From: Jaime Crespo Rincón [mailto:jcre...@warp.es]
Sent: Monday, October 26, 2009 12:52 PM
Hello, I have read through several pages of the reference manual, and
I've seen several instances where it is stated that LOCK TABLES (and
UNLOCK TABLES) is not allowed in a stored procedure, but so far, I
haven't found an explanation as to *why* that is. Could someone please
enlighten me?
Thanks
Hi,
I just realized that mysql does not have nested queries, and
I need to do something like this:
update table1 set A="blah" where B=(select B from table1, table2 where
table1.B=table2.B)
Is it possible?
Thanks,
Jeff Pavel [EMAIL
"
- AND t1.id=t2.table1_id
- AND t2.no_of_Items =1;
Jeff
_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
-
Before posting, p
Ooops, I forgot to notice that you required consequetive days.
This query works for me:
select T1.*, T2.*, count(T2.id) as c, concat(T2.id,T2.d) as x from table1
as T1, table2 as T2, table 2 as T3 where T1.id=T2.id and T2.id=T3.id and
T2.d='2001-02-04' and T2.d='2001-02-06' and
hey-
If anyone is looking for a freelance web developer check me out. I have
recently become available. We're talking perl/php/mysql/c++/linux and a
bs degreee.
jeff
--
Jeff Saenz ([EMAIL PROTECTED])
Perl/PHP/SQL/Unix Consulting
http://www.planetoid.net
'/var/lib/mysql/m
ysql.sock' (111)
One thing I have to consider is some recent DNS work I did. Is it possible
DNS could cause these problems?
I'm really at a loss here. Any help is greatly appreciated.
Thanks,
Jeff
-
Before
Ahhh using mysql command instead of mysqldump command to import. It
worked splendidly!
Gracias,
Jeff Gannaway
At 07:21 PM 2/21/01 -0300, Fbio Ottolini wrote:
I just importa data created by mysqldump using
mysql -u username -p dbname table
MySQL asks for my password and it's done.
BR
| mysql --host=[IP Address of New
Server] database -uUSERNAME -pPASSWORD
and I received the following output:
ERROR 1130: Host 'old.server.hostname.net' is not allowed to connect to
this MySQL server
Any tips???
Thanks,
Jeff Gannaway
is some recent DNS work I did. Is it possible
DNS could cause these problems?
I'm really at a loss here. Any help is greatly appreciated.
Thanks,
Jeff
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
r to sort through your e-mails.
Anyway, that's my 2
-Jeff Gannaway
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To requ
"Security" section of the manual to find out how to run mysqld
as ro
ot!
010225 22:17:06 Aborting
Any help is appreciated.
Thanks,
Jeff
-
Before posting, please check:
http://www.mysql.com/manual.php (the manua
nux operating system software. The only linkage in both cases is through
APIs in the LGPL libraries. I can't see the distinction.
Any thoughts?
Jeff
, I would also greatly appreciate if you would
let me know :)
Thanks to everyone in advance.
Jeff Jones
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
)
doesn't always give me the same set of access rights. Can anyone provide an
example of using the host table to grant permissions? Especially useful
would be an example in which using the db table alone would not achieve the
same results as using the db/host tables.
Thanks,
Jeff Brewer
or tails
of it.
-Jeff Brewer
-Original Message-
Did you read chapter 6 in the manual?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive
There should be no password for root@localhost initially. Try
$mysqladmin -u root password 'thisIsMyNewPassword'
instead. The password mysqladmin is asking for is the current password.
The one on the command line is the new one. In your situation the current
password is nothing.
-Jeff
not pan out.
Once again I ask, how specifically is the host table used in granting of
privileges. I challenge someone to write a GRANT statement that affects the
host table. I'd like to utilize the host table but the documentation is so
very cryptic. Just one EXAMPLE would really help.
Thanks,
Jeff
so, where can I change it
so it uses our new domain? Or do I have to do a complete reinstall with a
newly compiled
installation app?
Thanks,
Jeff
-Original Message-
From: Gerald L. Clark [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 12, 2001 4:19 PM
To: Weber, Jeff
Cc: [EMAIL PROTECTE
.
-Original Message-
From: Gerald L. Clark [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 10:56 AM
To: Weber, Jeff
Cc: [EMAIL PROTECTED]
Subject: Re: Reinstallation HANG
when you enter the unix command
hostname
what do you get ?
This had better be resolvable with your DNS.
Maybe you
Are there any open source ERD programs for MySQL for doing basic data
modelling? I tried myERD at sourceforge and it couldn't parse the sql dump
from my database. It died with a parse exception on the unsigned attribute
for my int columns.
Any other choices out there?
Thanks,
--jeff
. a
column should have X unique values before using it in an index...)
Any insight is appreciated.
Thanks,
--jeff
P.S. -- um, sql sql sql -- I can't believe how strict the filter for this
list is...
-
Before posting, please check
or
not?
Thanks,
--jeff
- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
To: Jeff Kilbride [EMAIL PROTECTED]
Cc: MySQL [EMAIL PROTECTED]
Sent: Thursday, February 21, 2002 11:19 PM
Subject: Re: Wide Indexes
On Thu, Feb 21, 2002 at 08:13:51PM -0800, Jeff Kilbride wrote:
For reporting
any GRANT statements, does that mean all connections use the
'root' user with no password -- the default setup? That can't be good...
Just how much does this affect performance?
Thanks,
--jeff
sql,query
-
Before posting, please
and whether to use wide indexes or not. Can somebody
shed some light?
Thanks,
--jeff
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive
Can I have different indexes on the tables in my master and slave? I
want to use the slave strictly for reporting and the master for inserts, so
I'd like to index the crap out of the slave and leave the master relatively
index free.
Will that work?
Thanks,
--jeff
P.S. -- how 'bout adding some
mysql your_script.sql
or
cat your_script.sql | mysql
This assumes you have your username and password set up in your my.cnf or
.my.cnf (home directory). If not, add the -u[username] -p[password]
switches.
--jeff
- Original Message -
From: Chetan Lavti [EMAIL PROTECTED]
To: [EMAIL
I'm about to try a full text index in a very similar situation, which has
the potential to grow fairly big. I'd also be interested in hearing how
MySQL's full text index works for your large dataset.
Thanks,
--jeff
- Original Message -
From: Luke Muszkiewicz [EMAIL PROTECTED]
To: [EMAIL
change it.
Thanks,
--jeff
- Original Message -
From: Laszlo G. Szijarto [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, February 25, 2002 7:13 PM
Subject: any way to do this with SQL ???
Thank you in advance for your help.
I have a table which has a timestamp column. Now, I
(char instead of varchar), if you're not already.
Do you have enough memory to put this into a HEAP table -- or at least make
your temp tables HEAP tables?
Thanks,
--jeff
sql,query
- Original Message -
From: Steve Rapaport [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, February 26
that support CASCADE give you the option of turning it off.
http://www.mysql.com/doc/S/E/SEC445.html
Have you tried entering a bogus ACH number and a corresponding transaction,
and then deleting the key? I don't use InnoDB, so I don't know if it will
work, but it's worth a try...
Thanks,
--jeff
Why not put a flag variable (tinyint or enum) in your ABA table and instead
of deleting the records, just mark them as no longer valid?
--jeff
- Original Message -
From: David Felio [EMAIL PROTECTED]
To: MySQL [EMAIL PROTECTED]
Sent: Wednesday, February 27, 2002 11:49 AM
Subject: Re
Is there a rule of thumb for small tables and whether they should be
indexed? I have several small, two column lookup tables with few rows
(100-300) and some very small tables ( 10 rows). I don't plan on indexing
the very small ones, but what about the others?
Thanks,
--jeff
sql,query
Hi Egor,
Thanks for the reply. Does it actually hurt to index them on lower volumes
of traffic? Or is it neglible?
--jeff
- Original Message -
From: Egor Egorov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, February 28, 2002 8:40 AM
Subject: Lookup tables and indexing
Jeff
as a lookup table with a flag variable to determine their validity.
That may be your only option with MySQL, until InnoDB supports CASCADE.
--jeff
- Original Message -
From: David Felio [EMAIL PROTECTED]
To: MySQL [EMAIL PROTECTED]
Sent: Thursday, February 28, 2002 7:16 AM
Subject: Re: flexible
Hi Jeremy,
Just out of curiosity, what kind of tables are you using on your production
system? MyISAM, InnoDB, a mix of the two, etc...
Thanks,
--jeff
- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
To: Guy Davis [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, March
the transaction ability of InnoDB, but if concurrent replication
affects MyISAM performance in the same way as concurrent insert/select ops,
it makes me wonder which table type I should use on my high insert activity
tables. My assumption was MyISAM, but I'm not so sure now...
Thanks,
--jeff
P.S. -- I saw your
:
http://www.mysql.com/doc/M/i/Miscellaneous_functions.html
--jeff
- Original Message -
From: Richard Bolen [EMAIL PROTECTED]
To: MySQL Mailing List (E-mail) [EMAIL PROTECTED]
Sent: Friday, March 01, 2002 7:37 AM
Subject: Emulating a sequence in MySQL?
I need to have unique id's
.
--jeff
- Original Message -
From: John Hughes [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Saturday, March 02, 2002 12:32 AM
Subject: Query structure puzzle
I have a table with approximately 600 rows. Two of the fields are
record_date and status Every record
1 - 100 of 828 matches
Mail list logo