Re: Optimizing InnoDB tables

Have a look at this: https://rtcamp.com/tutorials/mysql/enable-innodb-file-per-table/ -- Andre Matos andrema...@mineirinho.org On Jun 25, 2014, at 2:22 AM, Antonio Fernández Pérez antoniofernan...@fabergames.com wrote: ​Hi again, I have enabled innodb_file_per_table (Its value is on). I

Collate issue

', some as 'latin1_bin', and others without any. Is there any known issue with previous versions of the MySQL 5.0.x regarding this? Is there a way I can do this so all applicable fields on my view uses the collation I want? Thanks for any help! Andre -- Andre Matos andrema...@mineirinho.org

Using RAND to get a unique ID that has not been used yet

that hasn't been used? The RandId must be only numbers and length of 6 (from 1 to 99). No other character is allowed. Thanks for any help! Andre -- Andre Matos andrema...@mineirinho.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Using RAND to get a unique ID that has not been used yet

It seems to be a good approach, although I was trying to get this by querying the table without creating another table to keep the Ids. Thanks, Andre -- Andre Matos andrema...@mineirinho.org On 2010-05-28, at 12:15 PM, Steven Staples wrote: If you wanted to use/go that route, then why

Re: Using RAND to get a unique ID that has not been used yet

When I mentioned having everything in the Query, I was thinking about this. I don't want to have a loop repeating the query until I get a unique Id. This is ridicules and imagine how many queries I might end up running. No way! Thanks for the warning and feedback! Andre -- Andre Matos andrema

SELECT through many databases

Hello, Let's suppose I have 5 database: db1, db2, db3, db4, and db5. They all have the same structure but different data. I would like perform this select SELECT TaskDoneOn, TaskDoneBy FROM {database} WHERE TaskDoneOn IS NOT NULL and collect the data from all 5 database. However, I would

Re: SELECT through many databases

I was trying to avoid both since the SELECT statement is not fixed. Time to time, users want different information. Thanks, Andre On 21-Nov-08, at 12:59 PM, Peter Brawley wrote: Andre Matos wrote: Today I have 5, but tomorrow I can have 50 and I don't want to forget any database. Do

Re: SELECT through many databases

Sounds interesting, but does the MERGER support complex SELECT statements and LEFT JOIN? Andre On 21-Nov-08, at 1:45 PM, Brent Baisley wrote: On Fri, Nov 21, 2008 at 12:44 PM, Andre Matos [EMAIL PROTECTED] wrote: Hello, Let's suppose I have 5 database: db1, db2, db3, db4, and db5

Re: SELECT through many databases

On 21-Nov-08, at 12:59 PM, Peter Brawley wrote: Andre Matos wrote: Today I have 5, but tomorrow I can have 50 and I don't want to forget any database. Do it in an app language or as a PREPARED statement in an sproc. PB --- Andre Matos wrote: Hello, Let's suppose I have 5 database: db1, db2

Re: SELECT through many databases

) for splitting data into multiple tables. Because now. the more tables you add, the more of a performance problem it may cause. -- Sincerely yours, Olexandr Melnyk http://omelnyk.net/ On Fri, Nov 21, 2008 at 9:58 PM, Andre Matos [EMAIL PROTECTED] wrote: Thanks everyone for the help. I

Re: Deployment of Database in a DEB package.

Just be aware about the security. I use shell or perl scripts to make automatic dumps (backups) or updates/changes in the database. Unfortunately, because they are automatic scripts, I need to add the username and password inside the scripts and if someone else have access to these scripts

Complex SELECT

for any help. Andre -- Andre Matos [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Complex SELECT

It worked like a charm. Thanks for the help! Andre On 22-Sep-08, at 2:58 PM, Jim Lyons wrote: look at using the group_concat function on OptionalDesc and group by the other fields. On Mon, Sep 22, 2008 at 1:40 PM, Andre Matos [EMAIL PROTECTED] wrote: Hello, I need help with a SQL

InnoDB Transaction and LAST_INSERT_ID()

Hi List, Let's suppose I have these two tables: CREATE TABLE `changes` ( `ID` int(12) unsigned NOT NULL auto_increment, `Key` varchar(25) collate latin1_general_cs NOT NULL default '', `Table` varchar(25) collate latin1_general_cs NOT NULL default '', `Value` text collate

Re: InnoDB Transaction and LAST_INSERT_ID()

. Is there any way to avoid this? What about the mysql_insert_id()? Andre On 11/28/06 7:50 PM, Mike Kruckenberg [EMAIL PROTECTED] wrote: Andre Matos wrote: SET AUTOCOMMIT=0; START TRANSACTION; INSERT INTO staff (`Name`) VALUES ('ABC'); INSERT INTO changes (`Key`, `Table`, `Value`) VALUES

Re: InnoDB Transaction and LAST_INSERT_ID()

will be responsible for writing the audit trail. Thanks again!!! Andre On 11/28/06 9:22 PM, Mike Kruckenberg [EMAIL PROTECTED] wrote: Andre Matos wrote: Thanks Mike. I understand the possible gaps that I might have if I use the ROLLBACK. This is acceptable in my case. What I really want to avoid

Insert and Update together

the information updated. I am trying to avoid writing a php4 program to do this. I am using MySQL 4.1 Thanks for any help. Andre -- Andre Matos [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Insert and Update together

was testing this on was running 4.0.x so I couldn't use it. http://dev.mysql.com/doc/refman/5.0/en/insert.html - Original Message - From: Andre Matos [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Saturday, February 11, 2006 10:54 AM Subject: Insert and Update together

MySQL 4.1.15 or 5.0.15

Hi List, I am current using MySQL 4.1.9 and I want to upgrade it, but which one, 4.1.15 or 5.0.15? Any suggestions? Andre -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Tracking changes in the database

, but the binary.log file was not created. Note: I am using Mac OS X. Andre -- Andre Matos [EMAIL PROTECTED] -Original Message- From: Daniel Kasak [mailto:[EMAIL PROTECTED] Sent: Thursday, October 13, 2005 2:33 AM To: Andre Matos; mysql@lists.mysql.com Subject: Re: Tracking changes

Tracking changes in the database

Hi List, I need to track the changes made in the database using the insert, update and delete statements in MySQL 4.1.9. Can I use the Binary Log to get this information or is there another better solution? Thanks for any help. Andre -- Andre Matos [EMAIL PROTECTED] -- MySQL General

RE: Tracking changes in the database

I am using InnoDB and replication, is there any issues? Thanks. Andre -- Andre Matos [EMAIL PROTECTED] -Original Message- From: Daniel Kasak [mailto:[EMAIL PROTECTED] Sent: Thursday, October 13, 2005 1:01 AM To: Andre Matos; 'mysql@lists.mysql.com ' Subject: Re: Tracking changes

PHP MySQL connection problem

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

Collation latin1_general_cs

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

Re: Collation latin1_general_cs

: At 15:28 -0400 5/2/05, Andre Matos wrote: Hi List, I was checking the list of collations for a character set latin that I have in my MySQL version 4.1.10-standard running on Mac OS X 10.4. Below is the that I have and does not include latin1_general_cs. What will happen if I force to use

Re: Collation latin1_general_cs

/05, Andre Matos wrote: Hi Paul, It does appear in the list, but there is no Yes in the column Compiled and that's why my concern. I am using the Collation latin1_general_cs since I moved from version 3.x to 4.1.10. Is it really working without compiled? Yes. Some character set information

Collation latin1_general_cs

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

Slow access Apache + PHP + MySQL

anyone had this kind of problem or has any suggestion or direction to help me to identify and solve this issue? Any help will be appreciated!!! Thanks. Andre -- Andre Matos [EMAIL PROTECTED] -- Andre Matos [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http

InnoDB and Transactions

in PHP4. My question is: Will the record named B be written in the database or it will be rollback with the record named A? Thanks for any help!!! Andre -- Andre Matos [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Symchronization problem

and where can I check this? Thanks for any help. Andre -- Andre Matos [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: utf8 x latin

- latin2_general_ci - 1byte but I'm having Romanian + English + French columns. Try to read http://dev.mysql.com/doc/mysql/en/charset.html with no distraction arround you ! Gabriel - Original Message - From: Andre Matos [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Sunday, January 30

utf8 x latin

Hi list, I was wondering which one is better to use, utf8_general_ci or latin1_general_cs, with English, French, Portuguese, and Spanish? Thanks. Andre -- Andre Matos [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Server crached problem

access and retrieve my data? Thanks for any help. Andre -- Andre Matos [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Rollback and INSERT_ID() or LAST_INSERT_ID()

the function MAX() to get the last ID inserted. Thanks for any help. Andre -- Andre Matos [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Rollback and INSERT_ID() or LAST_INSERT_ID()

id doesn't get used twice for different records. It's doing everything correctly. -Eric On Mon, 17 Jan 2005 19:06:45 -0500, Andre Matos [EMAIL PROTECTED] wrote: Hi List, I have a field in one of my tables that uses auto-increment from MySQL 4.1.8-nt (Windows XP). My problem is to get

Re: Rollback and INSERT_ID() or LAST_INSERT_ID()

of problem. Thanks a lot for your help. Andre On 1/17/05 9:53 PM, Paul DuBois [EMAIL PROTECTED] wrote: At 21:27 -0500 1/17/05, Andre Matos wrote: Thanks Eric, but I can let it increment because I cannot have a gave in the numbers. I think I will need to use MAX() in this case. Using MAX

Grant question

,INSERT,UPDATE,DELETE ON dbexample*.* TO 'user'@'localhost' BY 'password'; I tried this instruction but did not work. Is someone knows how to do if it is possible? Thanks for any help. Andre -- Andre Matos [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com

MySQL configuration file on Mac OS X

about this? Thanks for any help. Andre -- Andre Matos [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL configuration file on Mac OS X

On 11/29/04 1:55 PM, Michael Stassen [EMAIL PROTECTED] wrote: Mac OS X is Unix, so you follow the directions for Unix, which means you use my.cnf. See the manual for details http://dev.mysql.com/doc/mysql/en/Option_files.html. Michael Andre Matos wrote: Hi List, I installed the MySQL

MySQL 4.1 and PHP5 with old client

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

Re: SELECT question

version. Andre On 9/20/04 5:52 PM, Roger Baklund [EMAIL PROTECTED] wrote: * Andre Matos I am performing a SELECT and I am getting 0 rows when I run the SELECT direct in the MySQL database and getting 1 when I run using PHP. This is my select: SELECT * FROM scan WHERE TimePointID = 3

SELECT question

as a result, and if I use AND I got 0 as a result. Is anyone can tell me what is going on? Thanks in advance for any help. Andre -- Andre Matos [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Scripts

Hi List, Let's suppose that I have a script to create one database (tables, indexes, etc). How can I call another script from this script? For example: DROP DATABASE test; CREATE DATABASE test; (here call another script) back to the previous script Thanks. Andre -- Andre Matos [EMAIL

RE: Scripts - ERROR

Hi, I tried but didn't work. Here is my script: # # @Name : NTT_dbcreator.2004-06-07.v1-001.andre.sql # @DESCRIPTION : NTT Database Creator # @CREATED : Jun 07, 2004 by Andre Matos - [EMAIL PROTECTED

Re: ER Diagrams with mysql

good enough to remember. -- Andre Matos [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Subtracting two Dates and getting days

Hi, How can I subtract two dates and get the number of days? (date1 - date2) = days Thanks. -- Andre Matos [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Subtracting two Dates and getting days - SOLVED

Hi All, I found a function named TO_DAYS that solved my problem. Thanks. Andre On Sun, 23 May 2004, Andre MATOS wrote: Hi, How can I subtract two dates and get the number of days? (date1 - date2) = days Thanks. -- Andre Matos [EMAIL PROTECTED] -- MySQL General Mailing List

Sub-SELECT

-05-14') AND sc.QCResult_ID_Number 1 ORDER BY sc.Site_ID_Number Thanks. Andre -- Andre Matos [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Case Sensitive

server running on Linux? 2) What is better? Disable or enable the others two? By the way, I have the same problem with the usernames and passwords. How can I enable/disable MySQL case sensitive for data? Thanks. Andre -- Andre Matos [EMAIL PROTECTED] -- MySQL General Mailing List For list

SELECT HELP

another table creating the final result. Like this: ((value_from_record_1_from_table_A + value_from_record_15_from_table_A) / value_from_table_B ) + value_from_table_C Is this possible? Is there anyone who can help me to create this SELETC? Thanks. -- Andre Matos [EMAIL PROTECTED] -- MySQL

Re: SELECT HELP

. However I will have different Trials and each one has different formula. That's why I want to put the SELECT to work for me. Thanks Andre On Fri, 30 Apr 2004, Robert J Taylor wrote: Andre MATOS wrote: Hi, Is it possible to create a Select performing a math formula? For example: First I

The MySQL data folder can be an virtual link?

Hi, Is it possible to move the folder data where there are all databases to another hard driver and then create a virtual link using ln -s? If yes, is it just shutdown the MySQL server and then move the folder, create the link and finally start up the server? Thanks! Andre -- Andre Matos

How can I upload dumped data

Hi List, Once I have dumped my database using mysqldump how can I upload the data again using the mysql command line (MySQL in ansi mode)? Thanks. -- Andre Matos [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

How can I upload dumped data (fwd)

Hi List, Once I have dumped my database using mysqldump how can I upload the data again using the mysql command line (MySQL in ansi mode)? Thanks. -- Andre Matos [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: How can I upload dumped data

I tried it, but it didn't work. ERROR 1217 at line 3483: Cannot delete or update a parent row: a foreign key constraint fails I am using InnoDB... that's my problem... Thanks. Andre On Fri, 19 Mar 2004, Egor Egorov wrote: Andre MATOS [EMAIL PROTECTED] wrote: Hi List, Once I have

Re: MySQL Backup advice

, Ware Adams wrote: Andre MATOS wrote: What is the best way to make a good and trustable backup from a live database, in other words, without shutdown the database? Is there any free open source tool for this also? There's no free/open source tool that makes a true hot backup when you're

Re: Client connection error

Pachev wrote: Andre MATOS wrote: Hi, I am trying to connect from one computer that has MySQL installed (client) in another one that also has MySQL (server). Using this command: C:\mysql\binmysql.exe -u root -h server.com -p Enter password: * ERROR 2003: Can't connect to MySQL

MySQL Backup advice

, in other words, without shutdown the database? Is there any free open source tool for this also? Thanks. Andre -- Andre Matos [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Inserting and Grant users

into all databases instead of just have the rights to select in the database2. What I did was correct or it is missing something? Best Regards, Andre -- Andre Matos [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

MySQL speed problem

that can help to set up a good MySQL environment, because I will hold a lot of data in near future. Thanks. -- Andre Matos [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Inserting and Grant users

On Tue, 2 Mar 2004, Michael Stassen wrote: Andre MATOS wrote: Hi, I insert a new user to access the MySQL database. I have 4 databases plus the mysql database. I want that this user can run the select instruction just into one database, so I did this: [prompt]$ mysql u root

Client connection error

also using Apache+PHP and it is working withou problem. Does anyone know what is the problem? Thanks a lot. -- Andre Matos [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Join two tables with Select

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

Database user access

Hi, Is it possible to allow one user to access MySQL using for example PHP but stop him when he tried to access MySQL directly? Thanks -- Andre Matos [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Database user access

Hi, Is it possible to allow one user to access MySQL using for example PHP but stop him when he tried to access MySQL directly? Thanks -- Andre Matos [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Field name length

Hi, Is there any length limit for the field name or it is not good to define a field name like my_field_name_is_this_size_plus_a_little_bit_more ? Thanks. -- Andre Matos [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Privileges

Hi List, Is it possible to GRANT an USER to just UPDATE one specific FIELD instead of the entire TABLE? Is it also possible to create a GROUP with all GRANTs and then create the USERs linked with a specific GROUP? Thanks. -- Andre Matos [EMAIL PROTECTED] -- MySQL General Mailing List

Record only readable

else can change the value again. The people can still look it, but just look. If it is not possible to make readable the fields, is it possible the whole record? Is this possible to do in MySQL? If it is, how can I do it and which version of MySQL should I use? Thanks. -- Andre Matos [EMAIL