OTC News Alerts' Last 3 Picks have gained 358%!
Here is our next Hot Pick!
Single Source Financial Services Corp. (OTCBB : SSFL)
URGENT BUY AT $ .60 PER SHARE!
SELL TARGET $3.50 PER SHARE!
SSFL is the fastest growing, publicly-traded credit
card transaction
processor through its contractual
Description:
Following is the test reproduced in several databases (tables of around 7
millions records). Mysql compiled with GBK charset.
A select used with a like 'alpha%' condition fails to report exact matches.
Even if the select is completed by an OR field = 'alpha', it does not
work.
This
copy the 3 files to any of subdir in your datadir.
MySQL will regard the 3 files as a table.
if u donot know where is the datadir, issue the following command
in your mysql client program.
show variables like data%
--
Zu Zhihui [EMAIL PROTECTED]
- Original Message -
From: Eric
[EMAIL PROTECTED] writes:
OTC News Alerts' Last 3 Picks have gained 358%!
Here is our next Hot Pick!
That's it. I'm out of here too.
//C - wonders what the list owner gets for letting the spam in. 10%?
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] |
Carl,
You'll be missed but I can't blame you.
I'm tired enough of getting this kind of pam in my personal mailboxes, I don't need an
additional load from this list. Worst is that I've changed to using a SneakEmail
address to combat spam from spambots harvesting addresses from mail lists - but
FYI
-christian-
On Wed, Jan 09, 2002 at 08:52:34PM +0100, Sjoerd Simons wrote:
Package: mysql-client
Version: 3.22.32-6
Severity: normal
Tags: patch
mysql -D something causes a segv, the attached patch to mysql.cc seems to fix
this..
...
--- mysql.cc.orig Wed Jan 9 20:46:07 2002
I must be going so wrong here.
I deleted the users and started again.
added 2 users
dba and matt. Both of these have the host of % (connect from anything yes ?)
I then do a
grant all privileges on *.* to dba@%
flush privileges
and
grant all privileges on *.* to matt@%
flush privileges
* Yoed Anis
Hi... I have an interesting problem I don't know which way to
solve. I tried posting this on the PHP site (since I'm coding
with PHP and mysql) but they said I might want to try my odds
here.. since they suggested I go with the mysql solution, but
I'm clueless where to start. So
Hi all.
I would like to know why i cannot install the DBD-MySQL-2.1009 on my
computer. I use Perl 5 (ActivePerl build 630) and i have already install
some modules like DBI1.20 and some others (CSV, etc...) and it's always
very easy (using Perl MakeFile.PL - nMake - ) and work perfectly well.
Doug,
I am running redhat linux 7.1.
I have tried these commands, and re-read your mails for earlier, and I
understand what these commands should be doing, and how the tables work for
secuirty.
I have done all that I should have done and I am still stuck.
I have have made sure the linux box
On Thu, Jan 10, 2002 at 12:59:01AM +0200, Heikki Tuuri wrote:
Walt,
The kernel 2.4.4-SMP-64GB has been very stable on our 2-way
computer. Somewhere in about version 2.4.10 Linus changed the
virtual memory. I am not sure how stable kernels 2.4.10 - .17 are,
but at least some people are
Becky McElroy writes:
Two questions regarding multi-table operations:
1) I've got multi-table delete working with a couple of BDB tables,
where it's properly deleting from one or both tables, and all
possibilities of the delete criteria are being exersized. After the
multi-table delete
Vernon A Webb writes:
I have setup a database that GRANTs a specific user access
to a database, which is theirs and will be their
responsibility to manage.
They have privileges on that database only. Using MySQLGUI
they can log in and manage that database, but from the drop-
down menu
Hy,
We have a web application with a mysql DB running for our clients on one
server in the Internet at a provider's place, and we want to have a copy
of the files and the database on a machine in our local network which is
accessible from outside, too, but with lower bandwith, which we only
Hi,
Does anybody knows if is possible to disable case sensitivity in Linux
MySQL??
Thanks in advance,
Fernando Monteiro Duarte
-
Before posting, please check:
http://www.mysql.com/manual.php (the
On Thu, Jan 10, 2002 at 02:27:29PM +0100, Henning Sprang wrote:
We have a web application with a mysql DB running for our clients on
one server in the Internet at a provider's place, and we want to
have a copy of the files and the database on a machine in our local
network which is
Matt:
Can you check and see if you have more than 1 entry for user in your user
table? I wonder if there were more than 1 entry in the user table for user,
MySQL might pick the first one which do not allow you to connect using user
user.
Kam
-Original Message-
From: Matthew Darcy
On Thu, Jan 10, 2002 at 11:52:34AM -0300, Fernando Monteiro Duarte wrote:
Hi,
Does anybody knows if is possible to disable case sensitivity in
Linux MySQL??
Case sensitivity in what part? Table names? Values in columns?
--
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo
Hello Friends,
I've some performance problem, when I do sum() functions on my tables it
took 5-7 minutes to return the results.. here is my story:
I've table with 2461566 rows here is my table structure:
mysql describe imp_log;
Hi Mr. Zawodny,
If is possible, in everything from a Database, but if is not, in columns
is more important.
Thanks in advance,
Fernando Monteiro Duarte
- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
To: Fernando Monteiro Duarte [EMAIL PROTECTED]
Cc: [EMAIL
Jerry:
Can you specify the hardware/software your MySQL 3.23.41-max is running on?
Kam
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 10, 2002 9:07 AM
To: Fernando Monteiro Duarte
Cc: [EMAIL PROTECTED]
Subject: Re: Disable case sensitivity
Dennis Jacobfeuerborn writes:
I think I'll try the binary RPMs from mysql.com as we did not compile
our version with any critical optimizations anyway. Are there
any known issues when using gcc 2.96 as in RedHat 7.2 to compile MySQL?
If that would be the case than I could try to recompile
Fernando Monteiro Duarte writes:
Hi Mr. Zawodny,
If is possible, in everything from a Database, but if is not, in columns
is more important.
Thanks in advance,
Fernando Monteiro Duarte
Hi!
Column names are case insensitive.
--
Regards,
__ ___ ___ __
/
Can anyone give me an example of an alter table syntax that.
1.) adds a column
2.) deletes a column.
I am reading the examples in the oreilly book, and it does not work
also the Oracle or Infomix syntax doesn't work.
can someone give me a clue please.
Thanks,
Matt.
Jeremy,
Late last year, you were creating the Table of Contents for a book about
MySQL...how's it coming? I know that many on this list were anxious to get
a sneak peak, and perhaps suggest additional topics, such as advantages and
conditions for using INNODB and BDB tables versus MYISAM. And
On Thu, Jan 10, 2002 at 09:14:51AM -0500, Ho, Kam wrote:
Can you specify the hardware/software your MySQL 3.23.41-max is
running on?
That machine is a dual-CPU Linux 2.4.9 box with 2GB of RAM and 4 36GB
ultra-wide SCSI drives for the data and replication logs.
Before the restart we did in
You can't login as plain old nobody.
The default mysql user is your unix user, so if you are
logged into unix as root , and entered mysql you were logged into
mysql as root.
You appear to have been logged in as mysql.
If the user mysql has full privileges, then there was nothing to
prevent the
However, you are running WIN2K, not unix as i assumed in my previous post.
There still must be some default user which apparently has full privileges.
Bryan Capitano wrote:
Having some problems setting root password on MySQL. Can anybody help
me?
I've just installed MySQL 3.23.38 on a Windows
Hi,
in Oracle I have a test database. there are 2 tables table1 and table2.
there is a field on both tables called account_number. on table 1 it is set
to auto increment.
I have set up a trigger so that when a number is generated in table1 it
copies the number to account_number on table 2.
But how about the fields, the content of a database ??
Fernando
- Original Message -
From: Sinisa Milivojevic [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, January 10, 2002 12:32 PM
Subject: Re: Disable case sensitivity
Fernando Monteiro
I agree.
I don't see any reason to let a non-subscriber post.
How would you expect he reads the answer?
It's kind of like letting strangers piss in your water supply.
Marjolein Katsma wrote:
Carl,
You'll be missed but I can't blame you.
I'm tired enough of getting this kind of pam in my
Why don't you give us an example of what does not work, so someone can
tell you why?
Matthew Darcy wrote:
Can anyone give me an example of an alter table syntax that.
1.) adds a column
2.) deletes a column.
I am reading the examples in the oreilly book, and it does not work
also the
-Original Message-
From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]]
Subject: Re: Disable case sensitivity
If is possible, in everything from a Database, but if
is not, in columns
is more important.
Column names are case insensitive.
Correct... Database names and Table
ALTER TABLE member
ADD member_id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMERY KEY;
ALTER TABEL president DROP suffix
Simon
Note:From MySQL by Paul DuBois
-Original Message-
From: Matthew Darcy [mailto:[EMAIL PROTECTED]]
Sent: 10 January 2002 14:26
To: [EMAIL PROTECTED]
Subject: alter
On 10 Jan 2002, at 10:32, Marjolein Katsma wrote:
The list is too valuable for me to leave - but it really SHOULD be
subscription only.
Of course it should be. Every other big list I'm on is subscriber-
only and doesn't have these spam problems, or the annoyance of the
filter (which I hope
On Thu, Jan 10, 2002 at 08:32:03AM -0600, Rick Emery wrote:
Jeremy,
Late last year, you were creating the Table of Contents for a book
about MySQL...how's it coming? I know that many on this list were
anxious to get a sneak peak, and perhaps suggest additional topics,
such as advantages
I had cleared down the user table, and had the correct entries, BUT I had
not cleared down the DB tables, as I thought grant would do this.
after clearing down the db table and then granting the privileges it worked.
Sorry for the mistake on my part all but I have a better understanding of
Matt,
alter table table_name add column column_name column_decriptions;
alter table table_name drop column column_name;
Try checking documentation for more details:
http://www.mysql.com/doc/A/L/ALTER_TABLE.html
Hope this helps!
Can anyone give me an example of an alter table syntax
On Thu, Jan 10, 2002 at 12:58:03PM -0200, Fernando Monteiro Duarte wrote:
But how about the fields, the content of a database ??
VARCHAR and CHAR fields are not case-sensitive unless you declare them
with the BINARY attribute.
Jeremy
--
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo -
The many simple questions you ask imply that you have not read the manual.
Triggers are not supported.
Matthew Darcy wrote:
Hi,
in Oracle I have a test database. there are 2 tables table1 and table2.
there is a field on both tables called account_number. on table 1 it is set
to auto
I have read through the manual, admitidly not page by page but as a
reference.
I was aware that triggers where not supported, that is why I asked can this
be done and how ?
I meant is there a way around this ?? if so what and how.
Thanks,
Matt.
-Original Message-
From: Gerald Clark
* Fernando Monteiro Duarte
But how about the fields, the content of a database ??
char and varchar are by default not case sensitive, but can be made case
sensitive using the BINARY operator...
URL: http://www.mysql.com/doc/C/a/Case_Sensitivity_Operators.html
--
Roger
Hi,
I read the documents, but still I confuse how to use
COMIT/ROLLBACK.
I have 3 tables, I want to INSERT a data into 1st. table then, if it
is OK, I want to UPDATE second table, and if it is OK,
then a data from 3. table will be
Gerald...
He isn't on a Unix box, he is on a Win2k box
-Original Message-
From: Gerald Clark [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 10, 2002 8:46 AM
To: Bryan Capitano
Cc: [EMAIL PROTECTED]
Subject: Re: setting root psswd on Win2K ??
You can't login as plain old nobody.
I have a database in Firebird(Interbase) that has 106 million records
at 37.4 gig.
I imported the database into mySQL and built the same indexes.
with a query like this:
select * from experian.experian where latitude = '038631928' and
latitude = '038638092' and longitude = '096671646'
I am not familiar with cron. Could you expound? Is it Unix or Windows
based? Where can I get it?
Thanks,
Ron
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 09, 2002 7:33 PM
To: Jeffrey Lomas; [EMAIL PROTECTED]
Subject: Re: scheduling tasks
At 16:22 10/01/2002, you wrote:
On Thu, Jan 10, 2002 at 12:58:03PM -0200, Fernando Monteiro Duarte wrote:
But how about the fields, the content of a database ??
VARCHAR and CHAR fields are not case-sensitive unless you declare them
with the BINARY attribute.
neither TEXT/LONGTEXT
--
On Mon, 7 Jan 2002, Arne Mueller wrote:
I wonder whether one can use the full text indexes in mysql to find out
what words in a document are likely to be relevant key words.
. . .
I'd be nice to have a command like this:
select keywords(10.0) from MyDocs where DocId = 666;
Jeremy,
Reading through the TOC, it sounds like a book I'd definitely buy!
At 15:58 2002-01-10, you wrote:
2. How to cover common problems in a way that folks can find them
without reading the whole book? Maybe this is just an indexing
issue. An item that Monty brought up is MySQL's
I am trying to upgrade from mysql server v. 3.22.32 up to v. 3.23.47 on my RedHat6.2
box.
When I try rpm -Uhv MySQL. , I get::
Preparing...##[100%]
file /usr/bin/mysqlbug from install of MySQL-3.23.47-1 conflicts with file from package
unix, - man crontab
wincron also exists, but you can use scheduled tasks in windows too
regards
At 17:19 10/01/2002, you wrote:
I am not familiar with cron. Could you expound? Is it Unix or Windows
based? Where can I get it?
Thanks,
Ron
-Original Message-
From: Paul DuBois
In the last episode (Jan 10), Mike Grover said:
select * from experian.experian where latitude = '038631928' and
latitude = '038638092' and longitude = '096671646' and longitude =
'096680757';
Interbase takes 10 seconds to return 70 records, but mySQL takes 18 seconds
to return the same
Hello,
I'm trying to determine the best way to setup a new mysql install. I have
about 100 clients and each client has the same 16 tables. In a years time
there will be about 3.6 million total rows spread out between the tables.
The tables will be updated nightly from a legacy system. All other
A good spam-blocking keyword is the word guarantee. Just block out
messages with that keyword and most of your spam issues will go away. I've
used that technique for a couple years now, and it's worked great. I've had
to add a couple other words to my filter to pick up on adult material as
well,
At 18:15 10/01/2002, you wrote:
I have to say I'm shocked that the list is completely open. That's such a
stupid newbie thing to do.
maybe they think their filter is OK :
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter
ALTER TABLE member
ADD member_id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMERY KEY;
ALTER TABEL president DROP suffix
Simon
Note:From MySQL by Paul DuBois
Those statments will surely cause errors, since you've not spelled TABLE
or PRIMARY correctly. Are these your actually working
Yes, thank you, everybody's comments have been helpful.
It seems, as Roel has noted, that the user where user='' and host='localhost'
has all kinds of
privileges. Which explains why when I log in as simply 'mysql' without
specifying a particular
user, than I have omnipotent powers.
delete from
Yeah, any lookups based on char based columns are slower
than integer queries any day. I'm assuming it's a char
column because you're searching with apostrophe's '0'.
Would a between statement in the where clause help?
select * from experian.experian
where latitude between '038631928'
On Thu, Jan 10, 2002 at 10:25:55AM -0600, Mike Grover wrote:
I have a database in Firebird(Interbase) that has 106 million
records at 37.4 gig.
I imported the database into mySQL and built the same indexes.
with a query like this:
select * from experian.experian where latitude =
works great too (these are regexp) :
subject:.*your account
subject:.*free.*vacation.*
subject:.*\$.*
subject:.*\%\ .*
subject:.*[a-z0-9]\+[\.|\ ]\{5,\}[a-z0-9]\+
subject:.*\ \-[a-z0-9]\+$
subject:.*\(.*\@.*\)
this one would have caught by subject:.*[a-z0-9]\+[\.|\ ]\{5,\}[a-z0-9]\+
regards
On 10 Jan 2002, at 18:48, Thibaut Allender wrote:
maybe they think their filter is OK :
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the following words in your message:
. . .
Isn't function MATCH what you want?
. . .
The problem is that I don't know the expression for the 'AGAINST' part.
Given a document I'd like to know what it is about without reading it.
. . .
So you want a list of _descriptors_ for each document. That is
_precoordination_ which is
* Matthew Darcy
I am stuck on why this is not working though
ALTER TABLE account_details ADD account_name TEXT(30) NOT NULL
TEXT is a special field type for larger text elements, up to 65535 bytes.
You can not set a max length on this field type. Use VARCHAR, or drop the
size restriction.
Comments inline below.
On Wednesday 09 January 2002 18:13, Paul DuBois wrote:
At 17:23 -0800 1/9/02, Kyle Hayes wrote:
[snipped replication explanation]
The program works by getting the contents of the update log and using
the Perl DBI do() function on each statement.
The problem that
Keith C. Ivey wrote:
On 10 Jan 2002, at 18:48, Thibaut Allender wrote:
maybe they think their filter is OK :
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the following words in
Hi
The indexes are updated when you insert data, you don't need to update it
manually. However, you may want to find out about the 'optimize' function
out of interest.
http://www.mysql.com/doc/O/P/OPTIMIZE_TABLE.html
Regards
Girish
- Original Message -
From: Chuck Lidderdale [EMAIL
* Stephen S Zappardo
a) 1 db with 16 tables b) 100 dbs each with 16 tables
* adam nelson
Certainly 1 db with 16 tables.
Why? Normally, bigger means slower...
--
Roger
-
Before posting, please check:
You can place your statements into a file, e.g. numuser.sql, and redirect
this into mysql client:
use mysql;
select count(User) from user;
F:\MySQL\binmysql -uroot numuser.sql
count(User)
4
-Original Message-
From: Rick Emery [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 09,
well said!!
generously indeed...
soft, fuzzy rtfmS are badly needed.
-Original Message-
From: Steve Rapaport [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 10, 2002 12:46 PM
Cc: [EMAIL PROTECTED]
Subject: Heads up re Spam.
Okay guys, let's not get our panties in a twist.
I've
Hi Again
I just did this to check what you did:
SKYROAD#mercury1:/mercury/home/quentin:mysql --user=mercury -p mysql
Enter password:
mysql grant all privileges on mysql.* to matt@%;
Query OK, 0 rows affected (0.05 sec)
mysql flush privileges;
Query OK, 0 rows affected (0.19 sec)
mysql quit
At 19:46 2002-01-10, Steve Rapaport wrote:
Okay guys, let's not get our panties in a twist.
I've just scanned through the last 1500 postings and
come up with about 7 spams. On the other hand there
have been at least 4 times that amount of messages
griping about spam, which you will acknowledge
I just found this unexpected result, those who know how
indexing works might understand it but I don't, and it's
funny:
I have a large phone listing with over 22 million records.
The phone number is a string (varchar 16).
There's an index for the first 8 chars of the phone number.
Now note
MySQL
The reason it is char(9) fields is because I wrote my own import app
(Delphi 6) that writes directly to my myd file.
I can import 106 million records from a Fixed Field with text file
in 45 Minutes.
Then I ran myisamcheck -r -q experian to regenerate the indexes.
mike...
I have MYSQL installed on a hpux 11.0 unix system
I installed the binary and everything started up correctly
using /opt/mysql/bin/safe_mysqld
but when I try to connect as an user
/opt/mysql/bin/mysql -u root -pchrist1
It will not work .
Even if I do the following command I get an error
* adam nelson
Management seems like the biggest reason for me. Just from a time spent
point of view, I would go with 16 tables instead of 1600. Not only
that, I wonder if there would be a big memory hit from having all those
objects open at once. Just seems to me that mysql was designed
mail seemed to come through out of sink in a strange order.
I take it you got the message about grant not altering the db table.
Thanks for the help. I leant a lot.
Matt.
-Original Message-
From: Quentin Bennett [mailto:[EMAIL PROTECTED]]
Sent: 10 January 2002 19:32
To: '[EMAIL
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `' and `').
SEND-PR:
From: [EMAIL PROTECTED]
Description:
# scripts/mysql_install_db
Preparing db table
Preparing host table
Preparing user table
Does anyone use php.dig as a search engine with mysql? If so have you found
any bugs or security issues?
Thanks,
Richard
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Guys,
I am new to MySQL. How do I list the running
processes?? Help!!
=
The only person in the world who is enviable is one who does not envy others
__
Satish Santhakumar
378 Springboro Lane
Columbus OH-43235
Phone:614 880 0451
show processlist;
-Original Message-
From: Satish Santhakumar [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 10, 2002 3:46 PM
To: [EMAIL PROTECTED]
Subject: Process List
Guys,
I am new to MySQL. How do I list the running
processes?? Help!!
=
The only person in the world who
If this is a derivative of HTdig, we used it at a previous job, with
reasonable results, as long as the data set isn't too big.
james montebello
On Thu, 10 Jan 2002, Richard McNeil wrote:
Does anyone use php.dig as a search engine with mysql? If so have you found
any bugs or security
database,sql,query,table
I noticed that one of my servers had the wrong time set. It's a debian box
using 3.23.37. I changed the system time successfully, but the NOW()
function is still showing the old time. Looking through the docs, I found
the
SET TIMESTAMP= function and it said that I
Hi Everbody,
I'd like to know how people are forming text searches with MySQL. I'd
like to be able to support a query something like:
(login AND root) OR (invalid login AND tty*)
a code snippet that could turn a query like this into a MySQL Regular
expression or other query of some kind would
Is there a clean way to administrate mysqld without a password by
root?
I'm looking for ways to make it flush logs, reload my.cnf and shut
down cleanly, in an automated way - i.e, no password, but by root.
(similar to pg_ctl for postgresql or `kill -HUP` for reloading)
(e.g. shut down the
Is there a tool - a php script would be prefered -
to compare a local and a remote database for synchronisation?
Our aim is to have to identical databases all the time!
--
Jochen
-
Before posting, please check:
Hello,
I'm trying to change the path variables of an already installed mysql
server. Namely, I want to change:
pid_file
language
innodb_log_group_home_dir
datadir
basedir
I viewed these, using the
mysqladmin variables
command.
I'm using 4.0, and I'd like to know the easiest way to change
You dont have the FILE privileges.
http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Adm
inistration.html#GRANT
Thanks,
Sherwin Ang
Web Programmer / Systems Administrator
Alchemy Solutions
http://www.alchemy.com.ph
Creative. Technology.
Tridel Technologies, Inc.
7th
I have been testing Redhat 7.2 Linux for about 3 month's. I few notes
regarding the installation which might be helpful for MySQL Admins.
- Maximum Table Size: Limited online by disk space. (I have tested
tables upto 50 gigs)
- Maximum Records Per Table: Limited only by available disk
All right How do you set ext3 to minimum journaling??
-Original Message-
From: Benjamin Arai [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 10, 2002 9:22 PM
To: [EMAIL PROTECTED]
Subject: Redhat 7.2 Linux Maximum Database/Table Size
I have been testing Redhat 7.2 Linux
Hi,
Since the equality test is for a number, the phone_no field of every row of
the table
is converted into a number first and tested for the equality. This makes it
impossible
to use the character index and so forces the full table scan.
If it were using the index then, I think, it cannot
Hi Alex,
I don't think your problem will solved by making the time columns to full
datetime columns as there is no
functions to subtract two datetime values directly.
But you can can keep the time columns and go on like this:
convert the time into seconds using time_to_sec function.
subtract
Hi,
As we know that MySql support maximum of 4 GB data per table.
Now the question arise that what is the maximum limit of Database in MySQL.
Manish Mehta
E-mail: [EMAIL PROTECTED]
-
Before posting, please check:
On Thu, Jan 10, 2002 at 07:22:10PM -0800, Benjamin Arai wrote:
I have been testing Redhat 7.2 Linux for about 3 month's. I few notes
regarding the installation which might be helpful for MySQL Admins.
- Maximum Table Size: Limited online by disk space. (I have tested
tables upto 50 gigs)
I am having a problem with MySQL that I believe is related to SMP. I
have a machine that is an exact copy of another machine, only difference
is that this one is Dual processor, and the other one is single. The
single one has had no problems for the last 6 months the dual dies every
2 days
Hi,
As we know that MySql support maximum of 4 GB data per table.
Now the question arise that what is the maximum limit of Database in MySQL.
Manish Mehta
E-mail: [EMAIL PROTECTED]
-
Before posting, please check:
On Fri, Jan 11, 2002 at 01:11:11AM -0500, [EMAIL PROTECTED] wrote:
I am having a problem with MySQL that I believe is related to SMP. I
have a machine that is an exact copy of another machine, only
difference is that this one is Dual processor, and the other one is
single. The single one has
On Fri, Jan 11, 2002 at 11:42:59AM +0530, Manish Mehta wrote:
Hi,
As we know that MySql support maximum of 4 GB data per table.
Actually, you can go far larger than 4GB.
--
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454
Hi
Are there any JAVA based Forum sites which are using
MySQL as the backend.
I am new to MySQL and I am using JAVA.
I want to know whether there are any sites which
provide discussion forum,articles and tutorials on
Java + MySQL..Just like weberdev.com,which provides
discussion forums on
[EMAIL PROTECTED] wrote:
I am having a problem with MySQL that I believe is related to SMP. I
have a machine that is an exact copy of another machine, only
difference is that this one is Dual processor, and the other one is
single. The single one has had no problems for the last 6 months
Steve,
what did explain tell you in either case?
Regards, Frank.
Steve Rapaport wrote:
I just found this unexpected result, those who know how
indexing works might understand it but I don't, and it's
funny:
I have a large phone listing with over 22 million records.
The phone number is
1 - 100 of 101 matches
Mail list logo