XAMMP and Mysql error

/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.81.41 -- MySQL General Mailing List For list archives: http

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:

Re: Call a routine on mysqld startup

On Mon, 15 Jun 2009 10:00:00 -0400 Jim Lyons jlyons4...@gmail.com 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

RE: Oracle , what else ?

-Original Message- After MySQL bought by the java maker, and now Sun bought by Oracle, How did I miss this!? It seems like the little fish are getting eaten by the bigger fish. I understand Microsoft is now going to buy Oracle. :-) (Sorry, just kidding) The real

MySQL replication status plugin

done in this arena already, I would be over the moon, if someone has beaten me to it, but I am so not in the mood to write one! Any hints, recommendations, and ideas are wholly welcome! --- Kind Regards, Mr Gabriel

Re: renaming database

Or if RENAME DATABASE is not implemented yet: CREATE newDatabase; then for each table in the oldDatabase issue: ALTER TABLE oldDatabase.tblX RENAME TO newDatabase.tblX After all is done: DROP oldDatabase -- -- -- -- -- -- -- -- -- -- -- -- -- -- Gabriel PREDA Senior Web Developer -- MySQL

Re: MySQL Certification

-- -- -- -- -- -- -- -- -- -- -- -- -- -- 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]

MySQL Certification

are still valid ? And is the list still ON ? ... I'm subscribed to the list... but didn't got any messages... Thanx for the answers ! -- -- -- -- -- -- -- -- -- -- -- -- -- -- Gabriel PREDA Senior Web Developer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: InnoDB fixed file size, how much is left?

go with at most 2 files arround 500MB... keeping in mind that you have file_per_table on !!! How big transactions are you expecting... how many clients are you expecting ? Answers to these questions can help you tweak the server... -- -- -- -- -- -- -- -- -- -- -- -- -- -- Gabriel PREDA Senior Web

Re: Request problem (with \\)

Hi, It works, thanks you for your help :-) ViSolve DB Team wrote: Hi Gabriel, Try as: mysql select * from forum where topoc like %%; To search for '\', specify it as ''; this is because the backslashes are stripped once by the parser and again when the pattern match is made

Request problem (with \\)

Hello list, I am currently trying to fix a bug in a search function with a request like this one : select * from forum where topic like '%[...]%' ; where [...] is a string escaped by mysql_real_escape_string (C API) and topic is a varchar field (not null). It works, but there is a bug if

Re: MyISAM issues for UTF-8?

! -- -- -- -- -- -- -- -- -- -- -- -- -- -- 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: MyISAM issues for UTF-8?

Read here: http://dev.mysql.com/doc/refman/5.1/en/charset-connection.html have fun ! -- -- -- -- -- -- -- -- -- -- -- -- -- -- Gabriel PREDA Senior Web Developer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

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. Gabriel PREDA On 1/5/07

Re: Data types and space needs

see... is in prepending 0 to the number to reach the desired length... if the number is greater than or equal to the declared length it has no effect. So AFAIK this is the purpose of the length...in INTEGER columns. -- -- -- -- -- -- -- -- -- -- -- -- -- Gabriel PREDA Senior Web Developer -- MySQL

Re: MySQL Front

/ 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 Developer -- MySQL General Mailing List

Re: C API - Mysql 5

. Anyone have an idea? Thank's in advance Vincent Badier -- Cordialement Gabriel LINDER / JEUXVIDEO.COM --- http://www.jeuxvideo.com : Le site numéro 1 des jeux video en français http://boutique.jeuxvideo.com : Pour acheter tous

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 -- MySQL General

Re: Returning a Value from a Stored Procedure

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: http://lists.mysql.com/mysql

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: speed up index creation on existing tables?

!!! 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 columns in another table

Re: Question

] -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- 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: How to get size of biggest blob (for max_allowed_packet)?

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 max allowed packet

Re: problem with InnoDB

] 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://lists.mysql.com/mysql

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

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

= 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 list archives: http

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: Trying to understand why Select running out of memory if table not used

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 Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: MAX_JOIN_SIZE

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 ! -- Gabriel PREDA Senior Web

Re: Cumulative Totals

| 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]

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: Problems with: MySQL 5.0.21 - 64bit

): 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 General Mailing List

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: http

Re: Merging two fields; references to fields

) - 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

) -- 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

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: http://lists.mysql.com/mysql

Problems with: MySQL 5.0.21 - 64bit

... 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 Developer

Re: About the leftmost index prefixes using nounique index

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

an 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

: 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 unsubscribe

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

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. Control de Gestión ELECTROINGENIERA S.A

Search and Replace a word in memo field

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 archives

Re: Search and Replace a word in memo field

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 PROTECTED] escreveu na mensagem news:[EMAIL PROTECTED] Hello friends. In need your

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 Bill Vol 1

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

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

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

Re: How to rename a DB

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

Table so slow to read

; 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 List

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 the database from one server

Re: Mysql add multiple index

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: Query Help

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

is not not valid floating point for field

. 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 archives: http://lists.mysql.com/mysql

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

the 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 Mahiques Dto. Control de

Re: Error wiht VB 5 and MySQL

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 description about my problem. We

Re: fulltext wildcards

Try: http://dev.mysql.com/doc/refman/5.0/en/fulltext-boolean.html -- 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.

Re: describe table : improvement

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

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

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 time, temporarily killing performance

Re: better way of doing 1800 sequential updates?

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

: 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: Way of declaring variables?

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 up things ! -- Gabriel PREDA Senior Web

Re: Fultext search issues

. 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 at least one time !!! -- Gabriel PREDA Senior Web Developer

Re: Customer Recommendation Query

(`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

said before ! Good luck ! -- Gabriel PREDA Senior Web Developer

Re: Problems with UTF and MySQL

'*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 notice ! -- Gabriel PREDA Senior Web Developer On 3/28/06, Adam i

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

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 last updated if any. I keep getting an error

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 means

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: Very large from

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: Charset questions

! 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

Webminars

that way ! -- Gabriel PREDA Senior Web Developer

Re: How can I observe mysqld?

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: 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

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: MySQL query gifted book !!!

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 [EMAIL PROTECTED] wrote: Please does anybody knows the content

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 Developer On 2/22/06

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.

Re: Converting database and its tables to UTF-8

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 converted to UTF-8 to support

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 [EMAIL

Re: fulltext searches

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 interested in building a stop-word-list for RO... mail me ! On 2/10/06, Octavian Rasnita

Re: I need Query Help

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 ++---+--+-+-+---+ | Field | Type | Null | Key | Default

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. -Sheeri On 2/10/06, James Dey [EMAIL

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 ORIGINAL POST

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

alter only an enum label

on a enum? or another command to add new labels to a enum? thanks, Gabriel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: alter only an enum label

'); thanks, Gabriel 2005/6/16, Gordon Bruce [EMAIL PROTECTED]: If you have c values in the table currently you can just do an ALTER TABLE tablename CHANGE columnname columnname ENUM('a','b','c','x') DEFAULT a NOT NULL then UPDATE tablename SET columname = 'x' WHERE columname = 'c

Test - please ignore

Just a test - thanks There are no problems, only solutions. Gabe Tucker Bloomberg LP (609) 750 6668 - P (646) 268 5681 - F -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

No Longer Receiving Emails

Hi I have not received anything from this list for a couple of days. I just tried to re-register, and that did not help. If anyone reads this, please reply to ME so I can determine if the problem is with my account or with the list. Thanks Gabe There are no problems, only solutions. Gabe

RE: No Longer Receiving Emails

Thanks - now I am getting emails from the list.. Gabe -Original Message- From: Cummings, Shawn (GNAPs) [mailto:[EMAIL PROTECTED] Sent: Friday, May 27, 2005 2:39 PM To: Tucker, Gabriel Subject: Re: No Longer Receiving Emails You are sending messages without error, it would appear

Re: Underline or minus sign ?

No one ? Please help me with this. Gabriel - Original Message - From: Gabriel PREDA [EMAIL PROTECTED] Sent: Wednesday, May 04, 2005 4:36 PM Subject: Underline or minus sign ? I'm going to start the InnoDB engine... and I want to know if the syntax for the CNF file unified at last

  1   2   3   >