Re: Backup question.

snapshot. 3. From the first client, execute: UNLOCK TABLES. 4. Copy files from snapshot. 5. Unmount snapshot. (from : http://www.mysql.com/doc/en/Backup.html) Bernard Hope this helps, Joseph Bueno On Tuesday 18 November 2003 05:12, Simon Green wrote: Has any one use LVM to take a snapshot

Re: Problem about the maximum isze of MYISAM table

MyISAM tables can be larger than 4Gb without using merge tables. This topic has been discussed several times on this list. You will find all details in Google groups archive: http://groups.google.com/groups?q=myisam+4Gb+limit+group:mailing.database.mysqlscoring=d Hope this helps, Joseph Bueno

Re: inconsistent query times for same query

There is caching but it is at OS level: on first query, data are fetched from disk; other queries read directly from file system cache. Hope this helps Joseph Bueno [EMAIL PROTECTED] wrote: Hi everyone. I'm using MySQL 4.0.16 with W2K/SP4 on a 512KB RAM/1.2GHz Athlon machine (my dev workstation

Re: inconsistent query times for same query

Hope this helps Joseph Bueno -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL with OpenMosix

doesn't currently offer support for allowing multiple cooperating threads to be separated from one another. Since mysql is a single multithreaded process, you should not expect any performance increase :( -- Joseph Bueno -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: sorting/grouping

Have you tried: select commentref,max(commentid) from comments group by commentref Regards, Joseph Bueno Cummings, Shawn (GNAPs) wrote: This doesn't seem to be making sure that the newest commentid is the result... Seems to be random. At 09:11 AM 10/6/2003 -0400, you wrote: try select

Re: Information required

in mysql bye Waseem Ahmad Zia Subqueries and prepared statements are not available in 4.0.15. They will be in 4.1 Check the manual for details : http://www.mysql.com/doc/en/ANSI_diff_Subqueries.html http://www.mysql.com/doc/en/C_API_Prepared_statements.html Regards, Joseph Bueno -- MySQL General

Re: Slow query join problem

, Joseph Bueno -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: negative decimal problem

some values beyond these limits). Since your values are clearly out of this range, you should revue your field specification. Maybe DECIMAL(7,2) would be better ? Hope this helps Joseph Bueno -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Joining tables from two different databases

in another and do queries that pull from both databases? Thanks, Jeff Hi, Yes you can do that. Just prefix table name with database name in your query: select * from table1,database2.table2 where table1.field1=database2.table2.field2 Hope this helps, Joseph Bueno -- MySQL General Mailing List

Re: Select distinct speed on an indexed column

|678 | 2180988928 |NULL |530350080 | 0 | NULL | NULL | NULL | NULL || InnoDB free: 142368768 kB | Hi, What do you get when you do an EXPLAIN of your query ? -- Joseph Bueno -- MySQL General Mailing List For list archives: http

Re: Select distinct speed on an indexed column

Since your primary key is used, maybe you should consider adding an index on PostedZpdi field only. You may also check 'key_buffer_size' value (show variables like 'key%'). Since your primary key is more than 200 MB big, allocating a big key buffer ( 256MB) may help. Joseph Bueno Nathan Cassano

Re: Can't open...

Deependra b. Tandukar wrote: Dear all, what is the meaning of Can't open file: 'products_description.MYI'. (errno: 145) in mysql? Regards, _DT $ perror 145 145 = Table was marked as crashed and should be repaired Hope this helps -- Joseph Bueno -- MySQL General Mailing List For list archives

Re: Selecting only numbers from a string or vice versa

knows how to do a query like that. select * from mydata where mystring regexp '[A-Z]*1[A-Z]*2[A-Z]*5[A-Z]*4[A-Z]*'; should do it. Regards Joseph Bueno -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Dates

6 days 10:14:43.421275 +++ Time to read mysql manual ? ;) http://www.mysql.com/doc/en/Date_and_time_functions.html Regards, Joseph Bueno -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Re: Fixing Replication

;) Hope this helps, Joseph Bueno -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: External Access

is whether that port requires TCP, UDP or both to be open. Thanks! David Christensen Brokers International, Ltd. 1200 E Main St Panora, IA 50216 (641) 755-2775 [EMAIL PROTECTED] TCP only Joseph Bueno -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Database name

select database(); Regards, Joseph Bueno Vinay wrote: Is there an SQL command that i can perform which will return me the name of the Database i'm currently conected to. Thanks for your help. Vinay -- http://www.uptoten.com - The fun place to learn on-line UpToTen Kids : 600 educational games

Re: New Group By, order by question

select order by abs(field) desc; Hope this helps, Joseph Bueno Martin Moss wrote: All, I have a question about grouping numbers. Lets say I have 10 records each containing a numeric value:- 1 2 3 5 10 -1 -2 -3 -4 -5 What I wish to do is to select the records from the database but group

Re: Frequent Table Corruption - Please Help

It is a Redhat 7.2 with a 2.4.7-10smp kernel.It was upgraded last september and mysqld has never been restarted since then (mysqld uptime is now 316 days). Hope this helps Joseph Bueno Richard Gabriel wrote: I am running 2.4.18-smp. You said you upgraded to a 2.4 smp kernel and it solved

Re: error 1130 : Host xxx.xxx.xxx.xxx not allowed to connect this server ?

at the manual ? http://www.mysql.com/doc/en/Access_denied.html Regards, Joseph Bueno -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: specific records

to the table, then when I will remove some records from the middle part o the table I will have holes, and the next select will give me wrong data. Regards, Maciej Bobrowski Maybe: SELECT * FROM tablename LIMIT 5,5; See: http://www.mysql.com/doc/en/SELECT.html for details Regards, Joseph Bueno -- MySQL

Re: How to drop unique key

: alter table p_asset drop index asset_name2; Regards, Joseph Bueno -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Problem when use mont and from_unixtime.

://www.vcable.net Move the parenthesis: select timestamp from lastauth where month(from_unixtime(timestamp))=6; Regards, Joseph Bueno -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL/INNODB speed on large databases

a lot of insert/updates and very few selects. Regards, Joseph Bueno Wendell Dingus wrote: Hello, I've got a situation I'm hoping someone here can help me out with. We have a web server serving up data via some PHP programs pulling from MySQL (3.23.56 currently) in INNODB tables. There are 40

Re: INSERT weirdness

' , 'manufacturer_CREATIVE_LABS.gif' ) Regards, Joseph Bueno -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL/INNODB speed on large databases

could consider upgrading to MySQL 4.x. Its query cache may speed up your server (I have not tried it myself but there are been positive reports on this list). regards, Joseph Bueno Wendell Dingus wrote: Ahh, there's something I could have explained better. Each of the databases represents

Re: distributed database architecture for a large database

' but if it is a mediumint, you will be in trouble since its range is [-8388608..8388607]. You should use at least an unsigned int and may be an unsigned bigint if you suspect that you will have more than 4 billion rows. Hope this helps Joseph Bueno Aodhan Cullen wrote: I've got an interesting problem

Re: distributed database architecture for a large database

Sorry to reply to myself but after reading your post again, I think you can use replication to maintain member table in sync: it is possible to restrict replication to a some tables within a database: check 'replicate-do-table' option. Hope this helps Joseph Bueno Joseph Bueno wrote: I don't have

Re: Simple Question: MySQL and Shell Scripts

=`/usr/bin/mysql -uroot -prootpass -e 'SELECT * FROM Bobstable WHERE Name=1;' BOB` But this is more a shell than a mysql question, isn't it ? Joseph Bueno -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Mysql replication with 2 masters and 1 slave

replicating from one master: M1 -- S1 DB1DB1 S2 -- M2 DB2 DB2 Hope this helps Joseph Bueno Erik Olsen wrote: Yes. The idea was to backup 2 masters, 1 that is ours and 1 that is a costumer. The slave's job is just going to have a synchronised db of both servers db

Re: from_days/to_days

/Date_and_time_functions.html (TIP: type 'from_days' in 'Search the MySQL manual:' at the top-left of online manual page and click 'GO' ;) ) Regards, Joseph Bueno -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: multiple mysqld-max running ?

Hi, ps,top,.. on Linux show threads as processes. What you see is ONE process (mysqld) with 11 threads sharing 40Mb of memory. Check http://www.mysql.com/doc/en/Memory_use.html Regards, Joseph Bueno Gerald Fehringer wrote: hi list fellows, os: suse linux 8.1 myqld: mysql-max-4.0.12-pc

Re: AW: multiple mysqld-max running ?

. If this is too much, consider changing some parameters: http://www.mysql.com/doc/en/Server_parameters.html Also, if you don't use InnoDB, make sure that you have skip-innodb option set in my.cnf. (There were a few mails on that topic a few hours ago, check mailing list archive). Regards, Joseph Bueno

Re: Speed of SELECT ... LIMIT #,#?

If you want to speed it up, you have to make it use an index. You need to add a WHERE or an ORDER BY clause. Have you tried : SELECT Message_ID, Body FROM Body_etc ORDER BY Message_ID LIMIT N,M Of course, I assume that Message_ID is indexed ;) Regards, Joseph Bueno Nick Arnett wrote

Re: AW: replication on single server

Hi, With MySQL, you can join tables that are in different databases as long as they are on the same server. In your case, you could run: SELECT s.name FROM A.bouncebacks b, subcriber s where s.email = b.email Regards, Joseph Bueno Brandl, Thomas wrote: The thing is that this particular table

Re: Replication freezing

Hi, Have tried changing the value of 'slave_net_timeout' on slave side ? By default, it is 3600s, if you make it shorter than 10 mn, I think that the slave will start a new read (and generate some TCP/IP traffic) before the firewall closes the connection. Regards, Joseph Bueno Andrew L. Davydov

Re: disabling version number

important of your problems. Regards, Joseph Bueno -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

List-ID Header

Hello, It seems that emails coming from mysql mailing list don't include 'List-ID: mysql.mysql.com' header anymore. Is this going to be fixed or should we change our email filtering rules ? Thank you Joseph Bueno -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: Mysql And Backup

surprised that you could restore anything with mysqlimport :( Regards, Joseph Bueno - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

Re: Process Limit on Linux ?

this helps, Joseph Bueno Philipp wrote: Dear Walt, dear List, thank you for your reply. Finally a suggestions at all. I checked both /proc/sys/kernel/threads-max /proc/sys/kernel/shmmax I dont think threads-max will be a problem, because the value is 14336, and i dont think my system will ever have

Re: Process Limit on Linux ?

~600 connections, I have used this formula (a simplified version since I don't use InnoDB) to allocate a key_buffer as big as possible and make sure that I won't run out of memory. Hope this helps, Joseph Bueno Philipp wrote: Hi Dan, i just talked about openmosix because i read about shared memory

Re: store an array of double to mysql, How?

Check BLOB data type: http://www.mysql.com/doc/en/BLOB.html Regards, Joseph Bueno Lai wrote: Hi. I am writing a program to do pattern recognition. I decide to use mysql to store the features calculated. The features are stored as an array of double in my c program. But now I do think about it, I

Re: error

Hi, You should run mysqladmin from DOS prompt, not within mysql client. If you want to create a database from mysql client, you should use: create database database01; Regards, Joseph Bueno Patrick Geary wrote: Hi I am a new user of Mysql and have received an error. I enter my C drive

Re: list current db

select database(); Regards, Joseph Bueno Jonathan Li wrote: A few days ago I asked about how to know which database I am currently in, I got an answer and I also replied to thank the send but the email was returned. Any way I forgot to document it. I remember the answer listed three methods to do

Re: automatically incrementing an int value

://www.mysql.com/doc/en/example-AUTO_INCREMENT.html Regards, Joseph Bueno Douglas B. Jones wrote: Hi, I understood replace to only increment n when it matches the name value. There are 122,111 statements, but when you add up the numbers in the n column, they exceed 122,111. They should sum up (when

Re: Process pb

Hi, MySQL server is single process, multi-threaded, and creates one thread per client connection (more details in the manual: http://www.mysql.com/doc/en/MySQL_threads.html) What you see happens only if you run a single client at a time. Is it your case ? Regards, Joseph Bueno Julien Metayer

Re: Load Balanced Mysql Cluster

case) and it doesn't increase when we add more webservers. With this setup, you only deal with load-balancing at HTTP level which is much easier than SQL load-balancing. Hope this helps Joseph Bueno Jared Saul wrote: I have a database heavy site that utilizes a master mysql server which processes

Re: Fwd: data-retrieving udf

hi, There is an example (udf_example.cc) in 'sql' sub-directory of mysql sources. You can code your functions in C++ but you must declare your UDF entry points as 'extern C' Regards, Joseph Bueno Maurizio Oristanio wrote: hi everybody, i'm trying to add a udf to mysql that itself accesses

Re: Problem with registers import

Have you by any chance defined an unique index on a SMALLINT field ? In this case have a look at: http://www.mysql.com/doc/en/Numeric_types.html Regards Joseph Bueno Paulino Michelazzo wrote: People I have a txt file with 250.000 lines but, I'm import only 32767 lines. The database don't say

Re: Replication Questions 2

the slave has all the data replicated? You can run SHOW MASTER STATUS on the master, SHOW SLAVE STATUS on the slave and compare 'Log_File' and 'Pos' fields. Thanks thorsten guddack Regards, Joseph Bueno - Before posting

Re: partitionong MyISAM tables??

Hi, Have you looked at MERGE tables (http://www.mysql.com/doc/en/MERGE.html) ? Hopre this helps, Joseph Bueno Prasanth Krishna wrote: Is there any way to partition MyISAM tables in mysql? i have a huge table and want to partition it. Do InnoDB tables support partitioning? thanks. Prasanth

Re: # of connected user

SHOW PROCESSLIST Check http://www.mysql.com/doc/en/SHOW_PROCESSLIST.html for details Hope this helps, Joseph Bueno Mustafa Yelmer wrote: How i list connected users(active) to mysql server? it is important to know connected users for me? Mysql runs in server-client system, and each host

Re: [ mysqlimport ]

Hi, You should not use mysqlimport but mysql: mysql my_db file.sql See http://www.mysql.com/doc/en/mysqldump.html for details. Regards, Joseph Bueno Elby Vaz wrote: I created a file.sql with mysqldump. mysqldump my_db my_table file.sql What I do to get this file with the mysqlimport

Re: TIMESTAMP field is updated unintentionally

ERSTELL_DATUM to DATETIME type and set is explicitely to NOW() when you insert a new record. Hope this helps -- Joseph Bueno Marco Deppe wrote: Hi, I was already questioning my sanity, but the problem below is reproduceable: This is how my table looks: mysql describe T_ORDH

Re: file-descriptor limits for linux

with ulimit, you won't get any error message until the system actually reaches file-max limit. It will then deny any new file open (not just those coming from mysqld). Hope this helps, Joseph Bueno Martin Waite wrote: Hi, Does anyone know what the story is for file-descriptor limits on Linux ? I read

Re: how to get the Nth record of a result ?

Hi, select * from table where condition LIMIT N,1 More details at: http://www.mysql.com/doc/en/SELECT.html Regards, Joseph Bueno alx wrote: HI all I'm trying to get the Nth record of a query which i don't know nothing but the table name. I mean something like select * from table where

Re: insert query

, -- Joseph Bueno Murthy wrote: how to insert only blank spaces into a field using insert query. Its getting trimmed off. Regards, Murthy - Before posting, please check: http://www.mysql.com/manual.php (the manual

Re: Recreating indexes on large tables

Hi, Instead of using separate CREATE INDEX statements, you can build all your index at once with ALTER TABLE: ALTER TABLE my_table ADD INDEX ..., ADD INDEX ... , ADD INDEX ... ; Hope this helps, -- Joseph Bueno Salvesen, Jens-Petter wrote: Hello, everyone I have the following

Re: Perl DBI secret command?

No conspiracy, read it again ! ;) http://www.perldoc.com/cpan/DBI.html#rows Joseph Bueno Jeff Snoxell wrote: Hi, just stumbled across the following piece of code: my $rowcount = $sth-rows(); And I checked it out compared to a count of the fetched rows from an SQL QUERY. AND It matched

Re: MySQL Server Crashes under heavy load

postponed those optimisations. I think you really should audit your queries first. From my experience and what other users have reported on this list, you should expect to be able to run several hundred queries/s with the kind of hardware you are using. Hope this helps -- Joseph Bueno Chavvon Smith

Re: Loading a database into RAM

0 0 0 1359 1768 25 12 63 As you can see, no disk reads (bi) and a few disk writes (bo) Hope this helps, Joseph Bueno Steve Quezadas wrote: I have a mySQL database that is about 240 megabytes. I am loading it on a Linux server with 2 gigs of RAM. I would like to have the whole

Re: The diference about raw devices and disk partitions

advice. Hope this helps, Joseph Bueno NetClub Dyego Souza do Carmo wrote: I'm confused , what is the difference and raw device and a disk partition ? ex: on innodb I'm using /dev/sda1 for raw device, is it correct ? tnks. sql,query

Re: MySQL Select SUM Function

SELECT SUM(colA+colB) FROM TABLE ? Stevens, Ryan wrote: I understand the SQL statement in MySQL to be SELECT sum(column name) FROM table; but I would like to get a SUM of multiple columns. Is this possible?? Thanks, Ryan

Re: QUERY question (group by) - please help

? If yes, how? SELECT COUNT(*) FROM test WHERE (kid=1) OR (kid=2) OR (kid=4) GROUP BY cid,aid; Should do it, or am I missing something ? Thanks and regards, Dezo Hope this Helps Joseph Bueno - Before posting

Re: QUERY question (group by) - please help

(0.00 sec) So two rows are grouped because of same cid,did Any sugestion? Regards, Dezo SELECT COUNT(DISTINCT cid,aid) FROM test WHERE (kid=1) OR (kid=2) OR (kid=4) Should give you the number of groups. Hope this helps Joseph Bueno

Re: Ram Usage, and processes

a user ;) -James... Hope this helps Joseph Bueno - 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

Re: Why unsigned doesn't work?

. It should be: create table aaa(id int unsigned not null, name text); Please see the manual for more details: http://www.mysql.com/doc/en/CREATE_TABLE.html Thank you. Teddy, Teddy's Center: http://teddy.fcc.ro/ Email: [EMAIL PROTECTED] Regards, Joseph Bueno

Re: need index date help

. If you really need to work on day numbers, it would be more efficient to use a separate column where you explicitely insert TO_DAYS(NOW()). This way you can index it and efficiently use it on SELECTs. Hope this helps Joseph Bueno John Hinton wrote: OK.. no takers the first time... I'll try to give

Re: Storage Requirements Not Equal to Actual Disk Space Used...

mysql needs a few more bytes per record for its internal use. Since you use a VARCHAR, you have dynamic length records; this is described in the manual: http://www.mysql.com/doc/en/Dynamic_format.html Regards, Joseph Bueno Andrew Kuebler wrote: I have a table with 17,168,035 records. I have

Re: MySQL optimization

Hi, It seems that you don't have any index on your tables. You should at least create an index on flObjectID in all tables. You should also use 'explain' on your query to make sure that indexes are properly used. Hope this helps Joseph Bueno John Glenn wrote: I'm looking for recomendations

Re: How can I duplicate a mysql template database? [hack]

options but I just wanted to show the idea). Hope this helps, Joseph Bueno Daevid Vincent wrote: Seems to me there should be a built in SQL command to duplicate a database. Jeepers. Or to read in a .sql file from PHP and create a database out of it (which was the original intent). Anyways

Re: How can I duplicate a mysql template database? [hack]

: Unfortunately, command line is not an option for me. As I said before, the php scripts are on a web server and the database is on another server. -Original Message- From: Joseph Bueno [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 17, 2002 2:47 AM To: [EMAIL PROTECTED] Subject

Re: How can I duplicate a mysql template database?

You cannot execute several SQL statements within a single query. You are trying to reinvent 'mysql' client batch processing; if you want to do that, you have to write an SQL parser in PHP that split your input in independant SQL statements and execute them one by one :( Daevid Vincent wrote: You

Re: How to backup without blocking?

Hi, You can also use mysql replication: you install a slave server and run mysqlhotcopy on it. This way, you never freeze the master server. Hope this helps Joseph Bueno Philip Mak wrote: sql, query Right now, every day I run the equivalent of a mysqlhotcopy on my database (read-lock

Re: automatically inserting/updating timestamp

/DATETIME.html) Or am I missing something ? Regards, Joseph Bueno [EMAIL PROTECTED] wrote: I've created a table that contains a column called recordLastModified and that column uses timestamp as the data type. Is there a way in MySQL to automatically update timestamp fields as records

Re: Multiple Inserts and updates

you are getting from mysql. Regards, Joseph Bueno Ed Reed wrote: Thanks for the response. I tried your example but it doesn't work, Here's my SQL, can you tell what I'm doing wrong? Insert Into Table1 (Product, Qty) Values ((56-56, 5), (27-01, 1), (15-02, 2)); I've tried

Re: Multiple Inserts and updates

| 27-01 |1 | | 3 | 15-02 |2 | ++-+--+ 3 rows in set (0.00 sec) It really seems to work ;) Regards, Joseph Bueno Ed Reed wrote: I created a new table called Table1 and did a test with that command. My test table does have all three fields that I mentioned. The ID field

Re: Wont use Index when data is not evenly distributed

, as it can much more quickly find the few rows to return in the result. (see http://www.mysql.com/doc/en/MySQL_indexes.html) Regards, Joseph Bueno - Before posting, please check: http://www.mysql.com/manual.php (the manual

Re: MySQL max memory usage on linux/intel

caching. Since the total size of all databases is around 1.5 Gb they almost fit in memory and the server is happily serving around 300 queries/s with 200 concurrent connections and almost no disk I/O (no reads, just a few write every 5 seconds). Hope this helps -- Joseph Bueno [EMAIL PROTECTED] wrote

Re: mysql 3.23.53a-Max crashes on large memory machine

, and it will still speed up your database accesses. Hope this helps -- Joseph Bueno Johannes Ullrich wrote: I am having 'issues' with MySQL running on Redhat Advanced Server on a 8 Gigbyte machine (dual P4-Xeon). After large imports ('load data infile', file size about 1 Gigbyte) into a large

Re: Index using..

| | NULL| | | profiles| tinyint(4)| YES | | 1 | | +-+---+--+-+-+---+ Hope this Helps -- Joseph Bueno - Before posting, please check

Re: Important Restriction in Query Language?

This query uses a subselect that is not currently supported by MySQL. Check the manual for details: http://www.mysql.com/doc/en/ANSI_diff_Sub-selects.html Regards, Joseph Bueno jorge machado wrote: #Hello #I'm using hibernate a O/R model from sourceforge and it makes the #bridge #between sql

Re: mysql from redhat8 will only run one process and remote connectionsdie.

Try to upgrade glibc: https://rhn.redhat.com/errata/RHSA-2002-197.html [EMAIL PROTECTED] wrote: Description: I just installed redhat8 this weekend and am using the rpm's provided by them. when mysql runs it will only run a single process. and even worse... when I try and connect to

Re: Mysql Encryption

Have you considered putting your databases on an encrypted filesystem ? You don't need to add anything to mysql and those filesystems already exist (although I have not yet used them). Regards, Joseph Bueno mos wrote: At 08:15 AM 11/18/2002, you wrote: * Alexandre Aguiar On 14 Nov 2002

Re: restricting mysql

You can also restrict port 3306 to localhost with : bind-address = 127.0.0.1 in /etc/my.cnf Hope this helps -- Joseph Bueno David Lubowa wrote: port 3306 is the default port for mysql , if you do grep -i 3306 /etc/services you will see what service runs on that port. As for restricting

Re: min() in where clause

Erwin Ulreich wrote: I want to code the following in one statement: select min(field1) from table1; $res=result of the query select * from table1 where field1=$res; does anyone know? select * from table1 order by field1 desc limit 1

Re: min() in where clause

That's right, I should have checked before clicking on Send ;) gerald_clark wrote: That should not be DESC. That will give the max value. Joseph Bueno wrote: Erwin Ulreich wrote: I want to code the following in one statement: select min(field1) from table1; $res=result

Re: Using AUTO_INCREMENT like SEQUENCE - Resolved

number: UPDATE sequence SET code=LAST_INSERT_ID(code+1); SELECT LAST_INSERT_ID(); We use this method in our applications and it works well. (and I didn't invent it, it is described in Paul DuBois'book ;)) Hope this helps -- Joseph Bueno Mike Hillyer wrote: I was thinking

Re: find longest string in column

, Joseph Bueno - 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] To unsubscribe, e-mail [EMAIL

Re: Problems with ORDER BY from C API (works from command-linetool mysql.exe)

expect with ORDER BY 2 ? If you want to arder by sum(duration) you should use: SELECT exe, sum(duration) AS s FROM data GROUP BY exe ORDER BY s Hope this helps -- Joseph Bueno - Before posting, please check: http

Re: select using regexp

Hi, REGEXP is much more powerful than LIKE; you can match full words with this syntax: SELECT * FROM TABLE WHERE field REGEXP [[::]]cat[[::]]; (Easy, isn't it ? ;) ) You can find more examples in the manual: http://www.mysql.com/doc/en/Regexp.html Regards, Joseph Bueno NetClub gerald_clark

Re: mysql service on linux

in /etc/init.d/rc5.d Hope this helps, -- Joseph Bueno Natale Babbo wrote: Many Thanks No problems with mysql.server script ... it works fine if i start it manual like this: shell mysql.server start or shell mysql.server stop ... also symbolic link in /etc/init.d/rc3.d is ok. The only

Re: Is it possible to replicate just a couple of tables insteadof the whole database

-- Joseph Bueno - 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] To unsubscribe, e-mail

Re: self relation query help

as GroupName, A2.Name as Artist from A as A1, B, A as A2 where A1.id = B.grp_id AND B.art_id = A2.id should solve your problem. (Don't forget to create indexes on A(id), B(art_id) and B(grp_id) ;) ) Hope this helps -- Joseph Bueno

Re: subselect solution

Eric Hi, You should try: select fname, lname, date_creation from tb_person order by date_creation desc limit 1; and look at : http://www.mysql.com/doc/en/ANSI_diff_Sub-selects.html for other examples. Regards, Joseph Bueno

Re: MySQL - ERROR 2003: Can't connect

, have you checked the manual ? This page: http://www.mysql.com/doc/en/Can_not_connect_to_server.html may be useful, there are some comments on error 2003 from users at the bottom of this page. Hope this helps -- Joseph Bueno

Re: Incorrect key file for table

Renato Silveira wrote: I have this problem in MySQL select id from usuario; ERROR 1034: Incorrect key file for table: 'usuario'. Try to repair it How can I solve this problem? Repair it ! ;) See : http://www.mysql.com/doc/en/REPAIR_TABLE.html thks -- Joseph Bueno

Re: select from multiple tables

Hello, You can define a merge table and run your select on it. Check the manual for details: http://www.mysql.com/doc/en/MERGE.html Regards Joseph Bueno Veysel Harun Sahin wrote: Hello, I have a problem with select statetement. I need to query and select records from multiple tables

Re: AUTO_INCREMENT max value...

of AUTO_INCREMENT? Please include my direct email when repsonding - Thanks... Hello, The maximum value depends on the type of the field. It is 2^31-1 for INT, 2^63-1 for BIGINT. Check the manual for more details: http://www.mysql.com/doc/en/Numeric_types.html Regards, -- Joseph Bueno

  1   2   3   >