Re[2]: Different default collation in each connection

Hi Jeremy, >> P.S2 I store data in one table which has no default collation set only >> UTF-8 charset. In >> this table I can have data in different collations. > Every table does have a default collation either you specify it or it > comes from the default collation for your database or the ser

Re: merging of two tables using temp tables???

Hello bruce, Wednesday, September 29, 2004, 6:57:34 AM, you wrote: b> hi b> i'd like to be able to merge/combine the two tables so that i get b> +--+--++--+---+-+ b> | ID | type | status | user | ID| uID | b> +--+--++--+---+-

Re: SELECT queries on replicate DB server

Thanks, that is a really good answer. Raises a bunch more questions but they're good ones. Jim Grill wrote: My question is: Why would they deem it necessary to use yet a third server? Could it be because the main server and the main slave are constantly being updated and they wouldn't want to ov

Re[2]: Update a portion of text in a field

Hello Daniel, DK> MySQL has a 'replace' function for this: DK> update table X set field1=replace(field1, 'functionalities', DK> 'functionality') where tableid=1; DK> http://dev.mysql.com/doc/mysql/en/String_functions.html Awesome ! Got it, thanks Best regards, Jacques Jocelyn -- MySQL Gen

merging of two tables using temp tables???

hi i have a situation where i create the following tables via two different select sql statements. +-+--+---+--+-+ | ID | type | user | ID | uID | +-+--+---+--+-+ | 40 |1 | admin | 157 | 40 | | 102 |1 | admin | 405 | 102 | | 257 |1 |

Re: Update a portion of text in a field

Jacques Jocelyn wrote: Hello mysql, Something I have been thinking about without any clue on how I can achieve it. I know how to update a field with "update table X set field1='My Text' where tableid = 1" Now, say I have in a table X, the field1 with the value : 'I have been searching that func

Re: UTF8 columns and MySQL

> Hello, > > I have a table with the following column among others: > > text VARCHAR(120) CHARACTER SET utf8 > > The provider I am using however only offers MySQL version 3.23.58, > so I cannot use this statement. At first I thought I was not going > to be able to store UTF8. So I changed the c

Re: Different default collation in each connection

> P.S2 I store data in one table which has no default collation set only > UTF-8 charset. In > this table I can have data in different collations. Every table does have a default collation either you specify it or it comes from the default collation for your database or the server default. You n

Update a portion of text in a field

Hello mysql, Something I have been thinking about without any clue on how I can achieve it. I know how to update a field with "update table X set field1='My Text' where tableid = 1" Now, say I have in a table X, the field1 with the value : 'I have been searching that functionalities for sever

Re: ResultSet NotUpdatabelProblem

Hello: I have recently posted the message attached at the bottom of this one to the mailing list. Since then, I have continued to work the sporadic and troublesome errors that are described in that attached message on otherwise perfectly working and proven code. I now have some insights that

Re: Connection Error

Phillip Mangwiro wrote: Egor Egorov wrote: "Phillip Mangwiro" <[EMAIL PROTECTED]> wrote: I'm getting an Error 1130, ("MyDNSName is not allowed to connect to this machine"), whenever I try to connect to MySQL server from any client by using its IP or "friendly" DNS name other than 127.0.0.1 or local

testing

Testing Karl James (TheSaint) [EMAIL PROTECTED] http://theufl.com/

Re: Connection Error

Egor Egorov wrote: "Phillip Mangwiro" <[EMAIL PROTECTED]> wrote: I'm getting an Error 1130, ("MyDNSName is not allowed to connect to this machine"), whenever I try to connect to MySQL server from any client by using its IP or "friendly" DNS name other than 127.0.0.1 or localhost. This has happen

UTF8 columns and MySQL

Hello, I have a table with the following column among others: text VARCHAR(120) CHARACTER SET utf8 The provider I am using however only offers MySQL version 3.23.58, so I cannot use this statement. At first I thought I was not going to be able to store UTF8. So I changed the column to the follo

Re: query on a column with xml content

At 14:17 -0600 9/28/04, Elim Qiu wrote: Is there any tools or built-in functions for querying contents of a column that holds a xml file? If you mean using something like the standard string functions, yes. But I suspect you mean using something like XPath, in which case, no. If you mean something

Re: backup question: INSERT statements

At 19:47 -0230 9/28/04, Neil Zanella wrote: Hello, I need to backup a mysql database in such a way that the output is simply a bunch of insert statements. I do not want the database schema as output as well: just the insert statements. This is because I already have a script with CREATE statements

Re: Multiple Insert Statement?

Sorry, there were a few typos in my reply. I have amended the reply at the bottom Rhino - Original Message - From: "Rhino" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; "Paul DuBois" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, September 28, 2004 5:41 P

backup question: INSERT statements

Hello, I need to backup a mysql database in such a way that the output is simply a bunch of insert statements. I do not want the database schema as output as well: just the insert statements. This is because I already have a script with CREATE statements and would like to rebuild the database fro

Re: Multiple Insert Statement?

- Original Message - From: "Eve Atley" <[EMAIL PROTECTED]> To: "Paul DuBois" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, September 28, 2004 3:56 PM Subject: RE: Multiple Insert Statement? > > Then I need help getting on the right track here. What I reall

RE: Multiple Insert Statement?

At 02:56 PM 9/28/2004, you wrote: Then I need help getting on the right track here. What I really want to do is something like the following: INSERT INTO wow.resume_erp (Candidate_ID, Section_ID, Section_Value) SELECT * FROM wow.resume r WHERE r.Candidate_ID = '13103'; You need to match up the colu

query on a column with xml content

Is there any tools or built-in functions for querying contents of a column that holds a xml file?

RE: Multiple Insert Statement?

Then I need help getting on the right track here. What I really want to do is something like the following: INSERT INTO wow.resume_erp (Candidate_ID, Section_ID, Section_Value) SELECT * FROM wow.resume r WHERE r.Candidate_ID = '13103'; INSERT INTO wow.candidate_erp (Candidate_ID, Vendor_ID, Last

RE: increasing mysql/table performance..

Primary Keys and Unique Keys are still Keys. Key is a synonym for INDEX. So, you already have some indexes. What you need to look at is the possibility of defining other "regular" keys (just plain indexes) to help specifically with some of your common query situations. Some people also add ind

RE: increasing mysql/table performance..

You are correct. It's not necessary to change your SQL statements to take advantage of indices. Redefining your tables may not be necessary, but I can see areas where you might see benefits. One example would be the stateVAL field in the first table. It looks like you're storing an abbreviati

Re: Problem with insert statement; ERROR 1030 at line 188: Got error 28 from table handler

Hi Sebastian, If the new cds_catalog is created with primary key, this should produce a duplicate key error for the second iteration of the second table, as the data selected is from cds_catalog alone, but joining two tables causing cartisian joint to be formed(n*(m- t1.field<>t2.field)), each tim

Re: Multiple Insert Statement?

That's the syntax used to do a full-text search in MySQL. Here's some light reading: http://dev.mysql.com/doc/mysql/en/Fulltext_Search.html Shawn Green Database Administrator Unimin Corporation - Spruce Pine GH <[EMAIL PROTECTED]> wrote on 09/28/2004 03:14:21 PM: > I know that this is off topi

Re: increasing mysql/table performance..

It is possible to have too many indexes. Usually you tune your indexes to fit the majority of your queries. Definitely index the fields that are used to JOIN your tables. Consider multi-column indexes more than lots of single-column indexes as MySQL will use only one index per table for any que

Re: Multiple Insert Statement?

At 14:16 -0400 9/28/04, Eve Atley wrote: My query: SELECT * FROM wow.resume r INNER JOIN wow.candidate c WHERE r.Section_ID = '1' AND MATCH (r.Section_Value) AGAINST ('+baan' IN BOOLEAN MODE) AND c.Candidate_ID = r.Candidate_ID; Is it possible to do a multiple insert statement like so? No. INSERT I

Re: Multiple Insert Statement?

I know that this is off topic and such... but can you explain the Match / Against that you used in your query? i have never seen syntax like that in SQL On Tue, 28 Sep 2004 14:16:56 -0400, Eve Atley <[EMAIL PROTECTED]> wrote: > > My query: > SELECT * FROM wow.resume r INNER JOIN wow.candidate c

RE: increasing mysql/table performance..

> Um.. Are you serious? thats all you do, create indexes? Ok, I'm assuming familiarity with efficient schema design since joins are being used. I'm excluding factors like system hardware, system load, OS, MySQL performance tuning, etc.. And by efficient schema design, I'm referring to proper sep

RE: increasing mysql/table performance..

ok... here's a section of my tbl defs.. and the sql that accesses it.. are you saying that i should simply redefine the tbls, to create an index on the column name. as far as i can tell from reviewing mysql/google, i don't have to do anything differntly to the sql, in order to use the 'indexes'...

Re: Images

Tons of caching options.. tried quite a few.. - squid/similar proxy.. - the image streaming/serving script stores the image in /tmp, if the script next time sees the time file (perhaps using databaseid.img filename format) it serves it from disk.. maybe checking the last changed timestamp or som

RE: Using Visio to diagram MySQL db, export SQL

ari MYdbAL which you can download at www.it-map.com is completely FREE and includes data modeling, DDL generation or whatever you need to create your MYSQL database. Tim -Original Message- From: Ari Davidow [mailto:[EMAIL PROTECTED] Sent: 28 September 2004 12:59 To: [EMAIL PROTECTED] Sub

idex usages in updates

Hello! Could anyone tell me if updates in multiple tables also make use of table indexes? And if they do does it works in the same general manner as it does for select clauses? Thanks, Arthur

RE: Images

I read through the article and ran some more tests. The new scripts and tables provide similar initial latency, but I think the test results show them to be faster overall. When it comes to latency, direct file access is still the champion without caching. I think you made a good point about thr

Re: Transfer data from mySql to access

You should rather do some scripting. It will be a very simple one - use perl / python or whatever suits. If they were identical with only db or table or column names different - the simple work around would have been to to Find and Replace for those names but you also have the columns count diff

Re: increasing mysql/table performance..

one suggestion would be to get the latest mysql performance tuning book from o'reilly. its pretty good. bruce wrote: hi... i've got a basic question (with probably many answers) i'm creating a php/web app that uses mysql tbls. i have a number of pages that do various selects using 'left joins'/'ri

Re: increasing mysql/table performance..

On Tuesday 28 September 2004 01:02 pm, Ed Lazor wrote: > I usually create an index for each criteria being checked against in the > SQL statements. > > For example, for this query > > Select * from products where ProductID = 'aeg8557' > > I'd create an index on ProductID. The same thing applies if

Multiple Insert Statement?

My query: SELECT * FROM wow.resume r INNER JOIN wow.candidate c WHERE r.Section_ID = '1' AND MATCH (r.Section_Value) AGAINST ('+baan' IN BOOLEAN MODE) AND c.Candidate_ID = r.Candidate_ID; Is it possible to do a multiple insert statement like so? INSERT INTO wow.candidate_erp (Candidate_ID, Secti

Re: Images

Ed brings up a great point... i would rather not have anyone 'searching' for images in directories and such... On Tue, 28 Sep 2004 10:53:01 -0700, Ed Lazor <[EMAIL PROTECTED]> wrote: > Ok... I have some more test results. After optimizing as much as I can > think of, without using caching, I'v

Re: Images

Getting images/files into blob is quite easy.. examples could be provided based on what lanaguge/interface way you want to use... Mysql site has a great list of data types and capacities, etc... do a search for it.. On Tue, 28 Sep 2004 13:58:16 -0400, GH <[EMAIL PROTECTED]> wrote: > I thank y

Re: Images

Great .. I don't have any numbers.. but basically there is quite little latency using the FTP interface, data is streamed in and out of mysql on the fly, inserting and selecting blocks of rows.. The FTP server is written in java using JDBC to talk the database, so it's quite fast. On Tue, 28 S

RE: increasing mysql/table performance..

I usually create an index for each criteria being checked against in the SQL statements. For example, for this query Select * from products where ProductID = 'aeg8557' I'd create an index on ProductID. The same thing applies if you're pulling data from multiple tables. For this query: Selec

importing data into mysql from oracle

Hi, Could any one of you suggest me a better way to bump the data in oracle 7.3 to mysql 4.0 classic. Thanks, Narasimha -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tue 9/28/2004 8:58 PM To: martin fasani C

Re: Images

I thank you all for this discussion... and for the great information that everyone has provideded. Next question (which is part of my original) how do I actually get the images into the Blobs... Additionally, the what are the names and capacities of the datatypes that I could use? I have been he

RE: Images

Thanks for the article. I'll check it out. Throughput of 4600K/s is great. How's latency? -Ed > -Original Message- > So if the image was say 200K in size, the metadata for the image would > be 1 row in a table, and the image data would be 4 rows in the data > table. 3 full 64K rows +

Using Visio to diagram MySQL db, export SQL

Hi, I have Visio 2002. I am trying to set it up to use MySQL-specific datatypes (e.g., ENUM) and have some success using the User-Defined Types. But what I really want is something that I can export from Visio to actual SQL statements, and I am not succeeding in finding that at all. If Visio is

RE: Images

Ok... I have some more test results. After optimizing as much as I can think of, without using caching, I've gotten things down to a 13x difference. Using Apache's ab performance test, the image comes from a file at an average of 2ms and from the database (using PHP4) at an average of 28ms. I kn

increasing mysql/table performance..

hi... i've got a basic question (with probably many answers) i'm creating a php/web app that uses mysql tbls. i have a number of pages that do various selects using 'left joins'/'right joins'/etc... i'm getting to the point where most of the basic logic works. now i want to start figuring out ho

Re: Images

It would be quite easy to drop a squid or similar proxy infront to cache the db images in memory and deliver them for a set cache-time or something.. That would be 1 way to boost performance.. On Tue, 28 Sep 2004 09:55:54 -0700, Ed Lazor <[EMAIL PROTECTED]> wrote: > > -Original Message-

Re: Images

Most people make the mistake of using the biggest blob size to store files.. That blob size is capable of storing just HUGE files..What we do is store files in 64K (medium blob) chunks.. So if the image was say 200K in size, the metadata for the image would be 1 row in a table, and the image d

RE: Images

Thanks for the link =) I understand what you're saying about MySQL not being designed as a filesystem. I've used this same argument with others. It's just that... well, have performance boosts have decreased the margin of difference? Especially when web-page caching is being used - don't the

RE: Data fields from one database to another

Been trying it out. Seems to be very powerful! Thank you , Stuart --- Tim Hayes <[EMAIL PROTECTED]> wrote: > Yes. Absolutely. MYdbPAL has a complete > schema-to-schema table and data > field mapping capability that will also let you do > things like table splits > and joins. It also has inbuil

RE: Images

> -Original Message- > I have heard also that it helps to keep the table with the blobs having a > low number of fields. Like just a primary key and the blob field. Have > all your other metadata in a seperate table. Especially if you are going > to be occasionally doing queries of just

Re: Images

Grabbing the file was 38 times faster because MySQL was not designed to be a filesystem. There are filesystems out there specifically designed to handle hundreds of thousands of small files. One of the best is ReiserFS http://www.namesys.com If you record the filename in mysql tracking becomes a n

Re: won't start with mysqld_safe

Anne Ramey wrote: I had a server hacked last night and they did alot a damage, but I think I've got just about everything back up as normal...including a brand new mysql installation (4.0.21). My problem is this. The 4.0.21 or the old 4.0.20 will not start using mysqld_safe and will start wi

RE: Images

I have heard also that it helps to keep the table with the blobs having a low number of fields. Like just a primary key and the blob field. Have all your other metadata in a seperate table. Especially if you are going to be occasionally doing queries of just the metadata and don't want to al

RE: special characters not inserting into database - help

Try mysql_escape_string instead of addslashes. Also, I'm not sure why you did it, but you don't need to include your entire form in the PHP script and echo it. If you have PHP code before and after the form, you could use this approach: Form You could also try escaping the title all of the

won't start with mysqld_safe

I had a server hacked last night and they did alot a damage, but I think I've got just about everything back up as normal...including a brand new mysql installation (4.0.21). My problem is this. The 4.0.21 or the old 4.0.20 will not start using mysqld_safe and will start with mysqld if I don'

RE: Images

What do you mean "chunked"? I figured it would be easier to track about 32,000 images in MySQL than in files, so I setup a test to see what the performance difference is and if storing in MySQL would actually work. Everything is working and it's a lot easier to keep track of the images in MySQL.

special characters not inserting into database - help

Newbie type question: apostrophes ie. a ' single quote is not "getting into" the database fields. So if I entererd in a PHP/MYSQL web page entry field: Sally's Website. When I look directly into the column with the MYSQL cmdline I see: Sally s Website. Below are the code snips I'm using(I number

Re: Images

Separate/dedicated servers for web/database. All the data was chunked to allow faster streaming/lower overhead (large images/files).. If you have more specific questions I can answer them.. On Tue, 28 Sep 2004 11:49:27 -0400, GH <[EMAIL PROTECTED]> wrote: > Is there anything special in your

Re: Images

Is there anything special in your setup that you did to have such good performance? On Tue, 28 Sep 2004 11:47:26 -0400, DreamWerx <[EMAIL PROTECTED]> wrote: > It's an argument that can go on forever... We have 10's of thousands > of images in mysql databases.. very fast/reliable.. easy to > re

Re: Images

It's an argument that can go on forever... We have 10's of thousands of images in mysql databases.. very fast/reliable.. easy to replicate, stream, etc.. On Tue, 28 Sep 2004 08:42:13 +0200, Jigal van Hemert <[EMAIL PROTECTED]> wrote: > From: "GH" <[EMAIL PROTECTED]> > > > I was wondering how

Transfer data from mySql to access

Hi, How do I transfer mySql Database (e.g Test Case Manager ) to MS Access ( Test Director) The Table names are different for the two DB's , but the content is similar Let say I have a Table CASE in Test Case Manager having 10 columns , and want to transfer indivisual columns to an access DB ( T

Re: Oracle query to mysql

Your original Oracle(R) query (slightly reformatted): SELECT IMRTAB.IMR906 AS NUM906 , IMRTAB.IMRFLL AS FLL , SUM(IMRTAB.IMRCLL) AS CLL , ROUND(SUM(IMRTAB.IMRDSC),2) AS DUR , ROUND(SUM(IMRTAB.IMRDSC)/SUM(IMRTAB.IMRCLL),2) AS PRO , SUM(IMRTAB1.IMRCLL) AS CLL

RE: Data fields from one database to another

Yes. Absolutely. MYdbPAL has a complete schema-to-schema table and data field mapping capability that will also let you do things like table splits and joins. It also has inbuilt scripting and data value translation lookups. Timk -Original Message- From: Stuart Felenstein [mailto:[EMAIL P

RE: Data fields from one database to another

So it will let me transfar individual fields ? Most of the clients allow for data transfer provided the database schema is the same, and then it is the entire record. Stuart --- Tim Hayes <[EMAIL PROTECTED]> wrote: > Try using MYdbPAL - its a new free program that will > do the job plus lots of >

Certifications

Hi! I just passed the Mysql Core Certification ... (Applause!!!)... Thank you! ;) I was wondering if there is a shorcut for MySQL certified? Something like BSc, MSc. PhD... You got the idea. Thanks, Paul -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

RE: Data fields from one database to another

Try using MYdbPAL - its a new free program that will do the job plus lots of other goodies. www.it-map.com Tim Hayes -Original Message- From: Stuart Felenstein [mailto:[EMAIL PROTECTED] Sent: 28 September 2004 08:23 To: [EMAIL PROTECTED] Subject: Data fields from one database to another

Re: How to pick the oldest row

There are several things wrong here, which makes it a bit difficult to tell what you want. Let's look at the subquery first. SELECT idk FROM `mj_tmp` GROUP BY Concat(ida,u) HAVING Count(Concat(ida,u)) >1 First, you shouldn't use CONCAT() in your GROUP BY, as it breaks the possibility of u

Re: alias in expression not allowed in ORDER BY?

I guess I've never noticed that but why not just select more than one calculation such as: SELECT sqrt(col) AS blarg, sqrt(col) + 1 AS order_blarg FROM table ORDER BY order_blarg its a work around but it should work fine -John -- MySQL General Mailing List For list archives: http://lists.mys

Data fields from one database to another

I want to move over 2 - 4 fields from a table in one database , to a table in another. The field names are not an exact match but they function identically (i.e. username, password) Whatever I'm using , web development garbage program ;) won't allow me to connect to 2 different databases so I can

RE: SLOW select when ordering

Also note that the server is pretty fast, dual 2 GHz with 2GB of RAM. Using the "my-huge.cnf" settings. >Also... I forgot to mention [EMAIL PROTECTED] I'm using: >mysql 4.0.20-standard-log Official MySQL RPM > >And here is the EXPLAIN on the select portion of the slow query is: >+---+---

Re: Install Problem on Fedora Core 2 w/ ver 4.0.21

From: "Dennis Skinner" <[EMAIL PROTECTED]> > http://lists.mysql.com/mysql/168700 I've been searching through the 15502 messages from this list that I have archived since Jan 16, 2004 but I must've missed this one... Thanks for looking it up! Regards, Jigal. -- MySQL General Mailing List For

Re: show the row of last action like UPDATE or INSERT

Vincent Ghilardi <[EMAIL PROTECTED]> wrote: > Is there a way to show the row of last action like UPDATE or INSERT ? Only for INSERT if there was an AUTO_INCREMENT value added. See http://dev.mysql.com/doc/mysql/en/Information_functions.html -- For technical support contracts, goto https://o

MySQL Process

Hi, I run Debian 3.1 with kernel 2.6.8-1-686-smp, I wonder why why I do ps -aux, I only can see 1 MySQL process. mysql 4227 0.0 64.6 1849456 1341912 pts/1 S Sep16 4:57 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql/ --user=mysql --pid-file=/var/lib/mysql//natuna.pid --skip-lock

Re: -bin.001 Files

Rob Best <[EMAIL PROTECTED]> wrote: > Okay, replying to my own post is like talking to one's self but... > so I finally found the manual page that describes the two files. Any > reason I want them (the log files that is)? My databases currently are > not replicating (no plans to add it) and have

Re: MySql Distributed database version

Look forward in documentation at http://dev.mysql.com/doc/ for "Replication" and "MySQL Cluster" sections. Hopefully one or both will be answer for you. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/

select range of matched word in text field

hello, I wonder if it is possible to match a word like with instr() and get as a result just 10 words bevor and ten words after the matched word. (like google presents the matched query) I would need a select with a replacement and a fitting where clause which could be done with isset. I have is

Re: Error 1033, still having major problems

"Brian J.S. Miller" <[EMAIL PROTECTED]> wrote: > Does anyone have any ideas? This is killing me! In this case I may suggest you to buy a support and request a support incident. MySQL developers will recover your files manually if there is anything possible to recover. To buy a support contract,

Re: How to pick the oldest row

Thanks Jim,but that doesn't work for me because the order by performs after the records have been selected. At that time I already have the unwanted row. I will try to explain a little bit further SELECT * FROM `mj_tmp`This select is suposed to return all rows WHERE idk NOT IN but

Re: Install Problem on Fedora Core 2 w/ ver 4.0.21

"Jigal van Hemert" <[EMAIL PROTECTED]> wrote: >> > 040925 21:50:34 Warning: Asked for 196608 thread stack, but got 126976 >> Databases are installed. You can ignore the above warning. > > Egor, > > 1) A warning usually indicates an error that has limited impact on the > system, but still an erro

Re: Unable top drop table, error 1051

Bug filled: http://bugs.mysql.com/bug.php?id=5784 Thank you! -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_

Oracle query to mysql

Hi guys, I'm working in a telecom company that has Oracle for the call statistics. Now we export the daily stats to a remote mySql. The daily resume table looks like this: ++---+-++--+ --+++ | IMRFLL | IM

alias in expression not allowed in ORDER BY?

All tested in MySQL 4.0.x and 4.1.x (MyISAM and InnoDB): (1) A query with an expression in an ORDER BY clause works well: SELECT * FROM `table1` ORDER BY `col` + 1 (2) A query with an alias of a calculated field in the ORDER BY works also: SELECT * , sqrt( `col1` ) AS blarg FROM `table1`

Re: Retrieving field characteristics

On 27 Sep 2004 at 11:36, Rhino wrote: > I really have no idea how Java is getting the information. I haven't tried > very many of the metadata methods yet so I don't know how much Java can > actually see and what is hidden. But I do know that it can see the > descriptions of the columns. > > I

newbie permissions question

Hi All, I'm learning mysql among other programs to put together a web page with database in the background. My first goal is to simply produce a crude example for demo purposes, it can be refined a great deal later. I've set up a small mysql data base on a commercial web hosting server. It p

Is MySQL Cluster support for Windows ready yet?

Hello, This is my first posting on this list and I would like to know whether cluster support is ready for Windows. I've read on the www.mysql.com website that it is not ready yet, but the "MySQL Cluster Administrator Guide" describes installation procedures for Windows also. If there is Window

Re: -bin.001 Files

Okay, replying to my own post is like talking to one's self but... so I finally found the manual page that describes the two files. Any reason I want them (the log files that is)? My databases currently are not replicating (no plans to add it) and have many reads but few writes. On Sep 28, 2004

-bin.001 Files

On my mysql servers, I've noticed some unexpected files in the /usr/local/mysql/data/ directory. Specifically, I have files like: -bin.001 -bin.002 -bin.003 etc. (obviously with being replaced with the name of the computer) I also have files like... innodb.status.410 innodb.status.411 innodb.st

Different default collation in each connection

Hi, I have a problem setting default collation for each connection. I have multilanguage site and I don't want to add COLLATE statement to every SQL - I could set it once during PHP startup and forget about it... But there's a problem. I tried to do SET names 'utf-8'; SET collation_connection