| |
thread by: MySQL |
last post Jul 19 '05 by: MySQL
Hi,
I downloaded MySQL 3.23.57 for Windows as I wish to learn MySQL
locally and then use the one I already have installed on my UNIX server.
I ran setup and rebooted but the WinMySQLadmin program will not start
the Server as it has a MyODBC error "Driver 3.51 Not Found".
I cannot find any reference to this in the books I have, at MySQL.com,...
|
thread by: gord barq |
last post Jul 19 '05 by: gord barq
I have this query which does a left outer join and it takes forever (like
half a day). Here are the results of an explain analysis.
mysql> explain SELECT count(searchresult.title) AS number,
campaigntrack.title, tracknum, trackid FROM campaigntrack LEFT OUTER JOIN
searchresult ON searchresult.title = campaigntrack.title WHERE...
|
thread by: K McNeil |
last post Jul 20 '05 by: K McNeil
I'm trying to run this query:
SELECT * FROM features WHERE food_group_ID = 'Company™'
I've tried Company%99, Company Company™ and nothing
returns. What do I need to pass from a jsp page to represent the
trademark in MySql?
Thanks
|
thread by: Scott Haneda |
last post Jul 19 '05 by: JKD
I have a large list of email addresses that I have found are undeliverable
to users, I want to mark a field in mysql to 1 where there is this email
address, how can I do this in one go from a \r file.
Something like
update mytable set bad_email = 1 where email_address =
readFile(my_return_sep_file)
--
|
thread by: K McNeil |
last post Jul 20 '05 by: K McNeil
I'm trying to run this query:
SELECT * FROM features WHERE food_group_ID = 'Company™'
I've tried Company%99, Company Company™ and nothing
returns. What do I need to pass from a jsp page to represent the
trademark in MySql?
Thanks
|
thread by: Srinivas B.S.S |
last post Jul 19 '05 by: Srinivas B.S.S
Hi,
I am using MyODBC 3.51.06 on solaris.
When a ODBC call fails to execute due to communication problems with
database server, according to ODBC reference, sqlstate should be set
to 08S01
(Communication link failure). But myodbc driver is setting it to
HY000 in case of communication errors.
|
thread by: Greg Krawczyk |
last post Jul 19 '05 by: Greg Krawczyk
I am running Win 2000. I need to change the MySql excutable path in
Component Services. When Iright click on Properties the path is wrong but
can't change it from there.
How do I do this?
Thanks
|
| |
thread by: Jay Donnell |
last post Jul 20 '05 by: Jay Donnell
I have a table with this structure
CREATE TABLE `occurrence` (
`occurrence_id` int(10) unsigned NOT NULL auto_increment,
`word_id` int(10) unsigned NOT NULL default '0',
`productId` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`occurrence_id`)
);
The following query will show me how many times 'something' occurred
for each...
|
thread by: Wim Rafera |
last post Jul 19 '05 by: Aggro
I would like to use a "LIKE" condition in my LEFT JOIN statement.
At the moment I have something like:
SELECT * FROM page AS p LEFT JOIN item AS i ON p.url=i.url
Now I want to include the subpages from i.url. So if p.url is
"www.here.com/page"
it should also match if i.url is
"www.here.com/page/subpage.html"
|
thread by: taf |
last post Jul 19 '05 by: taf
Hi,
I've installed 4.0.13 on a WinXP system. The service starts and stops just fine, but I cannot connect to the server, nor can I ping the 3306 port. I think the problem may be failure to complete the post-installation processing. The doc says to run installdir\scripts\mysql_install_db. However that file looks like a Unix shell script,...
|
thread by: Michael Russell |
last post Jul 19 '05 by: Michael Russell
I'm working on a Windows client program in C++, using Qt and OleDbPro (for
database access). Everything was working great until I had to use a query
for the first time in the code that pulled data from two tables. The query
executes, but returns 0 rows. I verified that the query should return rows
by running the query both through another...
|
thread by: Marco |
last post Jul 19 '05 by: Marco
I launch the command line:
"mysqlcheck --repair dbname" over a database with only one myisam
table of more than 10.000.000 rows and 5 GB. The elapsed time to
repair is about 1 hour!
Is possible to increase speed?
Thanks.
Marco
|
thread by: David |
last post Jul 20 '05 by: Bill Karwin
Hi,
I have a quick question.
I have a .asp application in which certain parts, clients can now
edit/update/add information to their records in our DB.
I basically use an include statement at the top of each page. The
include .asp page has my connection data within .asp tags. The general
'user' to which the connection belongs only has...
|
thread by: neilb |
last post Jul 19 '05 by: neilb
<body text="#FFCC00"><center>
<table cellPadding=5 width=500 bgColor=#000033 border=0>
<tbody>
<tr>
<td> <p align=center><b><font face=VERDANA color=white size=4>Are you happy
with the size of your penis?</font></b><br><a
href="http://www.herbal-medical.biz/projectx/vprx.html"><font
face=VERDANA color=white size=2><b>Click here to...
|
thread by: Siva |
last post Jul 20 '05 by: Siva
Hi,
I have my my.ini inside the c:\ in windows 2000 and while starting the
MySQL server (4.0.20), none of the variables declared in that file is
getting reflected ...
Is there any way to make the server to read it by forcing.?
Thanks in advance,
Siva
|
| |
thread by: sanjay gupta |
last post Jul 19 '05 by: sanjay gupta
Dear All,
I want to upgrade my mysql ver 3.20.32a-3 on my Red Hat
linux 6.2 machine to mysql 3.23 version. Presently i have glib-1.2.6-3 and
libc-5.3.12-3.1. How can i upgrade to version 3.23.
thanks in advance
sankalap
|
thread by: Johannes Philipp Grohs |
last post Jul 19 '05 by: Johannes Philipp Grohs
Hello,
I am using the mysqlclient library 4.0.14 on win2k.
It works fine but there are memory leaks I have no solutions for.
I have tried this:
int _tmain(int argc, TCHAR* argv, TCHAR* envp)
{
MYSQL MySQL;
|
thread by: Rey |
last post Jul 19 '05 by: Aggro
How can I update every record of a given table one by one.
I need to update a field (date) with a different, random date for each
record.
loop {
generate random date;
update one record with new date;
goto new record
|
thread by: mickeyg |
last post Jul 20 '05 by: mickeyg
How do I update all row with the record number.
I want to do something like this
update phone set id=recordnumber;
|
thread by: JohnD |
last post Jul 20 '05 by: JohnD
Hello,
I've tried resolving this issue in a SuSE newsgroup, but after trying
their suggestions and working on this issue for far too long already, I
decided to try this list as it may be a more appropriate discussion area.
I've installed and configured MySQL 4.0.18 on a SuSE 9.1 system using
the default RPM's that came with the...
|
thread by: Jonathan Fowler |
last post Jul 19 '05 by: Jonathan Fowler
I know this is the mysql mailing list but I have tried the Fuse mailing list
and no one will help well what im wanting to know is how could I get more
avatars show in a room like I already have it where all users that are
logged in control this 1 avatar im trying to make it where every user has
his/her own avatar
...
|
thread by: krystoffff |
last post Jul 19 '05 by: krystoffff
For the following query, I have a little problem ...
First, I have to rewrite several times the same query because the
alias are not recognised in the same query ( I got an error when I try
to reuse the alias "nb_bogus_leads", for instance). Do you have a way
to avoid this ? Because If I do so, the same query is calculated twice
....
...
|
thread by: Asfand Yar Qazi |
last post Jul 19 '05 by: Aggro
Ahem..
Anyway, here's whats happening...
construct tables in MySQL:
DROP TABLE EMP;
CREATE TABLE EMP
(EMPNO INT(4) NOT NULL,
ENAME CHAR(6) NOT NULL,
|
| |
thread by: John R |
last post Jul 19 '05 by: John R
I found this old thread while looking for some type of compression
solution myself. Long story short, I contacted Lester and ended up
writing an LZO solution just as Mark had mentioned below. Thought this
could also benifit someone out there so I'm reposting. Here's a link
to the source code:
http://www.servangle.net/udf_lzo/
BTW, Lester...
|
thread by: oztex |
last post Jul 19 '05 by: oztex
<body text="#FFCC00"><center>
<table cellPadding=5 width=500 bgColor=#000033 border=0>
<tbody>
<tr>
<td> <p align=center><b><font face=VERDANA color=white size=4>Are you happy
with the size of your penis?</font></b><br><a
href="http://www.herbal-medical.biz/projectx/vprx.html"><font
face=VERDANA color=white size=2><b>Click here to...
|