In the last episode (Jul 28), Bill Leonard said:
> I have been searching and searching, and maybe this is a 4.0 thing,
> but is there a way, on a case by case basis, to pre-define a size
> limit for a MySQL database? In other words, make one 50MB and the
> next one make 100MB on the same server?
>
I have been searching and searching, and maybe this is a 4.0 thing, but is
there a way, on a case by case basis, to pre-define a size limit for a MySQL
database? In other words, make one 50MB and the next one make 100MB on the
same server?
I've seen indications you can set the default size for al
If it's for a "linking table", you'd just have something like this:
CREATE TABLE linking_table (
first_id INTEGER,
second_id INTEGER,
PRIMARY KEY (first_id, second_id)
);
For an n-m relationship, that's the only way to do it.
Dean Harding.
P.S. The syntax may be wrong, that's just
I have been searching and searching, and maybe this is a 4.0 thing, but is
there a way, on a case by case basis, to pre-define a size limit for a MySQL
database? In other words, make one 50MB and the next one make 100MB on the
same server?
I've seen indications you can set the default size for al
Hi,
Is it such a big deal to use more than one field for a primary key? Two
field keys are only a little slower than single field Primary keys for
selects. Often in linking tables you want to have duplicates of the two
foreign keys right?
I just wish people would stop making 100 field tables, t
Well, there are people who feel that tables should be linked by foreign keys
to ensure referential integrity. Everyone who uses MySQL gets by without
them though. Its up to your coding to make sure referential integrity is
not violated.
Although foreign keys are left out of MySQL for performanc
Hello Desmond,
I am not an expert in DB, but I support your ideas. The primery key is
one of the fundamental concept of database. With the key, you can refer
faster to the record that you are looking for. Even you have a perfect
codes, you will be not able to cover all senario that your softwa
Desmond,
A primary key is needed to maintain a unique identity of each record and
there by help in linking it to other records in other tables. However, we
have certain tables which link one table to another (needed because of
absence of foreign keys in mysql) which don't necessarily have primary
>Just when I thought I was getting the hang of this mysql stuff, the simplest
>of tasks
>is causing me to think about pulling my hair out.
>
>My table:
>
>NEWS {
> newsID (INT(3), AUTO-INCREMENT),
> newsTitle (VARCHAR (50)),
> newsText (BLOB),
> newsDate (DATE)
>}
It's
i think it's just a length limiter in serversite (mysql server)
string longer than this limit will be cut off
allowing you to be lazy to cut it off in clientsite (mysql client)
and also a way to indicate the string length, don't have to write a txt
file for document
>From: "toby -"
>To: [EMAI
Hello everyone,
We can find at mysql documentation, that using transaction may slow down
up to 4 times mysql. This because working with transfaction means to do
a lot of things while updating tables. I'm currently working in a system
where in some cases (very few cases) I realy need to use transa
k
This is seems ridiculous to me,.. but i'll let you tell me if i'm just being
stubborn.
So, one of my associates has made a linking table (some people also call it
intersection table, cross tab table, but i believe that the propper way to
model a many to many relationship is via a "linkin
I am currently working on a website that is implemented using PHP and MySQL.
The site currently has a simple search engine that allows a shopper to type
in a search string that is stored in $search. For example, if a shopper
types in 1972 Ford Mustang
$string ="1972 Ford Mustang"
Using the follo
[EMAIL PROTECTED] wrote:
> Would it be possible to have a MySQL manual (documentation) in .pdb or
> .pdf (for palm) so that it could be read on handhelds? It's a nice
> pocket reference.
Something like http://www.mysql.com/Downloads/Manual/manual.pdf ?
--
Hi,
I have installed apache-mysql-php with the apachetoolbox.com script.
(www.apachetoolbox.com)
I have first installed everything with keeping mysql 3.23.49(rpm),
everything was fine then, now i have used apachetoolbox to install mysql
3.23.51 and now i have a problem.
I use Snort-Mysql to rep
Dear Friends,
I am having a local Linux server which have MySQL
database. I am loging to MySQL by administrative user
root. I have two tables in the database lngsnet, the
table names are count and product. I want to load the
text file which have 25 lines / records which is stored
in the /tmp
Thanks Mike! Yes, the query is certainly using tmp tables for the longest of
times. I will try and implement the solution you provided and see how it
goes. If I do, I will update you with the results.
Regards,
Bhavin.
- Original Message -
From: "mos" <[EMAIL PROTECTED]>
To: "Bhavin Vyas"
Hello Benjamin,
BP> Hi.
BP> First, when you start an independend question, please start a new
BP> thread, but at least change the subject accordingly.
This is not independent question. Manual say what TRUNCATE TABLE will
recreate table from frm file, but when i use TRUNCATE TABLE, index file
wi
Hi,
Would it be possible to have a MySQL manual (documentation) in .pdb or
.pdf (for palm) so that it could be read on handhelds? It's a nice
pocket reference.
Thanks.
Ashifi.
-
Before posting, please check:
http://www.
Very interesting addition to message...
Forgot to mention what the problem-query produces: Nothing.
Cheers,
Tom.
-Original Message-
From: Tom Norwood [mailto:[EMAIL PROTECTED]]
Sent: 27 July 2002 19:39
To: mysql-list
Subject: Date Comparison Problem...
Just when I thought I was getti
Just when I thought I was getting the hang of this mysql stuff, the simplest
of tasks
is causing me to think about pulling my hair out.
My table:
NEWS {
newsID (INT(3), AUTO-INCREMENT),
newsTitle (VARCHAR (50)),
newsText (BLOB),
newsDate (DATE)
}
I just want to filter
desmond
one of my teachers at college once told me to give as less a digit as
possible
that is give it jst a BIT more den i need coz it takes up space .
:S ...
will someone correct me if im rong here . pleez
toby
>Hello there
>
>
>Mysql documentation says the following:
>
hi guyx
i ve a lil problem
i run this query n get a result set
$query = "SELECT lang_id,strng_id, strng FROM strngx where pg_id = 6 and
lang_id = '$lang_id '";
$query_result_handle = mysql_query ($query)
or die ('qry failed ! DA tbl must xixt in DA db specifyd bov ');
exe an
Jon,
replication basically pipes into the mysql client the SQL statements in the
output of
mysqlbinlog hostname-bin.xxx
Can you study from the output what was happening when row 6781602 was to be
inserted?
You should find
SET INSERT_ID=6781602
in the output.
If you pipe the output to the my
Hi.
On Fri 2002-07-26 at 15:24:58 -0300, [EMAIL PROTECTED] wrote:
>
> Why should I close port 3306 used by mysql? What would happen if a
> hacker use this port?
You should close it (as far as reasonable only, of course), simply,
because you lose nothing, but gain an additional layer a malicious
Hi.
On Fri 2002-07-26 at 16:33:40 +0100, [EMAIL PROTECTED] wrote:
> Does anybody have any PHP examples of how to use the mySQL HANDLER command in
> place of a select statement? From the manual it appears as a high speed version
> of SELECT.
Not to sound harsh, but IMHO, if you have to ask, you
Pada Fri, 26 Jul 2002 15:24:58 -0300
Anderson Pereira Ataides <[EMAIL PROTECTED]> menulis :
> Why should I close port 3306 used by mysql? What would happen if a hacker use
> this port?
Hemmm ... if you close the port 3306, so where do you put the mysqld to LISTEN on ?
Well, if you considering
Pada Fri, 26 Jul 2002 07:59:37 -0700
"Rich Amick" <[EMAIL PROTECTED]> menulis :
> Searched G for mysqld_list_processes:
> "The above happens if a new user logs in at the same time you do
> mysql_list_processes(). This is fixed in the newest MySQL 3.22
> version!"
>
> --We are using version 3.2
Pada Fri, 26 Jul 2002 11:17:08 -0700
Troy Hakala <[EMAIL PROTECTED]> menulis :
> ok, i turns out I have lots of sleeping connections. This is because I'm
> using PHP's mysql_pconnect which opens persistent connections so the next
> connect (on the same process) will reuse the connection. this d
At 15:24 -0300 7/26/02, Anderson Pereira Ataides wrote:
>Why should I close port 3306 used by mysql? What would happen if a hacker use
>this port?
You may want to close it at your firewall, if you want to allow the server
to be used only by machines on the local side of the firewall. That will
p
At 11:17 -0700 7/26/02, Troy Hakala wrote:
>ok, i turns out I have lots of sleeping connections. This is because
>I'm using PHP's mysql_pconnect which opens persistent connections so
>the next connect (on the same process) will reuse the connection.
>this does appear to improve performance over
At 10:24 -0700 7/26/02, David Kramer wrote:
>I automated the MYSQL start up process using the setup command.
"the setup command"?
> Everything
>works fine except that I noticed safe_mysql is the daemon running, shouldnt
>this be mysqld or mysql.server?
I suppose it depends on what "the setup
I am currently working on a website that is implemented using PHP and MySQL.
The site currently has a simple search engine that allows a shopper to type
in a search string that is stored in $search. For example, if a shopper
types in 1972 Ford Mustang
$string ="1972 Ford Mustang"
Using the follo
At 13:17 -0500 7/26/02, [EMAIL PROTECTED] wrote:
>Does anyone know of an older version of MySQL that runs on DOS
>(or on Windows 3.x)?
The earliest version mentioned in the manual is Win95.
-
Before posting, please check:
htt
hello there,
Is there a way to select an increment function so it returns an index
which is increemented by one for each row and that could be used to do
some calculations with other fields?
Example:
select incr() as INDE, date_add(date_col, interval (INDE-1)*7 day)
from suchtable
where da
sergei,
no i meant loading it up from raw data again. in the sense, i empty the
database, then i have a script which takes a directory full of files and reads
them into the database. each time i do that the database ends up corrupted.
is there any way to figure out where the corruption is? is it
Forget everything i said, now i realize that i didn't understand the
problem very well.
Francisco Reinaldo is right, use LEFT JOIN.
Sorry for having replied that!
On Thu, 2002-07-25 at 20:40, Kevin wrote:
> Hello,
>
> I have a query that runs perfectly until one of the items has no value or is
>
Nitesh,
Friday, July 26, 2002, 1:45:35 AM, you wrote:
ND> I need help with tables. I have created my table with some attributes in
ND> it.
ND> I need to modify my table attributes, can any one help me with the
ND> modify command or can give me the short cut to the web.
ND> Example:
ND> mysql>
Peoples,
I'm currently trying to work out if this is possible by SQL. I have the need
to use SQL and only SQL to achieve the following.
If a record exists and meets a certain criteria (i.e. field X = '1234') then
update the record. If the record doesn't exist then insert it.
For reasons too com
Hello All,
I need help with MySQL Log, can I know where does MySQL saves the log
files.
I need a log for ODBC; I have some problem with ODBC connection from
outside. I need to know what the Error is.
Please advice, Thanking in Advance.
Regards
Nitesh
First thanx to all those how answered:
Benjamuin Pflugmann
Gerald Clark.
hcir
Dicky Purnomo
Original posting is below.
The best answer came from Benjamin and he also gave a good
explanation why:
"Because it relates to the times table and you want to see
the users regardless, you have to put it
On Fri, 2002-07-26 at 15:46, Aman Raheja wrote:
> I have the following situation
>
> IDGRP PRC CHECK
> 1 3 10.0Y
> 2 2 12.0Y
> 3 3 32.0N
> 4 1 5.0 N
> 5 1 7.0 Y
> 6 2 9.0 N
> 7 3 17.0N
>
Manisha wrote:
> Hi,
>
> I am not a root. Our server is at ISP and I am trying to install mysql
> on our shared server. They have provided one user id and password with
> which I can access it. I also do not know whether mysql previously
> exists or not as mysql.sock is existing. (how to fin
At 09:16 26/7/2002 -0500, Mike Grover wrote:
Hi,
>Does anybody know if connecting with named pipes has changed in 4.02?
>
>
>I used to use . For the host name in 4.01 , after I switched to 4.02 I
>get the error "Failed to open named pipe" when I try to connect?
>
>Any Ideas?
Yes, on 4.0.2 the na
I'm using coldfusion to update a MySQL Database. on my edit record page
I'm querying the Database for some fields, i get most of the fields but
one field (Field "A" let's say) only returns 40 chars or so when it is a
blob field set to 65000 chars, were not actually using that many chars
but it's n
At 16:33 +0100 7/26/02, Steve Howie wrote:
>Does anybody have any PHP examples of how to use the mySQL HANDLER command in
>place of a select statement? From the manual it appears as a high
>speed version
>of SELECT.
Use HANDLER ... OPEN, then treat HANDLER ... READ like a SELECT, then
use HANDL
Hi.
On Fri 2002-07-26 at 11:00:31 -0400, [EMAIL PROTECTED] wrote:
> >
> >Hi Benjamin, Arjen
> >
> >I did some testing again. I have 75,000,000 rows table, after using group
> >by I got 62,300,000 rows.
> >If I use *nix -u sort, I got 74800,00 rows.
> >
> >I compared the two results, I feel I tru
Does anybody have any PHP examples of how to use the mySQL HANDLER command in
place of a select statement? From the manual it appears as a high speed version
of SELECT.
Cheers,
Steve
-
Before posting, please check:
http://
Francisco writes:
>Also, when I try to compile mysql-3.23.51.tar.gz, I
>get the following error executing the make command:
>"my_gethostbyname.c", line 81.5: 1506-068 (S)
>Operation between types "struct hostent*" and "int" is
>not allowed.
You need to modify the config file, since you are usin
Hi,
When starting the MySQL server from the command line, you can successfully run
multiple MySQL servers in the same Windows machine. This is possible because you can
specify the port number MySQL has to bind to on the command line. All you have to do
is run each server on a different port. I
Pada Thu, 25 Jul 2002 11:44:26 -0400
[EMAIL PROTECTED] menulis :
> Mysql engine is running under win98, then at the prompt I type mysql mysql then
>press enter and I have control. I can delete users (root included), whatever I want,
>so How can I make Mysql always require a username and a passw
Take a look at REPLACE:
http://www.mysql.com/doc/R/E/REPLACE.html
On Fri, 2002-07-26 at 10:17, Corey Wallis wrote:
> Peoples,
>
> I'm currently trying to work out if this is possible by SQL. I have the need
> to use SQL and only SQL to achieve the following.
>
> If a record exists and meets a c
> SQL does not exist in a vacuum.
> You have to run a client.
> The client is part of or runs under some scripting language ( perl ,
> php, sh, command.com )
> which in turn runs on an operating system.
> You have to somehow pass values that you want to select, update,
> or insert.
> So it really
SQL does not exist in a vacuum.
You have to run a client.
The client is part of or runs under some scripting language ( perl ,
php, sh, command.com )
which in turn runs on an operating system.
You have to somehow pass values that you want to select, update, or insert.
So it really not possible to
Looks as if the MySQL DB crashed and recovered.
Linux 2.4.18-5smp #1 SMP
MySQL version 3.23.51
>From the MySQL server while running mtop 26JUL02 ~6:45AM PST:
Unable to execute show procs [Lost connection to MySQL server during query]
Stack Trace:
at main::__ANON__(/usr/local/bin/mtop:446)
>
>Hi Benjamin, Arjen
>
>I did some testing again. I have 75,000,000 rows table, after using group
>by I got 62,300,000 rows.
>If I use *nix -u sort, I got 74800,00 rows.
>
>I compared the two results, I feel I trust my *nix result. Some lines just
>miss in "group by' result, look like no reaso
Hello Benjamin,
>> Why after TRUNCATE TABLE data file with indexes not freed ?
BP> See http://www.mysql.com/doc/A/d/Adding_and_removing.html (2nd paragraph)
BP> and
http://www.mysql.com/documentation/mysql/bychapter/manual_Table_types.html#InnoDB_File_space
BP> (second link does not work in th
On Fri, 2002-07-26 at 05:17, Corey Wallis wrote:
> Peoples,
>
> I'm currently trying to work out if this is possible by SQL. I have the need
> to use SQL and only SQL to achieve the following.
>
> If a record exists and meets a certain criteria (i.e. field X = '1234') then
> update the record.
Hi,
I suppose that what you want would be something like:
Mysql> create table test(ID int(4), Name varchar(20), Sex varchar(1));
Mysql> alter table test change Name FullName varchar(40);
You should read this for more information about ALTER TABLE:
http://www.mysql.com/doc/A/L/ALTER_TABLE.html
Hi,
On Thu, 2002-07-25 at 20:40, Kevin wrote:
> Hello,
>
> I have a query that runs perfectly until one of the items has no value or is
> set to 0:
>
> SELECT
> item.*, color.Name AS COLOR,
> shapecode.Shape AS SHAPE,
> clarity.Name AS CLARITY
> FROM item, color, shapecode, clarity
The language is English (same as server) and the client is PHP.
I've never seen this problem even when maxing out the connections at the
default 100.
On Thursday, July 25, 2002, at 02:55 PM, Georg Richter wrote:
> On Thursday, 25. July 2002 18:48, Troy Hakala wrote:
> Hello,
>
>> I've been ru
Hello All
I have the following situation
ID GRP PRC CHECK
1 3 10.0Y
2 2 12.0Y
3 3 32.0N
4 1 5.0 N
5 1 7.0 Y
6 2 9.0 N
7 3 17.0N
8 1 11.0N
Problem is th
> >> MP> But when I do it I get:
> >> MP> ERROR 1034: sort_buffer_size is to small
> >> Hm..
> >>
> >> Error 1034 means:
> >> "Incorrect key file for table ..."
> >>
> >> not a "sort_buffer_size is to small"
> >>
> >> How did you installed the server?
>
> MP> I compiled it from source files.
>
>
Hi!
You can run multiple servers on any Windows version with any MySQL version.
They must NOT share any data, .frm, or log files.
Below Miguel explains how with MySQL-4.0.2 you can run multiple instances
also as Windows services.
For any MySQL version you can do like this:
You have to create a
Hi Victoria,
Thanks. Does this mean in the future the -max version would be merged into
one release or just for the 4.0.2a??
Many thanks.
Regards,
Michael
-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 25, 2002 1:07 AM
To: [EMAIL PROTECT
clarification: can't run multiple instances of the same service on Windows.
- Original Message -
From: "Bhavin Vyas" <[EMAIL PROTECTED]>
To: "Paul DuBois" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, July 25, 2002 7:07 PM
Subject: Re: Do you run multiple servers on WIndows?
>
I am developing a new application using MySQL instead of MS SQL Server 2000,
I have just shelled out for the Microolap Delphi SQL DIrect Access
Components, having successfully converted an existing SQL Server database to
MySQL.
HOWEVER, I have tried using MyCC, MySQL Explorer, and PremiumSoft MyS
Hi.
On Thu 2002-07-25 at 18:28:20 +0200, [EMAIL PROTECTED] wrote:
> Hi,
>
> is it possible to change the default string quoting chars ('")?
> I'm using MySQL with an older shop solution. The data to write has
> both: ' and " chararcters. It isn't possible to escape those
> chars. Therefor I hav
>From what little I know of MySql on Windows, it runs as a service and you
can't run multiple services on the same Win Server.
Bhavin.
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, July 25, 2002 9:35 AM
Subject: Do you run multiple se
Hello All,
I need help with tables. I have created my table with some attributes in
it.
I need to modify my table attributes, can any one help me with the
modify command or can give me the short cut to the web.
Example:
Mysql> create table test(ID int(4), Name varchar(20), Sex varchar(1));
No
Andrew,
I assume that basedir and datadir are set to the *actual* paths specific to
your install and not 'the_install_path' and 'the _data_path'. If not, you
will need to set those.
Bhavin.
- Original Message -
From: "Wheeler, Andrew" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thur
On Thu, 25 Jul 2002, Gerald Clark wrote:
> create a group called mysql
> greate a user called mysql, and make it a member of the mysql group.
There is no groupadd or useradd command on MacOSX.
--
Dave Houghton [EMAIL PROTECTED]
System Manager
Hi,
We have a problem :
We are working with MySql ver 3.23.51 in Windows NT 4.0 Service Pack 6.
We use Acctualy MyIsam. It works fine, SELECT works fast with any indexes
( primary and others )
But when try to use InnoDB, only the primary key works like MyIsam
On Fri, 26 Jul 2002, Benjamin Pflugmann wrote:
> > is it possible to change the default string quoting chars ('")?
> > I'm using MySQL with an older shop solution. The data to write has
> > both: ' and " chararcters. It isn't possible to escape those
> > chars. Therefor I have to change the quoti
Hi,
Use LEFT JOIN instead of =. In a 1:m relationship,
only records that match in both tables are selected.
With L.J., the master is always selected even if the
record is not present in the child.
Master
Id
1
2
3
4
5
Children
FK_id Value
1 V1
1 V2
2 V3
Select id, value from Master,
Hi.
On Thu 2002-07-25 at 10:49:47 -0500, [EMAIL PROTECTED] wrote:
> Hi, I have a problem where the index for a SET column does not get used
> once I link in another table.
>
> The output to explain:
>
> mysql> explain select count(*) from NS_articles where
> find_in_set('approved', artFlags)
I would, very much, like to know if anyone has been able to do this.
NOTE: Multiple MySQL servers does not necessarily mean running multiple MySQL services
(just to clarify to another reply on this)
You can have multiple MySQL servers running on Unix system with some configuration in
your my
Hello Nitesh,
You can find that and more at...
http://www.mysql.com/doc/A/L/ALTER_TABLE.html
Good Luck,
--- Nitesh Divecha <[EMAIL PROTECTED]> wrote:
> Hello All,
>
> I need help with tables. I have created my table
> with some attributes in
> it.
>
> I need to modify my table attributes, ca
>Hi,
>
>I just downloaded the binaries. I have followed the installation
>instructions. Have run the command "mysqld-max-nt --install-manual " and
>checked the service panel and MySql is installed as a service. However when
>I either try to start the service in the service panel or issue the comma
I use the Now() function, and I just set my format to
"ww" without parenthesis and it gives me the current
week number.
--- Georg Richter <[EMAIL PROTECTED]> wrote:
> On Monday, 15. July 2002 20:28, Paul W. Reilly
> wrote:
>
> Hello Paul,
>
> maybe
>
http://www.mysql.com/doc/D/a/Date_and_time
At 09:42 25/7/2002 -0700, Wheeler, Andrew wrote:
Hi,
>Hi,
>
>I just downloaded the binaries. I have followed the installation
>instructions. Have run the command "mysqld-max-nt --install-manual " and
>checked the service panel and MySql is installed as a service.
In the same service panel screen
Hello
Thanks for getting back to. The real problem I have is that I
am rtying to install mysql remotely and don't have access to
the MacOSX console. Hence Netinfo is is not an option.
On Thu, 25
Jul 2002, Chris Garaffa wrote:
> He who calles himself "Gerald Clark" (from
> <[EMAIL PROTECTED]>)
It's my understanding that MySQL will only use one index per table on a
given query. For example...
SELECT * FROM
WHERE =
AND <
AND > ;
If col1, col2, and col3 are indexed the query can only use one index, right?
Single index access is a problem when you very large tables. What if you
h
Is there any plane to implement the REFERENCES function for foreign keys
on the alter table command.or is it implemented? If it is what
version of mysql?
Chris Dion
-
Before posting, please check:
http://www.mysql.com/
Hi,
Is anybody else having a problem using the MySQL client with Mac OS X 10.2
(Jaguar: Build 6C106)? When I try to connect to the server on 'localhost' I
get the following:
dyld: ./bin/mysql Undefined symbols:
./bin/mysql undefined reference to _BC expected to be defined in
/usr/lib/libSystem.B
85 matches
Mail list logo
