In my experience, RedHat in their 'wisdom' put mysql.sock in /tmp/ yet
ships their mysql-server.rpm with a my.cnf pointing at
/var/lib/mysql/mysql.sock
Make the necessary change to /etc/my.cnf to point to /tmp/mysql.sock, or
change /etc/rc.d/init.d/mysql to point to /var/lib/mysql/mysql.sock
-
I'm trying to get a slash in a variable into my database and am having
some trouble. If the variable = "1 1/2" it echoes to the screen correctly
but it seems to strip the 1/2 off the variable when updating the value to
the database.
Just FYI to everyone replying:
Ed replied to me personally admitti
ensure that everything related to MySQL, including the
> app itself, is removed before making a clean install of MySQL 4.0.22.
Hi,
>From a command prompt:
netstat -an
or gui (free) - this shows which prohrams have the ports open as well
http://www.sysinternals.com/ntw2k/source/tcpvie
It doesn't say access denied so I assume the socket is not even open.
Never assume :o)
From your windows box, you could try:
telnet host.domain.com 3306
... if it connects, it connected to *something*
How can I find out if MySQL is on the port 3306?
What Linux command shows all active ports
1. If a new database is created on db1, this is not replicated on db2
and db3. ... is there a better way to automate duplicating this
>>database on the slaves?
Yes put in your my.cnf on the master binlog-ignore-db=mysql,test this
means the master will replicate any event to any database other then
RAID system and mounted via NFS to multiple machines to
actually run the MySQL engine? The tables we use have a lot of
auto_increment fields, and I'd be worried about data being corrupted or
lost.
Thanks,
Ian Douglas
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[EMAIL PROTECTED] root]# ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock
[mysqld]
port= 3306
socket = /var/lib/mysql/mysql.sock
Which is fine ... you neglected to say whether or not that fixed your
problem?
-id
--
MySQL General Mailing List
For list archives: http://lists.mys
[EMAIL PROTECTED] root]# ls -l /var/lib/mysql
total 20564
-rw-rw 1 mysql mysql25088 Nov 1 14:10 ib_arch_log_00
-rw-rw 1 mysql mysql 10485760 Nov 2 07:39 ibdata1
-rw-rw 1 mysql mysql 5242880 Nov 2 07:39 ib_logfile0
-rw-rw 1 mysql mysql 5242880 Nov 1 14:10 ib_log
But can I edit a column field? Can I go into a specific column in a
specific record and edit it just like I was in a text editor? That's the
action I want. None on the products specifically state they can do it(?)
phpMyAdmin will allow you to alter a column name within a table, yes.
can't speak for
There are lots of ways to do it. My personal favorite is to write it in
Perl with the DBI library and tell cron to run that Perl script ... your
Perl script could then write the data in any format you see fit, even
send it somewhere else using Net::FTP or whatever.
Just my $0.02...
-id
Scott Ha
m/article/hierarchical-data-database
I found this by typing:
storing tree structure in mysql database
into Google ;)
Ian
--
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
rns the expected results.
- but thanks for the help.
- ian
--
| Ian Sales Broadband Solutions for |
| Database AdministratorHome & Business |
| PlusNet plc http://www.plus.net |
+ ---
set (0.00 sec)
Common sense expects the number of rows returned to be four. So where's
the Cartesian coming from?
- ian
--
| Ian Sales Broadband Solutions for |
| Database AdministratorHome & Business |
| Pl
Administrator and looking at the key
efficiency and sure enough it was 0%. I then decreased the key_buffer
to 2GB and it mysteriously started working again.
Thx,
Ian
The information transmitted in this email is intended only for the person(s) or entity
to which it is addressed and may
stamp datetime NOT NULL default '-00-00 00:00:00',
PRIMARY KEY (sid),
KEY http_host (http_host),
KEY user (user)
) TYPE=InnoDB;
--
Ian Gulliver
Penguin Hosting
"Failure is not an option; it comes bundled with your Microsoft products."
MySQL thread id 806227, query
available via the command line in the normal
> way for SQL catalogs. But that was strictly a wild guess; you may be totally
> correct in your assumptions.
Hi,
Maybe the Java driver is simply running this query:
USE database;
SHOW FIELDS FROM `tablename`;
and caching the re
Hi Haitao.
I'm in the process of developing one of these for the company I work for.
Feel Free to drop me a line and we'll see how we can get it going for you.
Regards
Ian
Haitao Jiang wrote:
Hi,
We want to test our MYSQL (4.1.4g) server's query performance, and I
just wondering if
. ( It is available for both unix/linux and windows ).
This will SSL encyrpt all traffic on the designated ports between the client and
server, you can also set it to only accept connections with the right client
certificates.
I have succesfully used this setup in production systems.
You wi
hi.
I want to create the one-page per chapter style of HTML docs on my local
hard disk.
how do I do this?
I have create the single page html document, but I can't find any docs
on the split one.
TIA
Ian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mys
e > help.txt
then read help.txt
Hope this helps
If not try this (joking):
http://foldoc.doc.ic.ac.uk/foldoc/foldoc.cgi?RTFM
Ian
--
and install a real firewall ;)
Hope this helps
Ian
--
ent to a browser via mime
type *application/vnd.ms-excel* ) will be opened directly by Excel.
You can also include styles / text formating / functions etc within the
cells.
I ues this as a method for customers to download data easily.
You will still have to write your own code to do the export t
dvantage of SSL. If
you want to protect the tunnel you could set up
firewall rules or even client certificates.
Hope this helps
Ian
--
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
anyone has implemented a UDF or
something which does a similiar thing with data in a mysql table.
TIA
Ian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
.0.17. This is also
displayed through the sql-bench results.
So the obvious question is what changed between 4.0.16 and 4.0.17 that would cause
these results?
Thx,
Ian.
The information transmitted in this email is intended only for the person(s) or entity
to which it is addresse
by
a list member infected with a virus, but with the growing increase in spam shouldn't
the archives be clean by default?
Thoughts?
I will be unsubscribing from the list and re-subsubscrbing with a new address shortly,
so don't be surprised if direct replies are bounced...
Re
On 8 Jul 2004 at 7:28, Victor Pendleton wrote:
> Does the older MyODBC version properly work? I have run into some oddities
> with the latest MyODBC driver.
Forgot to mention...
Same result with
2.50.33.00
Ian
--
>
> -Original Message-----
> From: Ian Gibbons
> To
: 800A01CA
Regards
Ian
--
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
this functionality?
Thanks
Ian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
at I normally visit without problems. Still
> no MySQL as of 9:14am EST.
Hi,
No luck with www.mysql.com
but
http://dev.mysql.com/
works fine.
Ian
--
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
t would like to
know if there is a parameter that indicates full (or not)
synchronization with the master that I can obtain through a
perl/shell/python script or C program.
The mysql version is 3.23.57.
Thanks for any input.
Ian.
--
Ian van der Neut
KNMI, R&D Observations, De Bi
I'd just like to say thanks to both Michael and Rocar for both solutions. I will be
giving them a go.
I now need to buy a more comprehensive manual for MySQL, as neither of these commands
are in the 2 books I currently have.
Many thanks
Ian
-Original Message-
From: Michael St
one in a single query? Is there
a command that I just haven't yet found?
If it is of any help, the version of MySQL being used 4.0.16. This version is
installed by the Helpdesk/Audit software, and so cannot be upgraded.
Your help is greatly appreciated.
Ian Izzard
Visit our web site at
d no
major errors.
Anybody have any ideas what might be causing the server to restart like
this?
-Ian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
the connection was refused.
Is this a known problem? Is there a solution?
- ian
--
| Ian SalesUnmetered & ADSL solutions
| database administrator for Home & Business
| PlusNet Technologies Ltd. @ http://www.plus.net
+ - My Referrals - It
Is it possible to have a 'worked out value' in the WHERE clause. The problem
I have is what I need to check for in the WHERE Clause is not a column:
SELECT
CONCAT_WS("-",DATE_FORMAT(EntryDate,'%c'),DATE_FORMAT(EntryDate,'%Y')) As
mthyr
>From Blogs
WHERE mthyr=1-2003
This does not work as it seems
Is anyone on the list using Coldfusion MX with MySql? It's just I've hit a
problem I've been hitting my head against for a week or so. The coldfusion
people I know have hit a blank (but they are using SQL Server). I'm
stretching now in an attempt to find someone with experience of both sides?
Than
I want to order my articles in descending order on date, and for articles on
the same date I want to order by ID in ASC. I've tried the following:
ORDER BY EntryDate DESC, ID ASC
But it does the EntryDate Order but nothing else. The problem I have is I
don't want to record the time (the user ente
rom: "sulewski" <[EMAIL PROTECTED]>
> I think you can just put the alias after the field like so,
>
> select id,author,date_format(entrydate,'%d %m %y') ArticleDate,
> SectionId,Title,Summary...
>
You were correct - the version using AS does not work (I'd tried that before
mailing).
--
MySQL
Regarding the following query:
SELECT ID,Author,DATE_FORMAT(EntryDate,'%d %m
%y'),SectionID,Title,Summary,Content FROM articles
ORDER BY EntryDate
DESC LIMIT 10
Okay, I've looked in the manually up and down, as I know how to do it in
Access, but I can't find it. I want to set an expression so I
I have a series of article in my database and I want to select them by month
and year. So I want a Selection List to hold values like January, 2004,
etc - put it should really select some sort of key like 01-2004. I should
then be able to use that key to filter articles by 01-2004.
I'm just a bit
From: "Terry Riley" <[EMAIL PROTECTED]>
> I think it should be:
>
> SELECT * FROM articles
> WHERE sectionID=1
> ORDER BY Entrydate Desc
> LIMIT 1,10
>
> Terry
That would be correct. I'll have to watch out for that ordering in the
future. What confused me is if you just have the Select, Order B
Any idea what is wrong with the following:
SELECT * From articles ORDER BY EntryDate DESC
LIMIT 1,10
WHERE SectionID=1
I want to return all articles with a particular SectionID, ordered by
EntryDate and then I want to pick the start point and list the next 10 from
that. Obviously in the final ve
ot;\""")
MySQLescape = Replace( MySQLescape Chr(0) , "\0")
end function
You should really check the type of data as well, to make sure its a string.
If you are going to have a lot of data to search you may want to try using a
FULLTEXT index on the searchable data:
<http://www.mysql.com/doc/en/Fulltext_Search.html>
Regards
Ian
--
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Is there something about longtext fields I'm missing?
When I return my longtext field (the Content column of a table containing
articles - it contains HTML) and place it in a TextArea on the HTML form it
always has the first so many characters missing. If I continually edit the
article repeatedly
I seem to be having some problems regarding HTML in Longtext fields - I
think it is something to do with the fact that I have items in double quotes
in the field.
As an example, the html will have double quates along the lines of:
When I pull the field out of the database via the Application Se
Original Message -
From: "Steve Folly" <[EMAIL PROTECTED]>
>
> At work we are currently investigating ways of filing all our
> electronic documents.
I don't know the answer, but it's an interesting question. We are currently
looking at using more and more SQL (we use MySQL now in places),
Quoting Mike <[EMAIL PROTECTED]>:
> One thing to remember is that every stored procedure you execute steals
> resources that would otherwise go to handling queries, so you do not
> necesscarily see a performance boost by using stored procedures for
> everything, in fact a MySQL server handling a
Original Message -
From: "robert_rowe" <[EMAIL PROTECTED]>
>
> Will I use them in MySQL 5.0? Probably, but only when justified.
>
>
So what are the justifications? What makes a wise stored procedure and an
unwise stored procedure?
--
MySQL General Mailing List
For list archives: http:
Quoting robert_rowe <[EMAIL PROTECTED]>:
>
> I'm lead developer for a company that writes custom software for the mining
> industry. We support MSSQL and MySQL. I've found that from a programming
> aspect (VB + ADO) there is relatively little difference between MSSQL and
> MySQL. There is some si
I've been playing with MySQL for a bit now (and it is playing) and I'm using
it for a number of personal sites (ie not many users, and only I really post
stuff). I've also adopted it at work, and we use it to dump Lotus Domino
information into for more structured reporting. All is good.
In the nea
Thanks a lot, time to look into my Coldfusion sting functions or Date_Format
in MySQL.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I'm very new to MySql and I'm having problems inserting dates into my tables
(via the Web using Coldfusion). The user can put the following in the field:
12/09/2003
But the data returned from the database is:
2012-09-20 03:00:00.0
So I'm a bit confused about what I need to do in the insert state
AIL PROTECTED]> wrote:
Dwight,
SET FOREIGN_KEY_CHECKS=0;
please address these general MySQL/InnoDB questions to
[EMAIL PROTECTED]
Regards,
Heikki
- Alkuperäinen viesti -
Lähettäjä: "Dwight Ian"
Vastaanottaja: "Heikki Tuuri"
Lähetetty: Thursday, November 27, 20
yesterday.
If anyone has any input on the crash I am dealing with I will be eternally
grateful.
Ian Rubado
-Original Message-
From: Ian Rubado [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 20, 2003 5:07 PM
To: [EMAIL PROTECTED]
Subject: suddenly started crashing
Since yesterday I have
0x8079fe3 dispatch_command__F19enum_server_commandP3THDPcUi + 1435
0x8079a3d do_command__FP3THD + 165
0x8079229 handle_one_connection + 641
0x82862bc pthread_start_thread + 220
0x82bba7a thread_start + 4
---
Ian Rubado
321.956.0019 OFFICE
solution would be to call only a few records out the table on
the hosted db and insert them into a table on my local machine - I haven't
got a clue how to do that also.)
TIA
Best Regards
ICB
--
. Ian Blackford
. Tel: 01746 718000
. Mobile: 07970 250168
. web: http://www
together so to
speak (highly available writes).
Thanks!
.......
Ian Neubert
Director of IS
TWAcomm.com, Inc.
http://www.twacomm.com/
-Original Message-
From: Dathan Vance Pattishall [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 07, 2003 12:54 PM
To: 'Ian Neuber
te be replicated to the slaves before the
browser is taken to a reciept page (which is queried against the slaves)?
http://linux.ianneubert.com/images/mysql_failover.png or
http://linux.ianneubert.com/images/mysql_failover.pdf
Thanks for your insight!
.......
Ian Neubert
Director
existed as part of a stored
procedure.
The only way I can see to do it is to use "show index from table", but
that gives all indexes and then parsing the results.
We are after a more efficient way (like the sqlserver query "select *
from sysindexes where name=.")
--
Many
Thanks Dathan! I really appreciate your comments and suggestions, they've
been very helpful.
I updated my drawings with your info. Thanks again!
http://linux.ianneubert.com/images/mysql_failover.png or
http://linux.ianneubert.com/images/mysql_failover.pdf
.......
Ian Ne
e and have used that info for my
plan here, but its a little difficult to get details from just the slides
(as you even mentioned on your site) :)
Do you bother with multi-masters? How do you ensure redundancy on the
write/master server?
...
Ian Neubert
Director of IS
TW
can't wait to get yours.
.......
Ian Neubert
Director of IS
TWAcomm.com, Inc.
http://www.twacomm.com/
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]
Sent: Monday, August 11, 2003 12:39 PM
To: Adam Nelson
Cc: 'Ian Neubert'; [EMAIL PROTECTED
=1000
binlog-do-db=maindata
replicate-do-db=maindata
--
Many Regards,
Ian Collins
System Manager
KIWIPLAN NZ Ltd.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello. Thought I¹d pass this along to whoever cares.
Issue:
error running the mysql-test-run as logged
> Installing Test Databases
> Removing Stale Files
> Installing Master Databases
> mysqld is missing - looked in ../bin
> Error: Could not install master test DBs
Any suggestions?
Details:
I
arted mysql.
What is the alarm queue. The documentation says it creates a queue for
alarms, but little else. What was the alarm queue full of? and how do I
stop it?
--
Many Regards,
Ian Collins
System Manager
KIWIPLAN NZ Ltd.
There are always alternatives.
-- Spock
Can anyone help.
I have created a database using Windows XP Professional OS and granted all
priviliges to a user called rwuser with a specified password. I am
attempting to access the data in a table through MySQL ODBC 3.51 Driver on
Windows XP Professional. I have specified the HostName as l
onfusion and better
explain the reason why it failed.
--
regards,
Ian Hartas
-
"Pluralitas non est ponenda sine neccesitate"
Occam's Razor.
-
--
MySQL General Mailing L
t fails.
(
This schema was originally on Oracle, where the syntax was valid and
acted on.)
Ian Hartas wrote:
>>Description:
>>
>>
>I have a database schema .sql file which is accepted when run with MyISAM
>tables. If I change the tables to be type = InnoDB, then it fa
the description line.
database called 'hbs', user called 'ts'
/*
** MySQL schema for the Holiay Booking System within FJS.
**
** by Ian Hartas, Kid01.
**
*/
drop table if exists ts_proj_team;
drop table if exists ts_resource_mgrs;
drop table if exists ts_entry;
drop table if
Having problems installing phpBB and Nuke-PHP on my OpenBSD box, all
seem to be stemming from attempts to access MySQL. For instance, phpBB
gives the error "Could not connect to the database" when using the
install.php script. The install script for Nuke just fails to load
completely so I'll try ta
_date date NOT NULL default '-00-00',
recording_global_expirydate date NOT NULL default '-00-00',
recording_global_counter mediumint(8) NOT NULL default '0', PRIMARY KEY
(recording_global_id) ) TYPE=MyISAM;
Any help much appreciated.
> Ian Roke
>
is RH 8.0); the
configuration/compilation/installation went through
fine, but the server never starts up due to a
complaining about charset not properly compiled.
I wish you can overcome those issues,
and please let me know.
-- ian
--- Jon Hancock <[EMAIL PROTECTED]> wrote:
&g
exec/mysqld: Shutdown
Complete
Appreciate if anyone could shed some light on this.
(My system is Red 8.0. )
thanks,
-- ian
__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up
mysql (stop|start), and it
will also be started and stopped automatically on boot/shutdown.
Ian.
-Original Message-
From: Ken Morley [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 04, 2002 9:31 AM
To: '[EMAIL PROTECTED]'
Subject: Automatically start MySQLServer on RedHat Li
select * from processo_arquivos order by DATE desc limit 10
-Original Message-
From: Felipe Moreno - MAILING LISTS [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 03, 2002 12:42 PM
To: [EMAIL PROTECTED]
Subject: MySQL: Select HELP!
Importance: High
Hi List Users,
I want to know i
The only one I found that creates a good schema that only needs minimal
massages, and imports all the data correctly is Access-To-MySQL. It's
not free though, but they have a trial. Once I went through my access
database and removed certain invalid records (some rows had a screwed up
primary key in
n now connect
with PuTTY and then open up your MySQL front-end and connect to the DB.
Ian.
-Original Message-
From: Todd Cary [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 27, 2002 10:57 AM
To: [EMAIL PROTECTED]
Subject: Front end for MySQL databases
I have
created a Web application
up_id ) values ( user_id, 6
)
Can I use a select into or something? Or should I just script it outside
of mysqlclient?
Ian.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysq
I am a new customer and have a question about mysqldump recovery, but cannot
seem to be able to logon. My user name is probusine8359 and my support
contract is 2002-1428. Would you please correct this anomaly? I need to get
my questions answered. My phone number is 925.737.3458.
Thanks.
Ian
similiar check in MySQL? I know I can just do a
DROP FUNCTION InfDropCurrentParametersTable;
and live with the error if it doesn't exist, but it would be nice to
make the script tidy.
Many regards,
Ian Collins.
-
Bef
Hello All List Members,
My name is Ian Hagan. I am a database developer specialising in Delphi. I am
new to Mysql. (Using a Windows 98 platform; installed version 3.23.51-max)
Can anyone help me with stored procedures in Mysql??
The Manual does not contain much info and refers me to several
Hi,
Use the following:
SELECT * FROM sysobjects WHERE type='U'
This will show you all of the user tables
And then
select * from syscolumns where ID = (select ID from sysobjects where
name = 'your_tablename' and type = 'U'
This should get you started!
HT
the ellipses characer, .,
and when I view access the data through my code, it comes out like this ?.
What is the best way to import data to a MySQL server on Linux and preserve
the correct escaping?
Ian.
-
Before posting, pl
: *** [all-recursive-am] Error 2
This is using the Build 6C106 Developer Tools. I'm afraid I don't have a
clue as to what the problem is but maybe some one else who knows a bit more
may be able to shed some light on the situation.
Cheers,
Ian
--
ng:
ERROR 2003: Can't connect to MySQL server on (61)
A socket problem of some sort???
The strange thing is I can connect using 'phpMyAdmin' without a problem from
both machines.
Just for the record I'm using binary of MySQL 3.23.51 obtained from
<http://www.entro
Can anyone see any problems with using the HPUX 10.20 MySQL binaries on
HPUX 11.00- it seems to work fine in small scale tests.
Regards,
Ian Collins.
-
Before posting, please check:
http://www.mysql.com/manual.php
>What version of MySQL are you using?
Our host, Interland, is running a pre-3.23 version.
>back, 3.23.x supports them), then just issue a similar query and store
>the result yourself...
Should've thought of that myself. Thanks.
--
SELECT @totalVotes:=COUNT(titleid) FROM movieratings
Thanks for the reply.
Alas, the above query syntax gives me an error 1064.
--
Ian Evans
Chairman & Executive Producer
Digital Hit Entertainment
http://www.digitalhit
-Original Message-
From: Andrew K-C [mailto:[EMAIL PROTECTED]]
you might be able to do a "ORDER BY weighted DESC" to get them to come out
in order of weight
Thanks...I'll give that a try...
Hmm, the only problem with that query is that it doesn't get it quite
[snip]
What do you mean by weighted? Taking into account the number of votes for
each and then weighting them against each other?
[/snip]
Yes, essentially each individual movie will show its raw average (people
think this movie is a 7/10) while an overall top rated list will take into
affect that
age?
Many thanks.
--
Ian Evans
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
T
I've upgraded to MySQL 3.2.49 do I still need to pass the big-tables option
on the command line when starting MySQL.
Thanks,
Ian
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
repair ?
We are currently running RedHat 7.2 (kernel 2.4.16) with MySQL 3.2.49
Regards,
Ian Hughes
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
repair ?
We are currently running RedHat 7.2 (kernel 2.4.16) with MySQL 3.2.49
Regards,
Ian Hughes
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
[snip]
WHERE ap_type='Original Movie Poster'
ORDER BY sort_title ASC
HAVING sort_title LIKE 'G%'
ORDER BY sort_title ASC
You may have to swap the HAVING and ORDER BY lines of the query,
[/snip]
Thanks so much. There was a slight syntax change, replacing your first ORDER
BY with a GROUP BY, but i
her". In the above select I was trying to
narrow the search down so I could grab all the films that started with 'G'
but still using the sort_title.
Since aliases aren't allowed in WHERE's, what can I do?
--
Ian Evans
Digital Hit Entertainment
http://www.digitalhit.com
--
Make sure your indexes are healthy
2) Try using a MERGE table
regards,
ian gilfillan
- Original Message -
From: "Jared Richardson" <[EMAIL PROTECTED]>
To: "Schneck Walter" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Tuesd
ne
there, and if you mail further questions there (and look at the excellent
online manual), you're likely to get a quicker response - I'm normally not that
punctual about answering email!
regards,
ian gilfillan
> Hi there. I am doing a query like this on my mysql table:
> selec
In reply to Egor's request...
Egor> > Ian, show me the contents of your .err file (the last
20-40 rows)
This is the total contents of this file.
/nfs/usr/libexec/mysqld: ready for connections
/nfs/usr/libexec/mysqld: ready for connections
/nfs/usr/libexec/mysqld: ready for conne
201 - 300 of 387 matches
Mail list logo