Hi.
I have the next problem:
I have two OSs - Linux (mdk9.1) and Windows (98se) - installed on one
of my computers, and on both I've installed the mySQL server. Problem
is that I want to have completely identical databases on both systems
- when I change something in Windows' DBs, I want it to be c
> Simply I didn't know where the password was located in myphpadmin.
The password is not in myphpadmin. It is in the database. Log in as root
and look at the "mysql" database.
Also, read sections 4.2 and 4.3 of the MySQL manual.
> I
> wanted it secure but I wanted to be able to get to the data
You need to create a cookie session using start_session() and something like
that. I'm actually reading up on it on this book
PHP & MySQL Web development - luke welling & Laura thomson (i think)
Cheers,
Mun Heng, Ow
H/M Engineering
Western Digital M'sia
DID : 03-7870 5168
-Origin
Hi,
I'm a newbie too. Was faced with this the other day.. I'm using
Redhat 8.0 PHP-4.2.2-8.07 and when this problem surfaced, found out that
phpinfo() states that it is compiled with the --with-mysql=shared. But I did
not install php-MySQL*.rpm
Did a rpm -Uvh php-MySQL*.rpm and it install
How do I unsub from this list? The unsub link doesn't work?
}
echo("Quick it's all most closing time!!!");
more_help();
?>
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: Sunday, June 15, 2003 8:46 PM
To: [EMAIL P
I didn't know where to send this, so I'm sending it anyway.
---
Spelling error in "MySQL Reference Manual"
Where it reads: "Portugise error messages."
Should read: "Portuguese error messages."
Where it reads: "A Portugese mailing list"
Should read: "A Portuguese mailing list"
I believe this should
You are welcome. Sorry I havent been more precise - at this time I didnt find
it.
Have a look at the UC presentations "Moving towards MySQL 5.0" from Matt
Wagner and "State of the Dolphin " from David Axmark and Michael (Monty)
Widenius
http://www.mysql.com/events/uc2003/highlights.html
Read
Hi,
while trying to handle severl key values,
I wonder if it is more efficient to put
those values in a row seperated by a
certain seperator (eg. comma).
The talbe has two fields and looks like;
UID ForeinID
1 2,3,4,6
27,9,4,5
33,4
41,5,7,9
52,3,4,5
and the values of Foreign
Sorry... I clicked send before pasting. Here is the function I was talking about.
function approvesignup($lid){
global $prefix, $dbi, $signqid, $ev_title, $ev_location, $ev_descrip, $ev_datetime,
$ev_organizer, $ev_contact, $ev_children, $ev_number, $ev_cost, $ev_phone;
sql_query("INSERT into $p
Hi...
I created the following function to move a record from one table to another. The only
difference in the table structures are the auto-incremented id column.
The purpose of my function is to allow Admin to get user input from the "queue" table
and after "approving it" she puts it in a t
Try specifying someuser at all hosts.
GRANT ALL ON * TO [EMAIL PROTECTED] IDENTIFIED BY 'somepass';
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Timothy Waters" <[EMAIL PROTECTED]>
To: "MySQL mail" <[EMAIL PROTECTED]>
Sent: Saturday, 14 June, 2003
With proper syntax. ;) Your WHERE conditions are improperly arranged.
SELECT * FROM stores,subcategory,category
WHERE (stores.category = $category->id AND subcategory.category =
$category->id)
OR stores.zip = $cityzip
ORDER BY name;
Also, assuming you're coding this in PHP, you need
> I have all privileges to all the databases and tables, with user 'root'.
User 'root' likely doesn't have access from the desired IP. Users are
configured by both name and approved hosts. Try this:
GRANT ALL ON database TO [EMAIL PROTECTED] IDENTIFIED BY 'password';
Edward Dudlik
Becoming Dig
Ahh, yes, thank you for clarifying. My code would obviously have been no
help.
Hmm, I have not tested the theory, but I believe you could add to your
SELECT statement, a declaration of the return and use it in the next INSERT.
That is, SELECT @high:=convert(...) AS a FROM Ops;
And then "a" refers
I have installed MySQL in Win98SE, with connection ASDL and Fixed IP.
In the same machine, works web server (Apache2+PHP) and e-mail e ftp server.
Everything works perfectly accessing from my INTRANET (local network). I
obtain access to MySQL without problems.
In Internet, all servers works perf
hello and thank you for your time.
how should i code:
select * from stores,subcategory,category where stores.category and
subcategory.category = $category->id and stores.city or stores.zip =
$cityzip order by name
thank you again, tad
--
Addison Ellis
small independent publishing co.
114 B 29th
I'm not sure I entirely understand your solution. A datestamp would only
work if you stamped the record when it's updated, and then when the next
update is called, you'd have to have, throughout the program, snippets of
code to edit the last modified timestamp, so it knows to update those
records.
Shane Bryldt wrote:
I think the solution is simple, remove the part of the code you are having
problems with, it's redundant. Instead, according to your statement, use
this:
UPDATE Ops
SET [EMAIL PROTECTED]
WHERE newphoto=1 AND tbprinted=1;
Thanks for the response Shane. I don't think I explai
Murdoch Mactaggart ,
The WINDOWS Environment needs the --console switch in order to output the
return of mysqld to DOS commands.
Please ref to: http://lists.mysql.com/list.php?list=win32#b
my.cnf will never be looked for by the WINDOWS Binary. Return to using
my.ini from th
> As my post suggested, I have already addressed the tweaks this this
> section of the manual addresses, and was hoping there might be some insight
> on my original question, the process of INSERT vs UPDATE.
Gotcha. I wasn't sure if you'd checked the manual or just run a huge number of
EXPLAINs o
Phill,
I think the solution is simple, remove the part of the code you are having
problems with, it's redundant. Instead, according to your statement, use
this:
UPDATE Ops
SET [EMAIL PROTECTED]
WHERE newphoto=1 AND tbprinted=1;
As for myself, I would actually use the client implementing the stat
Hi
I'm unclear whether the address I'm using here (referenced on page 29
of the manual) is the correct one but I hope one of them may either
get me an answer or a reference to where else I might seek help.
DETAILS
OS: Windows 2000 Professional, 5.0.2195 SP3 build 2195
MySQL version 4.0.13 for Wi
> On Sunday, June 15, 2003, at 01:36 PM, Nuno Lopes wrote:
>
> > I have a table with just one column and with 1000 rows. It's indexed
> > using
> > full text.
> > I've tried MATCH with AGAINST and LIKE and nothing works right!
> >
> > I've tried:
> > SELECT * FROM 'test' WHERE MATCH (p) AGAINST ('
Hi *
I'm running MySQl 3.23 and I'm trying to run a very simple command that
basically finds the highest number in a column and then for all matching
rows sets their card number to be +1. The code looks
like this:
#cardnumb is actually a string of the form SNx so set @high=x as
a nu
Ethan,
- Original Message -
From: "Ethan Joffe" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Sunday, June 15, 2003 6:16 PM
Subject: free table memory shrinks when data deleted
>
> After delete a large amount of data from an innodb table, the free memory
> available to in
On Sunday, June 15, 2003, at 01:36 PM, Nuno Lopes wrote:
I have a table with just one column and with 1000 rows. It's indexed
using
full text.
I've tried MATCH with AGAINST and LIKE and nothing works right!
I've tried:
SELECT * FROM 'test' WHERE MATCH (p) AGAINST ('arvor*');
but if I do
SELECT
Hi!
I have redhat 7.3 with the mysql packages that came with it.
Since RHSA-2003:093-14 came out I upgraded mysql with
mysql-3.23.56-1.73.i386.rpm
mysql-devel-3.23.56-1.73.i386.rpm
mysql-server-3.23.56-1.73.i386.rpm
When I try to start mysqld I get the following error message
in the log:
Table 'my
Hello,
I have a table with just one column and with 1000 rows. It's indexed using
full text.
I've tried MATCH with AGAINST and LIKE and nothing works right!
I've tried:
SELECT * FROM 'test' WHERE MATCH (p) AGAINST ('arvor*');
but if I do
SELECT * FROM 'test' WHERE MATCH (p) AGAINST ('arvore*');
The solution depends on which version of MySQL you are using. If you
are using 4.1, you the easiest solution is to use a sub-select.
Something like this may work:
SELECT m.member_number, m.name, s.status, s.date
FROM members AS m, status AS s ON
WHERE m.member_number = s.member_number
AND m.m
After delete a large amount of data from an innodb table, the free memory
available to innodb tables as reported by 'show table status' decreased
significantly rather than increasing.
I am guessing this is caused by fragmentation? If so, I am guessing the
only way to regain the free memory is t
On Sunday 15 June 2003 08:44 am, wrote:
> Greetings-
>
> I request your help constructing a query to return a list of active members
> based on the following:
select distinct members.members_number, members.name, status.status from
members,status where status.status='Active' and status.date
Greetings-
I request your help constructing a query to return a list of active members based on
the following:
CREATE TABLE Members(
member_number int unsigned AUTO_INCREMENT,
name varchar(25),
PRIMARY KEY(member_number))
CREATE TABLE Status(
member_number int unsigned AUTO_INC
As my post suggested, I have already addressed the tweaks this this
section of the manual addresses, and was hoping there might be some insight
on my original question, the process of INSERT vs UPDATE. That chapter was
helpful initially, but I have already addressed most of what that chapter
h
Consider going over Section 5.2.9 of the manual.
http://www.mysql.com/doc/en/Insert_speed.html
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Shane Bryldt" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, 15 June, 2003 01:12
Subject: Question
How about SELECT (column1, column2, column3, etc.) FROM products...
I believe something along the lines of EXCEPT FOR would be a huge violation of
SQL standards. It might be useful for you, but it's likely that most users
would simply declare the desired columns or exclude one programatically.
E
I don't think that solves the problem. There are multiple test chains with
Id's less than 7.
ie
7->6->4->3->2
5
1
and your query looking for history on testId=7
SELECT * FROM tests WHERE testID<=7 AND connect>0;
could return testId's 5 and 1 as well if they were part of longer cha
MySQL 4.0.12 max on AIX 4.3.2 HA. When I use show full processlist on localhost, all
Hosts show as localhost. but when I use show full processlist from remote, all Hosts
show as remote IP.
as follow:
mysql> show full processlist;
+-+-+-++-+
37 matches
Mail list logo
