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 wrote: > ​Hi again, > > I have enabled innodb_file_per_table (Its value is on). > I don't

Collate issue

ds are created using 'latin1_swedish_ci', 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 fo

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 an

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

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

umber 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 unsub

Re: SELECT through many databases

(if there's any) 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

Re: SELECT through many databases

al Message----- From: Andre Matos [mailto:[EMAIL PROTECTED] Sent: Friday, November 21, 2008 2:11 PM To: [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Subject: Re: SELECT through many databases I was trying to avoid both since the SELECT statement is not fixed. Time to time, users want different informat

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, d

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 databa

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 li

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

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

Complex SELECT

ot; as showed in the first table above? 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: InnoDB Transaction and LAST_INSERT_ID()

ch 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

Re: InnoDB Transaction and LAST_INSERT_ID()

hould have "1" but I got "2" instead. This happened because of LAST_INSERT_ID() used the ID from the "changes" table instead of the desired "staff" table. Is there any way to avoid this? What about the mysql_insert_id()? Andre On 11/28/06 7:50 PM, "Mi

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 latin1_general_c

Re: Insert and Update together

plicate key update set x=2,y=5; > > unfortunately, the server I 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" &l

Insert and Update together

into a log table including 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:

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

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

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

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]

Re: Collation latin1_general_cs

; <[EMAIL PROTECTED]> wrote: > At 16:15 -0400 5/2/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_gene

Re: Collation latin1_general_cs

PM, "Paul DuBois" <[EMAIL PROTECTED]> wrote: > 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 O

Collation latin1_general_cs

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

Collation latin1_general_cs

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

Slow access Apache + PHP + MySQL

, or PHP. Does 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

InnoDB and Transactions

; -- rollback - close the connection "1" This sequence will be written 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]

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

thought and aditional computation I declared myself satisfied > with: > latin2 - ISO 8859-2 Central European - 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 &

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/

Server crached problem

e? How can I 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]

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

Re: Rollback and INSERT_ID() or LAST_INSERT_ID()

y ot > insuring that the same 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

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]

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 ar

Re: MySQL configuration file on Mac OS X

ks. Andre 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>. > > Mic

MySQL configuration file on Mac OS X

c OS X. Does anyone knows 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]

MySQL 4.1 and PHP5 with old client

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

use OR using the PHP, I got 1 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:

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 PROT

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 [

Re: ER Diagrams with mysql

can feed it SQL scripts, but it seems like a logical function for it to > have. I haven't used it for quite some time... > > It's not free. I don't know of any free ER tools. Or at least none I've > found and investigated were 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]

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 PROT

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]

Sub-SELECT

te_ID_Number AND sc.TimePoint_ID_Number = tp.TimePoint_ID_Number AND sc.TimePoint_ID_Number = 8 AND (sc.Scan_Receipt_On >= '2004-05-10' AND sc.Scan_Receipt_On <= '2004-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

Re: SELECT HELP

here the "TimePoint" = 9 C is a value find from the field "TrialBaseValue" from table "Trial" This is easy to do using the PHP language. However I will have different Trials and each one has different "formula". That's why I want to put the SELECT to

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

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

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

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

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

Re: MySQL Backup advice

On Wed, 3 Mar 2004, 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

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]

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\bin>mysql.exe -u root -h server.com -p >

Client connection error

60) However I am 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]

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

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]

Inserting and Grant users

, I still can see the others database and a can insert, update and delete records 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 Ma

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 u

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