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

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

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

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

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

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

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 ? Can I use: innodb-file-per-table instead of innodb_file_per_table ? [This is just an example] Can I use only minus sign in the whole CNF file instead of underline ? Gabriel -- M

Re: mysql install on Redhat Linux 2.1AS (32 bit)

You should be shure that the old client is not in the PATH... because seems to me that when you're not int the mysql bin directory the old client is called... withc does not know about the new auth methods... Or else... start the server with the "--old-password" param. Gabriel - Original Me

Re: Weird Query Result

7; AS UNSIGNED); MySQL will yell: +--+ | CAST('FOOBAR' AS UNSIGNED) | +--+ |0 | +--+ 1 row in set (0.03 sec) I hope this is clear ! Gabriel PREDA www.amr.ro www.lgasso

Re: How does a multi-row INSERT work?

NSERT is faster. Of course THIS IS a faulty explanation ("grosso modo" in latin) but show somehow what's going on ! Gabriel PREDA - Original Message - From: "Chris W. Parker" <[EMAIL PROTECTED]> Subject: How does a multi-row INSERT work? > Hello, > I

Re: using one query to save data in 4 tables

ITLE in English', 'TITLE in French'); INSERT INTO `presa_im_content` VALUES(@ID, 'Content in Romanian', 'Content in English', 'Content in Fench'); UNLOCK TABLES; This way you do not need to actualy capture the value of the last insert id

Re: Problem with default-collation

)... but be carefull... ALTER them in 2 steps... ALTER all the columns in the table to a BINARY data type... then ALTER the table's collation to the desired one... finaly ALTER all columns back but now using the desired collation !!! Hope this helps ! Gabriel PREDA www.amr.ro www.lgasso

Re: change a column type and innodb foreign key constraints

CASCADE Gabriel PREDA www.amr.ro www.lgassociations.info www.falr.ro dev.falr.ro -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Tables,

ble_name` But the most verbose output you will get using: SHOW FULL COLUMNS FROM `table_name` This will show you collation, privileges the user has for the each column and per-column-comment. Verbose descriptions of the syntax can be found at http://dev.mysql.com/doc/mysql/en/show.html Good l

FullText StopWordFile

How internationalized is the ft_stopword_file ? How can I create a custom ft_stopword_file ? Is the build in one for english only ? Gabriel PREDA www.amr.ro -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: compare dates

ETIME... at 100 million rows that would make a difference at about 190MB... Or is it "Premature Optimization" ??) For the optimization issue you're right... Regarding TIMESTAMP... Reinhart didn't told us his MySQL version... as of 4.1.2 ... you have better control over TIMESTAMP co

Re: compare dates

ute in WHERE... so this is faster.. .but there are 2 queries: SET @this_moment = NOW(); SELECT * FROM activities WHERE act_date >= @this_moment Gabriel PREDA www.amr.ro - Original Message - From: Reinhart Viane To: mysql@lists.mysql.com Sent: Friday, February 18, 2005 1

Re: EXPLAIN: Select tables optimized away

O I see... I read this in MySQL Manual... I believe it's something like SHOW TABLE STATUS LIKE 'table_name' And then extract the number of rows... I never saw "Select tables optimized away" and it confused me ! Gabriel PREDA - Original Message - From:

EXPLAIN: Select tables optimized away

MySQL 4.1.10 What does "Select tables optimized away" mean ? mysql> explain SELECT COUNT(*) AS total FROM members_twining_main; | 1 | SIMPLE | NULL | NULL | NULL | NULL |NULL | NULL | NULL | Select tables optimized away | Gabriel PREDA -- MySQL General Mai

Re: instable behaviour of mysql

r that I think is not 'fai' but 'root' as you output says... To see grants for 'fai'@'mydom.tld' you should use: SHOW GRANTS FOR 'fai'@'mydom.tld' Hope it helps ! Gabriel PREDA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysqld error

uld remove from my.cnf or my.ini witchever you use... any declaration on named pipes... Gabriel PREDA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Difference between 'LIKE' and '='

; Results showing only differencies: type; ref range;NULL ref;const Of course things for me would make no big difference since `ccode` si a 2 letter CHAR... but for a varchar and a big table would ! Gabriel PREDA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: InnoDB and Transactions

ame transaction... that is IT WILL BE ROLLED BACK ! Good fortune ! Gabriel PREDA > -Original Message- > Andre Matos @ February 07, 2005 6:45 PM > Let's suppose that I have this sequence of events: > - create a connection "1" > -- start a transaction > ---

Re: Syntax for Compound "IF" Statements?

expr2 ELSE expr3 As you saw in the response I gave you I used instead of expr3 another IF... and so on !!! Gabriel PREDA www.amr.ro www.lgassociations.info -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: REPLACE INTO //add or update?

It simple... if mysql_affected_rows == 2 ---> update (because replace make DELETE and INSERT) else if mysql_affected_rows == 1 > insert Gabriel PREDA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/

Re: what happen if exceed max connection in innodb

Hi Chenri, > 1. is this value for one database or for overall mysql connections? The value is for overall mysql connections... so it's not for one database. > 2. i'm unable to generate 100 connections, i don't have 100 workstations yet, > how do i test it? Why would you ? > 3. what w

Fw: Syntax diagram, where is it located in the doc?

You're right there is none.. .but as you see there is a short line that says: "In the WHERE clause, you can use any of the functions that MySQL supports, except for aggregate (summary) functions. See section Functions and Operators." Gabriel PREDA > - Original Mes

Re: SHOW TABLES Problem

Because it does not know REGEXP... only LIKE patterns... % Matches any number of characters, even zero characters _ Matches exactly one character Taake a look in chapter 13 "String Comparison Functions". Gabriel PREDA - Original Message - From: "s

Re: Best way to store numeric data?

you have a total of 9 bytes DOUBLE - and it will take you 8 bytes per record So DOUBLE it's a good choice... Of course depending on what you do with the numbers the separation could provve better even if you loose one byte pe record ! Gabriel PREDA - Original Message -

Re: utf8 x latin

I think you should use: latin1_general_ci and on columns with spanish you should use latin1_spanish_ci. English, French, Portuguese not having a separate collation I believe that they are included into latin1_general_ci ? Please observe the last part from a collation name: case sensitive (_cs) .