are you using something like this? ::
set dbconn = server.createobject(ADODB.Recordset)
dbconn.open dsn=yourdsnname;uid=;pwd=;driver=mysql
sql = SELECT * FROM tablename
recordset.open sql, dbconn
insert = INSERT INTO tablename (column1, column2) VALUES
('valueforcolumn1', 'valueforcolumn2')
First - I read the Readme file several times.
Second - I went though your listserv where you very politely redirect
everyone to the Readme file
Third - I'm a newbe to linux and MySQL (Microsoft'er looking for the other
world) and I don't know what a socket file would be called or where I would
OK, well, mysql has LEFT JOINS, right? OK then, in that case, how the heck
do I use them?! I need to join 14 tables (with the exact same structure,
columns) together and view all of there contents with a WHERE clause like
this:
SELECT * FROM t1, t2, t3, t4, t5, etc ORDER BY date DESC
or
Hi,
Could somebody tell me what is this?
SQL select * from users limit 0,25 failed : Got error 127 from table handler
TIA
Alex
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Hi,
Could somebody tell me what is this?
SQL select * from users limit 0,25 failed : Got error 127 from table
handler
TIA
Alex
http://www.mysql.com/doc/manual.php?search_query=Got+error+127+from+table+ha
ndlersubmit=Searchdepth=0
jason
On Wed, Sep 12, 2001 at 02:13:59AM -0500, Deryck Henson wrote:
OK, well, mysql has LEFT JOINS, right? OK then, in that case, how
the heck do I use them?! I need to join 14 tables (with the exact
same structure, columns) together and view all of there contents
with a WHERE clause like this:
Hi
I was just browsing thru the amazon.com site and just happened to read a
customer review on the MySQL (other new riders) book by Paul DuBios and
Michael Widenius.
It has a wierd review from someone which says
I was extremely dissapointed to say the least. This book doesn't even begin
to
Hi everyone !
We've got a problem:
running mySQL on unix(sun) we connect a third party
windows software over ODBC. All is nice until a windows path
is stored in the db
Trying to store C:\Program Files\3p SW\
I find that it becomes C:Program Files3p SW.
Is it possible, by means of
I have tryed to download the mysql manual.pdf but for some reason I cant.
Would
anyone be able to email me the pdf version?
[EMAIL PROTECTED]
Hi,
I think it's around 3MB.. so if say 10 persons would mail it to you you'll
get about 30MB in your mailbox..
If you're using M$ IE you might need
On Wed, Sep 12, 2001 at 01:31:59AM +0530, Nilesh Parmar wrote:
Hi
I was just browsing thru the amazon.com site and just happened to read a
customer review on the MySQL (other new riders) book by Paul DuBios and
Michael Widenius.
It has a wierd review from someone which says
I was
On Tue, Sep 11, 2001 at 03:29:00PM +0200, Henning Schroeder wrote:
At 11:03 11.09.01, you wrote:
does MYSQL.COM has a table type same as GEMINI ( GEMINI
yes. MySQL contains support for BDB and InnoDB tables, that are
transaction-safe.
I don´t want to provoke any anger here, maybe i´m
Thanks Will,
to avoid further misunderstandings -
the escapefeature of backslash is fully understood.
The problem is that the 3d party sw or the myODBC
doesn't understand that the inbound text SHOULD HAVE backslash
but does exactly whats expected - escape the next char.
What I'm asking is - is
Greetings:
Sorry for the off-topic. All bookmarked .il irc servers are currently
unavailable.
If any on the list has an active .il IRC link it would be helpful. (Israeli
BBS-es also useful)
You can post anonymously from safeweb.com at http://www.dedserius.com/guestbook/
Best Regards,
Van
Hi,
I tried create table specify type=InnoDB.
with the following script:
create table objects(uri blob not null, primary key uriIndex (uri(255)),
classname blob) type=InnoDB;
I'm getting the following error
ERROR 1073: BLOB column 'uri' can't be used in key specification with the
Has anyone had any experience of running MySQL on Mac OS X? If so, how have
you found it - is it stable and non-buggy? Also, has anyone had any
experience of using both MySQL *and* PHP together on Mac OS X? I would be
very interested to hear anyone's thoughts on this,
regards
Paul
database,sql,query,table
Hi,
have been told to use joins and after reading the manual a bit I do not
know what it is about. I have added couple of examples. Could anyone tell
me what difference is in them if any? the MY: is what I have been using and
SUGGESTED is what was offered to be
It has a wierd review from someone which says
I was extremely dissapointed to say the least. This book doesn't even
begin
to cover **video game programming in mySQL**, not even the basics. In
fact,
it doesn't cover **video game programming at all**. . blah blah .
What's video game
I haven't run mysql personally on my OS X box yet but I do know of some
who have and there seems to be a current problem with getting mysql to
quit properly. I think that will be fixed with Mac OS X 10.1 which is
coming out sometime this month. Other than that go to
www.versiontracker.com and
Placed At : BOM
Durga Prasad@SATYAM
09/12/2001 03:25 PM
Hi all,
I have just installed
MySQL 3.23.42-1.
using MySQL3.23.42-1.i386.rpm.
OS: RH Linux 7.1
glibc:2.2.2.10
gcc: 2.96-81
perl: 5.6.0-12
When i try to install
Is there a way to add support for additional character sets to an
existing mysql installation without recompiling?
I am currently running mysql 3.23.32 if I do need to recompile
should I get the source for 3.23.32 or should I already upgrade to
3.23.42?
Thanks,
David Suna
[EMAIL PROTECTED]
database, sql, query, table
database, sql, query, table
(I hate 123box.co.uk)
Im not gonna go into long discussions of game programming in here.
But the reason most people dont use a database backend for most modern games
is more a matter of speed than anything else. You cant get an average
Hi everyone,
I am not a user of MYSQL yet, but shall be soon.
I needed to know if MYSQL has begun to support UNICODE (UTF-
8) as rest of the RDBMS' have adopted it to meet the
language needs of non-english countries.
And I am just hoping that amongst so many MYSQL users
probably some one
Hello,
Starting 2-3 days ago, when we or our users try to access some parts of our
site we receive some PHP/SQL, as this:
Warning: MySQL: Unable to save result set in
/home/bestjobs/public_html/nb/insert_user.php on line 21
We did not change anything in the php scripta or database structure
Has anyone had any experience of running MySQL on Mac OS X? If so, how have
you found it - is it stable and non-buggy? Also, has anyone had any
experience of using both MySQL *and* PHP together on Mac OS X? I would be
very interested to hear anyone's thoughts on this,
regards
Paul
--
Paul
At 9:10 AM +0100 9/12/01, Peter Gad wrote:
Hi everyone !
We've got a problem:
running mySQL on unix(sun) we connect a third party
windows software over ODBC. All is nice until a windows path
is stored in the db
Trying to store C:\Program Files\3p SW\
I find that it becomes C:Program Files3p
Placed At : BOM
Durga Prasad@SATYAM
09/12/2001 05:10 PM
Hi all,
I have just installed
MySQL 3.23.42-1.
using MySQL3.23.42-1.i386.rpm.
OS: RH Linux 7.1
glibc:2.2.2.10
gcc: 2.96-81
perl: 5.6.0-12
When i try to install
Hi there,
I am currently using Slackware 8 (linux) and I have some problems. There
is mysql package in the slackware installation, which I installed it but
never manage to run it successfully. Everytime I type the following
safe_mysqld
and I get the following message:
Starting mysqld
Merges wont work because they dont allow inserts. But I'll check out UNION.
Thanx
- Deryck H
- http://www.comp-u-exchange.com
- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
To: Deryck Henson [EMAIL PROTECTED]
Cc: MySQL [EMAIL PROTECTED]
Sent: Wednesday, September 12, 2001
I am currently using Slackware 8 (linux) and I have some problems. There
is mysql package in the slackware installation, which I installed it but
never manage to run it successfully. Everytime I type the following
safe_mysqld
and I get the following message:
Starting mysqld daemon
I presume that you did run the mysql_install_db first of all??
If so, then check the ownership of the directory where the database lives.
This should be mysql:mysql. HAd the same problems till I resolved the
ownership issue.
Regards,
Ian.
-Original Message-
From: Nikolaos Rasidakis
At 1:31 AM +0530 9/12/01, Nilesh Parmar wrote:
Hi
I was just browsing thru the amazon.com site and just happened to read a
customer review on the MySQL (other new riders) book by Paul DuBios and
Michael Widenius.
It has a wierd review from someone which says
I was extremely dissapointed to say
I have to measure the time of an select-query. How can i use the
benchmark command for doing it?
A simple benchmark(10,select field from tbl where
key_field=condition) gives me an error.
-
Before posting, please check:
Hello,
How I can make my mysql faster ? Can I compile it with special options
?
Pozdrawiam,
Marcin Pyla
(o_ [ Marcin Pyla - Cubbi [EMAIL PROTECTED] | + NetArt ISP + ]
(/)_ [
Look and making MySQL fly
The hard stuff is where to start. Raid 0 and lost of memory
Then yes there are a few things that you can remove when compiling to make
things faster depending what you need to do.
And then theirs stuff to do in my.cnf
Simon
-Original Message-
From:
On Wed, 12 Sep 2001, Simon Green wrote:
Look and making MySQL fly
The hard stuff is where to start. Raid 0 and lost of memory
I used Raid 5 + 1 (hardware) and it gaves only 2 seconds faster...
Then yes there are a few things that you can remove when compiling to make
things faster
I have 4 tables where the primary key is identical with the primary key
of the other tables.
Here's my strange result of two queries:
select count(*) from tbl_a natural left join tbl_b natural left join
tbl_c natural left join tbl_d where where tbl_c.field1=x and
tbl_d.field2=y;
Result: 7
Gene Gurevich wrote:
Hi all:
I'm trying to import the tables from the dump file
via
mysqldump testdb exp
That should be:
mysql testdb exp
and it complaints about the command in the export
file:
DROP TABLE IF EXISTS db;
CREATE TABLE db (
Host char(60) NOT NULL default
That's what I used :
mysql testdb exp. Sorry about the typo
Gene
--- Gerald Clark [EMAIL PROTECTED]
wrote:
Gene Gurevich wrote:
Hi all:
I'm trying to import the tables from the dump file
via
mysqldump testdb exp
That should be:
mysql testdb exp
and it
I had similar problems with sue7.2 i finally got fed up and downloaded
the most current binary distribution
and followed directions. I am still trying to work out some issues but
at least i have a working
system
XAPHS
Chris Bolt wrote:
I am currently using Slackware 8 (linux) and I have some
Steps In Compiling MySQL
Use the right compiler
Use pgcc = Pentium optimzed gcc on Pentium
Strip unnecessary parts
Only use character sets you will use
Skip BDB tables, replication if you don't need them
compile MySQL without support for exceptions (as MySQL does not use C++
exceptions)
Simon
Marcin wrote:
How I can make my mysql faster ? Can I compile it with special options?
Check out section 5.5 of the manual. I found there's also some very useful
information
readily available in the file INSTALL-SOURCE* in the top level of the
source directory. I'm not
sure whether GCC v3.0
Hi.
Is there a tool to convert a mysql database to oracle?
thanks
=
__
Do You Yahoo!?
Get email alerts NEW webcam video instant messaging with Yahoo! Messenger
http://im.yahoo.com
Brian,
the error message means that you updated a secondary
key of a row but InnoDB did not find the index entry
in the secondary index. The bug may be due to
an error in purge, insert buffer, or the buffer
pool. I am currently running tests on this and
studying it.
Could you please run CHECK
Hi!
You can probably circumvent the problem by
adding an extra VARCHAR column where you put
the first 255 characters of the blob column.
Or maybe you could generate an artificial
primary key with auto-increment, for example?
Regards,
Heikki
http://www.innodb.com
Hi,
I tried create table
I have a table with over 26 million records that experiences a high volume of traffic.
Recently, query results became a little screwy; upon investigation it was found that
the table and the index were fouled up.
The results of an isamchk on the table yielded:
Checking ISAM file:
Hi Devin,
You need to look into serveral things. Did you run
mysql_install_db? If there is an error file in /usr/local/var (it will
be servername.domain.err ) read what it says in that file. See
http://www.mysql.com/doc/P/o/Post-installation.html
Sorry for the delay in responding we here in
Heikki,
Here is the output from CHECK TABLE:
mysql check table roster;
+--+---+--+--+
| Table| Op| Msg_type | Msg_text |
+--+---+--+--+
| webassign.roster | check | status | OK |
Hi there,
I'm having trouble configuring MySQL 3.23.36 running on a Sparc/SunOS 5.8 to
use the available 1 gig of memory and was wondering if anyone might be able
to help find a solution.
/usr/ucb/ps -aux gives the stats:
USER PID %CPU %MEM SZ RSS TT SSTART TIME COMMAND
Sasha,
I tried the bug script to send the bug, but didn't have time to go thru
the problems (looking for X, then couldn't open on vi). Reading that script
I thought I saw support@..so I went ahead and send to that list.
I knew it was a paid support list, but I didn't have any question, only
In the last episode (Sep 12), Joe Kaiping said:
Hi there,
I'm having trouble configuring MySQL 3.23.36 running on a Sparc/SunOS 5.8 to
use the available 1 gig of memory and was wondering if anyone might be able
to help find a solution.
/usr/ucb/ps -aux gives the stats:
USER PID
Brian,
your table seems to get corrupt only
temporarily. It suggests I have a bug
in the interplay of UPDATE and purge.
Probably no need to reimport the table.
About keys: there is no need to define
the same key as the primary key and
a non-primary. Thus the key roster_ is
unnecessary.
Thanks
Thanks for the quick reply, Dan.
The EXPLAIN SELECT for that SELECT outputs:
mysql EXPLAIN SELECT count(id) FROM ind WHERE cust=1 AND email'';
+---+--+---+--+-+--++---
-+
| table | type | possible_keys | key | key_len | ref | rows | Extra
Hello,
I'm new to MySQL, so forgive my ignorance.
I'd like to copy data from one table to another.
I have one table I've made from a filemaker database.
And one that contains my main data.
I want to update the main data from the Main file using the data from the
filemaker file. Each row has
Sorry...here is the rest of the info:
uname -a= FreeBSD reviews.aspd.net 4.2-RELEASE FreeBSD 4.2-RELEASE #0: Tue
Dec 26 18:38:27 GMT 2000 [EMAIL PROTECTED]:/usr/src/sys/compile/FLASH42
mailto:webmaster@:/usr/src/sys/compile/FLASH42 i386
ldd did not work, the system told me to use objdump -i
I believe the answer will be for you to create a single index on *just*
the cust column. (I assume that a specific cust id occurs only once or a
few times in the
whole table.) This will allow MySQL to use that index to find the small
set of records (quickly) where cust=1,
then to screen the email
I obviously dont know what the error message is but
Update tbl1, tbl2 set tbl1.CategoryInTable1 = tbl2.CategoryInTable 2 where
^
|
Kevin:
A database is, in some sense, a container for your tables. It sounds
like you want
to compose a new container. Thus,
To list your databases (containers):
mysql show databases;
... it seems that the list should contain your dbb and mysql, probably
also test.
To create a new database
Kevin thanks for your response. Here are the different errors for each SQl
command I enter.
Command: update tblSNLC,tblSNOrg set
tblSNOrg.OrgSponsor1=tblSNLC.SponsorFull where tblSNOrg.OrgZip=tblSNLC.Zip;
Error: Failed to execute SQL : SQL update tblSNLC,tblSNOrg set
Hi there,
I'm experiencing problems with compiling my source that uses mysql++.
It compiles ok but in the linking process it prints many warnings and it
doesn't produce any output file.
When I pass the -c flag to gcc to stop at linking, it looks ok cause it
produces a .o file.
I have gcc
I am having a hard time printing
Select * from table_1 \p;
the result is:
--
Select * from table_1
--
.
.
.
But it doesn't print.
Anyone?
-
Before posting, please
At 2:14 PM -0400 9/12/01, Jeremy Morano wrote:
I am having a hard time printing
Select * from table_1 \p;
the result is:
--
Select * from table_1
--
.
.
.
But it doesn't print.
Anyone?
Define what you mean by print.
--
Paul DuBois,
hi,
i have a lamer question:
where is my binary log file? i can't find it.
i am sure it exists because grows crazy, when
i restore a database from dumpfile.
i found nothing about binary log in my.cnf.
version: mysql 3.23.32-log
install path: /usr/local (default)
thanx,
ati
I think you need a new approach. It appears that update does not support the join you
are attempting.
It seems that you are trying to update
the value for a column from one table with the value of a column from another table.
If this is the case, i would use a shell script to first extract
I hope that someone can please tell me how to fix this. When I try to run
IIS Im getting an error
WMI ADAP was unable to load the w3ctrs.dll performance library due to an
unknown problem within the library: 0x0
Thats just one of several. Im running win2k pro. I have installed PhP and
MySQL ...
On Wednesday 12 September 2001 10:36, Rodrigo Zerlotti wrote:
Sasha,
I tried the bug script to send the bug, but didn't have time to go thru
the problems (looking for X, then couldn't open on vi). Reading that script
I thought I saw support@..so I went ahead and send to that list.
I knew
Hi group,
I am in need of assistance with a database and php query we are trying to
achieve.
Basically we are have a form where one field searches a field in the mysql
database and the other searches for keywords using the MATCH query.
What we need to do is for the user to be able to enter a
I have a date comparison problem that I'm sure is simple enough but I'm just
not experienced enough to figure it out. I simply want to grab every entry
in a given table that has been entered within the last three days.
I'm using Perl so I first start with a Perl timestamp and convert it to a
Hi,
when I compilling mysql that occur something error below on solaris.
Soft Spc.
Solaris 8
Mysql 3.23.42
gcc 3.0.1
GNU Make 3.79.1
My steps:
gunzip -d -c mysql-3.23.4.tar.gz | tar xvf -
cd mysql-3.23.42
CC=gcc CFLAGS=-O3 CXXLD=g++ \
CXX=gcc CXXFLAGS=-O3
I have a date comparison problem that I'm sure is simple enough but I'm just
not experienced enough to figure it out. I simply want to grab every entry
Um.
First of all, better code would be:
my @now = localtime( );
$now[5] += 1900;
$now[4] += 1;
$currenttime = sprintf(
That error message is coming from PHP, not from MySQL.
PHP generates that error message when, for some reason, the number of fields
returned by a MySQL query was greater than zero, but the return from
mysql_store_result() or mysql_use_result() was zero or NULL.
The PHP code which checks those
Hi,
I am pretty new to mysql and started installing it on freeBSD from
usr/ports/. I got the following error. Can somebody help me why it is
failing.
thanks,
siva
=== Installing for mysql-server-3.23.36
=== mysql-server-3.23.36 depends on executable: mysql - not found
===
I installed MYSQL on a HPUX 11 machine and I ran the mysql-test-run
script and everything
passed, but when I start mysql up using bin/safe_mysqld or
bin/safe_mysql --user=mysql
I receive this error in the logfile
Table 'mysqld.host' doesn't exist
Any solutions
--
At 8:31 AM -0700 9/12/01, Gene Gurevich wrote:
Hi.
Is there a tool to convert a mysql database to oracle?
thanks
Check the Oracle web site.
--
Paul DuBois, [EMAIL PROTECTED]
-
Before posting, please check:
How??? ALTER TABLE table1 RENAME ???
Tried it, dont work.
- Deryck H
- http://www.comp-u-exchange.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the
At 10:03 AM +0100 9/12/01, Paul Groves wrote:
Has anyone had any experience of running MySQL on Mac OS X? If so, how have
you found it - is it stable and non-buggy? Also, has anyone had any
experience of using both MySQL *and* PHP together on Mac OS X? I would be
very interested to hear anyone's
How??? ALTER TABLE table1 RENAME ???
Tried it, dont work.
That renames the table itself.
ALTER TABLE tbl_name CHANGE old_name new_name column_definition
where column_definition is how you defined the column when you created
it. For example if you have a table
CREATE TABLE xyz
(
c
Rename is for Tables (I think ...I am fresh, too. So fresh that I send it to you
privatly. Sorry about that!)
ALTER TABLE table1
CHANGE column1 coloum2 varchar(20) not null [or what ever datatype];
gives you what you want.
Ann
- Original Message -
From: Deryck Henson
I have a table with several fields, the primary key
is a CHAR(11) field that does NOT allow NULL values. This field is called
rec_key. Now, when I attempt to run the following query:
SELECT * FROM table_name WHERE rec_key LIKE
'key_value'
it returns NO data.. If I drop EXPLAIN in front of
Hello,
I'm new to MySQL and I was wondering if there was a command that you can
issue to see the current size of a mysql database (in kb or MB)?
=
'Toine
-
Before posting, please check:
http://www.mysql.com/manual.php
Right now MySQL is getting really backlogged but I have no idea why. There
are 169 concurrently running queries, and 153 of them are in show the status
as Opening tables. A processlist looks something like this (formatted by
Status, Seconds query has been running, and query):
Opening tables
I got an idea and thought i would ask around about a recovery plan about
databases? Currently all i do is dump the databases on to a share on an
NT box thru a SMB share from the RH 7.1 Linux DB server. The NT box is a
Compaq CL1850 which is 2 Compaq 1850 server with a shared SCSI array.
The NT
Description:
How-To-Repeat:
Fix:
Submitter-Id: submitter ID
Originator:root
Organization:
MySQL support: [none | licence | email support | extended email support ]
Synopsis:
Severity:
Priority:
Category: mysql
Class:
Release:
Description:
How-To-Repeat:
Fix:
Submitter-Id: submitter ID
Originator:root
Organization:
MySQL support: [none | licence | email support | extended email support ]
Synopsis:
Severity:
Priority:
Category: mysql
Class:
Release:
Hi Guys, here goes..
SELECT count(page_searchwords.word_id) as score, page_data.id, filename,
title FROM page_data, pagewords, page_searchwords WHERE
(page_searchwords.media_type='static' AND pagewords.id =
page_searchwords.word_id AND page_data.id = page_searchwords.id AND
In the last episode (Sep 12), adam said:
I got an idea and thought i would ask around about a recovery plan
about databases? Currently all i do is dump the databases on to a
share on an NT box thru a SMB share from the RH 7.1 Linux DB server.
The NT box is a Compaq CL1850 which is 2 Compaq
On Tue, Sep 11, 2001 at 03:17:47PM -0500, Weslee Bilodeau wrote:
They average around 500 connections/second at any given time, two
have a master/slave setup.
Connections/sec or Queries/sec? That's a lot of connections per
second? Can you use persistent connections? It would save a
86 matches
Mail list logo