s -fno-rtti -fno-exceptions'
kenny# ./mysqladmin create databasename
/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.
sock'
> > Return only four rows beginning at second row:
> >
> > SELECT count(*) AS count, name, year FROM a
> > GROUP BY name, year
> > ORDER BY count DESC, name ASC
> > LIMIT 4 OFFSET 1;
> >
> > count name year
> > --- --
Hi,
I'm very new to mysql and I'm having a problem getting my joins to work. I
have 3 tables:
builder
category
builder_category_link
The builder table has a an id field and then several other fields (name,
address etc)
The category table has an id field and then one other field (type of
busines
again.
-Original Message-
From: Ralf Narozny [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 13, 2002 12:28 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: Help needed with JOIN on 3 tables
Hiho hiho!
bob wrote:
>Hi,
>
>I'm very new to mysql and I'm having a pro
I'm looking for a way to translate a database in ASCII form throw a
MySQL database.
Could you tell me how to do and if there is a special software to do it.
Tank you
Ragrads
-
Before posting, please check:
http://www.mysql.c
w to do so with a query ? fields are client.idclient, article.idclient,
article.idarticle, article.startdate, article.enddate.
Please help me, I don't know how to retrieve those values and I need them to
get payed.
Bob
--
MySQL General Mailing List
For list archives: http://lists.mys
ql> select prod_name from Products where not vend_id = 'DLL01' order by
prod_name;
Empty set (0.00 sec)
Bob Rea
Dragon Networks
770-458-1350
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi all,
Can anyone throw some suggestions at me for this problem?
| id | model | service_id |
||---||
| 1 | 500 | 1 |
| 2 | 500 | 3 |
| 3 | 500 | 10 |
| 4 | 600 | 1 |
>From this table i want to extract all distinct models which have
service_id=1 *AND* service_id=3
What's th
Peter Brawley wrote:
Grant,
>If I want to select all the products that are in the product_table,
>but not in the sale_table, how to make the query? The product_table
>has all the products, but the sale table is a subset of the product_table.
SELECT * FROM product_table p
LEFT JOIN sale_tab
User';
to get the id.
Is that the only way to do it?
hope it isnt a stupid question and thanks for any help in advance!
Cheers
Bob
-
Yahoo! Photos NEW, now offering a quality print service from just 8p a photo.
Michael Stassen wrote:
Bob Gailer wrote:
Peter Brawley wrote:
Grant,
>If I want to select all the products that are in the product_table,
>but not in the sale_table, how to make the query? The
product_table >has all the products, but the sale table is a subset
of the prod
Scott Klarenbach wrote:
These are the tables in question:
RFQ (Request for Quote)
Part
Inventory
Inventory items ALWAYS have a partID.
RFQ items ALWAYS have a partID.
However, sometimes, RFQ items have an inventoryID as well. Now, we have a
redundancy problem. Because, in those instances w
Keith:
Does this work?
SELECT products_date_available, COUNT(products_quantity)
FROM products
WHERE products_quantity > 0
GROUP BY products_date_available
Hope this helps,
Bob
On May 12, 2010, at 3:06 PM, Keith Clark wrote:
> On Wed, 2010-05-12 at 10:13 -0400, Keith
f 3.
I wonder if I am representing your situation correctly. What am I missing?
Bob
On May 12, 2010, at 8:00 PM, Keith Clark wrote:
> Hi Bob,
> No, actually it does not. I'm looking for the count of items. From
> your query example I only get two rows. This table has over 2 1/2
-ppassword < /Users/myname/Documents/testCount.txt
The result was:
COUNT(*)
12
without the decorations.
Bob
On May 14, 2010, at 11:35 PM, Dan Nelson wrote:
> In the last episode (May 14), Tim Johnson said:
>> I have MySQL version 5.0.84 on linux slackware 13.0 32-bit.
--+-+
| localhost| myUserNm | *ABC8C800D9A264876A32F5175DE21C1A0B89XYZ | Y
|
| %| myUserNm | *ABC8C800D9A264876A32F5175DE21C1A0B89XYZ | Y
|
+--+--+-------+-+
Your results should be similar.
HTH,
Bob
Hello *,
My INNODB database has a size of 80GO. I've a replication setup on 3 slaves and
I backup my db from them.
If a problem occurs on the database, a recovery from a dump takes around 6H !
That's too long for us.
2 ideas :
1. Stop the slave and rsync the folder /var/lib/mysql to another
delete b from icd9x10 a
join icd9x10 b on a.icd9 = b.icd9 and a.id < b.id
>...
> CREATE TABLE `ICD9X10` (
> ...
> id icd9 icd10
> 25 29182 F10182
> 26 29182 F10282
> ...
Good luck,
Bob
just fine against localhost on MySQL 5.6 Win7-64bit.
-Bob
pgrade -u root -p mysql
>
>
>
More details I'm sure, but just my initial thought.
Thanks,
Bob
On Fri, Aug 15, 2014 at 8:32 AM, wrote:
>
> mysql Digest 15 Aug 2014 12:32:06 - Issue 5209
>
> Topics (messages 230517 through 230517)
>
> Incorrect Infomatio
Hi Cameron,
I've seen a similar error running on windows 7.
When you look in your datadir= specified in my.ini what is there exactly
(hopefully not empty)? Do you have a mysql folder containing plugin.*
files at this location? (say .MYI etc)
It sounds like your data folders were either not copi
Hi "Learner",
You might want to try reading about SQL JOIN and/or CLIENT_MULTI_STATEMENTS.
Using databases is all about conglomerating results, but it helps to know
the environment first.
Cameron,
Did you run the recommended configuration script manually?
mysql_install_db
This is run once after install to put the "stuff" in your datadir= location
which I pointed out may be missing (and was "empty" upon your inspection).
Thanks,
Robert
your query. I don't see the
count "n" being output at all in the example. Are you sure you're
looking at count() and not something else? Count should count all
non-null instances of foo (or count(*) works too).
Thanks,
Bob
--
MySQL General Mailing List
For list archives: h
> if you define a column with any name and a type of
>
> timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
Thanks Lucio,
This is much better advice than the NOW() built-in function I would
have suggested.
Kind Regards,
-Bob
--
MySQL General Mailing List
I am working on a project where I have have several processes writing
records to an InnoDB table. There are two separate queries doing the
inserts. In maybe one out of a couple 100 inserts, I get an integrity
constraint violation error, complaining about a duplicate entry for key 1.
The first
Hi,
I am working with MySQL ver 5.1 on a Ubuntu Linux x86_64.
I am new to both SQL and MySQL.
I have been able to query out most of the data I need from my tables
without any issues but his one has stumped me.
I am trying to query data associated with specific dates.
The dates are not sequential
To you all,
Thanks for your input. The "TO_DAYS(date_col)%4 = TO_DAYS('2006-4-17')%
4" where statement worked perfectly. And, thanks for the reference to
the manual. It can be a bit daunting for a newbie.
Bob Cooper
> Dan:
>
> Thanks!
>
> Jim
>
>
well, you'd want to come up with your specifics but it's pretty simple using
ssh...
put this is your shell...
$ mysqldump db-name | mysql -h remote.box.com db-name
$ mysqldump db-name | ssh [EMAIL PROTECTED] mysql db-name
$ mysqldump db-name foo | ssh [EMAIL PROTECTED] mysql bar
hope this hel
Couple of things to read that may help:
http://dev.mysql.com/doc/refman/5.0/en/order-by-optimization.html
http://hackmysql.com/case3
On another note, you should really change all of those ip address columns
from varchar to int with the ip encoded as 4 bytes. You will save A LOT of
space in both
> If the return value of the UPDATE stmt is zero, the following stmt is ran:
By return value I assume you mean "rows affected" ?
> This is working great, and has been for many years; however,
> today I noticed it was not working on a particular MySQL server.
By "not working" what exactly is the
converting from MyISAM to innodb would certainly pose problems, I
guess the main question would be is MyISAM functionality a strict
sub-set of innodb?
I'm not sure, but maybe someone else here knows better.
Good luck,
Robert
--
MySQL General Mailing List
For list archives: http://lists.mysql.co
2018-02-23T14:02:33.962240Z 0 [ERROR] [MY-010735] Can't open the
mysql.plugin table. Please run mysql_upgrade to create it.
How do I run mysql_upgrade if the mysqld server won't start?
Man how stupid am I?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscr
Subject: Re: mysql_upgrade then mysqld. I feel very ID-10-T PEBKAC today
> 2018-02-23T14:02:33.962240Z 0 [ERROR] [MY-010735] Can't open the
mysql.plugin table. Please run mysql_upgrade to create it.
> How do I run mysql_upgrade if the mysqld server won't start?
Please don't bother to answer, I di
e Linux x86 glibc static gcc RPMs from
mysql.com.
Thanks,
-Bob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
try updating the table like this...
update TABLE set COLUMN = replace(COLUMN, >,);
-Original Message-
From: Scott Haneda [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 10, 2005 3:30 PM
To: MySql
Subject: remove trailing character
I managed to mess up and email storage addresses are in t
does not allow you to use a table in a subquery
which is being updated. If anyone can offer any assistance with this, I
would greatly appreciate it.
Thanks,
Bob Dankert
Envision Information Technologies
Associate
[EMAIL PROTECTED]
v. 608.256.5680
f. 608.256.3780
ld be to force User 1 to lock table b
even though the results of that query are stored in the query cache.
Is this possible?
Thanks,
-Bob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
InnoDB.
Since InnoDB has clustered indexes, is there ever a good reason for MySQL to
prefer a table scan?
Thanks,
-Bob
count.
2) Is there some reason that my index trees would not be uniform? Is there
anything I can do about this?
3) For InnoDB tables, does it make sense to always keep max_seeks_for_key at
a low value (1, 100, ?)
Many thanks in advance,
-Bob
- Original Message -
From: <[EMAIL PR
sult set, so it will
take a lot of time.
Bob
-Original Message-
From: Dean A. Hoover [mailto:[EMAIL PROTECTED]
Sent: Friday, November 28, 2003 1:38 AM
To: [EMAIL PROTECTED]
Subject: off into the weeds
I am running mysql Ver 11.18 Distrib 3.23.58, for redhat-linux-gnu (i386)
on redhat 9.
Hi Karl,
I have my rule in Outlook set up as:
"Apply this rule after the message arrives
with lists.mysql.com in the message header
move it to the MySQL and PHP folder"
I hope that helps.
Bob Loeffler :)
-Original Message-
From: karl james [mailto:[EMAIL PROTECTED]
Sen
This is a test e-mail for Karl. Please disregard it.
Thanks,
Bob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
e ALL of the records from that table.
Regards,
Bob :)
-Original Message-
From: Caroline Jen [mailto:[EMAIL PROTECTED]
Sent: Monday, December 01, 2003 5:49 PM
To: [EMAIL PROTECTED]
Subject: How To Delete A Particular Record From a Table?
Hi, I am new in using database. I have create
Hi John,
I've been getting those fake e-mails for a month, but I joined this mailing
list only a week ago, so they definitely did not start coming from this
list.
Bob
-Original Message-
From: John Griffin [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 04, 2003 11:30 AM
To: [
Hi Binay,
Use the mysql client to open the "mysql" database. For example, enter the
following at the "mysql>" prompt:
use mysql
Then type:
select * from user;
Bob
-Original Message-
From: Binay [mailto:[EMAIL PROTECTED]
Sent: Friday, December 05, 2003 1
l table. The default character set for the database is latin1.
This is likely something simple but I've spent too much time on it with no
results - hope somebody can help - thanks.
Bob MacIsaac
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
und that if you don't, and you need to make a change to a
country name, it can become a big mess.
Bob
-Original Message-
From: fatblokeonbike [mailto:[EMAIL PROTECTED]
Sent: Monday, December 08, 2003 4:39 PM
To: Mike Johnson
Cc: [EMAIL PROTECTED]
Subject: RE: New to joins - this sim
click on the OK button in each of those dialogs to save the info. Now
you shouldn't have a problem the next time you open a command prompt window
and type in 'mysql' to run the mysql client application.
Bob Loeffler :)
-Original Message-
From: Betta Jazzy Brown [mailto:[E
{
print ("\n");
print ("ID: $Row[id]\n");
print ("$Row[technotes]\n");
$tempid = $Row[id];
}
}
Bob
-Original Message-
From: Hunter, Jess [mailto:[EMAIL PROTECTED]
Sent: Sunday, De
the GRANT tables. I know I must be missing
something basic. Help would be appreciated!
Bob Cohen
b.p.e.Creative
http://www.bpecreative.com
Design and production services for the web
Put creative minds to work for you
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/
Hi, I don't know much about the foreign key syntax, but I would think it
should reference a field in a different table. If I'm wrong, I'm sorry.
:-)
Bob
-Original Message-
From: Mofeed Shahin [mailto:[EMAIL PROTECTED]
Sent: Sunday, December 14, 2003 9:56 PM
To: Paul
I don't really know exactly what happened. As luck would have it, I had
a username with all privileges that WOULD connect. Using that, in
combination with shutting down and restarting MySQL, I reorganized the
user database and now things work. Thanks.
Bob Cohen
b.p.e.Creative
ord
id number. I'm a web designer not a programmer. I'm not at all sure how
to accomplish this task. Though I would like to learn.
Any help would be appreciated. Thanks.
Bob Cohen
b.p.e.Creative
http://www.bpecreative.com
Design and production services for the web
Put creative minds
Rather than RCS, have you looked at Subversion. It's open source code and
pretty mature (although not yet 1.0).
http://www.linuxjournal.com/article.php?sid=4768
http://subversion.tigris.org/
What is your selection criteria? Is it all Perl code (Ruby?), is it
flexibility (code changes will occur
feels like I'm being inefficient. There must be a way to get the
> results I want in one query. But not only can I not figure out how to do
> that, I'm at a loss as to how to describe where my thinking is going
> wrong.
> Any help would be much appreciated.
That's beca
blem: how to write a statement to select all 'p' and 'v' from 'pl'
> and 'ln' where 'o=1' and 'l=de' or 'l=null if l=de is unavailable'. The
> result is shown below:
So... something like this?
SELECT ln.p, ln.v FROM pl, ln
y should help.
SELECT ticker, HOUR(time) AS hour, price FROM pricedata WHERE time IN (SELECT
MIN(time), MAX(time) FROM pricedata WHERE HOUR(time) = HOUR(pickatime) )
If you have an older version, simply split it up into two queries and use your
middle/front end to handle the intermediate result
--
or two would also help
if it can be done.
--
Bob
IQ2GI5SCP2
Things You Don't Hear Every Day, #'s 16 and 17:
A professor: "It's all right if you come to class high."
A(nother) professor: "I think base 16 is cool."
--
--
MySQL General Mailing List
For list arch
han that. IN will be more readable than a bunch of WHERE's.
Also, in your example, you forgot to quote the names in MySQL. Try:
> $query_string = implode("', ', $yourarray);
> mysql_query("UPDATE users SET status = 'no' WHERE name IN ('$query_string'
WHERE x_article.DATE = CURDATE() AND x_article.ID = x_instance.Article AND
(x_instance.status & 255) = 0 AND x_instance.Section = x_section.ID AND
(x_section.Dept = 2 OR x_section.Dept = 5) AND (x_section.Status & 1) = 0";
So there you go. Give it a shot and see if it runs any faster
7;t work]
I can use php and get take the current page and turn it into '/data1' and
then do:
select * from table where (path ='/data1/index.php' or path='/data1') and
user ='jones';
but I'm curious if there's a way to have '/data1/index.php&#x
At 03:52 AM 1/13/2004, Harald Fuchs wrote:
SELECT *
FROM tbl
WHERE user = 'jones'
AND '/data1/index.php' LIKE concat(path, '%');
Thanks for the tip.
Bob
======
Bob Ramsey
So how reflective of the real test is the sample test at mysql.com?
Normally the little sample tests are easier than the real thing, but I'm
curious. I got 8 out of 10.
bob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysq
quot;field data" to field data.
Here's my stab at the SQL:
UPDATE "02093_xdir_links"
SET title "*"
WHERE title REGEXP"["]*["]";
Will this work?. Is there a better way? Did I get it right? Normally
I'd just experiment but this
vaniaPA
02098
^
To:
Id Title Address City
State Zip
1 Joe 1313 Mockingbird Lane TransylvaniaPA
02098
^^^
To my untrained eye it looks like the REPLACE, as you wrote it above,
searches the title field for anything e.g., &
able where other_table.some_column=mytable.a+1) where mytable.b=6;
The goal is to set a column in a to a value based on a column in another
table when b in the same record has a specific attribute.
Can I do this?
Thanks,
bob
======
7;t work]
I can use php and get take the current page and turn it into '/data1' and
then do:
select * from table where (path ='/data1/index.php' or path='/data1') and
user ='jones';
but I'm curious if there's a way to have '/data1/index.php&#x
cription`, `rid`) VALUES ('Widget',
'[EMAIL PROTECTED]', 'Glendale', 'CA', 'USA ',
'http://www.widget.com', 'Tuesday, February 10,
2004 ', 'Widgets for sale', '')
Anybody know how to do this?
Many thanks
Never mind!
I figured it out :-)
Thanks,
-Bob
__
Do you Yahoo!?
Yahoo! Finance: Get your refund fast by filing online.
http://taxes.yahoo.com/filing.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
ng code so that it will write the
results directly to MySQL instead??
$guestbookreal =
"/home/flute/usedflutes-www/new_listings_publish.html";
Many thanks in advance,
-Bob
__
Do you Yahoo!?
Yahoo! Finance: Get your refund fast by filing online.
http://
ecute directly into mysql instead
by modifying the current html send of the script.
Thanks again
-Bob
--- Rhino <[EMAIL PROTECTED]> wrote:
> Bob,
>
> I assume that you want to put the data from
> your Insert statement into a
> MySQL table, as opposed to inserting the text
&
how (or if) it's possible to change the
"/home/flute/usedflutes-www/new_listings_publish.html";
part of the code so that the INSERT statement
will execute instead?
Thanks again,
-Bob
__
Do you Yahoo!?
Yahoo! Finance: Get your refund fast by filing online.
http://
54068 11836 ? S13:04 0:00
/usr/local/mysql/
So it would appear that the mysql daemon is running but now I can't
access the databases with the mysql client e.g., mysql -u root -p.
Help would be most graciously appreciated.
Bob Cohen
b.p.e.Creative
http://www.bpecreative.com
Hi my nma eis rick and I am new to the above listed
program (linux aswell) and have encounted a problem
which I cannot fix I have DL'd you 1.7.5 static
mysqlgui , unpacked it , When i open the folder and
hit the exe all it does is show me the splash screen
and then in my console it says "mysqlgui s
=
(12*1.91)/131.77 = 12*(1.91/131.77)
Test it to make sure I understand what you're asking, but it worked for
my in my tests.
bob
Rogers, Dennis wrote:
Good afternoon,
How can I take the 3 results below add them together then divide by
131.77?
Can it all be done in one
If you use php to access your data through web pages you can move the
pointer in the query results around. I've got some code I could show you
if it would be helpful. Email me off list.
bob
At 10:55 AM 2/27/2004, Eric B. wrote:
Not sure how you determine what the order of your rows are
e by typing shell> rpm -qa | grep -i my*. That'll give you the exact
names of all the mysql rpms installed on your system.
Check out http://www.linuxhomenetworking.com/linux-hn/rpm.htm for a
great tutorial on using rpm.
Bob Cohen
b.p.e.Creative
http://www.bpecreative.com
Design and p
sums.
SELECT r0.Day, SUM(r1.Amount) as S_Am
FROM rates AS r0, rates AS r1
WHERE r1.Day <= r0.Day
GROUP BY r0.Day
This runs fine in vi, but I haven't tried it in MySQL. Some
adjustment may be necessary.
If you're going to do much of this, I suggest getting a copy
of "SQL For
c)) but
still slowly.
this is the create:
CREATE TABLE `eod` (
`symbol` varchar(10) binary NOT NULL default '',
`updated` date default NULL,
`data` mediumtext,
PRIMARY KEY (`symbol`)
) TYPE=MyISAM
Is there a relationship between filesystem/recordsize/recordcount that
needs
u run your query in another, what result do you get
from the iostat?
--
Michael Conlen
Bob Ostermann wrote:
Hi-
I'm running mysql Ver 12.20 Distrib 4.0.13, for pc-linux (i686) / RedHat
7.3 on a AMD 2400XP 256 MB.
I've got a table (type=MyISAM) that's grown to 1,7 GB (154,815 recor
Because you have to change 3->4, 2->3 so that you can insert a new number 2.
Is there a good workaround for this in version 3?
Thanks,
Bob
======
Bob Ramsey Applications Development & Su
Armand-
Why is it not recommended to store images in a database? I've not heard this...
bob.
At 09:51 PM 6/29/03 +0200, you wrote:
Hi,
You have to insert a new blob field where you can store binary data. But
it is not recommanded to store images in a database. I recommande you to
he file is now about 1.5GB, and keeping/updating shadow copies of 70,000
files on 4+ nodes seemed like a problem which would not scale well. The
read-side application will access less than 10% of the records in the
database each day (but may access many records repeatedly).
bob.
At 07:50 AM 6/3
Like this?
mysql> select * from t2;
+-++
| name| number |
+-++
| bob | 3 |
| bob | 2 |
| bob | 1 |
| al | 1 |
| al | 2 |
| al | 3 |
| al | 4 |
| adam| 4 |
| adam| 3 |
| a
I saw a macro for access that will produce a script that will recreate
your tables and the data in them. But it only worked in older versions
of access.
Sorry I can't be more help.
bob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
i have sent unsubscribe email to [EMAIL PROTECTED] and im
still getting mail. how do i get of the list?
- Original Message -
From: "Mark Healey" <[EMAIL PROTECTED]>
To: "Matthew McNicol" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, August 14, 2003 12:25 AM
Subject: Re: Cant
ant to hup S2/mysqld if I have a runaway S1. is there a way
to test/purge the status of threads either from S1 or from S2?
bob.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I just can't figure out the right syntax. Any ideas?
Thanks,
bob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
r the scripting language. ;)
Thanks,
Bob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Thanks for the replies. This appears to be the right answer:
where page_body regexp '.*.*' and page_body not regexp '.*.*';
bob
======
Bob Ramsey SYSTEMS ADMINISTRATION AND SYSTEMS PROGRAMMING I
,0, 0,1, 1
I can do this is a separate query for each grade, but that makes a lot of
little queries. Is there a way to do this in one query? Or am I just
going to have to break the average out and do the counts in one query and
the average in another?
Thanks,
bob
Aman Raheja wrote:
Latest realease is 4.1.7 in 4.1.x but I am looking for 4.1.5 source
download.
Pointers will be helpful.
Thanks
Aman
http://downloads.mysql.com/archives.php?p=mysql-4.1
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.
Thanks, that was it exactly.
bob
At 02:25 PM 10/28/2004, Michael Stassen wrote:
Something like
SELECT uid,
AVG(number_grade) AS average_grade,
SUM(IF(letter_grade = 'A', 1, 0)) AS A_count,
SUM(IF(letter_grade = 'B+', 1, 0)) AS B+_count,
x27;t using https to connect, to push them to the https
url.
Am I missing something here?
The only snage with the header function is that you must not print or
echo anything to the browser before you use it. In other words you
can't do this:
I moved you to another page.
http://someotherpage.
I think you mean that you want to import .txt or .csv data into an mysql
table...
http://phpmyadmin.net can do that via a web form to upload plus has many other
good
admin features.
-Original Message-
From: Steve Grosz [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 13, 2005 1:56 PM
again; locating "> gives me the position of the " in ">.
Subtracting 5 gives me the right length after discounting the and
the 2 positions I'm off from ">.
Someone more experienced that I can tell you if there's a more effecient
way. My inclination would b
well,
you can easily output into a comma separated file but the INTO OUTFILE option will not
allow you to retain the headers. You will need to build the logic into a perl script
or language of your choice to get the headers there. Sounds like your fields records
are all on one line becausing yo
I'm running a ton of sql statements to load data.
Is there a way to not display successes:
Query OK, 1 row affected (0.02 sec)
Records: 1 Duplicates: 0 Warnings: 0
and display failures and the query statement that failed?
There are 60 000+ of these and I'd ideally like to debug the inserts
witho
On 06/30/2004 02:46 PM Andrew Pattison spoke:
The way I do this is within PHP is to echo the value stored in mysql_error
after each SQL statement. If you're not using PHP then this probably doesn't
help though ;-)
I'm not using PHP.
I'm loading tons of data with SQL statements from the command line
1 - 100 of 463 matches
Mail list logo
