On Tue, Oct 30, 2001 at 11:31:12AM -0800, William R. Mussatto wrote:
> Thanks but it doesn't work...
>
> Below is the extract of the configuration file it does not matter whether
> I include spaces around the "=" or not, starting using mysql_safe results
> in a "failed" There is no entry in th
Gisella,
.43 only prints info when there is MySQL server
activity. I have changed it to .44 so that it
always prints info every 15 seconds, regardless of
server activity.
If you want to study locks, then
innodb_lock_monitor
is the right tool.
About your other question, I am afraid that
timest
hi,
I have a clarification from u. Actually I am
using MySQL 3.23.39 version. Does MySQL 4.0 or any
latest version supports subQueries / subQueries with
IN operator. How do I come over this problem. Plase do
suggest if any alternatives available. Expecting great
response from u.
Awaiting q
What about the binary log files? Isn't there something that can be done
this way?
- Original Message -
From: "Russell Miller" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, October 30, 2001 10:11 PM
Subject: Re: WELCOME to [EMAIL PROTECTED]
> If you did
hi all,
Let me to introduce somethings first, we use mysql for a logging system
and take about max 150 000 records hourly. And we need to take a period of
data for analyzing.
>Well, how many records are in the table? How many would be returned by the
>query you present?
The previous table
MySQL is working perfectly on my Linux box. I downloaded MySQLGUI, and ran it.
It connects fine, I can view a table, etc.. But, when I click on the
GRANT/REVOKE menu, it hangs on the Windows side. When I go to the Linux side and
issue SHOW PROCESSLIST, there are as many processes connected as I ha
If you did not have any backups, then you're probably SOL. ALWAYS MAKE
BACKUPS.
--Russell
- Original Message -
From: "Kelvin Cheong" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, October 30, 2001 11:15 PM
Subject: Re: WELCOME to [EMAIL PROTECTED]
> dear all,
>
> is their a
dear all,
is their anyway at all to undo a direct UPDATE fromt he mysql prompt? i did not have
any backups.
desperately need a reply.
thanks.
kelvin.
-
Before posting, please check:
http://www.mysql.com/manual.php (the
On Tue, Oct 30, 2001 at 10:50:50AM -0500, C. Williams wrote:
>
> Sorry, semantic miscommunication. It's a heavily used table and the
> performance of other queries done during the mass deletion slows,
> which is a problem since this is a near-realtime system where delays
> in queries cause perform
On Tuesday 30 October 2001 20:44, Joe Fan wrote:
> What GUIs exist for MySql and which is the best to use?
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
Notice it says Please check lists.mysql.com
My current web hosting company (www.ehost.com) does not support MySql.
Is there a way that I can install within my own CGI-bin library? If not,
are there any other open-source RDBMS available that would work
independently of hosting servic?
Thanks,
Joe
What GUIs exist for MySql and which is the best to use?
Come visit http://www.joe-fan.com For the Fans, by the Fans !
-
Before posting, please check:
http://www.mysql.com/
Greetings:
Not really, but for those unfortunate enough to have a server they can't get
time synchronization via xntp/ntp to work, here's a simple bash script you can
use to keep the machine's time current:
#!/bin/sh
#Tue Oct 30 21:12:14 MST 2001: Van; ntpdate doesn't want to build on this
machi
At 2:43 AM + 10/31/01, Curtis Gordon wrote:
>I have a query where I am inserting a record into a db, and would
>like to have the primary key
>value returned, I have been reading and reading, but I can't seem to find
>any mention of this. I would think that this would be useful. Can anybody
>h
Hi,
I just installed the binary version of mysql
(mysql-3.23.38-dec-osf5.1-alphaev6) for Tru64. It installed and ran fine,
but I ran into a problem when setting it up as a highly available
application through CAA. Setting the application up seemed
straightforward, it registered, but ne
Hello,
I have the Mysql 3.23.27-beta version installed on my Windows NT PC and I am able to
create the database and query from the command line and from a Perl script. I was
reading the readme file which comes with the installation about a GUI tool for Win32
version. I am typing an excerpt from
I have a query question that I can't seem to find an answer to. Perhaps
someone can suggest something. I will try to explain what I am trying to do:
I have what is essentially 2 queries that I would like to sum into the same
result set. I do not know if it is possible, but it would make my l
I'm curious. Will adding a timestamp field into various tables
that may cause deadlock, prevent the deadlock from happening?
Thanks,
Gisella
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Hello,
I'm running into the "100" deadlock error, so I would like to trace the
problem.
Server: mysqld-max-nt 3.23.43
myodbc 2.50.39
Server application that connects to mysqld is multithreaded.
Mysqld has been installed as a service.
I stopped it. Then I issued the following command:
>my
I have a query where I am inserting a record into a db, and would like to
have the primary key
value returned, I have been reading and reading, but I can't seem to find
any mention of this. I would think that this would be useful. Can anybody
help?
__
Hi!
Is there a way to create a temp table and _not_ have it logged to the
binlog? We use temp tables only to increase the speed of certain types of
selects (we have discussed the type of select that causes this problem on
this list already), and don't want them rerun when we might have to to a
re
If this hasn't been answered yet, the PC speaker on/off switch is usually an
option in your system BIOS. I had the same problem on my Dell PE 2550 dev
server until I switched it in setup. The problem with cutting the cable is
that some motherboards have the speaker built in... n wires. :-)
#
Some programming language in some platform could compare this string
numeric. But, Why not use it in real numeric value (no quote) or use
convert method before compare?
SF
At 13:24 30/10/2001 +0900, Joel Rees wrote:
>I don't have any experience with SQL, but I'm thinking that zero filling
>bo
Hey now, why would you want to turn it off, After all its a `feature'
[EMAIL PROTECTED] wrote:
>
> Back a few years there was a nasty little virus that played Chops on your
> WinDoDie box's and we had to unplug the PC Speakers on a couple dozen
> becuase there was not fix for it at the time.
At 7:46 PM -0600 10/30/01, Camilo Rostoker wrote:
>Hi.
>
>I have a query that determines the ranking of teams in a league by
>several calculations on the table. Below is the query:
>
>SELECT TeamName,TeamWins,TeamLosses,TeamSpirit,
>(TeamSpirit/(TeamWins+TeamLosses)*100) AS AvgSpirit,
>((TeamWins
I'm new to this list, and new to mySQL but used SQL with DB2 years ago, so
here goes my try at answering this: have you tried select count(*) as
your_variable_name From etc .etc.etc.
Anne
- Original Message -
From: "Mark Worsdall" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROTECTED]>
Sent
Hello all,
I have a problem. I am able to get a copy of a text file which resides
on another server for a task I am completing. What I need to do is
import this text into a database table on a nightly basis, and I am
trying to set this up via PHP so it is all automated. I have one
problem tho
Hi.
I have a query that determines the ranking of teams in a league by
several calculations on the table. Below is the query:
SELECT TeamName,TeamWins,TeamLosses,TeamSpirit,
(TeamSpirit/(TeamWins+TeamLosses)*100) AS AvgSpirit,
((TeamWins*2)-TeamLosses) AS TeamPoints
FROM Teams_1
WHERE DivisionN
Hi,
I'm newly acquinted with MySQL today, and made a very first attempt to
create a table with MySQLGUI. However, the "Commands-Tables-Create Tables"
menu option doesn't seemed implemented -- nothing happens. Is this something
that hasn't been implemented, or am I not using the tool correctly? I'
At 12:54 AM + 10/31/01, Mark Worsdall wrote:
>Hi,
>
>When I do the following in a perl script I get back all the records I want:
>
>$prep = "SELECT id,name FROM go.objectives WHERE subjects_id='1' AND
>subjectHeadings_id='2' ORDER BY displayOrder";
>
>$sth = $dbh->prepare($prep);
>
>$sth->exe
At 12:43 AM + 10/31/01, Mark Worsdall wrote:
>Hi,
>
>I want to alter this statement so it returns the number of records.
>
>$prep = "SELECT COUNT(*) FROM go.objectives WHERE subjects_id='1'
>AND subjectHeadings_id='2' ORDER BY displayOrder";
>
>$sth = $dbh->prepare($prep);
>
>$sth->execute;
>
MYSQL>
>>Hi!
>>
>>When i type: mysql -u franck -p then my password, it's ok.
>>
>>My machine's name is r-lx-collineau
>>
>>When i type mysql - h r-lx-collineau -u franck -p then my password, i have
>>this message:
>>"ERROR 1130: host 'r-lx-collineau' is not allowed to connect to this MySQL
>>serve
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I dont have hard quota's, It is a script that looks at the userdir
and tells them if they are over the limit, then if they are xMb over
the limit the admin is notified.
Yes, I could modify this script, but I would rather have all the
user's data in
Have you tried using the $rows = $sth->rows() after you execute to get the total
rows returned?
>>On Wed, 31 Oct 2001 00:43:00 +, Mark Worsdall <[EMAIL PROTECTED]> wrote:
>>Hi,
>>
>>I want to alter this statement so it returns the number of records.
>>
>>$prep = "SELECT COUNT(*) FROM go.o
If you want your backends to crash when a user reaches their quota, that
would be an amaizing idea. I doubt that is actually intended though. How
about a simple script which will just look at the size of the database file,
or look at the size of the data in the database [edit the new phpMyAdmin
> But when I add in the LIMIT statement it returns no records
>
> $prep = "SELECT id,name FROM go.objectives WHERE subjects_id='1' AND
> subjectHeadings_id='2' LIMIT 1,5 ORDER BY displayOrder";
>
> $sth = $dbh->prepare($prep);
>
> $sth->execute;
>
>
http://www.mysql.com/doc/S/E/SELECT.html
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
How to I put a users MySQL data into thier home dir? I have tried
moving thier database over and sym-linking it:
mv /var/lib/mysql/userdb /home/user
ln -s /home/user/userdb /var/lib/mysql/userdb
But mysql doesnt see the database.
I also tried to
Hi,
When I do the following in a perl script I get back all the records I
want:
$prep = "SELECT id,name FROM go.objectives WHERE subjects_id='1' AND
subjectHeadings_id='2' ORDER BY displayOrder";
$sth = $dbh->prepare($prep);
$sth->execute;
But when I add in the LIMIT statement it returns
I have a perl script that selects users dial-up usage based on month/year -
It works fine, but if the selected month/year does not contain any usage
data, the only way I can check is with the following code:
# $sth->execute() # Execute the query
$my_result = $sth->execute()
Hi,
I want to alter this statement so it returns the number of records.
$prep = "SELECT COUNT(*) FROM go.objectives WHERE subjects_id='1' AND
subjectHeadings_id='2' ORDER BY displayOrder";
$sth = $dbh->prepare($prep);
$sth->execute;
So what I need to do is add the COUNT statement into the ab
On Tue, 30 Oct 2001, Hamid Amjadi wrote:
> When i try to run bin/safe_mysqld &
>
> i am getting the following error:
>
>
> /usr/lib/libcocket.so.2 not found.
>
>
> operating system: SCO unix version 3.2V5.0.6
> mysql version: 3.23.43-pc-sco3.2v5.0.6-i386
This is because there was a socket fix on
I don't believe that the table is corrupt, I'm more inclined to believe
your zero theory.
create table crashme (a int(10) not null auto_increment primary key) type=isam;
insert into crashme set a=0; # actually inserts a = 1;
update crashme set a=0 where a = 1;
insert into crashme set a=0; # a
When i try to run bin/safe_mysqld &
i am getting the following error:
/usr/lib/libcocket.so.2 not found.
operating system: SCO unix version 3.2V5.0.6
mysql version: 3.23.43-pc-sco3.2v5.0.6-i386
please advise how and where i can get this library.
thanks
---
Back a few years there was a nasty little virus that played Chops on your
WinDoDie box's and we had to unplug the PC Speakers on a couple dozen
becuase there was not fix for it at the time. Or was it cause they where to
cheap..hmm.
>> Does anyone know how to turn that annoying beeping off in th
We used to use phpmyadmin, but moved on to mysqltool last January. You
might want to check it out.
http://dajoba.com/projects/mysqltool/
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
doesn't windows have some control panel that lets you turn sounds off and
on for certain functions and/or events?
On Tue, 30 Oct 2001, Paul DuBois wrote:
> >Paul DuBois wrote:
> >
> >>At 4:34 PM -0500 10/30/01, Benjamin J Pracht wrote:
> >
> >
> >>>Does anyone know how to turn that annoying b
From: Patrick Nelson <[EMAIL PROTECTED]>
> RH 6.2 with the following MySql stuff installed (by rpm)
Unfortunately, I could only find 'bench' in RPM. Since that requires me to install the
package (which I'm not willing to do without know what's going to happen), I can't
continue. I appoligize.
Ken Abe writes:
> I am a student at NYU trying to install mysql on our department
> machines. The fact
> that I do not have root priviledges is probably part of the issue, but I
> followed
> the instructions regarding installation as a normal user.
A bit further down I see that you're install
>>> At 4:34 PM -0500 10/30/01, Benjamin J Pracht wrote:
Does anyone know how to turn that annoying beeping off in the text mode
utilities such as mysql.exe?
Ben Pracht
>>>
>>> I don't believe mysql.exe has ever beeped at me. What are you doing
>> > when it beeps at you?
I fig
>Paul DuBois wrote:
>
>>At 4:34 PM -0500 10/30/01, Benjamin J Pracht wrote:
>
>
>>>Does anyone know how to turn that annoying beeping off in the text mode
>>>utilities such as mysql.exe?
>
>
>>I don't believe mysql.exe has ever beeped at me. What are you doing
>>when it beeps at you?
>
>
>Wheneve
You might have a corrupt table. For 3.22 format, you'll need to use
isamchk, I think... It's been a long time since I've worked with ISAM
tables.
Now that I look closer at your email, though, it is probably the fact
that your id's start with 0, not 1. The alter table actually dumps the
data in
> Does anyone know how to turn that annoying beeping off in the text mode
> utilities such as mysql.exe?
Cut the speaker cable.
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
--
At 3:43 PM -0700 10/30/01, [EMAIL PROTECTED] wrote:
>Correct me if I am wrong. You are using Linux correct? I seen your post
>before but was leaving for awhile and could not help.
If he's using mysql.EXE, he's no doubt using Windows. I believe you're
correct that it's not a mysql issue, though.
> I'm using the following query
>
> SELECT DISTINCT a.addrdsp,a.listdate,a.solddate,a.lpricea,a.sprice
> FROM archive a, archive b
> WHERE a.status='s' AND a.addrdsp IS NOT NULL
> AND a.addrdsp = b.addrdsp AND a.solddate < b.solddate
> AND date_add(a.solddate, interval 1 year) > b.solddate
> As subject what do I do if I want a field called (for example)
> Competition ID?
>
> I have looked (http://www.mysql.com/doc/C/R/CREATE_TABLE.html) but to no
> avail.
Section 6.1.2 is probably closer to what you need.
> I have tried enclosing it in "quotes" and 'single quotes' but neither
> w
Hello,
I'm the Associate Publisher with New Riders Publishing and I've recently
published a book with Paul DuBois titled "MySQL and Perl for the Web." (You
may know Paul's work from his previous book with us "MySQL.")
Earlier this year we also published "MySQL: Building User Interfaces" by
Matt S
Correct me if I am wrong. You are using Linux correct? I seen your post
before but was leaving for awhile and could not help.
Using the Linux theroy: Everytime you use anything you still get a beep
correct?
If so, you have sound enabled on all system functions therefore when you
open close or in
David Ayliffe wrote:
> As subject what do I do if I want a field called (for example)
> Competition ID?
> I have looked (http://www.mysql.com/doc/C/R/CREATE_TABLE.html) but to no
> avail.
> I have tried enclosing it in "quotes" and 'single quotes' but neither
> work. Can this be done?
I beli
Paul DuBois wrote:
> At 4:34 PM -0500 10/30/01, Benjamin J Pracht wrote:
>> Does anyone know how to turn that annoying beeping off in the text mode
>> utilities such as mysql.exe?
> I don't believe mysql.exe has ever beeped at me. What are you doing
> when it beeps at you?
Whenever there's
Hello David!
> As subject what do I do if I want a field called (for example)
> Competition ID?
>
> I have looked (http://www.mysql.com/doc/C/R/CREATE_TABLE.html) but to no
> avail.
> I have tried enclosing it in "quotes" and 'single quotes' but neither
> work. Can this be done?
Wrong doc. :) T
At 5:16 PM + 10/30/01, David Ayliffe wrote:
>As subject what do I do if I want a field called (for example)
>Competition ID?
>
>I have looked (http://www.mysql.com/doc/C/R/CREATE_TABLE.html) but to no
>avail.
>I have tried enclosing it in "quotes" and 'single quotes' but neither
>work. Can th
At mysql site here (down in the Linux downloads section):
http://www.mysql.com/downloads/mysql-3.23.html
here is the link:
http://www.mysql.com/Downloads/MySQL-3.23/MySQL-bench-3.23.43-1.i386.rpm
RH 6.2 with the following MySql stuff installed (by rpm)
MySql 3.23.43
MySql Client 3.23.43
MySql Sha
I'm using the following query
SELECT DISTINCT a.addrdsp,a.listdate,a.solddate,a.lpricea,a.sprice
FROM archive a, archive b
WHERE a.status='s' AND a.addrdsp IS NOT NULL
AND a.addrdsp = b.addrdsp AND a.solddate < b.solddate
AND date_add(a.solddate, interval 1 year) > b.solddate
ORDER BY a.add
At 4:34 PM -0500 10/30/01, Benjamin J Pracht wrote:
>Does anyone know how to turn that annoying beeping off in the text mode
>utilities such as mysql.exe?
>
>Ben Pracht
I don't believe mysql.exe has ever beeped at me. What are you doing
when it beeps at you?
I've recently upgraded from 3.22.32 to 3.23.43 and I'd like to convert my
tables to the MyISAM format.
According to the docs regarding the upgrade
(http://www.mysql.com/doc/U/p/Upgrading-from-3.22.html),
this is the procedure:
ALTER TABLE table_name TYPE=MyISAM
On one of my tables, I receive t
>Description:
I have found some inconsistencies (one may call them bugs ;-) in the
current MySQL 3.23 version. I tested this on Linux and Solaris 2.8
so this should not be platform specific...
The result differs, if one uses the constant value "-00-00" or
To: [EMAIL PROTECTED]
Subject: installation problem[50 character or so descriptive subject here
(for reference)]
Hi,
I am a student at NYU trying to install mysql on our department
machines. The fact
that I do not have root priviledges is probably part of the issue, but I
followed
the instructi
download phpmyadmin from sourceforge
-Original Message-
From: Gonzalo Valenzuela [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 30, 2001 2:56 PM
To: Todd Williamsen; 'Gonzalo Valenzuela'; 'Ing. Gustavo Edelstein';
[EMAIL PROTECTED]; 'Bennett Haselton'
Subject: RE: web-based interface f
As subject what do I do if I want a field called (for example)
Competition ID?
I have looked (http://www.mysql.com/doc/C/R/CREATE_TABLE.html) but to no
avail.
I have tried enclosing it in "quotes" and 'single quotes' but neither
work. Can this be done?
Thanks lots
David Ayliffe
ICQ# 125646758
David,
First of all, please post to the list in the future. I'm not always
available to help with problems, and others may benefit from the
problem/solution.
I would change your query to the following:
SELECT DISTINCT a.addrdsp,a.listdate,a.solddate,a.lpricea,a.sprice
FROM archive a, archive
On 30-Oct-2001 Matthew Walker wrote:
> Does anyone see anything wrong with the following code/query syntax? I'm
> using the PEAR DB class for PHP. When this runs, it correctly inserts
> the row to the table, but is failing to retrieve the last_insert_id().
>
> function StartOrder()
> {
> globa
Does anyone know how to turn that annoying beeping off in the text mode
utilities such as mysql.exe?
Ben Pracht
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
On Tue, 2001-10-30 at 13:10, Bennett Haselton wrote:
> I'm creating a database where one of the tables stores data about news Web
> sites, and I'm using the URL of the site as a primary key field. This
> field value might change occasionally. I'm wondering if this is bad
> practice, especiall
I'm looking for instructions on installing the mysql GUI interface on a unix system.
Is that possible? Thank you,
Nathan
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.my
here's my code that is working perfectly
$Conn is the connection object
$sql = "INSERT INTO dp_survey_question (survey_id,question_type_id,question_text)
VALUES
(" . $s_id . "," . $qt_id . "," . $Conn->quote($q_text) . ")";
$result = $Conn->query($sql);
if (DB::isError($result)) {
die( $re
rc wrote:
> Mysql_Insert_ID($dbhandle->connection);
>
> gets the last id of the last insert statement -
> if you do any db activity
> after the insert, this won't work.
In other words:
> $res = $dbhandle->query("select
last_insert_id()");
> $dbhandle->query("UNLOCK TABLES");
> $res
> Hello,
> I'm losing precision when I send a double to a mysql database from a Java
> program trough JDBC.
> Code:
> stmt.setDouble(i+3,((Double)value).doubleValue());
>
Ok, the problem was solved after I updated my MM.MySQL driver to the newest
version. Here you can get it:
http://www.then
funny that. i'm using PEAR, and that is working for me perfectly.
have you tried it?
On Tue, 30 Oct 2001, Matthew Walker wrote:
> That won't work. The connection is being made through the PEAR DB class,
> so the standard PHP functions won't work. (And yes, I did just test it.)
>
> -Origin
That won't work. The connection is being made through the PEAR DB class,
so the standard PHP functions won't work. (And yes, I did just test it.)
-Original Message-
From: rc [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 30, 2001 1:58 PM
To: Matthew Walker
Cc: [EMAIL PROTECTED]
Subjec
ok, ok, ok.
thanks...
At 02:53 p.m. 30-10-01 -0600, Todd Williamsen wrote:
>No PHPadmin has two versions PHP3 and PHP
>
>Thank you,
>
>Todd Williamsen, MCSE
>home: 847.265.4692
>Cell: 847.867.9427
>
>
>-Original Message-
>From: Gonzalo Valenzuela [mailto:[EMAIL PROTECTED]]
>Sent: Tue
Responding to my own email... sheesh. It's just that kinda day. :>
I found reference in the archives to what seems to be the same problem.
Monty replied to a thread entitled "I got it hanged !" on 2001-07-17, and agreed that
it shouldn't be happening. Unfortunately, I can't find a solution in
Mysql_Insert_ID($dbhandle->connection);
gets the last id of the last insert statement - if you do any db activity
after the insert, this won't work.
On Tue, 30 Oct 2001, Matthew Walker wrote:
> Does anyone see anything wrong with the following code/query syntax? I'm
> using the PEAR DB class f
where I can find it? for php4?
Thanks
At 02:53 p.m. 30-10-01 -0600, Todd Williamsen wrote:
>No PHPadmin has two versions PHP3 and PHP
>
>Thank you,
>
>Todd Williamsen, MCSE
>home: 847.265.4692
>Cell: 847.867.9427
>
>
>-Original Message-
>From: Gonzalo Valenzuela [mailto:[EMAIL PROTEC
You can download either, php or php3.
>>On Tue, 30 Oct 2001 14:47:01 -0600, Rick Emery <[EMAIL PROTECTED]> wrote:
>>I use phpmyadmin on a system with PHP4
>>
>>-Original Message-
>>From: Gonzalo Valenzuela [mailto:[EMAIL PROTECTED]]
>>Sent: Tuesday, October 30, 2001 2:39 PM
>>To: Ing
No PHPadmin has two versions PHP3 and PHP
Thank you,
Todd Williamsen, MCSE
home: 847.265.4692
Cell: 847.867.9427
-Original Message-
From: Gonzalo Valenzuela [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 30, 2001 2:39 PM
To: Ing. Gustavo Edelstein; [EMAIL PROTECTED]; Bennett Hasel
Does anyone see anything wrong with the following code/query syntax? I'm
using the PEAR DB class for PHP. When this runs, it correctly inserts
the row to the table, but is failing to retrieve the last_insert_id().
function StartOrder()
{
global $dbhandle;
global $OrderID;
global $CustomerID
I use phpmyadmin on a system with PHP4
-Original Message-
From: Gonzalo Valenzuela [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 30, 2001 2:39 PM
To: Ing. Gustavo Edelstein; [EMAIL PROTECTED]; Bennett Haselton
Subject: Re: web-based interface for manipulating MySQL tables?
But PhpMy
But PhpMyAdmin only use php3
At 12:39 p.m. 30-10-01 -0300, Ing. Gustavo Edelstein wrote:
>If you have PHP installed, try phpMyAdmin. It's a very good tool, easy use
>and installing.
>Regards.
>
>Ing. Gustavo A. Edelstein
>Tech. Mgr.
>Equiplus Argentina S.A.
>__
Hi!
> "R" == R Talbot <[EMAIL PROTECTED]> writes:
>> The following configuure line should have a big likehood to work:
>>
>> rm config.cache
>> CC=gcc CFLAGS="-O3" CXX=gcc CXXFLAGS="-O3 -felide-constructors -fno-exceptions
>-fno-rtti" ./configure --prefix=/usr/local/mysql --with-low-mem
Use a join query, rather than separate single-table queries:
SELECT a.*, n.url
FROM articles a, news_sites n
WHERE a.news_site_key = n.news_site_key;
-- Greg Johnson
-Original Message-
From: Bennett Haselton [mailto:[EMAIL PROTECTED]]
Se
If you have PHP installed, try phpMyAdmin. It's a very good tool, easy use
and installing.
Regards.
Ing. Gustavo A. Edelstein
Tech. Mgr.
Equiplus Argentina S.A.
__
Visit us On Line at www.equiplus.com
Email addresses:
Operations: [EMAIL PROTECTED]
Consulting: [
Hi all,
mysqld seems to 'hang' under certain circumstances when I'm doing a fairly large ALTER
TABLE -- adding or dropping an Index, repair etc. The server and client are still
'alive' and I can do simple things like show processlist, or selecting a count(0) from
another table, but other selec
I'm creating a database where one of the tables stores data about news Web
sites, and I'm using the URL of the site as a primary key field. This
field value might change occasionally. I'm wondering if this is bad
practice, especially since foreign keys in other tables might point to the
news
Thanks but it doesn't work...
Below is the extract of the configuration file it does not matter whether
I include spaces around the "=" or not, starting using mysql_safe results
in a "failed" There is no entry in the error log. Commenting out the
line results in a successful restart. I am p
Mario,
Can you send a sample of the code that is causing this to happen? I have a couple
ideas, but I would need to see the actual code to be sure.
You mention a "probable cause". Have you done anything to verify this (like get rid
of the update and see what happens)? When you run the same
If possible, update your UNIX DB to 3.23, and convert the tables to MYISAM -
the tables can then be freely copied between platforms.
Alternatively, you could use ODBC to update the UNIX tables directly.
Otherwise, you would have to use mysqldump to copy the data to windoze and
back again, assumi
From: Patrick Nelson <[EMAIL PROTECTED]>
> Trying to get the benchmark 3.23.43 installed but it says I need
> MYSQL-DBI-perl-bin which I can't seem to locate.
Hmm, I couldn't find that either. Can you tell me where you've found "benchmark", I'll
have a look at it and see if I can answer your qu
Humm
Well could you make your unix box master and you microsoft box slave?
So letting one update the other..???
Or just run CDE?
Simon
-Original Message-
From: Ryan Winterbourne [mailto:[EMAIL PROTECTED]]
Sent: 30 October 2001 18:59
To: [EMAIL PROTECTED]
Subject: Can you
On Tue, 30 Oct 2001, M. A. Alves wrote:
> I seem to be hitting a ceiling in MYSQL_RES (mysql_use_result). I select
> 2 or 3 items but only 2295 are returned. What might be the cause
> of this?
The probable cause is I was accessing the same table at the same time (but
thru different conn
I was wondering if there is a way to download the MySql database hosted on a
UNix machine running Solaris, to my Windows computer and be able to view and
modify it from there? The Solaris version has .ISD and .ISM files wheras
Windows has .MYD and .MYI files. Any help would be greatly appreciat
1 - 100 of 146 matches
Mail list logo
