Hello all,
I need to load a new InnoDB table with about 80 million rows.
With MyISAM I have often found that it is faster to create
the table without indexes, add all the data, then add the
indexes. Is this true with InnoDB as well, or should I put
my indexes in before loading?
Similarly, I
In theory it is fastest to add indexes first, then disable it (ALTER
TABLE x DISABLE KEYS), then add data and, on the end, re-enable keys
(ALTER TABLE x DISABLE KEYS).
mirza
Keith Thompson wrote:
Hello all,
I need to load a new InnoDB table with about 80 million rows.
With MyISAM I have often
Hi Massimo,
May be after some minutes of inactivity client closes connection to MySQL
server?
In this case MySQL deletes all temp tables that were created by this client.
Best regards,
Mikhail.
- Original Message -
From: Massimo Petrini [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent:
Env: Windows 2003 server, .NET framework 1.1, ODBC .NET provider,
Connector/ODBC 3.51.
I'm developing a test .NET application that connects to mysql using ODBC
.net provider.
For the test I'm using this simple table
CREATE TABLE `provanuova`
(
`id` INTEGER (11) NOT NULL AUTO_INCREMENT
no; because the client have still the result of the query on the screen and
on the server the thread is still existent in sleep mode.
- Original Message -
From: Mikhail Entaltsev [EMAIL PROTECTED]
To: Massimo Petrini [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, January 22, 2004
no; because the client have still the result of the query on the screen
and
on the server the thread is still existent in sleep mode.
could you explain in details what is your system configuration?
what is the client of MySQL server?
- Original Message -
From: Massimo Petrini [EMAIL
Hi!
You should always create the indexes BEFORE adding the data to an InnoDB
table.
In CREATE INDEX ... ON ..., MySQL rebuilds the whole table. Thus, it will be
much slower to add the indexes afterwards.
Many databases have an optimized index build procedure where adding an index
afterwards is
anybody used prepared statements in 4.1 succesfully?
Has anybody used prepared statements in mySQL 4.1 succesfully. By succesfull
I mean quicker !
I have some prepared statement in my app and they take just as long the
second++ time as they do hte first. My querys may need to be optimized (i
Hi,
I would have a question respect to the spatial extension inserted in the
version 4.1.0 - alpha.
A limit of coordinates exists that a LINESTRING succeeds in managing ?
And if yes,it's possible to modify it ?
One query of mine that operates with spatial data doesn't go to good end if
I try to
Victoria Reznichenko wrote:
Kittiphum Worachat [EMAIL PROTECTED] wrote:
Try to set character set to other not latin1 with MySQL 5 (windows
binary) it not work can some one tell me how to do this.
If you want to set character set on the server level, you should start mysqld with
We have a server running NT4 with mysql 4.017 (with the my.ini as in
previuous mail). In the network the client (the single pc ) run msaccess
application linked to mysql database. In such case we use a temporary table,
created as follow
CREATE TEMPORARY TABLE wrk_AlzateIntervalli(Lotto CHAR(10)
Kittiphum Worachat [EMAIL PROTECTED] wrote:
Victoria Reznichenko wrote:
Kittiphum Worachat [EMAIL PROTECTED] wrote:
Try to set character set to other not latin1 with MySQL 5 (windows
binary) it not work can some one tell me how to do this.
If you want to set character set on the server level,
What is the difference between Left Join and Left Outer Join?
Thanks
Hello guys!
I was wondering, do you have any aproximate date for the release of the
mysql administrator? Also, i read that there is a linux version, but i
only got to see windows screenshoots, does anybody have a linux
screenshoot available?
Best regards!
--
Victor Medina [EMAIL PROTECTED]
--
Since you aren't using the C API directly, you should make sure your
API is actually using prepared statements. I don't know anything about
Connector/J, but for example, last I checked, the Perl DBI mysql
modules didn't really prepare statements when you called the prepare
method. This is of
Mike Mapsnac wrote:
What is the difference between Left Join and Left Outer Join?
Thanks
If I get it right, there is none.
Greetings
Fred
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi Daniel,
You are not alone in your quest to successfully start the mysqld
server on a Mac OSX platform. I am having similiar difficulty
on my ibook...
--- On Thu 01/22, Daniel Lahey [EMAIL PROTECTED] wrote:
From: Daniel Lahey [mailto: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Date:
on a related note how can you verify that you're actually using a prepared
statement (re: not reparsing)?
in Oracle you can watch ratio of executions/parse_calls in v$sqlarea but how can
you measure their effectiveness in mysql?
obviously you can infer it with comparative tests of execution
I've posted the same question on another forum and have got no reply, so
that doesn't look good.
I would love to hear about it, since I really, really want them to be
working properly.
me too!
do any of the dudes involved with mySQL read this forum ?
even though I didn't pay for support would
I successfully used the packages from Server Logistics for this task,
installing PHP, Apache and MySQL first on my 10.2.8 Jaguar, then on my
10.3.2 Panther G4.
http://www.serverlogistics.com/mysql.php
- Eve
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
If you have the right level of logging turned on, you will see
evidence in your query log.
Generally you see command sequences like Connect, Query, Query, Query,
Quit. With prepared statements you would see Connect, Prepare,
Execute, Execute, Execute, Quit.
I don't know off hand if there is a
On Thu, Jan 22, 2004 at 01:51:09PM +, Brian Power wrote:
do any of the dudes involved with mySQL read this forum ?
even though I didn't pay for support would they respond to a direct email ?
My experience is that if you aren't filing rock-solid bug reports, and
you aren't paying, the
I referred the left join because sub selects are not available in 4.0
(which is the release version) only 4.1. If I'm wrong on this please
somebody tell me.
Joe
On Wednesday, January 21, 2004, at 10:45 PM, Randy Johnson wrote:
SELECT * FROM tableone WHERE value NOT IN (SELECT column FROM
Heikki,
Thanks for your help.
I have another very large table to convert to InnoDB from MyISAM.
I also have the same table saved in a file suitable for 'load data'.
Which would be faster:
ALTER TABLE xxx TYPE=InnoDB;
or
CREATE TABLE newxxx ...; INSERT INTO newxxx select * from xxx;
or
Thanks to all those who answered
Even after changing the the day() to dayofmonth(), the queries would still
not pull out the request information...
After a little reflection, I noticed that something had changed this DB
was originally an Access DB, and it was converted to MySQL, in the
I think this is the package I used. The one that I used actually wrote
and init script so if you reboot mysql will start automagically. I
think this is the one.
Joe
On Thursday, January 22, 2004, at 08:51 AM, Eve Atley wrote:
I successfully used the packages from Server Logistics for this
This one actually installs a preference pane that allow you to manipulate
settings, start/stop server, and change root password. It's quite nice.
- Eve
-Original Message-
From: sulewski [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 22, 2004 7:25 AM
To: Eve Atley
Cc: [EMAIL
wow! That is nice
On Thursday, January 22, 2004, at 01:28 PM, Eve Atley wrote:
This one actually installs a preference pane that allow you to
manipulate
settings, start/stop server, and change root password. It's quite nice.
- Eve
-Original Message-
From: sulewski [mailto:[EMAIL
At 22:39 -0800 1/21/04, Daniel Lahey wrote:
Ok, I've read the release notes, the manual, the threads on this
mailing list, installed/removed/re-installed about 5 times, tried
4.0.1, 4.1, 5.0, and I can't get MySQL to run on my Mac (dual-proc
867MHz, 768MB RAM). When I run configure, it tells
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Brian Power wrote:
anybody used prepared statements in 4.1 succesfully?
Has anybody used prepared statements in mySQL 4.1 succesfully. By
succesfull I mean quicker !
I have some prepared statement in my app and they take just as long the
My hosting company uses MySQL 3.23.58, and I'm running PHP-Nuke 6.9 (if
you're not familiar with it; it's at http://www.phpnuke.org/).
At any rate, the problem I'm having is that PHP-Nuke uses a field to
store a signed-up date for each user, but, for some reason, it's just
a text field and not
Thanks Mark I'll try that tonight.
just curious, what sort of development process do you use ? Agile, XP ?
Nightly builds, fortnightly releases. You must run a smooth ship over there.
From: Mark Matthews [EMAIL PROTECTED]
To: Brian Power [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Subject: Re:
Hi there,
I've got a small issue which looks a little like a bug. I'm using MySQL
4.0.15-standard-log, on RedHat 9.0 with InnoDb tables.
Essentially I have two tables, one table is a list of integers, while the
second is a table of integer pairs. e.g.
+---+ +-+-+
| A | | B.x | B.y
Michael McTernan said:
I'm using MySQL 4.0.15-standard-log, on RedHat 9.0 with InnoDb tables.
Essentially I have two tables, one table is a list of integers,
while the second is a table of integer pairs. e.g.
+---+ +-+-+
| A | | B.x | B.y |
+---+ +-+-+
| 1 | | 1
Keith,
I would divide the work:
1) CREATE TABLE innodbtypetable ...
2) INSERT INTO innodbtypetable SELECT * from myisamtypetable WHERE
primarykey = xyz AND primarykey zyx;
etc.
If you run out of disk space or get some other problem, the rollback will
not be as huge as for a single
* Ben Ramsey
My hosting company uses MySQL 3.23.58, and I'm running PHP-Nuke 6.9 (if
you're not familiar with it; it's at http://www.phpnuke.org/).
At any rate, the problem I'm having is that PHP-Nuke uses a field to
store a signed-up date for each user, but, for some reason, it's just
I'm using MySQL 4.1.1 for NT and noticed the following
select date_sub('2003-08-29', interval 21 week)
produces a syntax error. It doesn't recognize week or quarter. But I
can substitute day, month, year and it works.
The MySQL manual says it accepts week and
quarter
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Works perfectly! Thanks!
Roger Baklund wrote:
| Yes, it can be done using the FIELD() function:
|
| SELECT * FROM tablename
| ORDER BY
| MID(datecol,8), # year
| FIELD(LEFT(datecol,3), # month
|
I installed MySql 4.0.x on MacOs 10.2.x and it works fine.
There are some problems of permissions: check /tmp and mysql data directory.
Santino
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Actually, it's not working quite as perfect as I thought. When using
ASC, it works fine, but when using DESC for sort order, it's quirky.
For example, in ASC mode, it orders like this:
Sep 28, 2003
Oct 05, 2003
Dec 06, 2003
Dec 31, 2003
Jan 02, 2004
Daniel Lahey wrote:
Ok, I've read the release notes, the manual, the threads on this mailing
list, installed/removed/re-installed about 5 times, tried 4.0.1, 4.1,
5.0, and I can't get MySQL to run on my Mac (dual-proc 867MHz, 768MB
RAM). When I run configure, it tells me everything is
That's perfect, but in DESC mode, it orders like this:
Sep 28, 2003
Oct 05, 2003
Dec 31, 2003
Dec 06, 2003
Jan 14, 2004
Jan 10, 2004
Jan 02, 2004
If you're ordering by three fields and you want all of them to be in
descending order you have to put DESC after each of them, not just
the
At 12:38 -0500 1/22/04, Ben Ramsey wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Actually, it's not working quite as perfect as I thought. When using
ASC, it works fine, but when using DESC for sort order, it's quirky.
For example, in ASC mode, it orders like this:
Sep 28, 2003
Oct 05,
We are currently doing an audit of the software installed on all our
systems, in an effort to remove as much junk (adware, etc) from the
computers as possible.
To help give the management staff of the company a good overview of
where problems may be, my boss would like an Excel-style summary so
* Paul DuBois
[...]
Jan 02, 2004
[...]
By the way, why do you have MID(datecol,8) rather than MID(datecol,9)?
There was no comma in the dates in his original post. He should use
MID(datecol,9) if there actually is a comma in his dates, though
MID(datecol,8) will also work in this case because
Hi there,
Thanks for your quick response!
Why all the locks, temp tables and updates? You can just do:
SELECT
CASE WHEN B.y IS NULL THEN A.x ELSE B.y END AS newX
FROM
A LEFT JOIN B ON A.x = B.x
Spot on - many thanks! I wasn't aware of the CASE function, but I've
certainly learnt
Folks,
Is InnoDB activated by default in MySQL V4 or V4max? Do I have to
compile from source with the innoDB flag in order to use the innoDB
tables or just in stall the RPM?
Patrick
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Yeah, that was my mistake. Sorry about that. I've changed it to 9.
Roger Baklund wrote:
| * Paul DuBois
| [...]
|
|Jan 02, 2004
|
| [...]
|
|By the way, why do you have MID(datecol,8) rather than MID(datecol,9)?
|
|
| There was no comma in the dates
Here is my problem:
I have 2 tables, a parent table and a child table. The parent table has got 113
rows, the child table has got 3 000 000 rows.
parent:
---
| p_id | name |
---
| 1| A |
| 2| B |
| ... |... |
| 112 | C |
|
I'm using a preconfigured package that includes PHPMyAdmin, which seems to
be a pretty good program. However, I just read that similar programs are
available, including MySQL Control Center, EMS MySQL Manager, urSAL,
PremiumSoft MySQL Studio and MySQLGUI. I just wondered if there might be
some
At 10:49 -0600 1/22/04, mos wrote:
I'm using MySQL 4.1.1 for NT and noticed the following
select date_sub('2003-08-29', interval 21 week)
produces a syntax error. It doesn't recognize week or quarter.
But I can substitute day, month, year and it works.
The MySQL manual says it accepts week and
At 11:19 -0800 1/22/04, David Blomstrom wrote:
I'm using a preconfigured package that includes PHPMyAdmin, which
seems to be a pretty good program. However, I just read that similar
programs are available, including MySQL Control Center, EMS MySQL
Manager, urSAL, PremiumSoft MySQL Studio and
On Thursday 22 January 2004 02:19 pm, David Blomstrom wrote:
I'm using a preconfigured package that includes PHPMyAdmin, which seems to
be a pretty good program. However, I just read that similar programs are
available, including MySQL Control Center, EMS MySQL Manager, urSAL,
PremiumSoft
At 13:34 -0600 1/22/04, Paul DuBois wrote:
At 11:19 -0800 1/22/04, David Blomstrom wrote:
I'm using a preconfigured package that includes PHPMyAdmin, which
seems to be a pretty good program. However, I just read that
similar programs are available, including MySQL Control Center, EMS
MySQL
At 02:19 PM 1/22/2004, David Blomstrom wrote:
I'm using a preconfigured package that includes PHPMyAdmin, which seems to
be a pretty good program. However, I just read that similar programs are
available, including MySQL Control Center, EMS MySQL Manager, urSAL,
PremiumSoft MySQL Studio and
I recently installed a preconfigured package with Apache, PHP and MySQL
from Apache Friends (XAMPP). It seems to be a pretty slick package, and I
got all three programs up and running without too much trouble. Now I'm
beginning to learn about MySQL.
I finally got MySQL connected to
At 12:42 PM 1/3/2004, Ugo Bellavance wrote:
-Message d'origine-
De : Kirti S. Bajwa [mailto:[EMAIL PROTECTED]
Envoyé : Saturday, January 03, 2004 9:24 AM
À : [EMAIL PROTECTED]
Objet : MySQL Control Center!!!
Hello:
I have been reading MySQL Control Center. There are screen
I have a shell script that will insert information about systems I have into
a MySql database. I wanted to have it so that the script could run daily,
and just update the records if a record for the particular system was
already in the database. This could make the script complex because I would
Prompt, then through phpMyAdmin. Each time, it knocked out phpMyAdmin,
and I had to reinstall everything from scratch. So I'm finished with
the root password.
Once you've added a root passsword you'll need to add this to the
config.inc.php (assuming you're running phpMyAdmin with conf option;
At 02:57 PM 1/22/2004, David Blomstrom wrote:
I recently installed a preconfigured package with Apache, PHP and MySQL
from Apache Friends (XAMPP). It seems to be a pretty slick package, and
I got all three programs up and running without too much trouble. Now I'm
beginning to learn about MySQL.
I'm a total newbie. I just ran the installer
(mysql-standard-4.0.17.pkg) on my Mac (10.2.1). The installer ran
correctly and said that it successfully installed the package. But I
can't find it. It's not in Applications or Utilities. I actually read
the Read Me file, which says that it's at
Thanks for your reponses but I tried both of the
suggestions below and still had problems.
I killed mysql and then I used
/etc/init.d/mysql start
I was able to use mysql --user=mysql and get into mysql
However when I tried to create a database I get
ERROR 1044: Access denied for user:
Does it make sense to ever index a DATETIME column? We do a
lot of reporting on a large (~10MM records) table where we
only need to look at a particular day or two. My selects
currently look like:
WHERE entered = 2004012400 AND entered = 20040124235959
Is there such a thing as an index on
At 14:39 -0600 1/22/04, Eamon Daly wrote:
Does it make sense to ever index a DATETIME column? We do a
lot of reporting on a large (~10MM records) table where we
only need to look at a particular day or two. My selects
currently look like:
WHERE entered = 2004012400 AND entered = 20040124235959
Hello Marco,
When I'm trying to do an insert I got the following
error
Error [07006][MySQL][ODBC 3.51
Driver][mysqld-4.0.17-nt] Restricted
data type attribute violation sql-c-numeric
Could you please provide the code you use to do the
insert.
TK
__
Do you
Massimo Petrini wrote:
We have a server running NT4 with mysql 4.017 (with the my.ini as in
previuous mail). In the network the client (the single pc ) run msaccess
application linked to mysql database. In such case we use a temporary table,
created as follow
CREATE TEMPORARY TABLE
Mike, have you looked into Perl, and Perl's DBI module?
You can do something like this... (example only, not tested code):
--
use DBI;
use strict;
use warnings;
# Get arguements from command line
my $ether_address = $ARGV[0];
my $location = $ARGV[1];
# Database connection info
$database =
Paul wrote:
Is there such a thing as an index on the first 8 characters
of a DATETIME column?
No. Indexes on partial column values are available only for string
types.
Won't PACK_KEYS=1 help in a situation like this?
From the Documentation:
6.5.3 CREATE TABLE Syntax
If you don't use
At 14:33 -0700 1/22/04, [EMAIL PROTECTED] wrote:
Paul wrote:
Is there such a thing as an index on the first 8 characters
of a DATETIME column?
No. Indexes on partial column values are available only for string
types.
Won't PACK_KEYS=1 help in a situation like this?
Yes, but it's a different
Everyone,
I downloaded Backup Watcher for MySQL today and am trying a few tests. I
created one backup from a remote server, but the SQL statement Backup
Watcher generated is over 20 megs, making it a little difficult (at least
for me) to process. I'm running a W2K-SP4 setup, MySQL 3.23.49. I'm
At 01:20 PM 1/22/2004, Paul DuBois wrote:
At 10:49 -0600 1/22/04, mos wrote:
I'm using MySQL 4.1.1 for NT and noticed the following
select date_sub('2003-08-29', interval 21 week)
produces a syntax error. It doesn't recognize week or quarter. But I
can substitute day, month, year and it works.
Hi,
Is there a more practical way to execute a statement of
this size, or another program that will handle remote
server backups differently?
You might use mysql.exe client (found in 'c:\mysql\bin'
folder):
mysql.exe -u your_username -p c:\backup_file.sql
Take care,
Aleksandar
-Message d'origine-
De : brent [mailto:[EMAIL PROTECTED]
Envoyé : Thursday, January 22, 2004 4:50 PM
À : [EMAIL PROTECTED]
Objet : large SQL statements
Everyone,
I downloaded Backup Watcher for MySQL today and am trying a
few tests. I
created one backup from a remote
Hi All
My data file has all these files
(root)@webrt:/usr/local/mysql/data# du -sh *
25K ib_arch_log_00
3.0Kib_arch_log_02
3.0Kib_arch_log_04
101Mib_logfile0
101Mib_logfile1
1.9Gibdata1
1.5Gibdata2
2.0Kmy.cnf
70K mysql
2.0Knewdb
39M
I believe that this will flush those logs:
mysql reset master;
-- Greg
On Thu, Jan 22, 2004 at 05:23:07PM -0500, Asif Iqbal wrote:
Hi All
My data file has all these files
(root)@webrt:/usr/local/mysql/data# du -sh *
25K ib_arch_log_00
3.0Kib_arch_log_02
3.0K
Hi there,
Patrick Fowler wrote:
Do I have to
compile from source with the innoDB flag in order to use the innoDB
tables or just in stall the RPM?
As I am using flawlessly working InnoDB tables on an RPM installation of
MySQL, I can say: no need to compile from source for InnoDB use.
Fred
--
(Note: I've been having trouble with Eudora; I can receive mail, but I
often can't send e-mails. So I resubscribed to the MySQL list from my other
e-mail address,
http://us.f604.mail.yahoo.com/ym/[EMAIL PROTECTED]YY=19813order=downsort=datepos=0view=ahead=b[EMAIL PROTECTED],
but I haven't
I am having a problem with accessing the mysql database in a new MySQL
installation on OS X Panther.
This installation came with the original OS, and some configuration was done
right after installation. I have previously installed MySQL on Linux and Win
and have never encountered this problem.
Hi!
I've got a box that has several IP addresses assigned to it, but I'd
like MySQL to listen on just one of those.
Could someone point me in the right direction if this is possible?
Thanks!
Andrew
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Quite some time ago, I started doing a book of exercises. I got some work,
put it down, and now I need to start over. So I start up MySQL, do a DROP
DATABASE [name];. And I'm answered by:
ERROR 1008: Can't drop database '[name]'. Database doesn't exist
So I figure, okay, then I can CREATE it,
At 08:29 PM 1/22/2004, you wrote:
Quite some time ago, I started doing a book of exercises. I got some work,
put it down, and now I need to start over. So I start up MySQL, do a DROP
DATABASE [name];. And I'm answered by:
ERROR 1008: Can't drop database '[name]'. Database doesn't exist
So I
[EMAIL PROTECTED] wrote:
Quite some time ago, I started doing a book of exercises. I got some work,
put it down, and now I need to start over. So I start up MySQL, do a DROP
DATABASE [name];. And I'm answered by:
ERROR 1008: Can't drop database '[name]'. Database doesn't exist
So I figure,
Hello,
I'm a newbie in MySQL. I have a table that contains column 'startdate
[date]' and 'enddate [date]'. Somehow, I have to execute SQL that search
any entry that corresponds to the current year and current month, e.g.:
SELECT * FROM mytable WHERE fieldx = '123' AND (startdate LIKE
Hey guys,
Im trying to build a login system with
Phpmyadmin and php, with dreamweaver.
I use the coder view to code my pages.
Would any of you guys be willing to help a rookie
Out. Ive tried to read and follow tutorials but
I have a hard time manipulating it towards my code and site!
Anyone
Andy Prasetya wrote:
Hello,
I'm a newbie in MySQL. I have a table that contains column 'startdate
[date]' and 'enddate [date]'. Somehow, I have to execute SQL that
search any entry that corresponds to the current year and current
month, e.g.:
SELECT * FROM mytable WHERE fieldx = '123' AND
Victoria Reznichenko wrote:
Starts fine for me from command line:
C:\mysql\binmysqld-nt.exe --default-character-set=tis620 --standalone --console
040122 14:36:50 InnoDB: Started; log sequence number 0 43634
mysqld-nt.exe: ready for connections.
Version: '5.0.0-alpha-nt' socket: '' port: 3306
this could help
http://www.mysql.com/doc/en/Date_and_time_functions.html
V!nay
Chris W wrote:
Andy Prasetya wrote:
Hello,
I'm a newbie in MySQL. I have a table that contains column 'startdate
[date]' and 'enddate [date]'. Somehow, I have to execute SQL that
search any entry
Hi, MySQL Team!
First this:
Fantastic product. You are to be congratulated.
Secondly:
I've downloaded and successfully installed v5.0 win2k, and am happily using stored
procs, but seem to be encountering problems with subqueries in stored procs. When I
run a stored proc containing a
A few quick questions for installing on red hat 9 (on a funky old
Pentium 2 333mhz machine with 256MB ram).
When I attempt to install the rpm for the server I get a HUGE list of
conflicts with an existing install of mysql (3.53.x). Weird thing is,
I've never installed MySQL on this machine and
Hi,
I was wondering if anyone has compiled, or found, statistics in terms
of what percentage of installs are running which version of MySQL. The
main concern would be version 3 versus version 4. We are currently
deciding if it makes more sense to optimize our software to run on 3
and then
Specifically I get the following error when attempting to start the
server:
Starting mysqld daemon with databases from /var/lib/mysql
040122 22:09:21 mysqld ended
And when I try to connect I get an error (as expected)
Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
If
Ari Denison wrote:
Specifically I get the following error when attempting to start the
server:
Starting mysqld daemon with databases from /var/lib/mysql
040122 22:09:21 mysqld ended
And when I try to connect I get an error (as expected)
Can't connect to local MySQL server through socket
Greetings all,
I have 3-4 tables of members on a website.
However over time I have table one that lists 14000 records and table two
lists 14121 records.
What kind of SQL call would I put out to compare the two tables and find
out which records in table two do not have a corresponding ID number
93 matches
Mail list logo