Greetings, sql people!
I'm from Poland, studying on Technical Unversity.
For now I'll stay quiet and hear what's going on ;)
Regards!
Korzon
--
Ile zarabiasz? Wypelnij ankiete,
dowiesz sie jak zarabiac wiecej [ http://listaplac.onet.pl ]
Unfortunatly you can do this only on local databases. It would be very useful to also
request databases on different servers with one statement.
Philip
On Fri, 8 Jun 2001 17:19:34 -0600
Chris Bolt [EMAIL PROTECTED] wrote:
Try it =P (just don't forget the WHERE clause)
If you want to make
Wouter de Jong writes:
Hello,
I'm a database administrator for a hosting provider, and we have currently 2 SMP
MySQL-database servers. The one that is causing me problems, has at least 900
databases running on it. That's an dual PIII-550, with 1024MB memory, running RedHat
6.2, with Linux
I'm having a lot of difficulty trying to figure this out. I have a table
with a list of projects that I would like to arrange and view as a tree.
This is my table:
++--+--+-+-++
| Field | Type | Null | Key | Default | Extra
Hello Rolf,
I need the decoding option, since I need to have a password lookup
function...
Hmmm... offcourse, I *COULD* completely rewrite it, and instead of lookup up
a password, make it so that you can reset your password if you have verified
your email address or something.
However, I
I used the function password() if that helps but of course you can't
decode it.
- Original Message -
From: Leon Mergen [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, June 09, 2001 22:44
Subject: Re: Password encryption
Anyone has any idea how much this encryption method sucks
Description:
When I try and run mysqldump, I get a core dump.
How-To-Repeat:
it repeats anytime I try and run mysqldump.
Fix:
I have not found a fix yet.
Submitter-Id: submitter ID
Originator:Phillip Porch
Organization:
Phillip P. Porch [EMAIL PROTECTED] NIC:PP1573 finger for
I have compiled 3.23.38 without problems. I ran the test suite and mysqld
passed all 117 tests (I think it was 117). mysql client works fine but I
tried to use mysqldump and received a core dump (segmentation violation). I
also receive this if I try and run mysqlshow. As far as I can tell,
I have just started to use MySQL and like the ease in which it does it's one way
replication. However I have a situation that has multi-sites that would need to do
local entry to a database and then update the centreal database which could then
update those databases that don't have the
Hi All,
I've got this php script which has three times now halted with this error
message:
SELECT * FROM eZSession_Session WHERE Hash=''
Table 'eZSession_Session' was not locked with LOCK TABLES
After this Apache or MySQL has to be restarted to get contact with the
database.
I do not
Well, if you're using web pages, I've never thought much of passwords being
passed from one page to the next. Too much at risk of being sniffed out
each time a page is submitted to the server. I devised a way that creates a
random char string which changes each time a user logs on and that
Hi!
The Zend article is somewhat outdated, because it says that MySQL does not
support transactions.
The benchmark the Zend article is referring to is the TPC-C benchmark
and the AS3AP-IR-select benchmark financed by Great Bridge LLC, a company
selling support for PostgreSQL.
I have written
I have four tables, and I want to use bits of each one to display a list on
one page. I tried listing what I wanted out of each, but it seems that if
any one of the fields chosen is null, the whole row with that ID# is left
out. I thought perhaps a LEFT JOIN but don't know how to make that work
I had this problem the other day, and thought I would post this for the
archives.
Running MySQL 3.23.38 with apache 1.3.39 and PHP 4.05. the versions are
really
irrelevant. MySQL compiled fine, and the daemon was running fine on Linux
7.0. Or
it appeared to be. But when I tried to run mySQL from
You need to use the following when you build mysql to use all options.
CC=gcc CXX=gcc ./configure --prefix=/usr/local/mysql --enable-thread-safe-client
--with-berkeley-db=./bdb --with-innodb
Not that CXX is gcc and not the c++ compiler from SCO.
Good Luck,
--
Boyd Gerber [EMAIL PROTECTED]
Here is my db hierarchy:
Database: xtopsites
Table: Categories
idName
1Name1
2Name2
3Name3
4Name4
5Name5
6Name6
I would like the user to get to a sign up form and have all the names of the
categories displayed.is this possible to do using fetch_array? If it
After much searching the net trying to find a solution to the problem
of not being able to get mod_auth_mysql-2.20 to work as a DSO in
Apache 1.3.x (the problem being, on server start, Cannot load
/usr/local/apache/libexec/mod_auth_mysql.so into server:
Hello mysql,
I have FreeBSD 4.3, gcc 2.95.3
I do:
./configure
gmake install
I have error when I try to compile mysql:
gmake[1]: *** No rule to make target `my_init.c', needed by `my_init.lo'. Stop.
gmake[1]: Leaving directory `/c/mysql-3.23.38/libmysql'
gmake: ***
Hi
i'm newbie and have the problem -
sometimes after some INSERT and also sometimes just from nothing
simple SELECT begin work not properly - it returns not all rows in the table
that must.
in most cases FLUSH TABLES help, but yesterday it won't help - SELECT
continue return empty result,
Have a look at the PHP mysql_fetch_array and mysql_fetch_row functions and
associated documentation...
?php
//assuming the db is already connected
$query = select id,name from Categories;
$res = mysql_query($query,$dbh) or die (bad query);
while($row = mysql_fetch_array($res)) {
echo
On 10-Jun-01 All wrote:
Hello mysql,
I have FreeBSD 4.3, gcc 2.95.3
I do:
./configure
gmake install
I have error when I try to compile mysql:
gmake[1]: *** No rule to make target `my_init.c', needed by `my_init.lo'.
Stop.
gmake[1]: Leaving directory
I recently downloaded the windows odbc client software such that I would
access mysql server (on linux) from a WinME laptop using Microsoft Access
(or whatever). After running the setup program, I went into Settings and
tried to add MySQL for ODBC sources, per the 'readme'. Well, there was no
Okay, to get mysql --port= to work with a forwarded port it's also
necessary to specify the host name as the external name rather than the
assumed localhost.
Doing that, I'm now seeing: ERROR 2013: Lost connection to MySQL server during query
after entering the password.
I'm trying to fix
Hello MySQLers:
Is there a way that I can make mysqldump output a row in a single line ?
The line is fairly long, and wraps to something like 20 lines or so,
due to one column that is a clob. Total there are 67K records.
I am trying to output mysqldump and then import into Oracle using
you can use fetch_array:
$data = mysql_query(select * from Categories);
$aux=select name=categorie;
while ($row = mysql_fetch_array($data)) {
$aux.=option value=,$row['id']..$row['Name']./option;
}
$aux.=/select;
echo $aux;
this code will print in html a combobox with the options, in php,
Hello,
I was wondering if you could help me on a problem I am having with mySQL.
I've installed MySQL (Win32) on F:\mysql. I've placed my.cnf on C:\. This is
the contents of my.cnf:
---
# Example mysql config file.
# Copy this file to c:\my.cnf to set global options
#
# One can use all
Brian Walker ([EMAIL PROTECTED]) writes:
010609 14:40:21 Do you already have another mysqld server running on port:
3306
?
The manual said to try to telnet in on port 3306 so I did that and got this:
[root@www data]# telnet www.sfslsports.com 3306
Trying 209.15.183.134...
Connected
Doing that, I'm now seeing: ERROR 2013: Lost connection to MySQL
server during query after entering the password.
The problem above shouldn't be master.info related.
Does the master.info file on the slave contain accurate info?
Removing master.info and restarting the slave server
Well I fixed that part so now the file looks like this:
html
head
body
?php require('../common.php');
connectdb();
mysql_select_db(xtopsites);
$validated=1;
$sql = select id, siteurl, sitename, from sitesats where validated = '$validated';
$r = mysql_query($sql);
$numrows = mysql_num_rows($r);
On 10-Jun-01 Dawn H wrote:
Here's what I currently have that doesn't work:
Ahh. 'it doesn't work.'
As in: it returns a error ? or doesn't display you what you want ?
BEGIN QUOTE-
$sth=$dbh-prepare (SELECT listing.id, pictures.thumb_1,
description.mls,
listing.p_city,
Have you tried ismchk/myismchk?
- Original Message -
From: Artem Krsheminsky [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, June 11, 2001 2:01
Subject: simpe select return not all rows - and flush
Hi
i'm newbie and have the problem -
sometimes after some INSERT and also
Howdy Hi,
Any word on how to select distinct database records using PHP code?? Thanks in
advance...
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the
On Sun, Jun 10, 2001 at 08:18:52PM -0500, Whit Blauvelt wrote:
Doing that, I'm now seeing: ERROR 2013: Lost connection to MySQL
server during query after entering the password.
The problem above shouldn't be master.info related.
Right. That was a client error. The server is the only
On 11-Jun-01 Dawn H wrote:
Ahh. 'it doesn't work.'
As in: it returns a error ? or doesn't display you what you want ?
Both. I've fiddled with it doing this and that and haven't been able to get
it to display correctly.
do the cut-n-paste thingy get your query correct first; sweat display
Hello.
On Sun, Jun 10, 2001 at 02:56:45PM +0200, [EMAIL PROTECTED] wrote:
I've got this php script which has three times now halted with this error
message:
SELECT * FROM eZSession_Session WHERE Hash=''
Table 'eZSession_Session' was not locked with LOCK TABLES
Usually, one gets this
Hello.
On Sun, Jun 10, 2001 at 07:13:11PM -0700, [EMAIL PROTECTED] wrote:
Hi, I was reading a book on MySQL/PHP, and it was talking about the lack
of certain features. My question is, what features does MySQL lack yet,
and are there any plans to include those features?
You may want
I am on 3.27.37. My mysqldump looks something like this:
mysqldump -T
/data/home/pmehta/mysql --no-create-info --fields-enclosed-by='' --fields-t
erminated-by=',' --opt mydb MyTable
- Original Message -
From: Ed Carp [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent:
Hi.
On Mon, Jun 11, 2001 at 04:18:19AM +0200, [EMAIL PROTECTED] wrote:
Hello.
On Sun, Jun 10, 2001 at 07:13:11PM -0700, [EMAIL PROTECTED] wrote:
Hi, I was reading a book on MySQL/PHP, and it was talking about the lack
of certain features. My question is, what features does MySQL
At 09:54 PM 6/10/2001 -0400, Jeffrey L. Fitzgerald wrote:
Howdy Hi,
Any word on how to select distinct database records using PHP code?? Thanks in
advance...
mysql_query(SELECT DISTINCT * FROM BLAH;);
-
Before posting,
Hi,
Yes, I have done it. You need to connect to your MySql database via ODBC.
Setup your ODBC datasource for your database and set the Target Server in
ERwin to ODBC.
Regards,
Michael
Is it possible to use ERwin from Logic Works (www.logicworks.com) with
MySQL
?
How ?
For the sake of
Need a little assistance. I've looked through the current MySql manual, but
I can't find any information concerning my questions.
My MySql server keeps crashing, or that's what my host server tells me. He
claims that my scripts are crashing MySql. However, when I look at the
MySql error log,
http://marc.theaimsgroup.com/?l=mysqlr=1w=2
Is there a list archive for this list? I have a few questions which I am
sure are asked all the time. But For the life of me I can't seem
to find the
answer's in the documentation at mysql.com. Thx,
Try echo(mysql_error()); after each call to mysql_query()
The following code doesn't insert and update info in the db for
some reason:
(clipped)
Thanks in advance.
-
Before posting, please check:
I can't help with the php...but I do know that insert statement is invalid.
You need something more like
$sql = insert into sitesats (id, areview, apositive, anegative, arate)
values('$id', '$areview', '$apositive', '$anegative');
And I assume the update is trying to update the just-inserted
This doesn't make much sense to me. By host server you mean your ISP?
If so how are you able to view the logs? Are you DB admin or something? By
the looks, someone is able to get in and shut it down. This can only happen
with admin rights or mysql server wasn't set up correctly in the first
Greetings:
Full source is at http://az.dedserius.com/main.c
I'll reduce this to one problem at a time and see if I can make some progress,
that way.
With the following code, running with -psecret works, but, --password doesn't.
Anyone ran into this?
begin code
struct option long_options[] =
46 matches
Mail list logo