Hello,
I have a empty db that I'm trying to load a .sql file (created via
mysqldump) into. The dump has 791611 lines and is 807 MB. Loading the
dump is consistently failing at line 1763. Line 1763 is an INSERT
statement. The line is 95610 characters long.
The error is:
ERROR 2013 (HY000) at line
On Wed, Jul 11, 2012 at 5:46 AM, Reindl Harald h.rei...@thelounge.netwrote:
mysql show profiles;
+--++--+
| Query_ID | Duration | Query
, and
thus excluding writers.
Hope that helps,
--
Stephen Tu
Can't get slow querys to log. Does this not work in myisam?
*snip*
[mysqld]
log-slow-queries = /var/log/mysql/mysql-slow.log
long_query_time = 1
*snip*
restarted mysqld - no log.
Created in file in /var/log/mysql/
*snip*
-rwxr--r-- 1 mysql mysql 0 May 7 10:33 mysql-slow.log
*snip*
still
ORDER BY COUNT( * ) DESC
LIMIT 5
)
ORDER BY ee_entry DESC , dt ASC
But I received an error:
#1235 - This version of MySQL doesn't yet support 'LIMIT
IN/ALL/ANY/SOME subquery'
Thanks for your help,
Stephen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
I've been poking around google looking for tutorials and/or quick start
guides on optimizing the mysql server. We just upgraded our DB server from
2
Gb of RAM to 16. But I don't know how to reconfigure mysql to take full
advantage of it. Although, just installing the RAM seems to have
On Sun, 15 Feb 2009, John wrote:
How do I disable showing ALL the databases on the server for a normal user
that only has access to a single database? So that when a user runs show
databases, they only get a list of ones they can access. I've seen this done
before.
Sorry if it's a newb
I got this recently and haven't replied to the list in a while. I responded
to the list owner.
-Original Message-
From: Martijn Tonies [mailto:[EMAIL PROTECTED]
Sent: Monday, February 25, 2008 12:13 PM
To: mysql@lists.mysql.com
Subject: Re: Bogus unsubscribe!
I just got an email
This works fine for me:
http://www.mysql.com/products/tools/administrator/
-Original Message-
From: Esbach, Brandon [mailto:[EMAIL PROTECTED]
Sent: Monday, February 18, 2008 12:22 PM
To: [EMAIL PROTECTED]
Cc: MySQL User Group
Subject: RE: Backup table structure, not data
I ended up
column equals the value in the
modification column? I don't want to specify a specific id in either
of the columns.
TIA
Stephen P. Fracek, Jr.
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
I have two tables.
TableA is current data.
TableB (created with 'Create Table A like Table B' ) is an archive where
deleted data is inserted from Table A before being deleted from table B with
INSERT INTO TableA Select * , Null, NOW (), 'ACTION', 'USER' from TableA.
The null column in TableB
QUESTION: What are the most secure permissions settings for administrator
access to connect to my server without using a static IP address?
MY ISP changes my DSL ip address almost daily so when I log on to MySQL
Administrator with 'myusername'@'currentipaddress' using password
'mypassword'
I
I executed an insert...select and some empty fields were inserted into a
table. I'm trying to delete these empty fields but a look up for:
FIELD = ''
FIELD = 'null'
FIELD = '0'
FIELD = '[SPACE]'
Returns nothing.
What should I be looking for to delete these empty fields?
Thanks.
--
MySQL
I was able to delete them using the CreateDate timestamp.
For future reference what is the difference between = and is
if I may ask.
Thanks.
-Original Message-
From: Gary Josack [mailto:[EMAIL PROTECTED]
Sent: Saturday, September 22, 2007 1:20 PM
To: Stephen Sunderlin
Cc: mysql
Thanks!
-Original Message-
From: Gary Josack [mailto:[EMAIL PROTECTED]
Sent: Saturday, September 22, 2007 2:47 PM
To: Stephen Sunderlin
Cc: mysql@lists.mysql.com
Subject: Re: Finding empty feilds
NULL does not equal , , null, 0, 0 or any other variation.
Those are all values. NULL
an issue for SATA).
Cheers, Andreas
--
Andreas Dilger
Principal Software Engineer
Cluster File Systems, Inc.
___
Ext3-users mailing list
[EMAIL PROTECTED]
https://www.redhat.com/mailman/listinfo/ext3-users
--
Stephen Samuel http
I've recently converted a CRM database with about 20k entries. I exported
the data to ACCESS had to tweak the field names and value then Inserted all
into mySQL with mySQL Administrator. During the conversion out of the CRM
into ACCESS the unique Primary Key for each contact, which is also the
If you can import your excel doc into MS Access I'd suggest:
http://www.mysql.com/products/tools/migration-toolkit/
I just started using and love it - easy intutitive GUI tool for importing
data into nySQL databases.
Good luck.
-Original Message-
From: Jason Pruim [mailto:[EMAIL
shed me some light. TIA
B.R.
Stephen Liu
Send instant messages to your online friends http://uk.messenger.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
done ???
B.R.
Stephen
Send instant messages to your online friends http://uk.messenger.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ON test.* FROM
'vmailuser'@'localhost';
then
FLUSH PRIVELEGES;
???
Tks.
B.R.
Stephen
Send instant messages to your online friends http://uk.messenger.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
be better to run 'FLUSH PRIVELEGES'.
Can I re-run
REVOKE SELECT, INSERT, UPDATE, DELETE ON test.* FROM
'vmailuser'@'localhost';
then
FLUSH PRIVELEGES;
Yes. I think on this recent a version, it will have no effect, but
will not harm anything.
Noted with tks.
B.R.
Stephen
--- Baron Schwartz [EMAIL PROTECTED] wrote:
Stephen Liu wrote:
If you want to
get rid of the user entirely, use DROP USER.
Could you please explain in more detail??? Where shall I add DROP
USER
The manual always explains the full syntax (http://dev.mysql.com/),
Whether you
I think that offering some sort of feedback other than result sets would
be nice for debugging.
Peter Brawley wrote:
I hope this isn't a silly question, or something covered in a FAQ. . .
but is there any reason to not have at least some primitive print
formatting commands in MySQL? Or am
I'd go the other way and use a trigger to validate the data, and roll
back the transaction if it isn't in valid format (assuming you are using
transactions). This way, ANY app that puts data in that field gets the
validation. An error in an application or typing by someone who has
direct table
'@'localhost' (using password:
YES)'
* end *
That is asking for your *old* password.
I did not create any password before. This is a new installation. I'm
tuning it.
B.R.
Stephen Liu
Send instant messages to your online friends http://uk.messenger.yahoo.com
--
MySQL General Mailing List
: NO)'
* end *
Stephen
Send instant messages to your online friends http://uk.messenger.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--- Chris [EMAIL PROTECTED] wrote:
- snip -
So you *have* set the root password before.
From your previous emails:
# mysqladmin -u root password yourrootsqlpassword
That set the password to yourrootsqlpassword.
If you need to reset it, see documentation:
I always go with REPLACE(REPLACE(STRING, '\n', ''), '\r', ''), since
depending on where your data came from there may be one or the other, or
both. Although if there is a shorthand/more efficient way I'd love to
hear it.
[EMAIL PROTECTED] wrote:
Ok.. I found the problem.. I needed to add a
http://lists.mysql.com/[EMAIL PROTECTED]
that link ought to help you.
Jacques Brignon wrote:
Hi,
I keep receiving this message by several dozens each day, how can this
be stopped?
Regards
Jacques
-Message d'origine-
De : Jerry Schwartz [mailto:[EMAIL PROTECTED]
Envoyé : jeudi
You should send that one to The Daily WTF... http://thedailywtf.com/
Jay Blanchard wrote:
[snip]
I recently last week Had and experience with an Very small Company,
where as
they had around 15 Machines all hooked Star topology and a central iis
ASP
Web server that only showed the date, and a
You can use the INFORMATION_SCHEMA.TABLES view to generate the GRANT
statements for you. Write a query along these lines:
SELECT CONCAT('GRANT SELECT ON test.', TABLE_NAME, ' to ''foouser'';')
FROM INFORMATION_SCHEMA.TABLES
WHERETABLE_SCHEMA = 'test'
AND TABLE_NAME LIKE
Hi,
For my current website project I'm developing a fine-grained access control
system.
I have the schema mostly worked out, although it will be having additional
data added to parts of it later.
For the record, I have 6 tables:
users (contains all my individual users)
usergroups (contains all
There apparently isn't a PRINT or RAISERROR function like there is in
SQL Server, I've asked about this before.
I created a stored procedure to dump debug text into a table (which is
timestamped) and another to output the rows in there in a SELECT. It
isn't the same but it's something.
Dan
= tab_e.id2 AND tab_e.id3 =
tab_f.id3 LIMIT 1; - this is ok
Why doesn't the original query work in MySQL 5.0? What do I need to do to
make it work?
TIA
Stephen P. Fracek, Jr.
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
and the join, I realized there was a
simple fix and that I had misinterpreted the section on the first read.
The revised query works.
Stephen P. Fracek, Jr.
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
that is what I get paid for).
I'm not here to discuss people's religious beliefs, I'm here to learn
what MySQL can and can not do.
Peter Brawley wrote:
Stephen Cook wrote:
There are such things as extensions to the standard, and many
languages besides BASIC that have the ability to output
There are such things as extensions to the standard, and many languages
besides BASIC that have the ability to output a character string. No
need to be snippy.
I will look into the --silent option, thanks!
Peter Brawley wrote:
Stephen Cook wrote:
I appreciate it but SELECT isn't quite what
, particularly string expression and function,
I think we will find that the SQL SELECT will do all of the things that
Stephen has come to expect from the PRINT statement in MS SQL Server.
I've just put together an SQL Script that I think demonstrates that
SELECT can do mostl of the same things
I've started using the SELECT with no other clauses but I am still
curious about a PRINT-like command. It is for SQL scripts.
Rhino wrote:
- Original Message - From: Stephen Cook [EMAIL PROTECTED]
To: MySQL List mysql@lists.mysql.com
Sent: Sunday, May 07, 2006 3:53 AM
Subject: PRINT
Is there a statement similar to PRINT in T-SQL (MicroSoft SQL Server)?
It would be handy to debug some scripts.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Several of my DISTINCT searches are frequently showing up in the slow query
log. These queries use multiple table joins. Using EXPLAIN shows that the
queries are using the appropriate keys, as far as I know. Are DISTINCT
searches using multiple joins slow?
TIA.
Stephen P. Fracek, Jr.
[EMAIL
query log.
Stephen P. Fracek, Jr.
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
the sites..
I do have an index on the Site table, it is the Site_ID. The
Project.Site_ID is also indexed.
Stephen P. Fracek, Jr.
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
A commonly used example (at least at my last 3 jobs) would be a table of
demographics for people (whether they be employees, clients, whatever).
You can have one table and allow NULLs for some of the fields (id,
LastName, FirstName, MiddleInitial, Title, NameSuffix, AddressLine1,
I am scripting out the creation of a database so I can make changes and then
run the script to generate a clean copy (by running it in MySQL Query
Browser).
The script DROPs all the tables, then CREATEs them again along with all the
indices and whatnot. However, if I run the script after having
(and of decent size) going I'll start using the other options; right
now I'm just playing with a throwaway database to get a feel for the syntax.
On 3/13/06, Andreas Krüger [EMAIL PROTECTED] wrote:
Stephen,
the behavior of MySQL server sounds bizarre, as to what information you
give us
Maybe it is because I am a programmer, but (unsigned) 0 - 1 = 4294967295.
What's the big deal?
Gleb Paharenko wrote:
Hello.
That seems like a bug:
http://bugs.mysql.com/bug.php?id=14543
Marko Domanovic wrote:
mysql 5.0.15-standard
UPDATE table SET fieldname = fieldname-1
Jim Winstead wrote:
This is addressed in the FAQ for the mailing lists.
http://lists.mysql.com/faq.php#replyto
Jim Winstead
MySQL Inc.
Times and technology change. Take a look at the changes to MySQL server
and the internet in general since 2000.
That's all I'm going to say as there
I got one from mysql@lists.mysql.com, and one from [EMAIL PROTECTED]
And my filters remove anything that isn't from one of the mailing lists
I subscribe to.
Daniel Kasak wrote:
Stephen Cook wrote:
What's the deal with SPAM on the list?
I don't see any. Maybe my spam filter is better
What's the deal with SPAM on the list?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
://dev.mysql.com/downloads/administrator/index.html)
for GUIs to manage your database server.
Regards
Stephen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
You must not install 5.0 over 4.1, put it somewhere else.
Also, instead of naming the service MySQL both times, call it
something else (i.e. MySQL41 and MySQL50). If you use the Windows
installer distribution, it is one of the options; if you are doing it by
hand then you already know how to
His answer was correct, and somewhat politer than RTFM.
As for finding your own damn answers, see again Mr. Green's original
reply.
Beauford wrote:
Sorry, but I don't take kindly to idiots. I don't care if he's gods gift to
MySQL. If there isn't enough info for him to give an informed
=#qryLookUp.ID##qryLookUp.Description#/option/cfoutput
Where ID and Description are the column names in the look up table.
Hope this helps
Regards
Stephen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
to install one of the many MySQL
GUIs out there. I actually quite like MySQLs suite of tools now. Query
Browser is still a bit buggy, but its getting better each iteration.
http://dev.mysql.com/ - just check out the links in the box on the right
hand side.
Stephen
--
MySQL General Mailing List
I am curious, can MySQL be used for Directory Sevices and act as an LDAP Server.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I'm getting a strange ordering when using ORDER BY on a int column.
The rows are being returned sorted as follows:
1
10
11
12
13
14
15
2
3
4
5
6
7
8
9
I'm sure this is a simple one, but I haven't found an answer in the
archives.
Thanks,
Steve
--
MySQL General Mailing List
For list
On Sep 27, 2005, at 2:58 AM, Jigal van Hemert wrote:
You are most likely to get meaningful suggestions to solve the
mystery if you include the table definition (output of SHOW CREATE
TABLE tablename) and the query.
mysql SHOW CREATE TABLE Player|
+
On Sep 27, 2005, at 3:29 AM, Jasper Bryant-Greene wrote:
mysql SHOW CREATE TABLE Player|
| Player | CREATE TABLE `Player` (
`id` int(16) NOT NULL auto_increment,
`first_name` varchar(32) NOT NULL default '',
`last_name` varchar(32) NOT NULL default '',
`year` varchar(16) NOT NULL
On Sep 27, 2005, at 9:56 AM, Edward Vermillion wrote:
Michael Stassen wrote:
Stephen A. Cochran Lists wrote:
On Sep 27, 2005, at 3:29 AM, Jasper Bryant-Greene wrote:
mysql SHOW CREATE TABLE Player|
| Player | CREATE TABLE `Player` (
`id` int(16) NOT NULL auto_increment,
`first_name
On Sep 27, 2005, at 10:28 AM, Pooly wrote:
The command in PHP is:
$query=SELECT id,first_name,last_name FROM Player ORDER BY id;
$players=mysql_query($query);
When issued from the mysql prompt, order is fine, but when
called from php I'm getting that strange order:
1, 10, 11, 12, etc...
. The db appears to be working fine.
MySQLHotCopy works ok with other databases on this server.
MySQL 4.0.23
Server: Mac OSX Server 10.3.8 dual 1.33 Ghz PPC G4 with 2 GB SDRAM
DB has 274 tables with 1.6 million records. DB size is 400 MB.
Any insights would be greatly appreciated.
TIA
Stephen
about MySQLi here :
http://uk.php.net/manual/en/ref.mysqli.php
Stephen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL is a relational database. XML is a text file.
the biggest difference is that MySQL will let you organize, sort,
match/link (joins), and otherwise manipulate the data you have. XML is
just text with tags in a heirarchy; anything other than reading it in a
text editor will take
it is because of the dollar sign that it works so much quicker.
Scott Hamm wrote:
I'm now trying to learn engines in MySQL. When I migrated from M$ SQL to
MySQL to learn the migration process and executed the following:
SELECT
*
FROM
QA
LEFT JOIN
Batch
ON
Batch.QAID=QA.ID
LEFT JOIN
Per Jessen wrote:
3. Again, as you can understand, I want to minimize the cost here. If
you don't think I can use mysql, do you think Microsoft SQL server is
good enough for this task?
I don't think so, no.
what are you basing this on?
SQL Server is a truly great database package, don't
depending on what you use this information for, you might want to keep
two tables, one with the current information, and one of the history. it
would keep the current one relatively small, but allow for looking up
historical data if necessary.
nephish wrote:
Hey there,
i have been messing
Is there a good place/book to lookup formulas for tunning mysql ?
What size should the table_cache be ? I have 2,770 tables
What size should the key_buffer be ? I am only using 38 MB out of 265
MB, yet my Index Length reported by mysql-administrator is 2.72 G
Total number of records are 61
of memory:
# pidin in
CPU:X86 Processors:1 FreeMem:927Mb/1015Mb BootTime:Apr 21 16:44:25 PDT 2005
Processor1: 1586 Intel ?86 F15M2S9 2670Mhz FPU
Any ideas what is going wrong? This system has been running fine for months
until now.
...Stephen
--
MySQL General Mailing List
For list archives: http
is classified as Bug number 312
(http://bugs.mysql.com/bug.php?id=312)
Regards
Stephen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
someone be kind enough to give me an idiots
guide on what to do please?
Regards
Stephen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
of LONG datatypes may throw a monkey
wrench in the works.
Good luck.
Stephen
(Sr Oracle DBA by day - Jr MySQL DBA by night)
On Tue, 22 Mar 2005 10:48:53 -0500, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Z X C V [EMAIL PROTECTED] wrote on 03/21/2005 08:32:24 PM:
Hello,
Are there any good
just
want something similar for Linux.
Rekall looks like a tool that would meet my needs, but I'm getting
frustrated with the install process. Has anyone gone through that and
found a better way? Or does anyone have an alternate recommendation?
Thanks
Stephen
--
MySQL General Mailing List
Manish wrote:
We're having some problems in getting MySQL 4.1.8 to work with JDBC drivers
in -
mysql-connector-java-2.0.14-bin.jar
Do these drivers work with MySQL 4.1.8? hey seem to be working fine with
4.0.14 version of MySQL.
Is there any compatibility data available for all these JDBC drivers
IN ('stotts','statts','stutts')
http://dev.mysql.com/doc/mysql/en/Comparison_Operators.html#IDX1235
Regards
Stephen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Ian Grant wrote:
On Wed, 05 Jan 2005 12:22:18 +
Stephen Moretti [EMAIL PROTECTED] wrote:
Kentucky Families wrote:
... If I use a VARCHAR or TINYEXT field to enter these values and
I want to be able to retrieve all records where the surname field
contains the whole word Stotts, how
?
Stephen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I have a database that is constantly moving large numbers around.
At the moment when a simple INSERT into Table_Name
('3573286532896523465328654654365436543'); is run
the value entered into the table is a zero. The field type that I am inserting
into is DOUBLE(200,0) unsigned.
Also this is all
Stephen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Jochem van Dieten wrote:
On Wed, 10 Nov 2004 07:42:29 +, Stephen Moretti (cfmaster) wrote:
Why is this list reply to sender and not reply to list?
Why don't you read the FAQ?
Ah right. I see - a 2 year old article -
http://www.unicom.com/pw/reply-to-harmful.html
Completely
Jason Williard wrote:
I recently upgraded MySQL from 3.23.58 to 4.1.7 on a Fedora Core 1 system.
After the upgrade, I ran into the following error with a previously
installed copy of Bugzilla. I think the core of the error is Client does
not support authentication protocol requested by server.
may be of interest to other members of the list.
Just a suggestion, but please make the list reply to list and not
reply to sender.
Thanks
Stephen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
.
...Stephen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
the updates.
...Stephen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
);
}
However, when I do this, I get:
Commands out of sync; You can't run this command now
Anyone have any ideas on how to to accomplish this?
...Stephen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
can't recover them, being my dev machine, but
would be nice if I can get them into the server. Any suggestions?
TIA and regards from a very foolish feeling
Stephen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
FYI, I ran the same scenario under MySQL 3.23.58 and it produced the
results you wanted/expected:
+--+-+-+
| col1 | A-count | B-count |
+--+-+-+
|1 | 4 | 0 |
|2 | 0 | 6 |
+--+-+-+
So could it be a bug in
I reformated the hard
drive and reinstalled. In order to install, I copied the
/usr/local/mysql directory from a working system.
Stephen Rasku
Tantalus Systems Corp.
Your Power. Your Data. One Wireless Network.
T: 604-299-0458 x220 F: 604-451-4111
www.tantalus.com
--
MySQL General Mailing List
Never mind. I installed MySQL from a different location and now it
works.
...Stephen
-Original Message-
From: Stephen Rasku [mailto:[EMAIL PROTECTED]
Sent: September 23, 2004 9:32 AM
To: [EMAIL PROTECTED]
Subject: MySQL client hangs
I am running MySQL 4.0.17 on QNX 6.2.1B
select name
from mytable a
where changedate
(select changedate
from mytable b
where a.name=b.name
and a.changedate != b.changedate);
or:
select name
from mytable a
where exists
(select * from mytable b
C.F. Scheidecker Antunes [EMAIL PROTECTED] wrote:
I have a table that has a PartNumber and the Quantity of Items sold for
each partNumber, that is:
PartNumber
Qty
I need to get its sales raking given its PartNumber, that is. So if I
order the table by Qyt in descending order the first
record
I had a similar problem, but my criteria for selecting the
value of f1 was different; it's a date field and I wanted
only the rows with the most recent date value in that field,
so only the latest of otherwise identical entries got inserted.
I ended up doing something like this:
create temporary
Andrew Dixon [EMAIL PROTECTED] wrote:
Hi Everyone.
I require some help with an IN statement I'm trying to get working. I have
inherited a database from someone else in which there is a table with
project information and a field containing which geographic regions the
projects relate. As a single
[EMAIL PROTECTED] wrote:
My connection to the mysql is correct, that is host, username, password,
however when I click the link of form so that it will pull out data from
mysql database, I see the php code of the form, any guidance, please.
This is a Web server configuration issue.
Assuming
but one gets
backed up much more frequently than the other. The whole operating
system and application is stored on the flash drive.
HEAP tables might be the solution. How would I archive these to disk on
shutdown?
...Stephen
-Original Message-
From: mos [mailto:[EMAIL PROTECTED]
Sent
I just looked into this. It looks like HEAP tables don't support the
BLOB field type and we are using it.
...Stephen
-Original Message-
From: Brent Baisley [mailto:[EMAIL PROTECTED]
Sent: Jul 30, 2004 6:19 AM
To: Egor Egorov
Cc: [EMAIL PROTECTED]
Subject: Re: Installing MySQL Databases
could get running on QNX.
...Stephen
-Original Message-
From: mos [mailto:[EMAIL PROTECTED]
Sent: Jul 30, 2004 10:23 AM
To: [EMAIL PROTECTED]
Subject: RE: Installing MySQL Databases on RAM Drive
QUOTE
Ok, then it makes sense to use compact flash just for backup and not the
primary
databases that we are using. Neither is very big but one
is updated very frequently and the other one is not. However, even
though the databases are small, the ibdata1 file is 136M. Is there a
way to prevent this file from growing too big?
...Stephen
--
MySQL General Mailing List
For list
or similar on the connection procedure. Does anyone know or have
any suggestions as to where I can find such
information?
Thanks,
Stephen Finn
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
1 - 100 of 266 matches
Mail list logo
