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

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

MySQL replication status plugin

know if anything has been 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

Re: MySQL Certification

DEV1 and DEV2 !!! Thanx -- -- -- -- -- -- -- -- -- -- -- -- -- -- 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

esults for DEV1 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:/

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

personally 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

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 aga

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 s

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: 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: Data types and space needs

. The only notable difference... as you can 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. --

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Re: fulltext wildcards

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

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

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

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: On Duplicate Key....

Try: INSERT *IGNORE* INTO table (a,b) VALUES (1,2) -- 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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

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

Webminars

way ! -- 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 !!!

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

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

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

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

Re: alter only an enum label

me columnname ENUM('a','b','c');" 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'

alter only an enum label

the "c" value? isn't there any optimization for that? ...leaving "blank" labels 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: 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

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 <><><><><><><><><><><><><><><><><><><><><> "T

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 un

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

  1   2   3   >