Hi,
abdulazeez alugo wrote:
Date: Sun, 19 Apr 2009 23:19:56 +0100
From: andy-li...@networkmail.eu
To: defati...@hotmail.com
CC: mysql@lists.mysql.com
Subject: Re: Need help with mysql prob
Hi Alugo,
Hi Andy,
Thanks for your prompt response. However, since tbl1_id has
Date: Mon, 20 Apr 2009 08:06:05 +0100
From: andy-li...@networkmail.eu
To: defati...@hotmail.com
CC: mysql@lists.mysql.com
Subject: Re: Need help with mysql prob
Hi,
abdulazeez alugo wrote:
Date: Sun, 19 Apr 2009 23:19:56 +0100
From: andy-li...@networkmail.eu
To: defati
Hi Alugo,
abdulazeez alugo wrote:
Hi Andy,
Thank you very much you have been really very helpful. All those
mistakes you pointed at in the script about the apostrophe and others,
are simple mistakes I just made in the rush of typing the message; and
yes $conn is the result from
Date: Mon, 20 Apr 2009 13:03:14 +0100
From: andy-li...@networkmail.eu
To: defati...@hotmail.com
CC: mysql@lists.mysql.com
Subject: Re: Need help with mysql prob
Hi Alugo,
abdulazeez alugo wrote:
Hi Andy,
Thank you very much you have been really very helpful. All those
mistakes
Hi guys,
I'm having a really terrible problem with my mysql coding and I'ld appreciate
any help I can get on this cause it's really driving me crazy.
I have two tables and I've succeeded in creating a one to many relationship
between both table but the problem I'm having is that I dont know
Hi,
Now I have successfully created a relationship between the two tables but how
do I make sure the value of tbl1_id in tbl1 is equal to the value of tbl1_id in
tbl2???
MySQL handles this for you. Simply INSERT the value into tbl1, then
INSERT the value of tbl1_id in tbl2. Then try
Date: Sun, 19 Apr 2009 22:50:20 +0100
From: andy-li...@networkmail.eu
To: defati...@hotmail.com
CC: mysql@lists.mysql.com
Subject: Re: Need help with mysql prob
Hi,
Now I have successfully created a relationship between the two tables but
how do I make sure the value of tbl1_id
Hi Alugo,
Hi Andy,
Thanks for your prompt response. However, since tbl1_id has an auto_increment value in tbl1, mysql is actually generating the values for it automatically.
Ah, I see your point. I'm guessing by your code you're using PHP? If
so call mysql_insert_id() after you've
Hi Abdul-
you may want to check this thread out regarding the same issue...
http://www.webmasterworld.com/php/3565843.htm
On Apr 19, 2009, at 3:23 PM, abdulazeez alugo wrote:
Hi guys,
I'm having a really terrible problem with my mysql coding and I'ld
appreciate any help I can get on
Date: Sun, 19 Apr 2009 23:19:56 +0100
From: andy-li...@networkmail.eu
To: defati...@hotmail.com
CC: mysql@lists.mysql.com
Subject: Re: Need help with mysql prob
Hi Alugo,
Hi Andy,
Thanks for your prompt response. However, since tbl1_id has an
auto_increment value in tbl1
Hi,
For mysql stress test suite (mysql-stress-test.pl) to execute, it requires
--stress-tests-file to be provided which contains the list of tests to be
executed. As per the documentation the default name of the file is
stress-test.txt and it will be located under ./mysql-test directory.
But I
Hi,
My mysql is crashing. Below table has the values it logs in the .err file
before restarting. I am using the large.cnf file.
The parameters I have changed are below. Rest are default values.
#for performance SSR
log=/var/log/mysql-queries.log
join_buffer_size=1M
max_connections=300
Hi,
I am using Mysql
4.1.15(mysql-standard-4.1.15-sun-solaris2.8-sparc-64bit)on
a solaris machine. My application is running on
weblogic8.1 sp2.
I have configured the mysql connection pool on
weblogic and tested from configuration wizard. I am
facing issues when connecting to Mysql pool from my
Hi,
I currently have a table with 2 text fields, both of
which are marked as fulltext. I'm using the full-text
boolean search method with fairly good results.
My problems however are:
1. I am on a shared host provider so I can't tweak
the full-text search options such as stop words or
Can you send me the configure file + makefile configured for cygwin ? Version 3.23.58
please thanks alot!
KEVIN ZEMBOWER wrote:
The organization hired an outside consultant to
evaluate which SQL engine to go with. This is
what he sent to us:
...
SQL Server 2000 is a complete Relational Database
Management System (RDBMS) that also includes integrated
analysis functionality for OLAP and data mining.
I'm a system administrator for a small (200 people) branch of a large
university/medical school. I've worked with MySQL and use it as my database of choice
for web-based dynamic content. I would not consider myself an experienced,
professionally-trained, knowledgeable database administrator,
Hi Kevin,
I'm a system administrator for a small (200 people) branch of a large
university/medical school. I've worked with MySQL and use it as my database
of choice for web-based dynamic content. I would not consider myself an
experienced, professionally-trained, knowledgeable database
Martijn, thank you very much for your analysis. I hope others will continue to join in.
With regard to your point quoted below, are you referring to PostgreSQL, and would
that be a
stronger competitor to MS SQL Server 2000 than either the current version of MySQL or
MySQL 5?
Thanks, again, for
Hi Kevin,
Martijn, thank you very much for your analysis.
I hope others will continue to join in.
So do I :-)
With regard to your point quoted below, are you referring to PostgreSQL,
and would that be a
stronger competitor to MS SQL Server 2000 than either the current version
of MySQL or
I have not work with it but postgres is supposed to work great in
/BSD/Linux/Unix/solaris environment
Which platform are you using?
:-)
Nestor A. Florez
Martijn Tonies [EMAIL PROTECTED] 11/7/2003 10:08:53 AM
Hi Kevin,
Martijn, thank you very much for your analysis.
I hope others will
It sounds like a copy and paste from Microsoft, but that is just my
guess. An objective recommendation with show pluses and minuses of
both. It most definitely does not sound like this consultant is
qualified to suggest a database product. What about PostgresSQL,
Oracle, Sybase, DB2? They all
Nestor, thanks for your question.
The platform will actually be dictated by the SQL engine, not the
other way around, which is more typically the case. If we go with
MS SQL Server, we'll build a separate host, NT I would guess, to
host it. I'm only responsible for Unix and Linux boxes here, so
that do
very nicely without them. Why are you different?
John Griffin
-Original Message-
From: KEVIN ZEMBOWER [mailto:[EMAIL PROTECTED]
Sent: Friday, November 07, 2003 1:53 PM
To: [EMAIL PROTECTED]
Subject: Re: Need help comparing MySQL to MS SQL Server
Nestor, thanks for your question
kevin,
i tend to think the consultant really just read something that microsoft
sent him. it doesn't sound like he's qualified to suggest one database
or another.
We've been usinf mysql for a year now. We use InnoDB tables, which give
us primary key/foreign key constraints and transactions.
On Thursday 20 February 2003 09:28, saravanan saravanan wrote:
I am using mysql for my project.I am finding
problems of using FOREIGN KEY and STORED procedures in
version 4.0.please help me and send the details as
earlier as possible
Stored Procedures are not supported in MySQL yet.
Dear sir
I am using mysql for my project.I am finding
problems of using FOREIGN KEY and STORED procedures in
version 4.0.please help me and send the details as
earlier as possible
by
Saravanan
__
Do you Yahoo!?
Yahoo! Tax Center - forms,
Veysel Harun Sahin wrote:
select vanNumber, sum(grossPay) from usertableDaily group by vanNumber;
The above is the correct query, to save yourself some time. As for your
problem:
But when I execute I get this:
Resource id#3
Resource id#4
This means you're using a resource
hello,
I've performed searches on this site and php.net to try and figure out
why this is occuring. I can't find any instance in my searches that
helped me. So, I'm posting my very first question to this list
Here's my table ($usertableDaily):
vanNumber|grossPay
-
select vanNumber, sum(grossPay) from usertableDaily group by vanNumber;
[EMAIL PROTECTED] wrote:
hello,
I've performed searches on this site and php.net to try and figure out
why this is occuring. I can't find any instance in my searches that
helped me. So, I'm posting my very first question
Hi
Interesting problem, normally to get a total by type, you would have a query
like,
select van, sum(pay) from ($usertableDaily) group by van;
However you are individually quering each total, your approach is correct, but
slower.
The problem you have though is the return of
Resource
[EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, February 15, 2003 10:09 AM
Subject: Need Help With MySQL Query
hello,
I've performed searches on this site and php.net to try and figure out
why this is occuring. I can't find any instance in my searches that
helped me. So, I'm posting
What does mysqld.log say?
Manuel Velasco wrote:
I'm getting the following messages after running
safe_mysqld (as root):
leo:/usr/bin # ./safe_mysqld
[1] 4798
leo:/usr/bin # Starting mysqld daemon with databases
from /var/lib/mysql
030121 19:38:15 mysqld ended
[1]+ Done
I'm getting the following messages after running
safe_mysqld (as root):
leo:/usr/bin # ./safe_mysqld
[1] 4798
leo:/usr/bin # Starting mysqld daemon with databases
from /var/lib/mysql
030121 19:38:15 mysqld ended
[1]+ Done./safe_mysqld
leo:/usr/bin # cd /var/lib/mysql
i've report this bug to php, they said it's not bug of php
but i've found the problem
* ALL is ok for SERVER, problem issue only by CLIENT(libmysql.a)
php-win-binary don't compile libmysql supporting GBK charset!
neight other multibyte charset.
also the one i compiled is linked with
Xuefer,
Monday, April 15, 2002, 8:55:08 AM, you wrote:
X mysql-4.01
X binary package
X windows
X also the same in linux source/binary package
X when SHOW VARIABLES
X got:
X -
X character_set gbk
X character_sets latin1 big5 czech euc_kr gb2312 gbk latin1_de sjis tis620 ujis
mysql:
mysql-4.01
binary package
windows
also the same in linux source/binary package
when SHOW VARIABLES
got:
-
character_set gbk
character_sets latin1 big5 czech euc_kr gb2312 gbk latin1_de sjis tis620 ujis dec8 dos
german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew
? stable or not? :)
Jean-Francois Dionne
- Original Message -
From: Jean-Francois Dionne [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, February 14, 2002 7:25 PM
Subject: Need help about mysql order and index
Hi there, I hope someone will can help me... First, sorry for bad
]
To: [EMAIL PROTECTED]
Sent: Thursday, February 14, 2002 7:25 PM
Subject: Need help about mysql order and index
Hi there, I hope someone will can help me... First, sorry for bad
english :)
i'm french
First all I have those index in my table
Hi there, I hope someone will can help me... First, sorry for bad english :)
i'm french
First all I have those index in my table
+---+---+-++
--+-++--++--
+
I need to remove a previous version of mysql and install the newest. When
trying to remove the previous version it complains about dependencies . I
don't know what to do about it, so I end up with a successful install of the
new version. Any help would be appreciated
rpm -e mysql-3.23.36-1
try just upgrading the RPMs using rpm -ivh
--
Kelly Firkins
[EMAIL PROTECTED]
I need to remove a previous version of mysql and install the newest. When
trying to remove the previous version it complains about dependencies . I
don't know what to do about it, so I end up with a
PM
Subject: Re: need help with mysql rpms
try just upgrading the RPMs using rpm -ivh
--
Kelly Firkins
[EMAIL PROTECTED]
I need to remove a previous version of mysql and install the newest. When
trying to remove the previous version it complains about dependencies . I
don't
:
MySQL conflicts with mysql-3.23.36-1
MySQL-server conflicts with mysql-server-3.23.36-1
- Original Message -
From: Kelly Firkins [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, December 10, 2001 4:20 PM
Subject: Re: need help with mysql rpms
try just upgrading the RPMs using
Raymond Norton wrote:
error: failed dependencies:
MySQL conflicts with mysql-3.23.36-1
MySQL-server conflicts with mysql-server-3.23.36-1
Yeah, the MySQL rpms are incompatible with the mysql rpms (which are done
by RedHat). Apparently the two camps each think the other's file system
On Wed, Aug 01, 2001 at 08:19:45PM -0400, Stonix wrote:
Hi,
I installed a RH 7.1, and I installed all the packages for
apache, php and mysql. I don't know how to check if mysql
server is running. On my machine cannot connect to mysql
server.
Hi,
try executing the following command:
ps
Date |Wed, 1 Aug 2001 20:19:45 -0400
From |Stonix [EMAIL PROTECTED]
Hello!
S Hi,
S I installed a RH 7.1, and I installed all the packages for
S apache, php and mysql. I don't know how to check if mysql
S server is running. On my machine cannot connect to mysql
S server.
S Thanks in advance
Hi,
I installed a RH 7.1, and I installed all the packages for
apache, php and mysql. I don't know how to check if mysql
server is running. On my machine cannot connect to mysql
server.
Thanks in advance for all advices if can help me out!
Regards,
Alex shi
Hello. I installed on my computer Red Hat Linux 7.0. After that I started configuring
mysql. I upgraded mysql, added all necessary packages and I wanted to run mysql
server.
Whenever I type mysql it gives me such an error message: ERROR 2002: Can't connect to
MYSQL server through socket
Malkhaz Mangoshvili [EMAIL PROTECTED] writes:
Hello. I installed on my computer Red Hat Linux 7.0. After that I started
configuring
mysql. I upgraded mysql, added all necessary packages and I wanted to run mysql
server.
Whenever I type mysql it gives me such an error message: ERROR
At 6:23 PM -0400 6/16/01, Malkhaz Mangoshvili wrote:
Hello. I installed on my computer Red Hat Linux 7.0. After that I
started configuring
mysql. I upgraded mysql, added all necessary packages and I wanted
to run mysql server.
Are you using RedHat's MySQL RPMs? If so, you should uninstall
it
can display.
-Original Message-
From: Neil Zanella [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 06, 2001 12:09 PM
To: Don Read
Cc: Ed Peddycoart; Mysql@Lists. Mysql. Com; Jorge Oliveira
Subject: RE: Need help on mysql/php
On Tue, 5 Jun 2001, Don Read wrote
At 2:13 PM +0530 6/7/01, Adrian D'Costa wrote:
On Wed, 6 Jun 2001, Ian Ford wrote:
Name your config file config.inc and if any of the below situations
happen your password and username will not show up in plain text for the
casual browser.
(EXAMPLE:
CONFIG.INC
?
://www.webfroggie.com
wap: http://www.webfroggie.com
-Mensagem original-
De: Ed Peddycoart [mailto:[EMAIL PROTECTED]]
Enviada: Quarta-feira, 6 de Junho de 2001 0:29
Para: Jorge Oliveira; Mysql@Lists. Mysql. Com
Assunto: RE: Need help on mysql/php
Thanks...this helped...Just had success
@Lists. Mysql. Com
Subject: RE: Need help on mysql/php
At 10:37 PM +0100 6/5/01, Jorge Oliveira wrote:
Hi again,
You are right, your username and password will have to be on every PHP
script that needs to use database.
However, you don't have to be afraid because nobody can access the source
Actually you are only exposed if you have not set up Apache to run with
virtual hosts. It is not difficult to configure Apache so that a person
can only see the scripts that are in his/her directory, and is prevented
from seeing or modifying the scripts in other peoples directories. Also,
On Tue, 5 Jun 2001, Don Read wrote:
Better yet, put the file outside the $DOCUMENT_ROOT, in case your server is
poorly configured.
include($DOCUMENT_ROOT/../config.php);
This is a very good idea. One day if the system administrator decides to
back up all the user data and upgrade the web
At 10:35 AM -0700 6/6/01, Kenneth Kopelson wrote:
Actually you are only exposed if you have not set up Apache to run
with virtual hosts. It is not difficult to configure Apache so that
a person can only see the scripts that are in his/her directory, and
is prevented from seeing or modifying the
: RE: Need help on mysql/php
On Tue, 5 Jun 2001, Don Read wrote:
Better yet, put the file outside the $DOCUMENT_ROOT, in case your
server is
poorly configured.
include($DOCUMENT_ROOT/../config.php);
This is a very good idea. One day if the system administrator decides to
back up all
On Wed, 6 Jun 2001, Ian Ford wrote:
Name your config file config.inc and if any of the below situations
happen your password and username will not show up in plain text for the
casual browser.
(EXAMPLE:
CONFIG.INC
?
$DBname = 'test';
$DBuser =
I recently move my website to FastWebServers.com. MySQL and PHP is
provided. I have a control panel which allows me to initialize MySQL for my
use. The initialization creates a db, named celticblues_com (my domain is
celticblues.com). So far, I have added a table to my database, and added
the
original-
De: Ed Peddycoart [mailto:[EMAIL PROTECTED]]
Enviada: Terça-feira, 5 de Junho de 2001 21:31
Para: [EMAIL PROTECTED]
Assunto: Need help on mysql/php
I recently move my website to FastWebServers.com. MySQL and PHP is
provided. I have a control panel which allows me to initialize
Great support..
Right.. take a look at www.devshed.com they've got a few nice tutorials..
if you plan to work a lot with MySQL you might want to buy the book called
MySQL written by Paul DuBois or fill out the survey and hope you'll get one
for free ;-)..
Other interesting websites:
Hello Ed,
Tuesday, June 05, 2001, 11:30:36 PM, you wrote:
EP I recently move my website to FastWebServers.com. MySQL and PHP is
EP provided. I have a control panel which allows me to initialize MySQL for my
EP use. The initialization creates a db, named celticblues_com (my domain is
EP
To: Mysql@Lists. Mysql. Com
Subject: RE: Need help on mysql/php
Hi,
Please refer to http://www.php.net/manual/en/ref.mysql.php
Jorge Oliveira
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
© webfroggie.com - Recursos Online!
web: http
-Mensagem original-
De: Ed Peddycoart [mailto:[EMAIL PROTECTED]]
Enviada: Quarta-feira, 6 de Junho de 2001 0:29
Para: Jorge Oliveira; Mysql@Lists. Mysql. Com
Assunto: RE: Need help on mysql/php
Thanks...this helped...Just had success in connecting to the MySQL server
and dumping the db contents
-
De: Ed Peddycoart [mailto:[EMAIL PROTECTED]]
Enviada: Quarta-feira, 6 de Junho de 2001 0:49
Para: Jorge Oliveira
Assunto: RE: Need help on mysql/php
I assume that you mean that they cannot access the scripts if the extension
of the file is .php3, but if I mix PHP within an HTML file, then all
On 05-Jun-01 Ed Peddycoart wrote:
Thanks...this helped...Just had success in connecting to the MySQL server
and dumping the db contents to the screenOne worrisome bit though...My
username and password for connecting to the db on my host is my username and
password for the web account.
At 10:37 PM +0100 6/5/01, Jorge Oliveira wrote:
Hi again,
You are right, your username and password will have to be on every PHP
script that needs to use database.
However, you don't have to be afraid because nobody can access the source of
your PHP scripts - unless they are a good hacker!
At 7:42 PM -0500 6/5/01, Don Read wrote:
On 05-Jun-01 Ed Peddycoart wrote:
Thanks...this helped...Just had success in connecting to the MySQL server
and dumping the db contents to the screenOne worrisome bit though...My
username and password for connecting to the db on my host is my
I just installed RH 7.0 selecting the 'install everything' option. Now
when I use safe_mysqld, it starts then ends immediately with the
following message in the log.
010310 12:43:30 mysqld started
010310 12:43:30 Can't start server : Bind on unix socket: Permission
denied
010310 12:43:30 Do
71 matches
Mail list logo