Agreed, I am not calling mysql_store_result(). I attempted to add
my_free() but the function does not seem to exist, it is also not listed
in the API docs for the c api. As such it still seems that there should
be no leak, but yet I do get one. Thanks for the idea anyway Chris,
maybe you can
Hi Ron,
My Scenario is if two users open an existing record with data already in
the fields. They then add
some information to the end of a field with data.
Now when they click update the last user/browser gets written to the db,
where the first users data is over written.
I thought
Any idea what is wrong with the following:
SELECT * From articles ORDER BY EntryDate DESC
LIMIT 1,10
WHERE SectionID=1
I want to return all articles with a particular SectionID, ordered by
EntryDate and then I want to pick the start point and list the next 10 from
that. Obviously in the final
I think it should be:
SELECT * FROM articles
WHERE sectionID=1
ORDER BY Entrydate Desc
LIMIT 1,10
Terry
--Original Message-
Any idea what is wrong with the following:
SELECT * From articles ORDER BY EntryDate DESC
LIMIT 1,10
WHERE SectionID=1
I want to return all
Ian
Check the documentation for the correct SELECT SYNTAX :
http://www.mysql.com/doc/en/SELECT.html
Your WHERE clause should be before ORDER BY
Freddie
-Ursprüngliche Nachricht-
Von: Ian O'Rourke [mailto:[EMAIL PROTECTED]
Gesendet: Sonntag, 18. Januar 2004 12:22
An: [EMAIL PROTECTED]
From: Terry Riley [EMAIL PROTECTED]
I think it should be:
SELECT * FROM articles
WHERE sectionID=1
ORDER BY Entrydate Desc
LIMIT 1,10
Terry
That would be correct. I'll have to watch out for that ordering in the
future. What confused me is if you just have the Select, Order By and Where
SELECT *
From articles
WHERE SectionID=1
ORDER BY EntryDate DESC
LIMIT 1,10
the where clause should be after the table name
HTH
Peter
-Original Message-
From: Ian O'Rourke [mailto:[EMAIL PROTECTED]
Sent: 18 January 2004 11:22
To: [EMAIL PROTECTED]
Subject: SQL Query
Any idea what
My guess will be that the where clause is misplaced.
Try
SELECT * From articles
WHERE SectionID=1
ORDER BY EntryDate DESC
LIMIT 1,10
PLS read URL: http://www.mysql.com/doc/en/SELECT.html
On that page it is stated that: All clauses used must be given in exactly the
order shown in the syntax
Hi everybody,
I dont know, if it's been asked before, I was looking for the syntax to fetch dynamic
no of column, which are actually the record values. I dont know, if it's possible with
mysql as it doesn't yet provide sub-query feature (prod ver).
I need to select a column's value as
On Sun, 18 Jan 2004, Nitin Mehta wrote:
I need to select a column's value as different columns and other fields grouped by
those values.
I want to select distinct values of reseller column as individual columns and other
data grouped on these values.
Since the approach of tables usually
On Sat, 17 Jan 2004, Mike Mapsnac wrote:
Is it possible to find out when the table was created? How to get information about
the table?
You can use the unix command `stat`, the last of the 4 dates will be the
creation date (in the order of Last Accessed, Last Modified, Last Inode
The emails have started to come today.
I did several things, but don't know which one of them caused the emails to
start coming in again :
I reported the problem on the 'contact us' page on www.mysql.com
I re-subscribed all my lists. When the confirmation emails came today and I
clicked on the
I have a series of article in my database and I want to select them by month
and year. So I want a Selection List to hold values like January, 2004,
etc - put it should really select some sort of key like 01-2004. I should
then be able to use that key to filter articles by 01-2004.
I'm just a bit
Hi,
I've inserted the following currecy sumbols in my table (structure mentioned below).
All symbols are displayed properly when I do select, expect for the Euro symbol, which
just shows a question mark (?). Any idea why is it behaving like that? I am using
MySQL 4.0.17 on Windows XP Pro. My
Ian-
The first step would be to insert date/time stamp into each of your records
during Insert/Update operations. Here is a link how to insert a DATE/TIME
into a MySQL Column
http://www.php-scripts.com/php_diary/070700.php3
Cheers,
Martin Gainty
001-617-852-7822
- Original Message -
From:
Hello,
is there any use under FreeBSD 5.x for having MySQL compiled
WITH_LINUXTHREADS? I only have one processor (does it have
anything to do with that?), running 5.1, and 256MB of memory.
Are there some benchmarks published wrt this?
Thank you
Jan
--
MySQL General
Probably your server is not using any sockets, check out your my.cnf.
man mysql
to see how to connect to a ip based mysql host. C/ya!
On Sat, 2004-01-17 at 18:51, Mike Mapsnac wrote:
I just install MYSQL on Linux (Red Hat 9)
using this
The mysql auth protocol changed. You will need to use the old-password
option in your [mysqd] secction of your my.cnf
Best regards!
On Sat, 2004-01-17 at 21:33, [EMAIL PROTECTED] wrote:
Description:
when compiled and started, mysqld_safe and mysql work fine
from console, but hen
Weird. I cannot find the my.cnf (configuration file).. How that's possible?
Thanks
From: Victor Medina [EMAIL PROTECTED]
To: Mike Mapsnac [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Subject: Re: Mysql Installation on Linux: ERROR 2002: Can't connect
tolocal MySQL server th
Date: Sun, 18 Jan 2004
Hi,
How do I resize (shrink expand) InnoDB file?
Thanks.
Hassan
On Sun, 18 Jan 2004, Hassan Shaikh wrote:
Hi,
How do I resize (shrink expand) InnoDB file?
You can read about the various InnoDB specific startup options here:
http://www.mysql.com/doc/en/InnoDB_start.html
cheers,
Tobias
--
MySQL General Mailing List
For list archives:
1. What is the format of the test questions? I.e., are they multiple
choice, free answer, essay, etc.? Are they theory based or is it fact
based, i.e., memorize the books to pass?
2. Upon the recommendation of someone on this list, I purchased two
books, one entitled, MySQL by Paul Dubois,
HI,
I have an OSX Server 10.2.8 that came with MYSQL installed. I have used the
utility to start it, but don't see it running when I use Process Viewer or
when I query the terminal I think ps ax.
So I have two questions.
How do I find out what the Username and Password are for MYSQL.
Second
Jan Stary wrote:
Hello,
is there any use under FreeBSD 5.x for having MySQL compiled
WITH_LINUXTHREADS? I only have one processor (does it have
anything to do with that?), running 5.1, and 256MB of memory.
Are there some benchmarks published wrt this?
I believe that is still the recommended way
Kind MySQL List,
I need your help.
I have an installation of replicated MySQL servers.
I am migrating to new servers and upgraded MySQL software.
My previous servers were RH8, MySQL 4.0.14. (A, B)
My new servers are Fedora, MySQL 4.0.17. (C, D)
Most of my critical data is built using INNODB
In the Certification section of the mysql web site there is a short sample
test which shows the types of questions. There's a lot of information there
too including the broad topics covered in each test. According to
amazon.com Paul Dubois will have a MySQL Certification study book coming out
At 14:27 -0500 1/18/04, Jeremy March wrote:
In the Certification section of the mysql web site there is a short
sample test which shows the types of questions. There's a lot of
information there too including the broad topics covered in each
test. According to amazon.com Paul Dubois will have
* Marc Dver [EMAIL PROTECTED] [2004-01-18 18:30 +0100]:
1. What is the format of the test questions? I.e., are they multiple
choice, free answer, essay, etc.?
They are multiple-choice (but very tricky) and fill-in-the-gaps.
For example:
Assume a column in a MyISAM table has type VARCHAR,
* Ron McKeever
I thought update is for existing records and insert is to add new records?
That is correct.
My Scenario is if two users open an existing record with data
already in the fields. They then add some information to the
end of a field with data.
They add information, you say? As
So how reflective of the real test is the sample test at mysql.com?
Normally the little sample tests are easier than the real thing, but I'm
curious. I got 8 out of 10.
bob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hi Ron,
how many clients can be connected to mysql ?
Is there any setup for client connections ? where can I find it ?
Timotius Alfa
-
Do you Yahoo!?
Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes
hi all,
i had a problem where:
running apple os 10.3 server with mysql 4.0.16 and mysql would not
start.
found this solution at:
http://docs.info.apple.com/article.html?artnum=107537
problem was that mysql was unable to start due to the hostname on my
system being set to something other than
test
Karl James
[EMAIL PROTECTED]
http://theufl.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello,
I installed mysql 3.23.58 a few days before on a clean Windows 2003 machine,
but today I noticed that in the user table there are two additional entries
(above the usual localhost root and localhost guest) which makes me
nervous. Does anybody know what are the gcw root and gcw guest
My question is how to improve an update. I had a set of records from an external
source to add to a table. In the new data one of the key values was not known.
It turns out that another key can be matched to key values in the old data
(extracted to the table temp).
The relation between the keys
35 matches
Mail list logo