Benjamin,
can you also grow MyISAM tables to such sizes?
Regards,
Frank.
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 d
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 numb
I am using the RPM's from ftp.mysql.com. I thought it was hardware as
well until I created a 2nd machind (the 2nd server that was had 2 CPUs)
and both of them had the same results. But I know its not a query thats
hanging it, because as I ordered the 2nd server I had a server with 1
CPU doing
[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 mont
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 PHP+MySQ
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
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
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:
http://
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 Thi
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 g
In the last episode (Jan 11), Manish Mehta said:
> As we know that MySql support maximum of 4 GB data per table.
Actually, http://www.mysql.com/doc/T/a/Table_size.html says that only
Mysql 3.22 had a 4gb table size. With 3.23, the real limit is how big
a file your OS can handle.
--
Dan
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:
http:/
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 f
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 find
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
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 space.
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 Flo
Where I work, we're at the point of needing to maintain two database
servers, one inhouse, and the other at another physical location. We
need to replicate between the servers, to keep them both up to date, as
both will be getting updated. This leaves us with the problem of
resolving primary key c
I am trying to load some new data into my database and I keep getting
this error:
ERROR 1045: Access denied for user: 'lreiter@localhost' (Using password: YES)
The files I am loading are located in another directory on the server
and I used the absolute path to point to them, but I still get an
Problem with using a regular expression (or even a simple wildcard search)
is that they are very slow. I have looked for a better solution to search
through a mysql database but didn't find anything that worked great with
mysql. If speed is important then you are pretty much out of luck without
up
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 eac
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:
http://www.m
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 serv
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 woul
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 s
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 issu
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 i
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
___
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)
http://lists.mysql.c
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
Prepa
* Steve Rapaport
> 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
Thanks for the info on 2.4, everyone. I've been doing my testing on 2.4.17.
Here are the "official" results of my testing here (I had the 2.4 time in my
previous email messed up):
MyISAM: 2.2 -- 11 minutes; 2.4 -- 6 minutes
InnoDB: 2.2 -- 21 minutes; 2.4 -- 9 minutes
Pretty good increase in per
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 PROTEC
* 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
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
/opt/my
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 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 the
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 acknowl
On Wed, 9 Jan 2002, Rick Emery wrote:
> First, you are describing a "one-to-many" relationship, bceasue one "file"
> record can be referenced by many "people" records. If this is the case, you
> may wish to re-design your tablse such that a "people record" contains a
> "file_id" field. You can
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> qu
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
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\bin>mysql -uroot < numuser.sql
count(User)
4
-Original Message-
From: Rick Emery [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 09, 2
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 for big
tables, 1600
direct responses please.
Hi.. I'm having some problems using mysql on a linux/debian box
when I start mysql I can connect to it via sockets using
> mysql -h localhost -u xxx -p
but if I try to connect via TCP/IP using
> mysql -h mymachine -u xxx -p
all I get is 'ERROR 2003: Can't connect to
* 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:
http://www.mysql
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" <[EMA
"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
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 is
just as off-topic.
If you raise the nois
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
* 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.
Maybe the "list mom/dad" doesn't care where you go.
Maybe MySQL provides this list for free and doesn't
care what you think. If you don't like it, get off
the boat. A free list, which puts people in direct
contact with the developers, is a plus to me. So
what if I get a spam mail from it every now
Here's a solution:
Send mail to <[EMAIL PROTECTED]>
Doing this will generate an auto-reply. When you get it, hit "reply"
and "send"
in your mail client.
That way you won't get any more spam.
Erik
On Thursday, January 10, 2002, at 12:15 PM, Patrick Crowley wrote:
> I have to say I'm shock
> > > . . .
> > 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_
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 10, 2002 12:20 PM
To: Mike Grover
Subject: Re: RE: RE: mySQL vs Interbase
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To by
Did the create table several months ago.
Did a create index idx_abc on tableA..
Have added lots of data - lots of data .
Back when I worked with Informix I would run "update statistics for
tableA "
which would recreate the index - et-al.
Now I'm using Mysql - do I need to do anythin
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:
>
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 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
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
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 us
> 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 workin
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
Certainly 1 db with 16 tables. Since it will be read only and then
write only, I would also use MyISAM instead of InnoDB, although I could
be wrong, anyone else?
-Original Message-
From: Stephen S Zappardo [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 10, 2002 12:13 PM
To: [EMAIL P
I figured out the problem in the book, I have no idea why my mail has not
come through.
I am stuck on why this is not working though
ALTER TABLE account_details ADD account_name TEXT(30) NOT NULL
-Original Message-
From: Gerald Clark [mailto:[EMAIL PROTECTED]]
Sent: 10 January 2002 14:
I've been working with a timesheet database, where all the employees of my
small business enter in the hours they work on projects. I've been storing,
for each record, a date of work, a start time, and a finish time.
When I attempted to write a Perl script to display invoices, though, I ran
i
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,
I have to say I'm shocked that the list is completely open. That's such a
stupid newbie thing to do.
Maybe we should initiate a spam strike until the list mom/dad listens. Just
subscribe the list to *another* list, and watch the fun begin...
best,
patrick crowley
mokolabs>>
making sure the futu
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 i
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 t
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 Du
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
MySQL-client-3
Thank you for your response and the info.
Actually I was using 4.0.1 which I downloaded a couple of days ago:
[beckymcelroy@indigo bhm]$ rpm -qa | grep SQL
MySQL-Max-4.0.1-2
MySQL-client-4.0.1-2
MySQL-4.0.1-2
[beckymcelroy@indigo bhm]$
Here's what I did:
mysql>
mysql> select * from cnam1;
+---
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
>
> 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
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
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 w
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
if there is no triggers or stored procedures as the manual states is there
such a thing as entry relasionships, and entry relationship editor ?
Is one of these planned ?
Matt.
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: 10 January 2002 15:18
To: Matthew Dar
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.
The
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 b
* 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...
http://www.mysql.com/doc/C/a/Case_Sensitivity_Operators.html >
--
Roger
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 [
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
> -Ursprüngliche Nachricht-
> Von: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]]
> Gesendet: Donnerstag, 10. Januar 2002 15:29
> An: Dennis Jacobfeuerborn
> Cc: [EMAIL PROTECTED]
> Betreff: Re: AW: Stability problems on 4-way server
>
>
> Dennis Jacobfeuerborn writes:
> >
> >
> > I t
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 Yaho
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 th
On Thu, Jan 10, 2002 at 02:48:26PM -, Matthew Darcy wrote:
>
> 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
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
whats
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 advanta
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
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
> -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
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
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
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 Montei
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.
C
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 Wind
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
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
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 ho
1 - 100 of 130 matches
Mail list logo
