Strange query issues

rs. The load is balanced, and no server is doing any significantly larger amount of processing than the others. Can anyone suggest anything for me to try to fix this problem? Many many thanks in advance, Gabriel. -- Gabriel Cain Unix Systems Administrator

Re: databases projecting

TECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > -- Gabriel Cain Unix Systems Administrator [EMAIL PROTECTED] Dialup USA, Inc. 888

Re: [thelist] MySQL to Excel Problem Pivot Table SOLVED!

gt; + > | 2001-10-26 | 3 | 0 | 0 | 0 | 0 | 0 | 0 > | > | 2001-10-31 | 1 | 0 | 0 | 0 | 0 | 0 | 0 > > This table contains over 5 million records. Nothing needs to be done i

Re: High-Speed/Volume Database

in memory, the better you'll do.) and 2 or 4 processors. (Actually, I suspect than an E450 would exceed your needs by a lot.) That sort of box would cost you about $20k, IIRC. HTH, Gabriel. Bob Smith wrote: > We are designing an application that needs to use > a relational database to

Re: Massive Research Data

; Seth > > > - > 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 PROT

Re: Fw: Simple SQL

| | Dec | All your lines are belong to us. | Are not. | +---+--+---+ 3 rows in set (0.03 sec) Does this help? -- Gabriel Cain Unix Systems Administrator [EMAIL PROTECTED] Dialup

Re: Fw: Simple SQL

Sampson, Peter wrote: > Gabriel. > > This works fine and the two tables talk to each other. > > BUT, > My website can have 5 - 10 news stories per month. So in the tblNews I > could have > [Snip multiple rows] > I need to use DISTINCT in the SQL lingo as I "

Re: What is going on? Performance question

-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > -- Gabriel Cain Unix Systems Administrator [EMAIL PROTECTED] Dialup USA, Inc. 888-460-2286 ext 208

Re: Foreign Keys and NULL

for mysql 3.23.50+ and 4.0.2+. > Now, I like MySQL 10 times more Cool. :) -- Gabriel Cain Unix Systems Administrator [EMAIL PROTECTED] Dialup USA, Inc. 888-460-2286 ext 208

Re: MySQLHost? What MySQLHost?

f mysql is started AND it has bound itself to the network interface, it should be reachable on :3306. Good luck, G. > Cheers, > > Peter. -- Gabriel Cain Unix Systems Administrator [EMAIL PRO

MySQL performance analysis help

do next? Many thanks in advance, Gabriel. -- Gabriel Cain Unix Systems Administrator [EMAIL PROTECTED] Dialup USA, Inc. 888-460-2286 ext 208 Faster, Better, Cheape

Re: creating database

(the list archive) >> >> To request this thread, e-mail <[EMAIL PROTECTED]> >> To unsubscribe, e-mail <[EMAIL PROTECTED]> >> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php >> >> >> > > > -- Gabriel Ca

Re: Too many mysqld-max processes!!

t archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > -- Gabriel Cain Unix Systems Administrator

Re: One-to-one relationship

ry much. And as for your query, you might look at LEFT JOINs. Here are links: http://www.amazon.com/exec/obidos/ASIN/0201447878/qid=1028051191/sr=8-1/ref=sr_8_1/103-4096381-4279056 Hope this helps. Quinten Steenhuis wrote: -- Gabriel Cain Unix S

Import from Access to MySql

Anyone can tell me how can i import an access db to mysql. Thanks in advance, Gabriel.

newbie password issue

now i changed the root password just fine but now i have to enter it every time i run mysqladmin even "mysqladmin version" reqires a "-p" tell me there's a simpler way - Before posting, please check: http://www.mysql.com

newbie nagging

anyone have any idea what this means? and why it comes up? mysql> use mydatabase; Reading table information for compltion of table and coumn names You can turn off this feature to get a quicker startup with -A Database changed mysql> this only comes up for _some_ databases not all any he

Re: describe table : improvement

) CHARSET utf8 COMMENT 'Some comment' ); Is this... what you needed ? -- Gabriel PREDA Senior Web Developer

Re: describe table : improvement

Sorry forgot to mention MySQL version 4.1.X > This option is operational as of MySQL 4.1. (It is allowed but ignored in > earlier versions.) -- Gabriel PREDA Senior Web Developer

Re: describe table : improvement

COLUMN COMMENTs are not the same as TABLE COMMENT... For TABLE COMMENT you should use: SHOW TABLE STATUS LIKE 'table_name' *Gilles *(the starter of the thread) wanted COLUMN COMMENTs. -- Gabriel PREDA Senior Web Developer

Query Cache configuration

Hi friends, I need your help. I want to configure the Query Cache, but it dosn't work. I have installed MySQL 5.0.19 in Mandrake Linux. The server has 2GB memory ram, 150 gb hard disk, exclusive for dbms. I configure my system how say the home page. I follow step by step the instructions. (http:

Re: fulltext wildcards

Try: http://dev.mysql.com/doc/refman/5.0/en/fulltext-boolean.html -- Gabriel PREDA Senior Web Developer

Problems with Mysql 5 and Visual Basic 5

I migrated to mysql 5 but the applications with Visual Basic 5 return error in data. We have installed ODBC 3.51 -- Saludos cordiales. Ing. Gabriel Mahiques Dto. Control de Gestión ELECTROINGENIERA S.A. Telefono: 474 1414

Error wiht VB 5 and MySQL

applications they had an error: all data in decimal format return "???" (for example: if the data must be 1345,68 the form show ""). Can anybory help me. -- Saludos cordiales. -------- Ing. Gabriel Mahi

Re: Error wiht VB 5 and MySQL

t, any implicit conversion? Maybe a declaration of type that is casting another type for the value returned from the resultset. Also check this: http://dev.mysql.com/doc/refman/5.0/en/precision-math-decimal-changes.html On 4/24/06, Gabriel Mahiques <[EMAIL PROTECTED]> wrote: Hi. A Brief descrip

"is not not valid floating point for field"

Mandrake -- Saludos cordiales. ---- Ing. Gabriel Mahiques Dto. Control de Gestión ELECTROINGENIERA S.A. Telefono: 474 1414 Uspallata 1461. Barrio San Martín. CP: X5008HSH Córdoba. República Argentina. -- MySQL General Mailing List For list ar

Re: Query Help

SELECT id, count(*) AS cnt FROM `table_name` GROUP BY id ORDER BY cnt DESC [ LIMIT 1 ] -- Gabriel PREDA Senior Web Developer

Table so slow to read

s=200; Thanks. -- Saludos cordiales. Ing. Gabriel Mahiques Dto. Control de Gestión ELECTROINGENIERA S.A. Telefono: 474 1414 Uspallata 1461. Barrio San Martín. CP: X5008HSH Córdoba. República Argentina. -- MySQL General Mailing Lis

Re: Table so slow to read

My name is Gabriel, "Saludos Cordiales" is the same than "Best Regard" in spanish. The server explanin is the same. The table structure is the same, the application is the same (redirect the data source only), the quantity of record is the same. All is the same, I copy t

Re: Mysql add multiple index

me will be faster ! [I'll get back if i'll find something in the Certification Study Guide... a pretty nice book !] -- Gabriel PREDA Senior Web Developer

Re: Mysql add multiple index

with creating the 2 indexes at once.* *If not create the one by one... i'm sure some other queries will be honoured between those ALTER statements.* -- Gabriel PREDA Senior Web Developer

Re: How to rename a DB

RENAME new_db.table2; ALTER TABLE old_db.table_N RENAME new_db.tableN; DROP DATABASE old_db; -- -- End renaming database -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Gabriel PREDA Senior Web Developer

Re: How To Pronounce MySQL

yo digo My eSe Qu eLe, but spanish aren't usefull for you for SQL Server I say "Mierda" (shit in english...) Good by friends.. Open source for everybody... the knowledge belongs to the humanity.. .. Chris Sansom escribió: At 7:38 -0500 8/6/06, Jimmy Guerrero wrote: "The official way to pro

Re: MYSQL->on delete no action

Barry, You Give Ass (en castellano basico seria Das ocote, para escribir eso mejor no escribas nada) Barry escribió: Nenad Bosanac schrieb: Hi all I made mistake i n my last post so now i make it true. I have problem in MYSQL query tool. Well i put on foreign key on delete no action bu

Re: How To Pronounce MySQL

the real pronuntiatios is.. MAIESEKUELE spanish, spanish... the rest is a dream... when I start up the system, it say... "wellcome.. I'm the best...my name is MAIESEKUELE and I'm free oh yea... I want to f... me to MS SQLServer.. ohhh yeh" Melvin Zamora escribió: Or you c

Search and Replace a word in memo field

"dvd" in all records. How can I do this? -- Saludos cordiales. ---- Ing. Gabriel Mahiques Dto. Control de Gestión ELECTROINGENIERA S.A. Telefono: 474 1414 Uspallata 1461. Barrio San Martín. CP: X5008HSH Córdoba. República

Re: Search and Replace a word in memo field

d I want to replace with "DVD" Trade Konami. so basically the word that I need to replace is located in the middle of the phrase. João Cândido de Souza Neto escribió: update table set field=REPLACE(field, 'vhs', 'dvd'); "Gabriel Mahiques" <[EMAIL PROTE

Re: Search and Replace a word in memo field

Thanks friends. Duncan Hill escribió: On Monday 12 June 2006 14:16, Gabriel Mahiques wrote: but I have a problem with this solution, because I have the words in the middle of the phrase. For example: Movie Kill Bill Vol 1 in "vhs" format, and I want to replace IT with Movie Kill

Re: MyMonitor - A novel SQL monitor tool for MySQL release 1

but there is more to come. ncurses library is required, as well as the MySQL Client library of course. Enjoy, and comments are welcome, I hope this tool will turn out useful -- Saludos cordiales. -------- Ing. Gabriel Mahiques Dto.

Re: About the leftmost index prefixes using nounique index

, c FROM table_name WHERE d > 9; - will use the index Hope this clears up things ! -- Gabriel PREDA Senior Web Developer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: About the leftmost index prefixes using nounique index

index on: a, c or c, a Try variations... of indexes toghether with EXPLAIN SQL... Also have a look at MySQL Optimization by Jeremy Zawodny at http://jeremy.zawodny.com/mysql/mysql-optimization.html -- Gabriel PREDA Senior Web Developer -- MySQL General Mailing List For list archives: http

Re: problem with altering a table

the column: DROP FOREIGN KEY `fk_message_idnr_manually_set` If you DROP an index a FOREIGN KEY based on that index will not be dropped automaticaly... Hope this helps ! -- Gabriel PREDA Senior Web Developer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To u

Problems with: MySQL 5.0.21 - 64bit

and... the only thing we can do is ask the hosting provider to do a HARDWARE reset... and someone goes to the machine and pushes the reset button... this hppens at least once a week... Does this happened to someone else ? What was the problem ? Thanx in advance ! -- Gabriel PREDA Senior Web

Re: Merging two fields; references to fields

N: SPACE(n) - generates a string with a space in it ! -- Gabriel PREDA Senior Web Developer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: InnoDB obeyance of PRIMARY KEY constraint - confirmation

ptimization.html - slide:37/80) -- Gabriel PREDA Senior Web Developer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Problems with: MySQL 5.0.21 - 64bit

Yup... For now the problem stopped... These humongos values were because they were initialized at MAX_INT on that 64bit machine... In the my.cnf file they were not mentioned at all ! 2^64 - 1 == 18446744073709551615 Now look at the values below ! -- Gabriel PREDA Senior Web Developer On 6

Re: multi-column indexes on InnoDB tables

in case of a power failure the domain controller is up and running and holding all the data up to the last SAVE given by any user Now imagine instead of domain controller is MySQL... in your case... ) -- Gabriel PREDA Senior Web Developer -- MySQL General Mailing List For list archives: h

Re: How to share data between servers

created on server2 do not reside on it... but on server1... the queries are actualy sent to server1 processed and the result is returned to server2... From these 2 i'll put my money on the first one ! -- Gabriel PREDA Senior Web Developer -- MySQL General Mailing List For list archives:

Re: Problems with: MySQL 5.0.21 - 64bit

ons... all used): innodb_thread_concurency / CPU-workload 8 / 90% 4 / 75 - 85% 3 / 60 - 70% 2 / 25% So set it lower... lower... lower... when I left the office friday my colleagues were still working at this... I'll keep you all updated ! -- Gabriel PREDA Senior Web Developer -- MySQL Gene

See lock table

manager then the table remains locked. Regards -- Saludos cordiales. Ing. Gabriel Mahiques Dto. Control de Gestión ELECTROINGENIERA S.A. Telefono: 474 1414 Uspallata 1461. Barrio San Martín. CP: X5008HSH Córdoba. República

Re: Cumulative Totals

GROUP BY DATE_FORMAT( payments . date , '%Y-%m' ) WITH ROLLUP This will give you something like: amount | paymentDate 200 | 2005-01 58 | 2005-02 258 | NULL Will it do ? -- Gabriel PREDA Senior Web Developer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MAX_JOIN_SIZE

only request 30 rows with LIMIT... MySQL will still JOIN the tables... the LIMIT clause is applied just before sending the resultset to the client ! If you can't do it otherwise try setting a higher "sql_max_join_size"... or try using some temporary tables ! Good fortune ! -- Gabr

Re: Trying to understand why Select running out of memory if table not used

hat was not the issue... Maybe you ran out of memory into one of: max_allowed_packet net_buffer_length max_join_size Try enlarging those values... on the server also... But first try to run with '--compress' maybe this will fix... -- Gabriel PREDA Senior Web Developer -- MySQL General

Re: How to disable foreign_key_checks when using mysqlimport?

Try: ALTER TABLE `tbl_name` DISABLE KEYS; -- now insert in the TXT file ALTER TABLE `tbl_name` ENABLE KEYS; I think this is what you were looking for ! -- Gabriel PREDA Senior Web Developer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: why size of table c united from table a and b are bigger than a+b ?

d in 60bytes. If a and b are VARCHARs and c are CHARs that's it ! If you have all VARCHARs I'm in the dark ! Hope it helps ! -- Gabriel PREDA Senior Web Developer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Problems with WHERE clause

N rs.serie_id = s.id INNER JOIN races AS r ON r.id = rs.race_id INNER JOIN participants AS p ON p.race_id = r.id WHERE s.receipt = 1 AND p.rider_id = 236 AND SUM(p.fee) > 0 GROUP BY s.id ORDER BY s.f_date; -- Gabriel PREDA Senior Web Developer -- MySQL General Mailing List For lis

Re: problem with InnoDB

as I mentioned above] But the gain is that the second query that will return the number of rows without the LIMIT clause: SELECT FOUND_ROWS() will return instantly. -- -- -- -- -- -- -- -- -- -- -- -- -- -- Gabriel PREDA Senior Web Developer -- MySQL General Mailing List For list archives: http://

Re: How to get size of biggest blob (for max_allowed_packet)?

H and CHAR_LENGTH only if you use multi-byte strings ! ... I use CN and others... So... try: SELECT MAX(LENGTH(`CnText`)) FROM `Translations` -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Gabriel PREDA Senior Web Developer On 9/14/06, Dominik Klein <[EMAIL PROTECTED]> wrote: For adjusting "ma

Re: Question

L General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Gabriel PREDA Senior Web Developer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: speed up index creation on existing tables?

reating them on disk !!! I'm pretty sure you can figure out the speed improvment ! -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Gabriel PREDA Senior Web Developer On 10/5/06, David Sparks <[EMAIL PROTECTED]> wrote: Its already been running 2 days. I probably need to index some more

Re: multiple primary keys on one table?

. -- -- -- -- -- -- -- -- -- -- -- -- -- -- Gabriel PREDA Senior Web Developer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Returning a Value from a Stored Procedure

this will not affect LAST_INSERT_ID() value. And another thing... LAST_INSERT_ID() is kept on a per connection basis... so it will not mix with other users LAST_INSERT_IDs -- -- -- -- -- -- -- -- -- -- -- -- -- -- Gabriel PREDA Senior Web Developer -- MySQL General Mailing List For list archives: h

Re: CREATE TABLE Inv_Id

I would try: CREATE TABLE Inv_Id ( ID INT(12) UNSIGNED ZEROFILL AUTO_INCREMENT PRIMARY KEY, MID INT NOT NULL, FOREIGN (MID) REFERENCES 'Model' (ID) ); Note the UNSIGNED and ZEROFILL flags ! -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Gabriel PREDA Senior Web Developer -- MyS

Re: C API - Mysql 5

t any trouble. I've tried with the --enable-auto-import as well as the disable one. Anyone have an idea? Thank's in advance Vincent Badier -- Cordialement Gabriel LINDER / JEUXVIDEO.COM --- http://www.jeux

Innodb Settings

Hello I am looking to determine the best Innodb Settings for our MySQL Instances. Specifically, the settings for innodb_buffer_pool_size and innodb_log_file_size. I have read the manual and understand how they work. I am looking for additional information that would help me determine their

Innodb Settings - repost

** I am reposting. ** I am looking for some general rule to determine the innodb_buffer_pool_size and innodb_log_file_size based on number of innodb tables, transactions, etc. Setting these values based on how much of the server resources I am allotted is not adequate. Thanks Hello I am loo

Re: I need Query Help

r` column... because it allows the `gender` not to be specified... to be null ! -- Gabriel PREDA Senior Web Developer On 2/10/06, Veerabhadrarao Narra <[EMAIL PROTECTED]> wrote: > > > I have a table named table1 structure is > > ++---+--+-+---

Re: Migration

Not the whole... maybe it's humongous... some lines above line 20 and some beneath... -- Gabriel PREDA Senior Web Developer On 2/10/06, sheeri kritzer <[EMAIL PROTECTED]> wrote: > > James, > > You're going to need to show us the contents of olddbname.sql. > >

Re: fulltext searches

my.cnf adding "ft_stopword_file=/var/lib/mysql/stop_file" 4. rebuild all FULL-TEXT indexes in all databases... if not only new indexes will take benefit from the new stop-words-file Hope it helps... !!! --- Gabriel PREDA Senior Web Developer PS: If intere

Re: Converting database and its tables to UTF-8

t database tables with different chartsets and even in a table you can have columns with other chartsets... Gabriel PREDA Senior Web Developer On 2/14/06, Peter Lauri <[EMAIL PROTECTED]> wrote: > > Hi, > I have a database with around 40 tables that needs to be

Re: 5.0.16. Bug in union?

Interesting... maybe this is because the fill is not actualy stored in the database... and being sorted/compared as a number MySQL removes the ZEROFILL ! You can go and do: select BINARY * from a union select BINARY * from a; -- Gabriel PREDA Senior Web Developer On 2/14/06, Juri Shimon

Re: describe table : improvement ?

column ! Good luck ! -- Gabriel PREDA Senior Web Developer ** On 2/17/06, Gilles MISSONNIER <[EMAIL PROTECTED]> wrote: > > when I do a "describe a_table", it displays : > | Field | Type | Null | Key | Default | Extra | I would like to have a "Comment" that would show > the meaning of a field.

inquiry

Yes... count me in for this question also... I didn't figured that out... I just bought "MySQL 5.0 Cerrt. Study Guide" and I wanna know also... I also saw that the exams for the 5.0 branch are in BETA... when are we going to expect a final exam ? -- Gabriel PREDA Senior Web Devel

Re: MySQL query & gifted book !!!

r him !)... The fact is that I don't have the bill... does this make me in a less legal position... will I still get 25% off at the exam ? Should I ask for some kind of a "deposition" from my friend in USA !??? -- Gabriel PREDA Senior Web Developer On 2/27/06, Anago Chima <[EMA

Re: Problem with UNION

the thing is DISTINCT is implicit ! You will need to add after UNION the keyword ALL ! Good luck ! -- Gabriel PREDA Senior Web Developer

Re: Boolean searches on InnoDB tables?

on the both tables I also did a sync. every Sunday ( I had the smallest traffic on Sundays) and a complete reconstruction of the table every 2 months... ( MyISAM table - is now 750 MB ) The system is working fine for about 16 months now ! -- Gabriel PREDA Senior Web Developer

Webminars

way ! -- Gabriel PREDA Senior Web Developer

Re: How can I observe mysqld?

STATUS - to get and/or compute the statistics you see on the top part of the screen ! SHOW FULL PROCESSLIST - to get a list of running proceses ( SELECT, INSERT, UPDATE, CREATE ... ) So it cannot be database bound ! -- Gabriel PREDA Senior Web Developer

Re: Charset questions

ODBC ! Have you searched for ODBC related issues ? Maybe is ODBC's fault. What server version do you use ? 4 or 5 ? Please specify minor also ! What about connection charset and/or collation ? Have you set them ? so... ? :) -- Gabriel PREDA Senior Web Developer

Re: Very large from

7;t know... 10 tables... what's the point of using "*one single insert*" how ca one use a "one single insert" to put data in 10 tables ? So... the design of the application follows in at least 50% of the cases the design of the DATABASE ! Give us a little more details about your database ! -- Gabriel PREDA Senior Web Developer

Re: Problems with UTF and MySQL

One must issue immediately after connection: SET NAMES 'utf8' Also look at: SHOW VARIABLES LIKE 'collation_%'; SHOW VARIABLES LIKE 'character_set_%'; Server must know what you are assking for... and they ALL have to "talk the same language" !!! -- Gabriel PREDA Senior Web Developer

Re: mysql query and version problem .... Help!

You don't need to drop a TEMPORARY table... it is dropped at connection-close ! You don't need to wory about different names for TEMPORARY tables... Manual says: > A TEMPORARY table is visible only to the current connection, and is > dropped automatically when the connection is closed. This mean

Re: Complicated select query

About the first problem I think you need to give us more data ! As for the seccond... I haven't sen such loops yet... But you can go arround them and do something like: SELECT * FROM db WHERE (id BETWEEN 5 AND 50) AND id%5=0 -- Gabriel PREDA Senior Web Developer

Re: best way to handle two timestamp times

r every change in the row only the second column will change values ! -- Gabriel PREDA Senior Web Developer On 3/28/06, jonathan <[EMAIL PROTECTED]> wrote: > > Basically, I want to have a content row that has two times, the time > that an insert was done and the time that it was

Re: Problems with UTF and MySQL

character sets: > > SET NAMES '*charset_name*' > SET CHARACTER SET *charset_name* > > Again the SET NAMES with quotes anything else without ! So... dear writers of MySQL... or DOCs... what's the catch ? And... of course I'll use it with quotes ... until further

Re: Customer Recommendation Query

ot scan NR_OF_ROWS(`list_problem_ma`) * NR_OF_ROWS(`list_problem_ma`) but only NR_OF_ROWS(`list_problem_ma`) * 1 You will still get: Using where; Using index; Using temporary; Using filesort ... but i believe that's no way arround that ! -- Gabriel PREDA Senior Web Developer

Re: auto_increment and the value 0

that a value of 0 in an auto_increment column is not a good thing ... as everybody said before ! Good luck ! -- Gabriel PREDA Senior Web Developer

Re: Fultext search issues

vance. Or you could use: SELECT title, Comment FROM table_name WHERE MATCH (Comment) AGAINST ('"foo bar"' IN BOOLEAN MODE); Note the double quotes inside single quotes... ' "foo bar" '... needless to say what it does... everybody had googled that way

Re: Way of declaring variables?

ELECT statements. In SET statements you don't need that... you can write: *SET @last = last_insert_id()* Or with values from outside MySQL: *SET @iNeedThis = 'someText';* Then use both in an insert statement: *INSERT INTO table (lid, txt) VALUES (@last, @iNeedThis);* Hope this cleared

Re: better way of doing 1800 sequential updates?

ave... you must add an index on the column named "id" ! Run in MySQL client: ALTER TABLE ultimas_respuestas_snmp ADD INDEX someNameForTheInde4x(id); It will take a while... but it will get you faster. -- Gabriel PREDA Senior Web Developer

Re: Help Needed

o use the last value from that table: Either you use a MAX() request: *SELECT @lastGenerated:=MAX(columnName) FROM tableName* Or: *SHOW TABLE STATUS LIKE 'tableName'* and somewhere in the result is the AUTO_INCREMENT value. Good luck ! -- Gabriel PREDA Senior Web Developer

Re: On Duplicate Key....

Try: INSERT *IGNORE* INTO table (a,b) VALUES (1,2) -- Gabriel PREDA Senior Web Developer

Re: new password will not be effective for connection immediately

Only if you run this SQL statement: *FLUSH PRIVILEGES* That will make the new password effective. -- Gabriel PREDA Senior Web Developer

Re: mysql on tmpfs

If there is plenty of free memory... Can't you completly disable SWAP ? -- Gabriel PREDA Senior Web Developer On 4/7/06, Atle Veka <[EMAIL PROTECTED]> wrote: > > However, even though > there is plenty of free memory linux makes weird decisions from time to > ti

Re: Do if and elseif and other calculations

AND tour_scorecard_hole.id=tour_player_score.scorecard_hole_id GROUP BY overpar; And instead of ELSEVALUE you can insert another IF... There is also a CASE in MySQL... you can also use that one... What i don't see here is a DEFAULT value... do you have any ? -- Gabriel PREDA Senior Web Developer

Call a routine on mysqld startup

Hi, I must call a routine when mysqld start (to populate a heap table). I did not find any related options in mysqld --help --verbose. Is there a way to achieve this, without modifying the startup script ? Thanks in advance. -- MySQL General Mailing List For list archives: http://lists.mysql.co

Re: Call a routine on mysqld startup

On Mon, 15 Jun 2009 10:00:00 -0400 Jim Lyons wrote: > There's an option called "init-file" that will invoke an sql script > on start up. That would probably work for you. Thanks you, that is what I was searching for. I guess I should clean my glasses :) -- MySQL General Mailing List For list

XAMMP and Mysql error

qld.exe!??? The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. Thanks for any help. -- Regards. Gabriel TESSIER LOGOSAPIENCE 3, Rue Pierre et Marie CURIE 49070 ST JEAN DE LINIERES +33 (0)2.41.36

Re: MySQL Front

: http://www.mysqlfront.de/ It's my favorite toll now it's gone -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Gabriel PREDA Senior Web Deve

Re: Varchar limit warning

Complementary to what Donna said, You can issue a SHOW WARNINGS sql after some of these queries... the "cutt-off" will be listed there ! You will get a mysql_result in the form: Level - Code - Message Warning - 1265 - Data truncated for column 'column_name' at row X. Gabri

  1   2   3   >