On 31/03/2015 12:20, Larry Martell wrote:
On Tue, Mar 31, 2015 at 1:13 AM, Andrew Moore wrote:
When you use a timezone with DST there is no such thing as 2.30am on the
date of changeover. That hour doesn't exist.
I am using UCT - I am not using a timezone.
In MySQL 5 and above, TIMESTAMP va
On Tue, Mar 31, 2015 at 1:13 AM, Andrew Moore wrote:
> When you use a timezone with DST there is no such thing as 2.30am on the
> date of changeover. That hour doesn't exist.
I am using UCT - I am not using a timezone.
> Look up the difference between timestamp and datetime data types.
I did do
When you use a timezone with DST there is no such thing as 2.30am on the
date of changeover. That hour doesn't exist.
Look up the difference between timestamp and datetime data types.
A
On 31 Mar 2015 05:43, "Larry Martell" wrote:
> I have a column that was a timestamp type. I was inserting row
On 17-03-2014 16:21, Mister Vlad wrote:
I am looking at building a dedicated MySQL server... was wondering about the
downside to using SSD drives?
My thoughts was going 2 servers, with 4 drives each in raid 5 (3+1)
configuration.
Is this a good idea? I was originally thinking about going Raid
I suspect, without knowing for sure, that the server will preallocate the 16MB
(or whatever) and then proceed to fill it in. Such a malloc is not costly, and
not risky (unless you have thousands of threads doing the same thing at the
same time).
Who cares? If GROUP_CONCAT() is what you need,
On Fri, Apr 6, 2012 at 2:46 PM, shawn green wrote:
> On 4/5/2012 3:14 PM, Wes Modes wrote:
>>
>> No one here has any experience with it?
We use the proxy between master/slaves for the last 3 years. I didn't
implement it, but I look after it. I'm just about to switch to 0.8.2,
but the only real
On 4/5/2012 3:14 PM, Wes Modes wrote:
No one here has any experience with it?
...
Probably not. If you notice the version number for MySQL Proxy still
starts with a "0." which the universally accepted indicator that it is
of pre-production quality. Thanks to the corporate changes of the las
No one here has any experience with it?
W.
On 4/4/2012 2:17 PM, Claudio Nanni wrote:
> Wes,
> Thanks for these questions about this 'ghost' of the MySQL world, it
> seems more a legend than a real thing!
> I am sorry I do not have the answers but I would love to hear some.
>
> All I can say is t
Wes,
Thanks for these questions about this 'ghost' of the MySQL world, it seems
more a legend than a real thing!
I am sorry I do not have the answers but I would love to hear some.
All I can say is that MySQL Proxy is currently (still) in Alpha
http://dev.mysql.com/downloads/mysql-proxy/
https://l
or u can use "for loop", have only the database to be exported and use that
variable in --database and do mysqldump of each database.
On Thu, Sep 15, 2011 at 6:27 PM, Carsten Pedersen wrote:
> On 15-09-2011 10:31, Chris Tate-Davies wrote:
>
>> Adarsh,
>>
>> 1)
>>
>> When restoring a mysqldump you
On 15-09-2011 10:31, Chris Tate-Davies wrote:
Adarsh,
1)
When restoring a mysqldump you have the option of which database to
restore.
mysql database1 < backup.sql
Admittedly, it's been a few years since I last used mysqldump, but I
suspect that it will contain USE commands - as such, it wil
Adarsh,
1)
When restoring a mysqldump you have the option of which database to restore.
mysql database1 < backup.sql
2)
You might be able to use the --ignore-table command. I'm not sure if
this would work
mysqldump --all-databases -q --single-transaction
--ignore-table=databasetoignore.*
Absolutely. You don't want to obscure the cause by just throwing more
hardware at things.
That approach just buys you time until a bigger pile hits the fan if
the underlying issue remains unresolved.
At the same time, though, 8 MB production innodb buffer pool
allocation should be fairly high on th
On Wed, Jun 9, 2010 at 8:04 PM, Kyong Kim wrote:
> If the memory is available, why not use it? It seems like the default
> buffer pool size out of the box was just never changed.
Agreed, of course, but if something happens on a system that is out of
the ordinary, it's very good practice to hunt t
On Tue, Jun 8, 2010 at 10:57 PM, Machiel Richards wrote:
> Good morning all
>
>
>
> I would like to try and find out how you can see what is using the
> query cache.
>
>
>
> My reason for asking is the following:
>
>
>
> On one of our client databases, the quer
And an answer to 2): http://www.maatkit.org/doc/mk-query-digest.html
On Tue, Oct 6, 2009 at 02:59, Brown, Charles wrote:
> Questions Folks:
> (1) What do you about un-index searches. How can one report and monitor them?
> (2) What do you do with the slow-query log. Are there any utilities or
> s
See
log-queries-not-using-indexes
option in my.cnf, used with the slow log.
http://dev.mysql.com/doc/refman/5.1/en/slow-query-log.html
Regards,
Gavin Towey
-Original Message-
From: Brown, Charles [mailto:cbr...@bmi.com]
Sent: Monday, October 05, 2009 12:59 PM
To: Mysql List
Cc: John M
donné que les email
> peuvent facilement être sujets à la manipulation, nous ne pouvons accepter
> aucune responsabilité pour le contenu fourni.
>
>
>
>
>
>
> > Date: Sat, 3 Oct 2009 18:11:59 -0600
> > From: john.l.me...@gmail.com
> > To: m...@phillipsmarketi
Mark Phillips wrote:
On Sat, Oct 3, 2009 at 3:06 PM, Martin Gainty wrote:
depends on the relationship of the Data Tables and the Users that use them
for instance if I was to setup a table of outgoing calls from 2 distinct
individuals :
Me> calls to HarvardMedicalSchoo
On Sat, Oct 3, 2009 at 4:02 PM, John Meyer wrote:
>
> John,
>> Thanks. The data is private to each user; there is no sharing of data. I
>> am not sure what you mean by "are the actions related" Each user is
>> reading/writing independently of each other. Would that argue for separate
>> database
On Sat, Oct 3, 2009 at 3:06 PM, Martin Gainty wrote:
> depends on the relationship of the Data Tables and the Users that use them
>
> for instance if I was to setup a table of outgoing calls from 2 distinct
> individuals :
> Me> calls to HarvardMedicalSchool, MassGeneral,
>
John,
Thanks. The data is private to each user; there is no sharing of data.
I am not sure what you mean by "are the actions related" Each user is
reading/writing independently of each other. Would that argue for
separate databases?
Mark
Are the actions of a similar nature (i.e. they're
On Sat, Oct 3, 2009 at 2:47 PM, John Meyer wrote:
> Mark Phillips wrote:
>
>> I am new at database design, and my question relates to the trade-offs
>> between putting all data in one database or several for mysql. For
>> example,
>> say I have an application where a users login from their mobile
Mark Phillips wrote:
I am new at database design, and my question relates to the trade-offs
between putting all data in one database or several for mysql. For example,
say I have an application where a users login from their mobile phones and
read/write data to a database. Say there are roughly 1
Robert,
I know you have had other answers, but as to the database name, yes, you can
remove the CREATE DATABASE statement and change the USE statement to the
right database name.
N.B. In our environment the students have only one database each, and will
install blogs and wiki's etc. using that one
then: dump, import locally, rename and dump again. Still feels a bit
safer then parsing though it might be a bit more work.
OlinData: Professional services for MySQL
Support * Consulting * Administration
http://www.olindata.com
On Sun, Feb 1, 2009 at 9:42 PM, Robert D. Crawford wrote:
> Walter
Walter Heck writes:
> Might be a bit late,
Better late than never.
> but on the naming issue: why not rename the tables on the old database
> before doing the dump? that would save you from potentially messing
> with your data due to parsing problems.
A good idea, but it wouldn't have worked
Might be a bit late, but on the naming issue: why not rename the
tables on the old database before doing the dump? that would save you
from potentially messing with your data due to parsing problems.
Just a thought :)
Walter
OlinData: Professional services for MySQL
Support * Consulting * Admini
Olaf Stein writes:
> I think he only has one DB, I guess that is a provider restriction...
True. I would create a separate db for each application if I could.
rdc
--
Robert D. Crawford rd...@comcast.net
--
MySQL General Mailing List
For list archives:
I think he only has one DB, I guess that is a provider restriction...
On 1/30/09 8:52 AM, "Claudio Nanni" wrote:
> Robert,
>
> keep the two databases separated,
>
> that is on different mysql database (or schema as they are also called).
>
> If the wordpress blog is on a database named 'wpbl
Robert,
keep the two databases separated,
that is on different mysql database (or schema as they are also called).
If the wordpress blog is on a database named 'wpblog' for example
import your dump in another newly created database.
Could just use those statement in the dump file
CREATE DATAB
Hello, Olaf,
"Stein, Olaf" writes:
> the import of the dump will not remove your other tables unless there
> is a naming conflict, then the table will be overwritten. As far as
> the prefix goes you can edit the dump file, find the create table
> statement for each table and add the prefix. If y
Robert,
the import of the dump will not remove your other tables unless there is a
naming conflict, then the table will be overwritten. As far as the prefix goes
you can edit the dump file, find the create table statement for each table and
add the prefix. If you have lots of tables or a huge d
2) Your OPTIMIZE statement does cause mysql to create a temporary table,
which eventually replaces your current one.
I suggest you try something along the lines of this and compare speed:
- LOCK TABLES ..
- CREATE TABLE `` (..) # identical table
- INSERT INTO `` SELECT * FROM `` WHERE date < (NOW(
ay, February 01, 2007 3:36 PM
To: 'Ian Barnes'; mysql@lists.mysql.com
Subject: RE: Questions about delete and optimize
Another way to do it would be to select the data you want to keep into a
table on another file system, truncate the existing table, optimize it,
then
reload it with the dat
Ian, based on your needs (regularly deleting everything morre than X
months old), I recommend you look into using the MERGE engine.
Essentially, it is multiple MyISAM tables that appear as one, and
lopping off the oldest data is as simple as redfining the MERGE and
then dropping the oldest table.
Another way to do it would be to select the data you want to keep into a
table on another file system, truncate the existing table, optimize it, then
reload it with the data you saved.
I can't say that I've tried this, and have no idea how long it would take or
even if it would work.
Regards,
Je
I don't think you can do this with mysqlimport. It wouldn't be hard to do
with Perl or PHP, though, and that could be automated any way you want with
a shell script.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
Hi,
> WHERE
> col1 > AND col2 > etc...
> AND PRIMARYKEY > 0;
[...skip...]
> I need an explanation of whether what I did is an
> optimization or not? Or should i be looking into something
> else to actually optimize the query.
The best way to optimize it is would be to a
Hi Dan,
You never really say what your memory problems are. Is MySQL crashing
because you're trying to use too much memory?
more comments inline
On 5/11/06, Dan Trainor <[EMAIL PROTECTED]> wrote:
What I'm dealing with here is memory problems using MySQL 5.0.19 under
FreeBSD. Although I'
Follow up at bottom:
On Tuesday 01 November 2005 04:15 pm, Hal Vaughan wrote:
> On Tuesday 01 November 2005 03:35 pm, [EMAIL PROTECTED] wrote:
> > Which tables can have duplicate records in them should be something
> > decided BEFORE you begin to populate the tables. 99.999% of the time,
> > each
On Tuesday 01 November 2005 03:35 pm, [EMAIL PROTECTED] wrote:
> Which tables can have duplicate records in them should be something
> decided BEFORE you begin to populate the tables. 99.999% of the time, each
> row of any one table should be different from every other row on the same
> table. Tha
Comments embedded. See below
Hal Vaughan <[EMAIL PROTECTED]> wrote on 11/01/2005 02:50:13 PM:
> I want to be sure I understand "INSERT IGNORE..." correctly before I
start
> depending on it. Up until now, I have not been using any kind of key or
> unique index, since many of my tables are cre
http://dev.mysql.com/doc/mysql/en/insert-select.html
There are 2 forms of INSERT INTO statement
1. INSERT INTO tbl_name (...) VALUES(...);
2. INSERT INTO tbl_name (...) SELECT ...;
there's no : INSERT INTO tbl_name (...) VALUES(...) SELECT ...;
its either ... or in MySQL i.e. aither provide values
> it might be best to ask this in the cf forums, however did
> you try to separate the statements with a ; ? I haven't tried
> 2 query statements for MySQL in cfquery...yet ;-) Also I
> believe MySQL 3.23+ supports @@identity
Yes I've tried semicolons after the statements, and I've tried setting
a
On 9/7/2005 1:17 PM Ryan Stille intelligently wrote:
> I am migrating from MS SQL Server to MySQL 4.1.
>
> I have code in my ColdFusion/SQL Server application that went something
> like this:
>
> SET NOCOUNT ON
> INSERT INTO TABLE ()
> SELECT @@IDENTITY AS adid
> SET NOCOUNT OFF
>
>
> That
Hello
JT> Did you try that link? When I follow it, I get a search results page
JT> saying <>. Too
JT> bad it doesn't actually show the search results
Sorry. Try this links
http://solutions.mysql.com/search.php?pc=4%2C86&q=backup&level=0
http://solutions.mysql.com/software/?c=backup
Since
"Ryan Stille" <[EMAIL PROTECTED]> wrote on 07/21/2005 05:47:28 PM:
> I'm trying to get a handle on MySQL backups and hot backups using MyISAM
> and InnoDB tables together. We plan to switch from SQL Server to MySQL
> soon.
>
> How are you guys handling full-backups of databases with mixed MyISAM
We are using MyISAM tables with MySQL running on Windows. We also use
Acronis (www.acronis.com) to take images of the various disc partitions
we have. This uses the "Volume Shadow Copy" capability of XP and Win2K.
Acronis can run a command before the "snapshot" is taken and after it.
It only takes
To: Ryan Stille; mysql@lists.mysql.com
> Subject: Re: Questions about backups, InnoDB tables, etc.
>
> Hello
>
> RS> I'm trying to get a handle on MySQL backups and hot
> backups using MyISAM
> RS> and InnoDB tables together. We plan to switch from SQL
&g
Ryan Stille wrote:
I've been doing some testing and came across something I don't
understand. I filled my test InnoDB formatted table with a lot of data
so mysqldump will take a while to complete. Then I start mysqldump on
this database with the --single-transaction option. While that is
runni
Hello
RS> I'm trying to get a handle on MySQL backups and hot backups using MyISAM
RS> and InnoDB tables together. We plan to switch from SQL Server to MySQL
RS> soon.
Did you see it:
http://solutions.mysql.com/search.php?pc=0%2C0&q=backup&level=0 ?
Sincerely,
Michael,
http://xoib.com/ http
Hi!
- Original Message -
From: "Gary Richardson" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Saturday, March 05, 2005 1:34 AM
Subject: Re: Questions regarding INNODB
You could configure per table table spaces.. I suppose that would be a
little more
You could configure per table table spaces.. I suppose that would be a
little more trackable..
On Fri, 04 Mar 2005 16:38:20 -0600, Michael Satterwhite
<[EMAIL PROTECTED]> wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> I just found out that the hosting company we're using has disabl
Thanks so much for the tips! It's all falling into
place now.
I'm still using the animal database tables you
suggested for me some time ago, but I also wanted to
tap into this ITIS database. Combining or linking the
two should be interesting. :)
--- [EMAIL PROTECTED] wrote:
> I see you found som
I see you found some DB code for a different platform. Most of your
questions are based on the fact that these are NOT MySQL commands (or
scripts) but SQL statements phrased for a different system. If you know
what system it is designed for (Oracle, DB2. ??? ) you should be able to
read their d
Hi
You shoule be able insert fewer columns. Of course,
you should include all the NOT NULL columns unless
they arere is auto_increment for them.
Regards
Bhaskara
> --snip--
> INSERT INTO TABLE1
> (COLUMN1,COLUMN3)
> VALUES
> ('ONE','THREE')
> --snip--
>
--- Scott Fletcher <[EMAIL PROTECTED]
You should try it. The database will like it just fine as long as you have
as many values/columns in your VALUES/SELECT clause as you list as columns
in your INSERT clause.
Just remember, though, that for all of the columns NOT listed in the INSERT
clause of your statement the database will assi
Hi Scott,
Yes this will work. But, you the columns you are leaving out, must be auto fill or
allow blank/Null entries.
Scotty.
Original Message:
>From: "Scott Fletcher" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Subject: Questions about MySQL's INSERT syntax
>Date: Thu, 17 Jun 2004 12:2
Thank you Sasha for your answer.0
I still miss-understand index and 'order by'.
After creating multiples index on a 'Test' table, the current problem
is that mysql optimizer doesn't choose the right index.
Here is a small example
mysql> desc Test ;
+-+-+--+-+
Bernard Chambon wrote:
I try to understand index usage for 'order by'
but that's seemn hard to me.
Here is what I have tried :
1_ About documentation
I have read carefully related documentation (7.2.9 How MySQL Optimizes
ORDER BY) but
I don't understand it.
- What is the difference betwween 'ke
Try this:
On Tue, May 11, 2004 at 12:51:28PM -0700, [EMAIL PROTECTED] wrote:
>
>
> below I have a snippet from a trace file read out for a section of code below. The
> problem seems to be with '$sth->bind_param (2,$rh_row->{prop_str_addr});' The first
> Bind works fine however the next one in
This is all dependent on your OS's unlimit sizes, FS INODE limit, and mySQL
table type. Generally is about 64K for databases and tables if you use
myISAM / LINUX / EXT3
--
DVP
> -Original Message-
> From: Mark.he [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, March 31, 2004 9:42 PM
> To: [E
Rochester, Dean wrote:
does the questions counter equate to the number of queries ran against the
database? or then number of questions a query may have to ask the database
for one query?
if I do a
select * from table1;
and table one has 100 records does that equate to 100 questions or one
q
Jigal van Hemert wrote:
At the moment we have 6 webservers (RedHat) behind a loadbalancer which use
one dedicated MySQL server (plus two smaller dedicated MySQL servers for a
few special sites) for their data.
On setting that seems to cause headaches is MySQL's "max connecterrors". We
cannot find w
I'm attempting a search for multiple strings using the bind_param option. My
understanding is the server will flag each string then after each string has been
selected and exicuted I can then do a fethall_array. However the the results only
include the last string searched. any ideas. an exa
> Should work, as long as your parameters are all strings. With numbers
> you currently need to specify the type (for example DBI::INTEGER or
> similar, written from memory) as a third parameter.
do I need to specify the DBD module in addition to DBI ? After reading the module info
on CPAN it s
Chris,
- Original Message -
From: "Chris Nolan" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Saturday, December 13, 2003 7:24 AM
Subject: Questions about MySQL implementation
> Hi all!
>
> I've got a few questions that I was hoping some of the fine readers of
> this lis
s
> Cc: 'Dan Anderson'; Chris Elsworth; [EMAIL PROTECTED]
> Subject: Re: Questions about indexing
>
>
> Even if your database fits entirely in memory, not having indexes in
> place would not be a good idea.
>
> In an interview Monty did regarding in-memory database
theory and practice. In practice
there is.
- Yogi Berra
---
-Original Message-
From: Dan Anderson [mailto:[EMAIL PROTECTED]
Sent: Monday, December 15, 2003 1:18 PM
To: Chris Elsworth
Cc: [EMAIL PROTECTED]
Subject: Re: Questions about indexing
With such a small database it really boil
re is no difference between theory and practice. In practice
there is.
- Yogi Berra
---
> -Original Message-
> From: Dan Anderson [mailto:[EMAIL PROTECTED]
> Sent: Monday, December 15, 2003 1:18 PM
> To: Chris Elsworth
> Cc: [EMAIL PROTECTED]
> Subject: Re: Q
> With such a small database it really boils down to just being tidy;
> you don't want indexes you're not going to use.
Well the database is going to be like 200MB and executing several
hundred queries a minute. Thus my concern about speed. Is a P4 w/ 1GB
RAM going to choke and die, or will inde
On Sun, Dec 14, 2003 at 03:53:00PM -0500, Dan Anderson wrote:
>
> I have a database I'm using for a MMORPG (well, it isn't very
> MM because I'm something of a noob), and I have a few questions about
> indexing. I am storing world data in a database. In order to keep
> everything as
On Sun, Dec 14, 2003 at 02:08:07PM +1100, Chris Nolan wrote:
> Hi!
>
> Thanks for the detailed reply!
>
> Regarding the hot backup method that the other guys use, sounds like a
> dodgy method of doing anything to be honest. It would have to have a
> fairly decent performance hit...
It's going to
Hi!
Thanks for the detailed reply!
Regarding the hot backup method that the other guys use, sounds like a
dodgy method of doing anything to be honest. It would have to have a
fairly decent performance hit...
Regarding the rollback of ALTER, DROP and RENAME statements, the main
use that I've seen
Hi,
On Sat, 13 Dec 2003, Chris Nolan wrote:
> 1. We all know that InnoDB can be backed up "hot" (by various means). I
> know that there are a few MS SQL Server (ick) and DB2 lovers in the
> group I'll be meeting with this week. I also know that these two
> databases do a form of online backup.
>
TECTED]
> Sent: Monday, September 08, 2003 8:07 PM
> To: [EMAIL PROTECTED]
> Subject: RE: Questions abou innodb
>
>
> InnoDB of course does not support
> > FULLTEXT indexes, and so forth.
>
> Which is a pain, because i want the foreign key relationships
> b
> start transaction
> do query
> if error
> rollback
> else
> commit
>
>
> --
Heh thats what i meant ;)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
At 13:06 +1000 9/9/03, <[EMAIL PROTECTED]> wrote:
InnoDB of course does not support
FULLTEXT indexes, and so forth.
Which is a pain, because i want the foreign key relationships but fulltext
indexing at the same time :\
As for transactions , is it simply by doing this?
start transaction
do query
InnoDB of course does not support
> FULLTEXT indexes, and so forth.
Which is a pain, because i want the foreign key relationships but fulltext
indexing at the same time :\
As for transactions , is it simply by doing this?
start transaction
do query
commit
if error
rollback
??
--
MySQL Gen
> 1) can you join a MyISAM table to an innodb table in a select?
Absolutely.
> 2) Under 'Restrictions...' in the manual, it says:
> When you restart the MySQL server, InnoDB may reuse an old
> value for an
> AUTO_INCREMENT column.
> Under what circumstances does this occur?
If you perform an I
Hi i have just started to use them aswell to do proper relationships
between tables to add data restrictions on deleting records.
>
> 1) can you join a MyISAM table to an innodb table in a select?
This seems to work.
>
> 2) Under 'Restrictions...' in the manual, it says:
> When you restart the M
As you write your code in somewhat pseduo code format, I can't comment on the
exact syntax. You may use PERL-DBI-DBD:MySQL to implement your code. However,
it may some problems with your logic. First of all, if the quote_for_family
table already exist, the create table sql do nothing and it defi
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Dj W wrote:
Hello,
I've been looking through the source code for
version 4.0.10-gamma trying to discern how exactly
this thing runs by tracing back through the various
inits() but because of how poorly it has been
documented its slightly overwhel
On Thu, Dec 05, 2002 at 04:03:41PM -0600, Dan Nelson wrote:
> Protocol compression is separate from Table compression. To enable
> protocol compression, set the CLIENT_COMPRESS flag when connecting to
> the server, or add the "compress" keyword to the [client] block of your
> my.cnf file.
How ab
On Thu, 05 Dec 2002 15:36:37 -0500, Michael She wrote:
>As for indicies is it better to create a single index per column, or an
>index for a set of columns. For example, if I go: SELECT * FROM SOMETABLE
>WHERE A = X and B = Y. Is it better to create a X AND Y index, or two
>separate indicies?
In the last episode (Dec 05), Michael She said:
> I'm planning to run a remote DB across the internet for a web
> application and I would like to minimize retrival times and
> bandwidth.
>
> I have a couple of questions about MyISAM compressed Tables:
>
> 1. Is it slower to retrieve from a compre
Hi all,
I'm planning to run a remote DB across the internet for a web application
and I would like to minimize retrival times and bandwidth.
I have a couple of questions about MyISAM compressed Tables:
1. Is it slower to retrieve from a compressed table, or actually faster
since data is packed?
At 20:15 -0800 10/31/02, Andre Kirchner wrote:
Hi,
is it possible in the mySQL to have an index that none
of the values could be repeated except for a single
value that could be repeated?
Yes, but the only value that can be repeated is NULL.
That's how UNIQUE indexes work for MyISAM and InnoDB
At 13:20 +0900 10/31/02, Chung Ha-nyung wrote:
Dear,
I'v mailed about this question before and got no complete answer, so
I'm asking
again.
Victoria said that suffix number next to 999 will be 1000 but didn't
mention about the
limit of suffix. I'm wondering whether the suffix number always
in
Tan Phooi San wrote:
Hi,
I got some questions regarding MySQL 3.23.36 and MM.MySQL JDBC Driver.
Hope
you could help me on this.
1. Can both products mentioned above working in Red Hat Linux 7.3 or 8.0?
You don't mention what version of MM.MySQL you're interested in, but
since it's no longer
At 16:13 -0700 10/22/02, Andre Kirchner wrote:
Hi there,
I want to load a file where the values of the columns
are separated by one or more tab ( \t ) characters. Is
it possible to configure the "load data" to accept an
unkwnon number of tabs separating these values?
No.
And how can I coment
Sorry to piggy back on this topic, but would you happen to know of or have a link to a
php discussion list?
-Original Message-
From: Kelly Firkins [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 17, 2002 12:12 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: questions
..If(qualify = true,'Qualified','Not Qualified') as Whatever ...
-=Bryan=-
> -Original Message-
> From: Norris, Joseph [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, September 12, 2002 2:37 PM
> To: Mysql_List (E-mail)
> Subject: FW: questions about IF(expr1,expr2,expr3)
>
>
>
>
> ---
You might also have a look at urSQL from
http://www.urbanresearch.com/ursql.
On Fri, 8 Feb 2002, BD wrote:
>
> Polly,
> Try MySQL-Front from http://www.anse.de/mysqlfront/. I
> have it running on Win2k with no problems. You'll like the price, free! :)
> There is also M
At 08:12 AM 2/8/2002 , you wrote:
>Hi, sir/madam:
>
>I'm new to MYSQL. I'm now doing my final year project,
>and intend to use mysql as the database system.
>
>I installed the version mysql-3.23.46a-win and
>myodbc-2.50.39-nt on my computer for testing.
>
>I would like to download a MYSQL GUI for
At 08:12 AM 2/8/2002 , you wrote:
>Hi, sir/madam:
>
>I'm new to MYSQL. I'm now doing my final year project,
>and intend to use mysql as the database system.
>
>I installed the version mysql-3.23.46a-win and
>myodbc-2.50.39-nt on my computer for testing.
>
>I would like to download a MYSQL GUI for
On Saturday 21 July 2001 00:28, Jeremy Zawodny wrote:
> On Thu, Jul 19, 2001 at 03:15:02PM -0500, Tom Wheeler wrote:
> > Our two most important requirements for the database engine are
> > speed and scalability. We will be inserting probably 5,000,000
> > records per day into our database
>
> Sou
Hi!
On Jul 22, William R. Mussatto wrote:
> >
> > Well, on my tests I was able to add ~4,000,000 rows in 17 hrs
> > with MySQL 3.23, and in 4 hrs in MySQL 4.0
> >
> > Table had 4 indexes. Removing those increased the speed by
> > several orders of magnitude (!!!).
> >
> > Hadware was moderate
On Sat, 21 Jul 2001, Sergei Golubchik wrote:
> Date: Sat, 21 Jul 2001 10:36:22 +0200
> From: Sergei Golubchik <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Cc: Tom Wheeler <[EMAIL PROTECTED]>
> Subject: Re: Questions about extremely large database support
>
> H
1 - 100 of 106 matches
Mail list logo
