Can anyone tell me why this:
Line 282mysql_select_db("centraldb",$db);
Line 283$qorder++;
Line 284$result = mysql_query("SELECT q.questid, q.question, q.answer, q.qorder,
q.depart, q.catid,
q.active, q.global, q.adate, q.author, q.authoremail, q.askemail,
On Sun, Feb 25, 2001 at 12:37:32AM -0500, Mark Chalkley wrote:
At this point, there's only 1 row in companies, and 8 in contacts.
MySQL won't use an index on tables with so few rows. It is simply
faster to scan the whole table. As you tables grow, however, MySQL
will begin to use the indexes.
On Sun, Feb 25, 2001 at 03:29:37PM +0900, wrote:
It sounds like you are using a version of MySQL that had a
replication bug in it. I suspect that if you upgrade to 3.23.33 the
problem will go away.
No, Master is 3.23.33, and slave is 3.23.32
3.23.32 was troublesome for slaves.
Here
On Sun, Feb 25, 2001 at 12:16:39AM +0100, Katja Ide wrote:
Hi everyone,
We've got a database with 46 tables running on the server of Schlund for
four months now. During these four months we've been inserting data into
the database by PHP-scripts without any problem whatsoever - until two
Vahan Yerkanian [EMAIL PROTECTED] writes:
Atle Veka wrote:
Why not use something that's already created for you, and is probably
*much* faster than your solution :)
Oh... if it really was an acceptable choice, I won't post this question.
:))
Out of interest, what's unacceptable
I got to wondering about that after your question about how many rows were there. I
was just playing with a test copy of the db, preparing to set the log options on the
production one, and noticed that. I rummaged around in the .pdf version of the manual
for over an hour before posting the
Hi all, has anyone also seen problems with ROLLBACK not working when
installing MySQL on Red Hat Linux 7.0? On Red Hat Linux 7.0, ROLLBACK does
nothing (though it doesn't generate an error either, and the table is
listed as a BDB in show table status, and locking works as expected with a
BDB
Hi-
I just crashed my computer and after restart it gives me this message on
some SELECT queries:
Warning: MySQL: Unable to save result set in
c:/apache/htdocs/neobt/otherservices.php3 on line 382
On line 382 I have: $gething = mysql_query("SELECT * FROM etc WHERE
type='transfer' AND
* Irmund Thum [EMAIL PROTECTED] wrote on 25.02.01 17:20:
ERROR 1196: Warning: Some non-transactional changed tables couldn't be
rolled back
***
so I'm not that expert knowing what "non-transactional changed tables"
exactly means
You're probably using the RPM version or otherwise just don't
Hi all,
I'm trying to get a query to work but am having no luck. It seems so
simple, it should work, but obviously, I'm doing something wrong.
Table: Employees
Fields: FirstName
LastName
EmployeeID
Table: Sales
Fields: SubTotal
EmployeeID
What I want to do
On Sat, Feb 24, 2001 at 09:43:45AM -0700, Karl Stubsjoen wrote:
I'm trying to understand MySQL indexing but am having trouble
understanding the differnences (and when to use each) between
Primary Key, Key, Unique, an Index. Can you help?
Index and Key are the same.
A Primary Key is
Sir, LEFT JOINs rule out the use of indices on the join column in the
left table, making LEFT JOINs inherently slow. Try putting indices on
the columns used in your WHERE and ORDER BY clauses. I'm not
promising it will help, but it is recommended in Paul's book.
Bob Hall
Hi folks,
after
Sir, you are trying to construct a many-to-many join. (One list has
many members, one member subscribes to many lists.) This is done with
a join table.
join_lists_members(list_id, member_id)
To get all the e-mail addresses for a given list name, use
SELECT m.email
FROM (lists AS l
I have mysql-server-3.23.22.6 and mysql-3.23.22.6, packages
installed on my PC during Linux RedHat 7.0 installation.
The problem occurs when starting mysqld program :
The command :
mysql install db
is OK
but the command :
safe mysqld
starts the server mysqld witch stops immediately after.
When
Hi, I ran into the following problem :
I,ve got suse 7 , and I tried to compile mysql-3.23.33 with the following
options :
/usr/src/mysql-3.23.33 # ./configure \
--prefix=/opt/mysql \
--localstatedir=/var/mysql \
--libexecdir=/opt/mysql/libexec \
--with-mysqld-user=mysql \
Sir, I don't see anything wrong with the syntax in your query. If I
haven't over looked something, and if you haven't misspelled
anything, then you have a data problem. Since your first query
returns a Cartesian product, you should get something if the WHERE
clause returns = 1 row for each
Ed Carp wrote:
Gorjan Todorovski ([EMAIL PROTECTED]) writes:
Since XML is a way to exchange data...and it is protocol/platform indepdnent
there is a very good reason to have XML docuemts going in and out the
No, it's not. You store *data* in a database, *not* metadata. Do you
I had pretty much the same problem.
I was unhappy with the RH v7.0 distro of MySQL and downloaded the MySQL
rpm's (v3.23.33). It installed and ran with _no_ problems! My problem was
the RH distro of php did not recognize that MySQL was there. I decided to
upgrade to php 4.0.4. I downloaded
Glorious Sunday morning greetings to you Jan,
No, XML is a format for 2 different applications, usually 2 totally separate
applications, to be able to exchange data. It is not an appropriate choice
for storing large amounts of data that will have to be queried. Nor is it an
appropriate choice of
Dave Hodgkinson wrote:
Out of interest, what's unacceptable about ht::/Dig for you?
--
Dave Hodgkinson, http://www.hodgkinson.org
Editor-in-chief, The Highway Star http://www.deep-purple.com
Apache, mod_perl, MySQL, Sybase hired gun for, well,
Description:
How-To-Repeat:
Fix:
Submitter-Id: submitter ID
Originator:Shadow Inc.
Organization:
MySQL support: [none | licence | email support | extended email support ]
Synopsis:
Severity:
Priority:
Category: mysql
Class:
Hello All,
I have a project coming up that we are programming with Perl, the coding is no
problems, just need to get some advise as to setting up the db tables properly
so they are efficient and meet our needs. If some one on the list may have some
spare time to take a look at our notes and
Hi there,
I just installed mysql (3.23) but when I run mysql_install_db or mysqld
it comes with an error message that the programming can't load the
libz.so file. I've found that file online and copied it into all myysql
directories but still it can't load the file. I propably should copy the
Hello
I have managed to build and install MySQL --with-libwrap. What next?
I haven't found any information on what to put in /etc/hosts.allow or .deny.
Of course the rules depend on what I want. I want to close all access
from outside the local LAN. I know I can put the barrier in the grant
Hi everyone.
I applied a patch (for Omniform 4.0 support) to the myodbc driver and would like to
upload the patched driver to the maintainers so that everybody in the near future can
profit from it.
Where do I have to send the driver?
Best regards,
Thomas
Hi everyone,
I have problem with Database inteded for setting access rights.
The problem is that IP addresses set in table 'db' dont affect access rights.
With no problem I accessed database from IP 147.229.177.57.
Dumping data for this database are as follows:
# DATABASE mysql
#
# Dumping
Hi everyone,
in mysql log file I found many, many errors as follows:
010224 13:32:43 Aborted connection 5 to db: 'XXX' user: 'YYY' host:
`localhost' (Got an error reading communication packets)
010224 15:18:34 Aborted connection 6 to db: 'XXX' user: 'YYY' host:
`localhost' (Got an error
At 20:46 25/02/2001 +0100, Thomas Thaele wrote:
Hi,
You can download it at:
ftp://support.mysql.com/pub/mysql/secret/
Thanks.
Regards,
Miguel
Hi everyone.
I applied a patch (for Omniform 4.0 support) to the myodbc driver and
would like to upload the patched driver to the maintainers so that
I just installed Redhat 7.0 and MySql while i was at it. But the deamon is not
running. I get the
ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (111)
when i try to use the client. Could someone please clue me in as to home I get this
baby
when i try to use the client. Could someone please clue me in as to home
I get this baby going...
Thanks!
Tom
RTFM (Read The Fine Manual) :-) you can find it at www.mysql.com
Search the archive: http://lists.mysql.com
Checkout www.devshed.com
Bye,
B.
Hi:
Make sure MySQL is started when your system boots up. Run 'setup' as root and go to
'System Services'
and make sure mysqld is checked. If you want to start the daemon without restarting run
'/etc/init.d/mysqld start' as root.
Seung-woo Nam
Thomas O'Neill wrote:
I just installed Redhat
Does anyone have any good ideas on how to pull a random record? I've been using PHP's
random function to create a random number to pull, but the problem is that if I delete
a record, it could still try to pull it. Is there a better way? I'd really like to
be able to just pull it in the SQL
At 11:15 22/02/2001 +0800, edith wrote:
Hi,
Other Microsoft products like Access doesn't permit the edition
of MySQL tables without a primary key on the table. If this is
your case, try to add a primary key on the MySQL table.
Regards,
Miguel
Dear Sir/Madam,
I'm a Visual FoxPro programmer.
Check the archives. The answer you seek is there.
Cal
http://www.calevans.com
-Original Message-
From: joe [mailto:[EMAIL PROTECTED]]
Sent: Sunday, February 25, 2018 5:40 PM
To: MySQL
Subject: Random record
Does anyone have any good ideas on how to pull a random record? I've been
Instead of pulling using equals, ie "select * from table where id =
$php_random_variable" you can do this instead "select * from table where id
= $php_random_variable LIMIT 1"... As long is there is atleast one row in
the table you will get back a result. Hope that helps.
ryan
- Original
At 10:37 AM -0600 2/25/01, Cal Evans wrote:
Glorious Sunday morning greetings to you Jan,
No, XML is a format for 2 different applications, usually 2 totally separate
applications, to be able to exchange data. It is not an appropriate choice
for storing large amounts of data that will have to be
Hi all,
I have just tried to use the mysql binary supplied for FreeBSD
(mysql-3.23.32-unknown-freebsdelf4.2-i386.tar.gz) on FreeBSD4.0 I
have gcc-2.95.2 installed.
M problem is I get this error when I try and run the
scripts/mysql_install_db:
/usr/libexec/ld-elf.so.1:
Hi,
This is how I set the variables in the my.cnf file.
[mysqld]
set-variable = key_buffer_size=16M
set-variable = max_allowed_packet=16M
I can only insert 8M at any one time using SQLPutData. Even if I insert 1024K more,
the SQLPutData will return a "Function sequence error". Does
Suggestion: Check file permissions.
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, February 25, 2001 12:33
Subject: can create, cannot drop...?
i'm newbie.
how come i can create but cannot drop? (errno: 21)
i am root.
mysqladmin asks if i am
I'm assuming this is on Solaris.
One workaround that you may be able to do is to set you LD_LIBRARY_PATH to
the path where libz.so is.
I've seen this problem with other products and it turned out to be a Solaris
install issue. I had to back rev to 2.7 in order to get it to work. I
I just installed mysql 3.23 and then ran a script to create a database I had
previously been using in an older version. I have a couple questions.
First, how can I make a drop database statement not fail if the database
doesn't exist. A book I was using seemed to say:
drop database dbname if
It is appeat "restartable system calls .. configure:error can not run test program
while cross compiling". thanks.
Greets All:
I've got the above (subject) build created and, need to free up some space on
the machine. Anyone want it, and, is there a good way to shrink it down or make
a binary package?
Let me know.
Regards,
Van
--
=
Hi
I am running Mysql on a Machine with two PIII-600, and 1 GB of RAM.
The disks are connected via U2W-SCSI.
I tried tuning mysql for maximal performance the last days, but I'm not
exactly sure which parameters I should increase, und to what value.
Our web application is quite slow at the
At 09:54 26/02/2001 +0800, Li Sze wrote:
Hi!
Did you read with attention the ODBC documentation about sending
long data ?. For example SQLPutData is used to send pieces of data
exactly to work on limited memory resources, in the code you define
the size of data which is send at every time, how to
This table contains more than 2.5 million records. I
created index on column hari. It needs more than 3797
secs, and have not finished yet.
Anybody has advice?
mysql describe tb_trafik_bulanan;
+---+--+--+-+-+---+
| Field | Type
Anyone can give me an example of create a transactional table in V3.22.23?
Thanks.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To
On Mon, Feb 26, 2001 at 01:26:55PM +0800, WANG_KING wrote:
Anyone can give me an example of create a transactional table in
V3.22.23? Thanks.
Simply append "Type=BDB" to any CREATE TABLE statement.
CREATE TABLE foo ( bar int not null, baz varchar(10) not null ) Type=BDB
Jeremy
--
Jeremy
Hi,Thanks.I just do so.
But how can I make mysql supported by BDB
On Mon, Feb 26, 2001 at 01:26:55PM +0800, WANG_KING wrote:
Anyone can give me an example of create a transactional table in
V3.22.23? Thanks.
Simply append "Type=BDB" to any CREATE TABLE statement.
CREATE TABLE foo ( bar
It is not that mysql it slow, its your database design and the fact you have
2.5 million records in the table.
It is not clear from your description of the problem what you are trying to
do, so giving advice is that much harder. If you are creating an index on
the column hari, it will take a
Michael,
Is anybody on this thread really rationally suggesting using XML
instead of SQL? I hope not. It would no longer be an SQL database. Of
course SQL is the language for committing data to the storage
mechanism. What the data consists of is another matter.
I'm suggesting there is a
Just simple question.. why u designed it such a way that differentiate the
'thn','bln' and 'hari' field
when you can do it just using one field and using DATE type field instead of
integer.
and when you query u can use your SQL sorting to speed up searching.
Regards
Teddy
- Original Message
Cal,
Cal Evans wrote:
Glorious Sunday morning greetings to you Jan,
No, XML is a format for 2 different applications, usually 2 totally separate
applications, to be able to exchange data.
It is not an appropriate choice
for storing large amounts of data that will have to be queried.
53 matches
Mail list logo