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 wrote:
> > mysql> show profiles;
> >
> +--++--+
> > | Query_ID | Duration | Query
> > |
> >
> +--
nse that the longer your
transaction block is, the more time you spend holding (read) locks, 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 no
_entry >0
GROUP BY ee_entry
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 a
> 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 fro
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 usi
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/[
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
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 an
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
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 G
____
> Ext3-users mailing list
> [EMAIL PROTECTED]
> https://www.redhat.com/mailman/listinfo/ext3-users
>
--
Stephen Samuel http://www.bcgreen.com
778-861-7641
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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
F
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 PROT
--- 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
gt; 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
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]
ne 4.3
To safe guard, it would be better to run 'FLUSH PRIVELEGES'.
Can I re-run
REVOKE SELECT, INSERT, UPDATE, DELETE ON test.* FROM
'vmailuser'@'localhost';
then
FLUSH PRIVELEGES;
???
Tks.
B.R.
Stephen
Send instant messages to your online friends http://uk.messeng
, 0 rows affected (0.00 sec)
mysql>
I suppose it has been 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]
replace [, user] with [, vmailuser]???
Please 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]
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 a
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
--- 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:
>
> http
d
error: 'Access denied for user 'root'@'localhost' (using password: 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]
; > mysqladmin: connect to server at 'localhost' failed
> > error: 'Access denied for user 'root'@'localhost' (using password:
> YES)'
> > * end *
>
> That is asking for your *old* password.
I did not create any password before.
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 'foo_
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
recedence with
the comma operator 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
db.tab_f WHERE tab_a.id = 'value' AND tab_a.id2 = 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 l
-SQL ones since 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 tha
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
in the
same way as MySQL does, 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 de
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"
Sent: Sunday, May 07, 2006 3
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]
y doesn't work - it finds ALL the rows in Project table and hence
repeats 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]
s query is now
frequently in the slow 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]
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
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,
AddressLine2,
(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
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 r
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 SET = -1
when the is 0 gives me
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 a
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 f
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]
s/query-browser/1.1.html) and MySQL
Administrator (http://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 ho
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 an
p.ID#">#qryLookUp.Description#
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]
just as well 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 Gener
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]
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...
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_increm
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 defaul
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 ) and the query.
mysql> SHOW CREATE TABLE Player|
+
+---
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 archiv
zed, and repaired all the tables
in the database without any luck. 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
ore information 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 programming
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
QAErr
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 l
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 M
his system has been running fine for months
until now.
...Stephen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
;c:\mysql\share\charsets\Index' file
which 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]
is.
Is there actually a fix?
If there is a fix, would 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]
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:
>
> >
and running. I 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 Gene
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 a
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 Stott
rname 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]
d then UNIONing the two record sets?
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
pear
when you fix this.
Hope this helps
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
Compl
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]
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".
[s
as it took to get
one. So, for example, I can process thousands of records in four
seconds or just one.
I did resolve my problem, however. I created a temporary database
connection to do the updates.
...Stephen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ed. Any rows that I haven't
processed yet should keep the old timestamp.
...Stephen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
);
mysql_query(&mysql, updateStr);
}
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]
eat shakes if I 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://li
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 4
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 run
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
"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 fi
>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 *
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 tempor
[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.
Assumin
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
ing I 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
Ok, then it makes sense to use compact flash just for backup and not the
primary
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 Data
databases 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 PROTEC
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
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 280 matches
Mail list logo
