On Mon, 2002-10-21 at 13:07, Chip Rose wrote:
I can't get PHP-4.2.3 compiled to work with MySQL and Apache, despite months
of trying. Apache compiled ok, and so did MySQL -both work, on my Debian
Linux box.
I've tried various combos of installing the Deb packages, compiling from
source,
Hello jantos,
Tuesday, October 15, 2002, 2:03:50 PM, you wrote:
jamdd when I'm connecting to mysql-server via tcp/ip then the mysql-server
jamdd cuts the connection and it restarts the mysql-server.
jamdd when I don't make connections from other hosts than it's running
On Thursday, September 26, 2002, at 10:46 AM, Darrell A. Sullivan, II
wrote:
I am sure I am going to feel ignorant when I get the answer to this
question
because it will be something simple that I have overlooked, but here
goes
anyhow.
I am using MySQL Version 3.23.51-max.
I am
At 16:26 -0700 9/10/02, Daniel Curry wrote:
I am unable to find the specific DROP command to remove only test@%,
test\_%@%,
snort@localhost, and snort@%.
I think you want DELETE, not DROP.
DELETE FROM db WHERE Db='test' AND Host='%';
DELETE FROM db WHERE Db='test\_' AND Host='%';
DELETE FROM
Paul,
Thank you. That did it.
You are correct I needed to DELETE.
Paul DuBois wrote:
At 16:26 -0700 9/10/02, Daniel Curry wrote:
I am unable to find the specific DROP command to remove only test@%,
test\_%@%,
snort@localhost, and snort@%.
I think you want DELETE, not DROP.
Clarify your question ... are you trying to drop TABLES, DATABASES, or
modify user privileges?
If you are trying to modify user privileges, use GRANT or REVOKE.
- Original Message -
From: Daniel Curry [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, September 10, 2002 6:26 PM
You wrote:
I apologize for asking such a basic SQL question, but I am failing in
finding
the solution...
Consider the following table:
id | option
---
1 | a
2 | a
2 | b
I want to find the ids with only a specific set of options.
For example, if I wanted to get the ids
I wrote:
I apologize for asking such a basic SQL question, but I am failing in finding
the solution...
Consider the following table:
id | option
---
1 | a
2 | a
2 | b
I want to find the ids with only a specific set of options.
For example, if I wanted to get the ids which have option
Does this work?
select t.id,t.option,t2.option from tableName t left join tableName t2 on
t.id=t2.id and t2.option!=t.option where t.option=a and isnull(t2.option);
HTH,
Jed
On the threshold of genius, [EMAIL PROTECTED] wrote:
I apologize for asking such a basic SQL question, but I am
PathFinder,
Wednesday, September 04, 2002, 10:25:46 PM, you wrote:
PS I am a not yet that experienced with System Administration and
PS need a little holding hand here if possible.
PS I am running Red Hat 6.2 with MySQL installed and running.
PS Frankly I have read the README and HELP and
It is just a config file.
You don't run it.
PathFinder Software wrote:
Hi,
I am a not yet that experienced with System Administration and
need a little holding hand here if possible.
I am running Red Hat 6.2 with MySQL installed and running.
Frankly I have read the README and HELP and still
On Tuesday 13 August 2002 06:50 pm, Steinar Kolnes wrote:
Just create indexes on first and last, that should improve the speed of your
query drastically. It will of course be a BIG index. You might experiment
with only making the width of the index small, like maybe 8 or 10 characters
might
Hi,
The best way to speed up your query would be to create a compound index
on (first,last):
create index first_last on subscriber(first,last);
In this case, mysql will use it for both fields instead of doing a
linear search for the second one.
In order to reduce index size without
You need an index, it should drastically cut the query time. See:
http://www.mysql.com/doc/en/CREATE_INDEX.html#IDX1466
Mike Hillyer
Dynamergy Software
-Original Message-
From: Steinar Kolnes [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 13, 2002 4:50 PM
To: Mysql List
Subject: Need
In the last episode (Aug 14), Steinar Kolnes said:
I have to make a large 6.5 million names and numbers database in
MySql(maybe not so large for some of you). Yet it is very simple,
here is my sql file:
create table subscriber
(
id bigint unsigned not null auto_increment
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
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
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
Hello!
Nitesh Divecha 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 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
Don't use 'root' ... create a new user, and make sure you GRANT the proper
privs (i.e.:
USE mysql;
GRANT ALL PRIVILEGES ON *.* TO username@localhost IDENTIFIED BY
'password';
GRANT ALL PRIVILEGES ON *.* TO username@% IDENTIFIED BY 'password'
WITH GRANT OPTION;
- Original Message
Pada Sat, 06 Jul 2002 15:10:43 +
duo fu [EMAIL PROTECTED] menulis :
Dear Friends:
I have installed Apache 1.3.26, MySQL.3.23.51 successfully. However, I
failed to install tarball versions of PHP4.21 with Apache1.3.26 under my
REDHAT 6.2. I always got the error message when I tried to
I would suggest you build apache and php from source. instructions can be found at
http://www.php.net/manual/en/install.apache.php.
dan
* duo fu ([EMAIL PROTECTED]) wrote:
Dear Friends:
I have installed Apache 1.3.26, MySQL.3.23.51 successfully. However, I
failed to install tarball
Try - and I mean *try* :-)
SELECT Customers.* FROM Customers, Subscriptions
LEFT JOIN Orders ON (Orders.customerid=Customer.CustomerID)
LEFT JOIN Ordered_Items ON (Ordered_Items.orderid=Orders.id
(Ordered_Items.productid = '23'))
WHERE Customers.id=Subscriptions.customerid
AND
coffee or some sleep
Peter Normann
-Original Message-
From: Jamie Tibbetts [mailto:[EMAIL PROTECTED]]
Sent: 18. juni 2002 22:21
To: Peter Normann; [EMAIL PROTECTED]
Subject: Re: Need help with a complex query
Try - and I mean *try* :-)
SELECT Customers.* FROM Customers
Try - and I mean *try* :-)
SELECT Customers.* FROM Customers, Subscriptions
LEFT JOIN Orders ON (Orders.customerid=Customer.CustomerID)
LEFT JOIN Ordered_Items ON (Ordered_Items.orderid=Orders.id
(Ordered_Items.productid = '23'))
WHERE Customers.id=Subscriptions.customerid
AND
Try - and I mean *try* :-)
SELECT Customers.* FROM Customers, Subscriptions
LEFT JOIN Orders ON (Orders.customerid=Customer.CustomerID)
LEFT JOIN Ordered_Items ON (Ordered_Items.orderid=Orders.id
(Ordered_Items.productid = '23'))
WHERE Customers.id=Subscriptions.customerid
AND
To: Peter Normann; [EMAIL PROTECTED]
Subject: Re: Need help with a complex query
Try - and I mean *try* :-)
SELECT Customers.* FROM Customers, Subscriptions
LEFT JOIN Orders ON (Orders.customerid=Customer.CustomerID)
LEFT JOIN Ordered_Items ON (Ordered_Items.orderid=Orders.id
Mike,
With the way you have it written below, all of the pic1_id, pic2_id,
pic3_id, and pic4_id must be equal (because they all equal pic.pic_id).
Since this wasn't true for any of the rows, that is why you were
getting no results.
To get each picture value seperately, you will have to do
Thanks for the help. Got that to work no problem.
Mike
- Original Message -
From: Harrison C. Fisk [EMAIL PROTECTED]
To: Mike [EMAIL PROTECTED]
Cc: mysql list [EMAIL PROTECTED]
Sent: Thursday, June 13, 2002 5:48 PM
Subject: Re: Need Help with JOIN
Mike,
With the way you have
Hi,
Any problem is an effect of the cause
so...
I keep getting errors involving resolveip when I install, or it just don't
work. When I try to run the ./configure command in Linux (7.1-7.3), it
kicks me back an error.
What error?
If I use the rpm installation, it seems to install
Hi,
I have a MySQL database with a table named CONNEXION. When i'm trying to do
something with the specific table, i have the following error:
ERROR1016:Can't open file: 'CONNEXION.MYD'. (errno: 145)
Please can anybody help me?
Thanks in advance
--
:[EMAIL PROTECTED]]
Sent: Tuesday, May 21, 2002 9:16 AM
To: [EMAIL PROTECTED]
Subject: Re: Need help
Hi,
I have a MySQL database with a table named CONNEXION. When i'm trying to do
something with the specific table, i have the following error:
ERROR1016:Can't open file: 'CONNEXION.MYD'. (errno
Bertrand,
Tuesday, May 21, 2002, 4:15:37 PM, you wrote:
BT I have a MySQL database with a table named CONNEXION. When i'm trying to do
BT something with the specific table, i have the following error:
BT ERROR1016:Can't open file: 'CONNEXION.MYD'. (errno: 145)
BT Please can anybody help me?
://www.mysql.com/doc/R/E/REPAIR_TABLE.html
Gurhan
-Original Message-
From: Bertrand TACHAGO [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 21, 2002 9:16 AM
To: [EMAIL PROTECTED]
Subject: Re: Need help
Hi,
I have a MySQL database with a table named CONNEXION. When i'm trying to do
Hello Alex,
If the mysql query returns 0 then it will display the message like this
-Uma
On Fri, 1 Mar 2002, Alex Behrens wrote:
ABHey All,
AB
ABI am new to mysql and I need help debugging this peice of code for my site:
AB
AB?php
AB$db = mysql_connect(db30.pair.com, net3dual,
: 3969599
Owner of the 3D-Unlimited Network:
http://www.3d-unlimited.com
Send News:
[EMAIL PROTECTED]
- Original Message -
From: Uma Shankari T. [EMAIL PROTECTED]
To: Alex Behrens [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, March 01, 2002 7:35 PM
Subject: Re: need help debugging!
Hello
Shankari T. [EMAIL PROTECTED]
ABTo: Alex Behrens [EMAIL PROTECTED]
ABCc: [EMAIL PROTECTED]
ABSent: Friday, March 01, 2002 7:35 PM
ABSubject: Re: need help debugging!
AB
AB
AB
AB Hello Alex,
AB
AB
AB If the mysql query returns 0 then it will display the message like this
AB
AB
AB -Uma
AB
AB
AB On Fri, 1
of the 3D-Unlimited Network:
http://www.3d-unlimited.com
Send News:
[EMAIL PROTECTED]
- Original Message -
From: Uma Shankari T. [EMAIL PROTECTED]
To: Alex Behrens [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, March 01, 2002 7:59 PM
Subject: Re: need help debugging!
Hello Alex
rahs is the name of your db and your table?
It's a good idea to check for errors as you go. Try something like:
?php
$db = mysql_connect(db30.pair.com, net3dual, rosevilleX1) or
die(Couldn't connect:
Try adding this to your mysql_query() function.
$search = mysql_query()
or die(ERROR: . mysql_error() . ( . mysql_errno(). ));
this will tell you whether or not the query is dieing for one reason or
another.
if it doesn't return the die() statement then you must assume that it was
PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, March 01, 2002 10:19 PM
Subject: Re: need help debugging!
Try adding this to your mysql_query() function.
$search = mysql_query()
or die(ERROR: . mysql_error() . ( . mysql_errno(). ));
this will tell you whether or not the query is dieing
Okay is not a reply for myself :) is only for add a question... :)
I read that mysql 4 will fix this, but mysql 4 is stable? I mean i'm on
production, i'm not selling mysql :) I mean I have a big projet in test
using mysql.. so if it crash it will be very bad for me... someone had test
mysql 4?
Bonjour Jean-françois,
Le DESC qui utilise l'INDEX est un fonction de MySQL 4.0. Il y a
un bug en la version 4.0.1 (Quelque fois il n'utilise pas l'index
descendre ) mais pour la plus part ça marche bien. En autre il y a un
forum de MySQL en français à:
Liens utils :
Poster un message:
On Thu, Feb 14, 2002 at 01:05:24PM -0500, Richard C Rossy wrote:
Ok I can't seem to get this. Now is it possible to have MySQL on a other
computer and run the script.
In other words the perl script is on foo.com and MySQL database is on
foo2.com. What is need to make the script work. What
hope you version came out better thn mine.. in my mail it was all out of
shape.. maybe could attach a text file.. doubt the list allows that
thoough alot dont
Upload it as your_code_name.txt to your website and send an URL to the list.
filter: mysql query sql
Bye,
B.
I think you need to post the code. The description of the
problem is a bit ambiguous.
_justin
Webmaster wrote:
Hello.. of all days i have a project thats to be shown tomorrow.
i cannot get the dam thing to work
it should be simple i'd think
i would post code and all and if asked will
the code is huge i'll post whats relevant. there may be a few irrelevant things in
there... but hell... if your willing to look i'm willing to post
i know what works so will skip down lower to prevent wasting your time
and if ya could please cc your responce to [EMAIL PROTECTED], though if
hope you version came out better thn mine.. in my mail it was all out of shape.. maybe
could attach a text file.. doubt the list allows that thoough alot dont
-- Original Message --
From: Webmaster [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Date: Tue,
Hello.. of all days i have a project thats to be shown tomorrow.
i cannot get the dam thing to work
it should be simple i'd think
i would post code and all and if asked will
[snip]
Is the performance of your code data independent?
That is to say, if you remove (from the database) the set of
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
I'm no expert in this in fact I just recently started playing with
joins, but here's one that I actually used for a recent shopprt cart
piece. I appologise if it wraps but the output is long...content
conatins the basic content info but product contains the list of prices.
Yes I could have
Hi,All:
I need your help, When I compile the Msql-Mysql-Modules, I got errors, I am
running Redhat7.1 with perl5.6.1, the whole process is just as follows:
[root@wappy local]# cd Msql-Mysql-modules-1.2218
[root@wappy
OldMembers
Memebers
Data
Why no have 3 tables:
Members
Data
TheseMembersAreOld
Members and Data are as you have them defined. TheseMembersAreOld
contains only the Member_ID field.
You then make the Member_ID field primary key on TheseMembersAreOld and
Members. You can then perform a very
Why no have 3 tables:
Members
Data
TheseMembersAreOld
Members and Data are as you have them defined. TheseMembersAreOld
contains only the Member_ID field.
You then make the Member_ID field primary key on TheseMembersAreOld and
Members. You can then perform a very fast joins.
Hm, thank you for
Hi.
On Tue, Nov 06, 2001 at 12:34:26AM -0700, [EMAIL PROTECTED] wrote:
In MSSQL I can aggregate various fields like the [totalRev] field listed
below:
Does anyone know if or how to do this in MySQL?
You can't. You only can do this in the SELECT clause or make a column
that your application
Hi,
I'm running MySQL ver 3.23.38 on Win98 platform and am trying to learn
to do backups. I'm trying the mysqldump command but I'm getting the
error:
Access denied for user '@localhost'
How do I specify a user for mysqldump?
mysqldump --user=username ... Try mysqldump --help for more
Hi John Kelly,
This is not a perfect solution but may be useful to you. But still with two
queries!
From Mysql prompt issue these two queries.
SELECT @maxcat := max(Category) FROM table
WHERE category = 'Sports:Football:Players' OR
category = 'Sports:Football' OR category = 'Sports';
Select
You need to use the LIKE command I think. The MySQL manual should give you
all the details. If you need further help I can just write the whole query
out for you. Or was the problem that you only want to worry about the
if..then stuff if needed? If so could you tell what your pulling back from
]
Cc: [EMAIL PROTECTED]
Sent: Friday, November 02, 2001 7:09 PM
Subject: Re: Need help with a query ...
You need to use the LIKE command I think. The MySQL manual should give you
all the details. If you need further help I can just write the whole query
out for you. Or was the problem that you
On Fri, Nov 02, 2001 at 06:15:08PM -0800, John Kelly wrote:
Hi, I have a MySQL table with a column that contains some of a web site
directory's category names in the format:
Sports:Football:Players
I am trying to build a query that that locates all records that match the
above category
jesse junsay writes:
Then this error occurs.
starting mysqld daemon with databases from XX
mysql daemon ended
The manual didn't say anything on how to solve this
problem. So I hope this will help.
That's not an error message. Error messages can be
found in the error log, which
Unless you ran it as
mysql_install_db --user=mysql
mysql does not own the databases.
do
chown -R mysql /usr/local/mysql
chown -R /var/lib/mysql
( Or whereever your database directory is )
jesse junsay wrote:
Hi..
I have a problem running my MySQL server. After
running shellmysql_install_db
I had a similar problem on a win2k system when I started using mySQL. I
changed the user and password in phpmyadmin's config.inc.php. Or you can
change it in the my.ini file.
This might be alot more complicated with a unix system.
- Original Message -
From: GUYOT Carole [EMAIL
First, there is no need to reinstall.
For future reference, if you forget your password - check the manual for an
easy way to fix: http://www.mysql.com/doc/R/e/Resetting_permissions.html
For a mysql that wont start, check the error log and isolate what the
problem is ( it probably isnt that
On Thursday 30 August 2001 15:28, Andre Konopka wrote:
Hi,
I have, three tables (one,two, three) with the rows id/value. id is the
key for all the tables.
with
select value from one where id=xx;
select value from two where id=xx;
select value from three where id=xx;
I can select
Date |Mon, 27 Aug 2001 12:54:25 -0700 (PDT)
From |S K Bryan [EMAIL PROTECTED]
Hello!
SKB Hello -
SKB I'm very new at this, so please pardon the very beginner questions...
SKB I'm attemtping to install MySQL to my local machine running Win98. The
SKB install seems to go alright, but when I try
At 12:54 PM 8/27/01 -0700, you wrote:
Hello -
I'm very new at this, so please pardon the very beginner questions...
I'm attemtping to install MySQL to my local machine running Win98. The
install seems to go alright, but when I try mysqld--standalone it
gives me an error. Then I tried mysqld
Try putting a space between mysqld and --standalone (mysqld --standalone)
- Original Message -
From: S K Bryan [EMAIL PROTECTED]
To: MySQL [EMAIL PROTECTED]
Sent: Monday, August 27, 2001 2:54 PM
Subject: Need Help Setting Up MySQL on Win98
Hello -
I'm very new at this, so please
Hi !!
)-Original Message-
)From: qball cow [mailto:[EMAIL PROTECTED]]
)Sent: Sunday, August 19, 2001 10:50 AM
)To: [EMAIL PROTECTED]
)Subject: Fw: need help
)
)
)I have made a mysql server on my linux box. and via Myobdc I
)access it from a C++ programm I made.. I can see the records..
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
alexandre Roussel wrote:
Hi,
I have some problems with the following SQL request that I process with phpMyAdmin :
select * from TABLE2 where FIELD not in (select FIELD from TABLE1);
This request identify all records in TABLE2 which are not in TABLE1 (depending on
value of FIELD).
On Wed, 6 Jun 2001 11:52:14 +0200, alexandre Roussel
[EMAIL PROTECTED] wrote:
subselects are not currently supported with MySQL.
Hi,
I have some problems with the following SQL request that I process with phpMyAdmin :
select * from TABLE2 where FIELD not in (select FIELD from TABLE1);
This
@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 =
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://www.webfroggie.com
wap: http://www.webfroggie.com
-Mensagem
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
On Thu, May 17, 2001 at 06:36:23AM -0700, mansoor spake thusly:
*] i m new to mysql, how i can convert a string 28-MAR-2001 to date
*]
In what language?
--
-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
Peter L. Berghold[EMAIL PROTECTED]
Joe:
AFAIR, as an ex NT4 sysadmin, system error 5 is access denied - you have a
permissions problem somewhere.
On NT4 these can be a swine to solve. Check out your NT system error logs
as a starting point.
HTH.
David
By the way, I once first tried to set up the slave on a NT machine. But
On Wed, May 09, 2001 at 10:29:42AM -0600, Joseph Chow wrote:
Hi, there,
This is my first try on this mailing list. I am a new user of mysql
and need some help about replication on mysql 3.23.36. I had
followed the manual to set up master/slave server. At the
beginning, they are
Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 09, 2001 10:33 AM
To: Joseph Chow
Cc: [EMAIL PROTECTED]
Subject: Re: need help on replication
On Wed, May 09, 2001 at 10:29:42AM -0600, Joseph Chow wrote:
Hi, there,
This is my first try on this mailing list. I am a new user of mysql
On Wed, May 09, 2001 at 11:18:14AM -0600, Joseph Chow wrote:
Hi, Jeremy,
It is very nice to talk to you. Thanks for your information. It's
working now, but I did nothing but going over the procedure again.
I may make some mistakes during my operations. But it is really a
good idea to
mysql use lum
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Didn't find any fields in table 'users'
Database changed
mysql select * from users;
ERROR 1017: Can't find file: './lum/users.frm' (errno: 13)
401 - 500 of 524 matches
Mail list logo