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
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:
It's my understanding that MySQL will only use one index per table on a
given query. For example...
SELECT * FROM HUGE_TABLE
WHERE col1 = val1
AND col2 val2
AND col3 val3 ;
If col1, col2, and col3 are indexed the query can only use one index, right?
Single index access is a problem when you
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])
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 right
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
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 command
net
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, can any
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
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) 0;
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
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 quoting char
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 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
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: Thursday,
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));
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 servers
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 have to
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
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?
From what
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
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
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.
Something is very wrong with your
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
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
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
WHERE
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
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. If the
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 the
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 reason at all.
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)
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
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
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
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
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.
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 using the
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:
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 trust my *nix
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 HANDLER
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
At 09:16 26/7/2002 -0500, Mike Grover wrote:
Hi,
cut
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 named
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 find
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
8 1
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
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
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
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 create
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
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
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
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:
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
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
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
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
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 does
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.23.51 -
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 the
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
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
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
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 and
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:
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
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
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:
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
will
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
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
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
[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 ?
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
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
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
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: [EMAIL
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 better to
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
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
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
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,
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
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
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?
85 matches
Mail list logo