> TT> Is it possible to add new 8-bit character encoding to compiled
> TT> mysql (version 3.23.49-win) without recompiling?
>
> No, you should re-configure and re-compile after adding new character
> set. You can read instruction how to add new character set at:
> http://www.mysql.com/doc/A/d
On Saturday, April 06, 2002 at 5:32 PM,
Aravind NagaVenkata Gorthy asked:
> Could any one tell me what all the chages I have to make in order
> to make my existing (english version) of MySQL database compatable
> to the Japanese language.
It's a little hard to read your mind. Have you read sectio
Hi,
I've got 2 tables in mysql, table 1 which contains records with fields like
+ADSM
in table 2, I got records like:
+ADSM anr2343E
+ADSM anr4523E
+ADSM anr7823E
now, i'd like to change each record in table1 where a field contains a +ADSM
entry, lookup the co
Hello all,
I have setup a replication between two MySQL v4.01a servers on FreeBSD,
which works really fine. The only problem is that since we have MANY
updates on the master database, the bin-logs grow very fast. We need to
do a manual clean-up at least once every other day, otherwise the disk
Hi everyone,
I've been reading up about InnoDB tables and they seem to have lots of
advantages. I'm particularly interested in using the foreign keys as this
will save me some much need time. In the benchmark tests on the InnoDB
website they show up faster than MyISAM tables but will foreign keys
Taavi Tiirik asked:
> Thanks. Let me put it this way then... There are character set
configuration
> files in mysql/share/charsets directory of binary distribution of mysql.
If
> these
> files cannot be used for defining new character sets then what is their
> purpose?
These files are used for c
Hi,
i'd like to alter a table which have a date and time field so 3 Bytes for
date and 3 Bytes for time.
I'd table to add a new field to store date like this : MMDDHHMMSS.
In fact, I can't use indexes on sql query like select with order by with 2
fields date + time and with
one unique field
Dave Newton wrote:
>On Wednesday 03 April 2002 03:50 am, Chuck Amadi wrote:
>
>>Sorry if sounds pathetic nevetheless i have downloaded the (mysql)
>>mm.mysql-2.0.4-bin.jar file .
>>I was able to get the PostgrSql to function correctly by installing
>>dbtags taglibrary and followed the configura
Hi,
I am writing a maintenance-deamon which is executing
CHECK TABLE, ANALYZE TABLE and OPTIMIZE TABLE once at
night.
If CHECK TABLE fails for at least one table, then the
rest will be skipped.
The question is if the order of the statements is ok
this way. A second question would be, if I should
Everyone,
Im trying to INSERT the SUM of the two data from table TEMP_IN and TEMP_OUT
TEMP_IN data
select * from temp_in limit 15
--
+--+
| cal |
+--+
| 00014.45 |
| 00013.95 |
| 00015.95 |
| 00016.78 |
| 00018.92 |
| 00015.7
Would you not be better of just runing myisamchk from crontab?
Simon
./myisamchk Ver 1.52 for unknown-freebsdelf4.1 at i386
By Monty, for your professional use
This software comes with NO WARRANTY: see the PUBLIC for details.
Description, check and repair of ISAM tables.
Used without options
I don't know what this (below) is, but gee, it seems good :-)
Best wishes
--
Pierre du Parté
Final Filer Software
349 Worrigee Road
Worrigee, NSW, Australia 2540
http://www.finalfiler.com
Phone 61 2 44216374
Mobile 0413 483 066
"If it feels good, do it!"
J Williamson wrote:
> Would you n
hye all ,
What is the SQL syntax for inserting records in child table ( i am
using foreign keys and
innodb table types ) .
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http:/
> Yes you are right
> We lock tables to run this but only when we have problems.
> One more thing I would do is run 'show processlist' and mail it to my self
> to see how thing are going.
> Simon
> PS have you tried mytop?
No, I did not try mytop, but I'll give it a try now :)
Another quest
MM.MySQL-2.0.12, a JDBC driver for MySQL was released yesterday. It can be
found at http://sourceforge.net/mmmysql/
Changes include:
- General code cleanup.
- Added getIdleFor() method to Connection and
MysqlLogicalHandle.
- Relaxed synchronization in all classes, shoul
Luke,
How exactly will the foreign keys save you time? Please explain.
Ric.
- Original Message -
From: "Luke van Blerk" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, April 09, 2002 9:17 AM
Subject: InnoDB tables
> Hi everyone,
>
> I've been reading up about InnoDB tab
David,
I could be wrong but since bigint isn't a date or time oriented data
type I imagine this would be completely useless to you unless you are
storing unix timestamps. You also have the option of using datetime data
types. I'm not quite sure what you are asking nor what difference it makes
Hey guys,
Still having this trouble with mysql.. Running the mysql_install_db renders
this...
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables
At this point the script locks
Hi Richard
I'm writing a web application in PHP with a MySQL backend. I'm a novice at
both PHP and MySQL having started with both about November last year and I'm
also new to programming at large so please excuse any question which may
seem obvious.
The foreign keys are to be used to enforce ref
Hi,
I use all this in the same order and i don't have any problems:
CHECK TABLE
IF (CHECK TABLE!=OK)
{
REPAIR TABLE
}
// i don't use analyze tables
OPTIMIZE TABLE
Before to perform this commands, you must be sure is not any users connected
(show full processlist;)
Sent: Tuesday, April 09, 2002 2:14 PM
Subject: Re: TIMESTAMP(14) or Bigint ??
> David,
> I could be wrong but since bigint isn't a date or time oriented data
> type I imagine this would be completely useless to you unless you are
> storing unix timestamps.
In fact i'm looking to a way to st
Sent: Tuesday, April 09, 2002 2:14 PM
Subject: Re: TIMESTAMP(14) or Bigint ??
> David,
> I could be wrong but since bigint isn't a date or time oriented data
> type I imagine this would be completely useless to you unless you are
> storing unix timestamps.
In fact i'm looking to a way to st
VR> Ryan,
VR> Thursday, March 28, 2002, 7:22:47 AM, you wrote:
RC>> I'm working on a MySQL permissions problem, and would welcome some
RC>> suggestions and/or comments, or to be pointed in the right direction. The
RC>> goals I have are:
RC>> b) Eliminate anony browsing of db's.. and ideally el
Kannan,
Tuesday, April 09, 2002, 7:54:07 AM, you wrote:
K> You need to create a user mysql and also create a group mysql and add the user
K> to the group..You will find this in the installation docs..
Using commands of your OS ...
It is described in the MySQL manual in the section 2.2.7 Install
Kathy,
Monday, April 08, 2002, 10:10:04 PM, you wrote:
KR> Can anyone tell me how can I uninstall mysql. I have done it again. I have
KR> messed up my permission.
KR> I dont know what is is that i'm doing that makes me loose my previleges.
KR> I keep getting the access denied error
Before un
LeTortorec,
Tuesday, April 09, 2002, 12:17:06 AM, you wrote:
Leoen> I have a table with the following fields:
Leoen> id=autoincrement, int (11)
Leoen> ts_h=decimal
Leoen> ts_pid=int (11)
Leoen> ts_day=text
Leoen> There is a unique record where ts_pid=60 and ts_day="20020328000
Chris,
Tuesday, April 09, 2002, 3:22:00 PM, you wrote:
CL> Still having this trouble with mysql.. Running the mysql_install_db renders
CL> this...
CL> Preparing db table
CL> Preparing host table
CL> Preparing user table
CL> Preparing func table
CL> Preparing tables_priv table
CL> Preparing colu
Barry,
Monday, April 08, 2002, 8:33:02 PM, you wrote:
BB> I have a system here based on Red Hat's 7.2 distribution and I am wanting to
BB> get MySQL up and running. After browsing your web page it seems that I will
BB> have go to a different version of gcc. Would I be safe to go to the latest
B
GOLDEN,
Monday, April 08, 2002, 11:09:36 PM, you wrote:
GS> Would you help me, how to install, setup, and configure MySQL in my server
GS> with O/S windows 2000 server and IIS v. 5
Installation on Windows is covered in the manual, please check
following links:
http://www.mysql.com/doc
Heiki,
I have a question concerning the new auto-extending function (which sounds
really cool by the way!). How does it handle the case where it runs out of
disk space while expanding? Will it gracefully handle this scenerio or will
some sort of recovery be necessary?
Carl McNamee
Systems Admi
>From my limited experience. I believe your gonna have to split that one
field of alpha and numeric into two fields one for the alpha info and one
for the numeric info. Then you can sort the information the way you want.
Mike
- Original Message -
From: "Luc Foisy" <[EMAIL PROTECTED]>
To:
Hello everyone
I want to alter 50 tables, and for each the names start with the string
'mak'
Is there an SQL query, so that I can do the change in one command.
I have tried using wildcards - they don't seem to work in SQL.
Thanks in advance.
Aman
_
Is there a way to store files in MySQL? Looking to store somthing like a
zip file in the databaseand be able to retrieve/download it from something like ASP.
Thanks
-Nick
-
Before posting, please check:
http://www.mysq
Hello everyone
I want to alter 50 tables, and for each the names start with the string
'mak'
Is there an SQL query, so that I can do the change in one command.
I have tried using wildcards - they don't seem to work in SQL.
Thanks in advance.
Aman
__
I am using Linux 7.2 OS.
I think reseting the root password fixed it. Because I was no able to log
in.
I'm not really running any queries to the mysql database that why i'm not
sure whats causing this problem.
I also cant figure out why when I type mysql it doesnt doesnt use the
password and I alw
Wild cards do work, but you have to make sure you use the right type. SQL
uses % and I believe _ as
wild cards. I know if you wish to use them in SELECT statements it would
look like: SELECT *
FROM pet WHERE name LIKE "b%" this would return anything from pet where
the name starts with ab.
Go look
>Description:
The mysql-test-run script uses 'time -p' to time the test scripts on
line 782 of the script. The -p option on this version of Tru64 is
broken though and causes the test script(s) to fail. Since -p is the
the default option for time on this version of
On Monday 08 April 2002 10:09 pm, Daniel Jarrett wrote:
> i'm building a table in MYSQL that has about 30 fields..
>
> is this inefficient to have a large number of columns?
Not necessarily, no. Often, it is more efficient.
> if anyone can direct me to some good info on efficient design tips
Hi,
I been using mysqlimport for a long time with no problems.
But today when I try (as root)
mysqlimport admin /usr/local/systems/admin/data/person.txt -p
I get
mysqlimport: Error: Can't get stat of
'/usr/local/systems/admin/data/person.txt' (Errcode: 13), when using
table:
person
even thou
I am playing around with portable sql queries (mysql, oracle and
postgres). When executing:
ipplan=> BEGIN;
BEGIN
ipplan=> INSERT INTO area (areaaddr, descrip, customer) VALUES
(16777216, 'kjshdf', 1) ;
ERROR: Cannot insert a duplicate key into unique index
area_areaaddr_key
ipplan=> SELECT cust
The server does not shutdown. It just stops responding.
Best Regards
Tommy Jensen
http://www.sc-resources.net
- Original Message -
From: "Miguel Angel Solorzano" <[EMAIL PROTECTED]>
To: "ServiceCenter resources" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, April 09, 2002 7:
Hi all,
I am pretty new to mySQL actually I started yesterday.
mySQL with innoDB handles integrity constraints.
I tried :
create table a (
id varchar(3) not null,
primary key(id) )
TYPE=INNODB;
insert into a values ('aaa');
create table b (
id varchar(3) not null,
a_id varchar(3),
i
The "insert into b values ('BBB', NULL)" statement should fail under the conditions
you describe, BBB was not inserted into the A table, and therefore the foreign key
constraint fails as it should.
Rance Hall
308.238.2455
Internal Office Extensions: 2455 or 6655
PC Programmer, The Buckle, Inc.
On 4/8/2002 7:25 PM, "Paul DuBois" <[EMAIL PROTECTED]> wrote:
> At 17:52 -0700 4/8/02, Jim Dickenson wrote:
>> I am having problems getting the "load data local infile" working.
>>
>> I am running Mac OS X 10.1.3 build 5Q110 with all available updates
>> installed.
>>
>> I had installed version
Nope
insert into b values ('BBB',null);
here:
BBB is PK of table b
null is FK of table b referencing table a
for example
insert into b values ('BBB','aaa');
works well
Alain
- Original Message -
From: "Rance Hall" <[EMAIL PROTECTED]>
To: "Alain Del Giust" <[EMAIL PROTECTED]>; <[E
At 9:31 -0700 4/9/02, Jim Dickenson wrote:
>On 4/8/2002 7:25 PM, "Paul DuBois" <[EMAIL PROTECTED]> wrote:
>
>> At 17:52 -0700 4/8/02, Jim Dickenson wrote:
>>> I am having problems getting the "load data local infile" working.
>>>
>>> I am running Mac OS X 10.1.3 build 5Q110 with all available u
well, your right about one thing, I did misread the order of your SQL statement, but
if you have a foreign key constraint, that field must be one of the values of the
referenced column, and that column, being an index, is never NULL
so inserting NULL into a properly configured foreign key colum
... but the key NULL does not exist on the table a, but it should!!!
Adib.
Alain Del Giust wrote:
> Nope
>
> insert into b values ('BBB',null);
> here:
>BBB is PK of table b
>null is FK of table b referencing table a
>
> for example
> insert into b values ('BBB','aaa');
> works well
>
"if you have a foreign key constraint, that field must be one of the values
of the referenced column and that column, being an index, is never NULL"
OK so my understanding is that it is impossible with mySQL to do such things
wich are basic with at least:
Oracle
Sybase Adaptive Server Enterprise
On Tuesday 09 April 2002 11:07 am, Alain Del Giust wrote:
> "if you have a foreign key constraint, that field must be one of the values
> of the referenced column and that column, being an index, is never NULL"
>
> OK so my understanding is that it is impossible with mySQL to do such
> things wich
On 4/9/2002 9:41 AM, "Paul DuBois" <[EMAIL PROTECTED]> wrote:
> At 9:31 -0700 4/9/02, Jim Dickenson wrote:
>> On 4/8/2002 7:25 PM, "Paul DuBois" <[EMAIL PROTECTED]> wrote:
>>
>>> At 17:52 -0700 4/8/02, Jim Dickenson wrote:
I am having problems getting the "load data local infile" working.
At 10:14 -0700 4/9/02, Jim Dickenson wrote:
> >> This still leaves the question as to when version 3.23.49a will
>be compiled
>>> for Mac OS X, instead of version 3.23.47.
>>
>> I always compile my own. Is there some reason you don't do that?
>
>
>There are many messages on this list that say
Well, I know I'm gonna catch flak for this, but oh well, here goes anyway
I send an off list mail to Alain to ask for some more specific information about what
he is trying to do so that we can find a way to do it.
But this I will say to the whole list...
What is the point of setting up a refe
I am just testing mySQL so I will be able to use it instead of Oracle Sybase
...
I am not saying a PK can be NULL wich is impossible
But a FK can be NULL and I'd like to know how to do that with mySQL
A concrete example could be:
table employee
column 1 : employee_id - primary key
column 2 : e
On Tuesday 09 April 2002 11:47 am, Alain Del Giust wrote:
> I am just testing mySQL so I will be able to use it instead of Oracle
> Sybase ...
>
> I am not saying a PK can be NULL wich is impossible
> But a FK can be NULL and I'd like to know how to do that with mySQL
I do not see this as being a
Carl,
when it runs out of disk space the auto-extend feature prints to the MySQL
error log a complaint that disk space has run out, and stops extending the
file.
If you do not give it more free disk space, InnoDB behaves as if it would
have a fixed size data file. That is, you will get the 'Tabl
I have a redhat 7.1 server, I want to get rid of the installed mysql
server. How can check which version is installed and how to get rid of it?
Thanks
Jianping Zhu
Department of Computer Science
Univerity of Georgia
Athens, GA 30602
Tel 706 5423900
---
Hi,
Try with SELECT VEERSION() from mysql client.
- Original Message -
From: Jianping Zhu <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, April 09, 2002 9:55 AM
Subject: How to check which version of mysql is installed
>
> I have a
> -Original Message-
> From: Alain Del Giust [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 09, 2002 12:48 PM
> To: Christopher Thompson; [EMAIL PROTECTED]
> Cc: Rance Hall
> Subject: Re: mySQL and innoDB
>
>
> I am just testing mySQL so I will be able to use it instead
> of Oracle S
FOREIGN KEYs by themselves make it faster and easier to validate that your
code is correctly maintaining referrential integrity.
They also let O/R mappers do more of the work in generating code for
accessing your data (Blatant Plug: http://freshmeat.net/projects/easyorm/ --
EasyORM is an O/R mapp
Hi!
>From the changelog of 3.23.50:
* We suppress the FOREIGN KEY check if any of the column values in the
foreign key or referenced key to be checked is the SQL NULL. This is
compatible with Oracle, for example.
It is conceptually a bit strange that we first declare a FOREIGN KEY
constraint, b
hi,
i'd like to know which ODBC driver is most suitable, fast and reliable for
win98.
I tried myodbc 2.50.39, but the dll was faulty, i had to replace it by the
2.50.36(on win2k!).
On win98 now am using the latest 3.51.01, but it has slown down the machine
so much, it's incredible.
So now am using
References: <[EMAIL PROTECTED]>
From: Scott Gifford <[EMAIL PROTECTED]>
Date: 09 Apr 2002 15:40:38 -0400
In-Reply-To: [EMAIL PROTECTED]'s message of "Tue, 9 Apr 2002 21:28:35 +0200"
Message-ID: <[EMAIL PROTECTED]>
Lines: 33
User-Agent: Gnus/5.0807 (Gnus v5.8.7) Emacs/20.7
MIME-Version: 1.0
Content
hi,
if i try to download the latest odbc driver i get a file with 43k. what
is wrong ? the original file on
http://www.mysql.com/downloads/api-myodbc-3.51.html is over 602K...
what have i to do?
-
Before posting, please check
Sorry, this came out ugly. I misinterpreted the list filter's
comments, and thought it would post my original message if I replied
to it, but instead it posted my reply including its warning.
Here's my original question, which is indeed about MySQL, although it
does not contain the words "SQL" o
Kathy,
Tuesday, April 09, 2002, 5:43:23 PM, you wrote:
KR> I am using Linux 7.2 OS.
KR> I think reseting the root password fixed it. Because I was no able to log
KR> in.
Ok, try to reset root password according to step-by-step instruction
in the manual. Don't forget execute FLUSH PRIVILEGES _bef
Hi,
Can I use the MD5 function in the where clause, as in:
Select * from table where md5(column)=value
spam filter: mysql
Andrew Hazen
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
On Tuesday 09 April 2002 2:13 pm, Andrew Hazen wrote:
> Hi,
> Can I use the MD5 function in the where clause, as in:
>
> Select * from table where md5(column)=value
>
I see no reason why not but note that you are likely MUCH better off storing
column as an MD5 hash, computing the MD5 of val
Hi !!
> -Original Message-
> From: Ralph Walther [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 09, 2002 12:43 PM
> To: [EMAIL PROTECTED]
> Subject: download latest odbc-driver
>
>
> hi,
> if i try to download the latest odbc driver i get a file with 43k. what
> is wrong ? the origin
Hi !!!
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 09, 2002 12:40 PM
> To: [EMAIL PROTECTED]
> Subject: MyODBC on win98
>
>
> hi,
> i'd like to know which ODBC driver is most suitable, fast and reliable for
> win98.
> I tried myodbc 2.5
When compiling Mysql on a Dec 3000 OSF1 V4.0 I get the following error:
...
net_serv.cc:421" macro ' thr_alarm' used with to many {3} args
Make[3]: [net_serv.o] Error 1
I've used this to configure, but changes the O3 to O like other
documentation has said to do:
env CC="cc -pthread" C
Hello,
I wondered if there is a way to create a mysql
database using Visual C++ 6.0. I don't want the
database to be registered, I want the program to
create the database for me.
Thanks a lot for your help.
__
Do You Yahoo!?
Yahoo! Tax Center - on
On Tuesday 09 April 2002 2:30 pm, Guy-Maurice Lepoutre wrote:
> Hello,
>
> I wondered if there is a way to create a mysql
> database using Visual C++ 6.0. I don't want the
> database to be registered, I want the program to
> create the database for me.
Certainly. If by no other way, execute a ba
You can, using the c++ api
-Original Message-
From: Guy-Maurice Lepoutre [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 4:30 PM
To: [EMAIL PROTECTED]
Subject: Creating a mysql database usinc VC++
Hello,
I wondered if there is a way to create a mysql
database using Visual C++
Hi !!
> -Original Message-
> From: Christopher Thompson [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 09, 2002 1:39 PM
> To: Guy-Maurice Lepoutre; [EMAIL PROTECTED]
> Subject: Re: Creating a mysql database usinc VC++
>
>
> On Tuesday 09 April 2002 2:30 pm, Guy-Maurice Lepoutre wrote:
Argh. my email got prematurely sent, sorry.
mySQL C++ API is available at
http://www.mysql.com/downloads/api-mysql++.html (along with a quick
tutorial)
Mike
-Original Message-
From: Mike Grabski [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 5:00 PM
To: 'Guy-Maurice Lepoutre'
After executing a query such as:
SELECT * FROM content ORDER BY id
I there a SQL query for skipping ahead a certain number of records?
Or should this be done as part of the initial query? If so, how?
thanks,
lance turner
-
B
Yes there is.. You can use LIMIT keyword to do so. For example to get the
records between 3 and 5, you could issue the statement:
SELECT * FROM content ORDER BY id LIMIT 2, 3;
See: http://www.mysql.com/doc/S/E/SELECT.html
Gurhan
-Original Message-
From: lance turner [mailto:[EMAIL PROT
I have one query, that basically reads from one table of 13 million rows,
groups it by two fields, and inserts into a rollup table. The result set
ends up being about 31,000 rows. This runs in about 2 minutes which is
acceptable. However, I add an additional group by field, which will probably
Heya:
in openBSD I have a cli interface for simple i/o to mysql database.
Written in C.
it works perfectly.
On Darwin and OS X it won't compile.
It gives the following errors.
$ cc -lmysqlclient -I/usr/local/mysql/include testmy.c linklist.c
/usr/bin/ld: Undefined symbols:
_mysql_close
_mysql_e
On Tue, Apr 09, 2002 at 10:15:12AM +0200, paul wrote:
> Hello all,
>
> I have setup a replication between two MySQL v4.01a servers on
> FreeBSD, which works really fine. The only problem is that since we
> have MANY updates on the master database, the bin-logs grow very
> fast. We need to do a ma
On Mon, Apr 08, 2002 at 08:25:01AM -0700, MySQL Newsgroup wrote:
> 1. Use PostgreSQL.
Why?
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
MySQL 3.23.47-max: up 61 days, processed 1,654,104,995
On Mon, Apr 08, 2002 at 01:32:59PM +0200, ddd wrote:
> HI,
>
> I want to insert into db 200.000.000 records of type (int6,int6)..
>
> the structure is:
> CREATE TABLE word_page (
>IDword mediumint(6) NOT NULL default '0',
>IDpage mediumint(6) NOT NULL default '0',
>KEY IDword (ID
Hi.
Is there a chance that you make this behaviour dependend on the --ansi
switch? I never used foreign keys until now, but from the theory I
would expect that a missing "not null" declaration on a FK declaration
should either be implicitly assumed or result in an error - at least
on insert.
I m
Hi.
For what I know, MySQL always reads a whole row if it has to read the
row at all. So, no, column order should not matter at all.
With MyISAM tables, indexes are in a seperate file, build their own
way. So no, also no influence. I don't know enough about InnoDB to say
something for sure, but
Hello.
First, key_buffer=16M seems a bit low for me with 13 million rows
(well, depends on the indexes, and how much free memory you have, of
course).
If I am not mistaken, sort_buffer/tmp_table_size are the one mostly
needed for this query, I think. Btw, you can get more info about the
query wi
I would like to make install to my home directory but can't seem to get it to
work.
make install prefix=/home/turner/mysql/test
It keeps wanting to install to /usr/local even though I pass the prefix parm.
Thanks, Dave
-
Be
On Tue, Apr 09, 2002 at 05:30:06PM -0700, David Turner wrote:
>
> I would like to make install to my home directory but can't seem to get it to
> work.
>
> make install prefix=/home/turner/mysql/test
>
> It keeps wanting to install to /usr/local even though I pass the
> prefix parm.
./configu
Thanks, but what I need to do is have
make install install everything into /home/turner/mysql/test then I'll
check everything out to make sure it is how I want it and last I'll copy it all
to /usr/local.
Any way to do this
./configure --prefix=/usr/local (default)
make
make install prefix=/ho
Hey Guys,
What is the command to add up the amount of rows in a total?
I need to know how many total reviews are in my table for each category
name, im using this query and it doesn't work:
SELECT SUM(name) AS articletotal WHERE category = 'Processors'
mysql
Thanks!
--
Benjamin Pflugmann <[EMAIL PROTECTED]> writes:
> Hello.
>
> First, key_buffer=16M seems a bit low for me with 13 million rows
> (well, depends on the indexes, and how much free memory you have, of
> course).
1 gig, plenty free.
> If I am not mistaken, sort_buffer/tmp_table_size are the one mo
Do anybody knows the range of MEDIUMINT, and BIGINT type to use
when I do the create table in mySQL ?
Son Nguyen
__
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/
-
Do anybody knows the range of MEDIUMINT, and BIGINT type to use
when I do the create table in mySQL ?
Son Nguyen
sql, query
__
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/
-
I have two mysql servers in a machine. OS is linux and system is dell.
I ran the servers in a separate datadir, socket and port yesterday. But
after six hours from the start two of them corrupted accidently.
I ran two servers from remote terminal. And there was no problem until
I exited from the
G'day Son Nguyen
> Do anybody knows the range of MEDIUMINT, and BIGINT type to use
> when I do the create table in mySQL ?
>From the manual at http://www.mysql.com/doc/C/o/Column_types.html
MEDIUMINT[(M)] [UNSIGNED] [ZEROFILL]
A medium-size integer. The signed range is -8388608 to 8388607
It seems that an internet connection from a browser to my unix/apache hosted
mysql database presents itself as some user to whom I haven't yet given
permissions because the calling web page gives up without a whimper. I have
generous permissions for 'root', 'nobody' and 'localhost'. The perl scrip
When a slave crashes or reboots, it should start replicating from where it
left off--at least ours do work that way. The current replication state
is saved in master.info on the slave and when it starts up again, it
should read that file and resume reading the binlog on the master where it
left o
i got a MySQL database that my supervisor wats me to do an ER diagram
for. The problem is that there is no/not much documentation on this
database. Also one cannot draw an ER-Diagram by looking at the mySQL-
Database, since there is no way (i know of) i can defining logical
relationships especi
> I need to know how many total reviews are in my table for each category
> name, im using this query and it doesn't work:
>
> SELECT SUM(name) AS articletotal WHERE category = 'Processors'
Try
SELECT count(name) AS articletotal FROM tablename WHERE category =
'Processors'
Sincerely,
Craig Vi
I use MySQL server replication last month, but currently I stopped using
it...coz for some reason
1. my master server is running on windows 98 platform, I cant prevent
it from hanging-up
2. my slave server is running on windows 98 also, I cant prevent it
also from hanging-up
3. if
1 - 100 of 114 matches
Mail list logo
