Hello,
I am Miki Tan from Gleneagles Medical Centre.
I am interested in MySQL database development.
1.Can I know with platform is suit for MYSQL ?
__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
-
Bengali is the script used in many Indian languages, like Hindi.
A search on google turned up a lot of pages written using Bengali, a
good example is http://www.parabaas.com/ and, for example,
http://www.parabaas.com/PB28/LEKHA/bMarkin28.html
Shyamal, if you're a coder, you can add support for it
Hi, I'm new to the list (& mysql) and not sure if there is an archive I can
search so apologies if this has been mentioned earlier. I was hoping someone
might be able to shed some light on a problem I am having:
I'm supporting a mysql 3.23.49 database with one master db (type=BerkleyDB)
and two s
Hi!
What is "Bengali" character set? Does it have a Unicode
mapping table like for example this one:
ftp://ftp.unicode.org/Public/MAPPINGS/ISO8859/8859-1.TXT
Please also send me some links to internet recourses
written in Bengali.
Regards!
Shyamal Banerjee wrote:
Dear sir,
I want to cre
First rule of JavaScriptis you don't talk about JavaScript!
Second rule of JavaScript is you _don't_ talk about JavaScript!
But seriously, remember that JavaScript has very, very few input/output
functions that can be used outside of a browser. There really isn't a way to
create a JavaScript conn
Yes, again. :( Although reluctantly, I finally decided to upgrade to
3.23.53a (on FreeBSD 4.7R), in the hope to get rid of these annoying errors.
Alas, 6 out of 10 times when I start a MySQL application, I get an error
like this:
DBD::mysql::st execute failed: Lost connection to MySQL server durin
From: Norm Lamoureux <[EMAIL PROTECTED]>
> ...700 individual web pages that EXCITE does a search for...
Are these web pages actual individual files, or are they simply information in a
database someplace that needs to get displayed?
> I don't know whether my server has these programs, I can
mysql:ÄúºÃ!±¾ÈË¿ÉÌṩÒÔÏ·þÎñ£º
1¡¢Ó²¼þ¼ÓÃܹ·Æƽ⣻
2¡¢Èí¼þÍêÈ«Æƽ⣻
3¡¢Èí¼þ×¢²á»úÌáÈ¡£»
4¡¢È¥³ýÈí¼þÏÞÖÆ£¨Èç°ÑÍøÂç°æµÄ10Óû§¸Ä³É100Óû§£¬´òÓ¡¹¦Äܵȣ©£»
5¡¢¹úÍâ´óÐÍÊý¾Ý¿âÆƽ⣻
6¡¢Èí¼þ¼ÓÃÜ£»
7¡¢²¿·ÖÒѽâÈí¼þµÍ¼ÛÌṩ£»
8¡¢ÊÖ»ú¶ÌÐÅϢȺ·¢Èí¼þ--ÆóҵȺ·¢°æ ²¢¸½ËÍ×¢²á»ú£»
9¡¢ÓʼþȺ·¢Èí¼þ¡¢ÓʼþµØÖ
Hi folks,
I'm looking for creative ways to setup a replication config that lets me
push all tables to some slaves and only a subset to other slaves. For
this scenario, let's say I have three db servers... One is a master and
gets all updates. One is an update slave, which gets all the master
Hi,
It is 760 organizations listed, when I said two, I meant that on the WWW
I have over 700 individual web pages that EXCITE does a search for and
my main database in DOS. I don't know whether my server has these
programs, I can check.
Thanks
Norm
Rodney Broom wrote:
>
> Hi Norm,
>
> I gather
Hello,
I have been racking my brains out for the last two days trying to get this
thing working..
I am using MS SQL 2000 linking server sp to link to MYSQL
at the moment I am using the generic ole db procider but I want to use the
myoledb provider, but when I go to use it it errors saying cant cr
At 19:32 -0600 11/25/02, Ronald Petty wrote:
I am trying to get my TIMESTAMPE field to auto update (use the current time
for inserts). However it keeps going to all 00, I read the
documentation and it says that is because it is getting an invalid input.
However it also states if you put n
I am trying to get my TIMESTAMPE field to auto update (use the current time
for inserts). However it keeps going to all 00, I read the
documentation and it says that is because it is getting an invalid input.
However it also states if you put null in it will work, it does on the
server, bu
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Michael C. Podlesny wrote:
Is there anyway to retrieve mySQL data from JavaScript?
Not directly. There's at least two ways to do it...You can use an
IFRAME, and post/retrieve to your favorite web programming language
which can talk to MySQL, or y
Hi all.
I am running MySQL-4.0.4 and have just compiled 4.0.5.
On the MySQL website, I found a bit that says:
You can always move the MySQL form and datafiles between different
versions on the same architecture as long as you have the same base
version of MySQL.
So does this mean I can do a '
Is there anyway to retrieve mySQL data from JavaScript?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[E
Hello,
I have made the mistake and now have no root access to mySQL. Could you
help me, please, to reset the root password.
Regards,
Jacek.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
I have successfully configured two mysql instances to replicate to each
other (According to /doc/en/Replication_Features.html, it is possible to
do it in a A->B->C->A relationship, but I only did it with two servers
and I don't have log-slave-updates on (I think if I did, it would
immediately stop
Greetings.
If I have a key on a float and attempt to insert a NaN I get
ERROR 1034: Incorrect key file for table: 'foo'. Try to repair it
if I attempt to update/delete that row.
If I remove the key from the float it seems to behave when I try to
update/delete the row.
Is this a bug / known l
Hello,
I am relatively new to MySQL though I have database experience.
I have a query that doesn't seem to want to use an index for the first
table despite my indexing several fields. Before I get too far in the
details of the query, here is what EXPLAIN SELECT tells me for the
first tab
> >> Your index contains a different set of columns than the columns listed
> >> in the match() list. You'll need to create another FULLTEXT index
> >> containing just title and subtitle.
>
> >Oh, OK. The manual needs to be corrected.
>
> Can you be more specific? I thought the manual already
I wish that was the answer (ego being less important
than sanity). I've put a tcpdump box in the middle
and tcp sessions are going out to the mysql server on
3307 (the creative port I chose for stunnel to use for
mysql) but the session hangs for about a minute after
I send the password. Here are
Hi Norm,
I gather that you are wanting to bring both databases together into a single MySQL
database. In order to do that, you'll have to have the mysql service running on your
web server. (Not actually true, but true enough for this conversation) However, it
sounds to me like you don't have th
Hi,
I'm trying to build mysql from the development sources (3.23.54,
retreived using bitkeeper) under win2k using cygwin.
Following the instructions in the mysql manual, I'm having a problem
running aclocal:
Dango) aclocal
aclocal: configure.in: 450: macro `AM_PROG_AS' not found in library
If I
Dear John,
probably the problem does not derive from MySQL, but from the URL encoded
search string, e.g.:
Search for "oneword" => oneword
Search for "two words" => two%20words
If you match against "two words", there will be no match, as it should match
against "two%20words".
I am not informed
> The question is what does Access do in order to > perform subqueries on MySQL via
>MyODBC driver > since it is obvious that they work?
access contains its own sql engine, so when you
link the mysql tables into it, you were then
running access queries.
> What can I do, but I do not want to
sql,query
At 16:01 -0500 11/25/02, John R Levine wrote:
> Your index contains a different set of columns than the columns listed
in the match() list. You'll need to create another FULLTEXT index
containing just title and subtitle.
Oh, OK. The manual needs to be corrected.
Can you be
> Your index contains a different set of columns than the columns listed
> in the match() list. You'll need to create another FULLTEXT index
> containing just title and subtitle.
Oh, OK. The manual needs to be corrected.
Regards,
John Levine, [EMAIL PROTECTED], Primary Perpetrator of "The Inter
At 13:57 -0500 11/25/02, John R Levine wrote:
I'm trying to make what I think is a very simple fulltext index for a
small library catalog, viz:
create table library (
id INTEGER UNSIGNED PRIMARY KEY NOT NULL,
callnumber VARCHAR(8) NOT NULL,
lastname TINYTEXT,
first
In the last episode (Nov 25), twig les said:
> Hey all, I'm having a painful time trying to get stunnel and mysql to
> play together. My mysql works fine locally and remotely until I add
> stunnel. After chasing my tail for a week (and drinking a lot on the
> weekend) I realized that Mysql is try
It funny that you ask me this.
I originally posted a note up on YOUR site that I had the Red hat 8.0
Files up for download on a site that I set up. They became so popular
that I decided to set up a forum to go along with them.
Oh, and no there is nothing wrong with the other sites, but you must
t
Hey all, I'm having a painful time trying to get
stunnel and mysql to play together. My mysql works
fine locally and remotely until I add stunnel. After
chasing my tail for a week (and drinking a lot on the
weekend) I realized that Mysql is trying to open a
socket on the server machine instead of
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release: mys
On Mon, Nov 25, 2002 at 11:51:00AM -0800, Lennart Stevens wrote:
>
> I just want to lets you guys know that I have recently setup a forum
> for disscusing linux and programming(including MySQL;). Come on and
> check it out here http://www.linuxforum.hopto.org thanks
What's wrong with the 6 millio
Hamid Amjadi wrote:
Hi ;
I am usein the following prepared statement:
insertOne = dbConnection.prepareStatement( "INSERT INTO appointment
(apptId,providerId,patientId,serviceLocationId, dateTime, assistant,
duration,state,statechange,memo,cancelMemo,dictationMarked, apptSeqId,
clinicId, appS
I just want to lets you guys know that I have recently setup a forum for
disscusing linux and programming(including MySQL;). Come on and check it out
here
http://www.linuxforum.hopto.org
thanks
_
STOP MORE SPAM with the new MSN
Hi ;
I am usein the following prepared statement:
insertOne = dbConnection.prepareStatement( "INSERT INTO appointment
(apptId,providerId,patientId,serviceLocationId, dateTime, assistant,
duration,state,statechange,memo,cancelMemo,dictationMarked, apptSeqId,
clinicId, appSharing) values (?,?,?
I am creating a search form for the TitleName. When I type in one word it
finds all titles with the one word. If I use two words it doesn't work.
How do I change my select statement to make it work? Thank you.
SELECT *
FROM Titles A, ActorTitle B, Actors C
WHERE A.TitleID=B.TitleID AND B.ActorI
I'm trying to make what I think is a very simple fulltext index for a
small library catalog, viz:
create table library (
id INTEGER UNSIGNED PRIMARY KEY NOT NULL,
callnumber VARCHAR(8) NOT NULL,
lastname TINYTEXT,
firstname TINYTEXT,
middlename TINYTEXT,
My previous question raised some follow up questions, so I am going to
try to clarify now by explaining the root of my problems:
My original (bash) script is the following:
./getTime.pl >> result.txt
echo "started: concurrent."
- Original Message -
From: "Rodney Broom" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, November 25, 2002 7:28 PM
Subject: Re: mailing list [EMAIL PROTECTED]~{5DWT6/;XPE~}
> Is anybody else getting this mail when they post?
>
yes, it's written in simplified chinese and it sim
Is anybody else getting this mail when they post?
---
Rodney Broom
President, R.Broom Consulting
http://www.rbroom.com/
sql
- Original Message -
From: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, November 25, 2002 11:15
Subject: ma
From: Geetika Tewari <[EMAIL PROTECTED]>
> ...perl script fork several processes...
> ...I think my 'select' statements are not happening concurrently.
Why do you think that?
---
Rodney Broom
President, R.Broom Consulting
http://www.rbroom.com/
sql
---
In the last episode (Nov 25), Geetika Tewari said:
> I am trying to make my perl script fork several processes that all
> execute 'select' statements on MySQL. I want the statements to
> happen concurrently (as I want to monitor the behaviour of MySQL with
> native ISAM tables under this concurren
From: Andrew Kuebler <[EMAIL PROTECTED]>
> I'm running a query to SUM a Decimal field with the configuration of
> DECIMAL(6,2) and I get a result looking like: 56.5515009
Hi Andrew,
I just did this (v 3.23.52):
mysql> create table dd ( myfloat decimal(6,2))
mysql> insert into dd (m
I am trying to make my perl script fork several processes that all execute
'select' statements on MySQL. I want the statements to happen
concurrently (as I want to monitor the behaviour of MySQL with native ISAM
tables under this concurrent Read access). So I am using 'fork'. However,
I think my
I'm running a query to SUM a Decimal field with the configuration of
DECIMAL(6,2) and I get a result looking like: 56.5515009
How is this possible???
Thank you in advance...
Andrew
-
Before posting, please check:
ht
From: Norm Lamoureux <[EMAIL PROTECTED]>
> ...I had to create 800 web pages...
> ...make a text file from our DOS database.
> I am wondering which program to put the data in.
Hi Norm,
It sounds to me like you are trying to build a data driven web site on a server with
no database available, as
(This is a forward of some private mail with the original poster,
with his permission.)
Date: Sun, 24 Nov 2002 22:59:33 -0500
From: Brian Reichert <[EMAIL PROTECTED]>
To: "Sweethome.co.il Webmaster" <[EMAIL PROTECTED]>
Cc: Brian Reichert <[EMAIL PROTECTED]>
Subject: Re: MySQL on virtual hosting
O
Hi
I've got a master database with 2 slaves. I've had them up and running for
quite a while now with no problems, but today I noticed an error - there was
a slave running on the master!
I checked /etc/my.cnf - no mention of slaves (it hadn't been changed for a
good while anyway). I looked every
Here is an example of our data, I had to create 800 web pages for each
organization, I had to make a text file from our DOS database. I am
wondering which program to put the data in. I also checked with our
server, we only have 7 meg. of space which is donated. I know he has SQL
server but won't le
In your InnoDB Section you need:
innodb_data_home_dir = c:/mysql/innodbdatapath
set-variable = innodb_mirrored_log_groups=1
innodb_log_group_home_dir = c:/mysql/innodblogspath
set-variable = innodb_log_files_in_group=3
set-variable = innodb_log_file_size=5M
set-variable = innodb_log_buffer_size=3M
Hello,
I'm considering building a dual athlon or dual xeon machine.
Which gives better results for mysql queiries using LIKES on
text columns? (under linux)
Currently availabe athlon 2.2 (1.8 ghtz) or Xeon 2.8?
Anyone run any numbrs between the two?
Thanks,
John
---
Alternatively, use the IF() function --
SELECT IF(captain=0, "C", "") from stats where captain > 0 and number = '23'
group by number;
Or something similar.
Nick
- Original Message -
From: "Insanely Great" <[EMAIL PROTECTED]>
To: "Alex Behrens" <[EMAIL PROTECTED]>; "MYSQL" <[EMAIL PROTE
You did not run the quote() funcion on $arch.
If $arch contains any special characters, it will break your query.
toby z wrote:
hay guyz
im havin a weired problem
i ve this search query
$srch_qry = " select ctnt_inf.* from ctnt_inf ".
" where (match (firstName ) against (\"".$srch."\")
Greetings...
I thin you need to look into the enum datatype. It stores data as integer
but when queried it will return data in text.
Rgds
Insane
SQLyog - The Definitive GUI for MySQL
http://www.webyog.com/sqlyog/download.html
- Original Message -
From: "Alex Behrens" <[EMAIL PROTECTED]>
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Monday 25 November 2002 15:03, Dyego Souza do Carmo wrote:
> ohhh, i´m sorry , the licences i was confused about are:
>
> MySQL-Standard and MySQL-Pro , not mysql-classic ;)
>
> What are the deferences between mysql-standard and mysql-pro ?
Well,
On Sat, Nov 23, 2002 at 04:37:01AM +0200, Octavian Rasnita wrote:
> I can do all the job with Perl, but if the link contains a "?" sign, it is
> replaced by the string "NULL" in the MySQL database and the link stored will
> be something like:
Just look up $dbh->quote(...) in the documentation.
$
On Fri, Nov 22, 2002 at 08:13:46PM -0500, Philip Mak wrote:
> SELECT *
> FROM boards
> LEFT JOIN boardAdmins
> ON boardAdmins.userId = #{userId}
> AND boardAdmins.boardId = boards.id
> LEFT JOIN boardMembers
> ON boardMembers.userId = #{userId}
> AN
mysql reference manual for version 3.23.7-alpha. - ...:ÄúºÃ!
ÆÕ¹âÍøÂç ÐֵܽãÃÃÃÇÈ¥Õâ¸öÍøÕ¾ÇÆһϣ¬Èç¹û¾õµÄ¿ÉÒԵĻ°¾Í×¢²á°É¡£Ç®ÊÇÉÙÒ»µã²»¹ý¶¼
ÊÇʵÔڵģ¬ÎÒÒѵõ½ÁË30¶àÔªÁË¡£
http://www.nu18.com/hz/?mid=extraterres´ó¼ÒֻҪͨ¹ýÏÂÏß¾ãÀÖÁªÃË×¢²á³ÉΪÆÕͨ»áÔ±(ÊÇÃâ·ÑµÄѽ)£¬Íê³ÉÿÌìµÄ10¸öµã»÷Á´½Ó£¬ºÃºÃµØ
>> The licence in mysql page is "obscure" for version 4.0
>>
>> What is a diference of MySQL-Classic and MySQL-Pro ?
LG> The only difference between those two is InnoDB - MySQL-Classic does not
LG> include it, while MySQL-Pro does. Both products are available under a
LG> commercial (non-GPL) lic
Bonjour,
Vous avez récemment demandé à vous inscrire au groupe
mysql-france. Comme vous êtes déjà membre de ce groupe,
votre demande ne sera pas prise en compte.
Pour toute question sur l'envoi de messages à ce groupe,
veuillez envoyer un e-mail à [EMAIL PROTECTED]
Cordialement,
L'équipe s
Hi All.
I have written a SQL script that should retrieve all the rows from a
table that match a value given as parameter by the user.
The script is something like:
SELECT TEST_NAME AS NAME, TEST_DATE
FROM TEST
WHERE TEST_NAME=NAME;
where NAME is the parameter the user should give.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Monday 25 November 2002 13:53, Dyego Souza do Carmo wrote:
> The licence in mysql page is "obscure" for version 4.0
>
> What is a diference of MySQL-Classic and MySQL-Pro ?
The only difference between those two is InnoDB - MySQL-Classic does not
He all,
I have a problem with MySQL ver 3.23.52 on Linux Redhat 8. It is
working successfully on the server, and can response all request
comming on Server. But, when I try to connect to the database thru
any client running on a Windows 2000 (like MySQLAdmin), I can't
connect it.
Firstly, I got
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Monday 25 November 2002 10:56, Graham Murray wrote:
> All of the other distribution files on mysql.com are showing version
> 4.0.5, but the linux RPMs are still at 4.0.4. Are these likely to be
> updated to 4.0.5 in the near future?
Yes, working o
The licence in mysql page is "obscure" for version 4.0
What is a diference of MySQL-Classic and MySQL-Pro ?
When may i use MySQL-Classic ?
When may i use MySQL-Pro ?
My Application is a commercial multi-database , running in mysql and
interbase , in my case , witch these licenceses must i use
JFL> Can i get more speed by disabling InnoDB tables, if I'm only using
JFL> MyISAM and HEAP tables?
JFL> Any warnings about this?
If your server is need more resources ( memory , etc... ), Yes.
The InnoDB only uses processor if the tables typped "InnoDB" are used , but the
memory is allocated.
Can i get more speed by disabling InnoDB tables, if I'm only using
MyISAM and HEAP tables?
Any warnings about this?
Regards, Jacob
http://www.sharksforum.com
sql
-
Before posting, please check:
http://www.mysql.com/manual.ph
If I use UPDATE LOW_PRIORITY, will the client then have to wait for the
update query to finish or not?
Regards, Jacob
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Jacob,
Monday, November 25, 2002, 12:03:14 PM, you wrote:
> If I use UPDATE LOW_PRIORITY, will the client then have to
> wait for the
> update to finish or not?
Yes, it will wait.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.n
I am running MySQL database 4.0.4 on a RedHat Linux 7.3 with the
database path being on raid disks and /tmp/ on a non raid disk.
Should the tmpdir be on a raid disk? If so they will be at the same disk
as the database. Is that the best option?
Regards, Jacob
-
Venlig hilsen
Jacob Friis Larsen
[ JFL WebCom | www.webcom.dk | +45 7027 0767 ]
> -Oprindelig meddelelse-
> Fra: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sendt: 25. november 2002 11:02
> Til: Jacob Friis Larsen
> Emne: Re: UPDATE LOW_PRIORITY database
>
>
> Your message can
All of the other distribution files on mysql.com are showing version
4.0.5, but the linux RPMs are still at 4.0.4. Are these likely to be
updated to 4.0.5 in the near future?
-
Before posting, please check:
http://www.mysql.com
Hi,
No, you should set it to 4 if you have 2 CPU :) (2*2 ;))
Regards,
Jocelyn
- Original Message -
From: "Jacob Friis Larsen" <[EMAIL PROTECTED]>
To: "Mysql maillist" <[EMAIL PROTECTED]>
Sent: Monday, November 25, 2002 8:46 AM
Subject: thread_concurrency (Try number of CPU's*2 for threa
set-variable= thread_cache=8
# Try number of CPU's*2 for thread_concurrency
set-variable= thread_concurrency=8
If I have 2 CPU's, does the above mean that I should set
thread_concurrency=16 ?
I am using a MySQL database 4.0.4
Regards, Jacob
-
> SHOW GRANTS FOR 'repluser'@'replmachine';
yes there is file grant on *.* - i used a simple password to avoid writing
it wrong. as i said, if i connect with mysql client tool from the slave
machine, i CAN login into the master server!
Only the slave can't login into the master server (with the sa
I have installed the MySQL database 4.0.4 client, but when I look at
phpinfo() I see that it says:
Client API version: 4.0.2-alpha
Why?
Regards, Jacob
-
Before posting, please check:
http://www.mysql.com/manual.php (the
78 matches
Mail list logo
