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: Запрос

Hello Johan, Sorry guys, that's just because I've seen familiar letters :-). the topic starter asked how he can "quit from this application". and I asked, from which application he wants to quit. That's all :-). -- With best regards from Ukraine, Andre Skype:

Re: Запрос

Hello Виктор, Из какого приложения?) -- With best regards from Ukraine, Andre Skype: Francophile My blog: http://oire.org/menelion (mostly in Russian) Twitter: http://twitter.com/m_elensule Facebook: http://facebook.com/menelion Original message From: Виктор Ефимович

Re: LEFT JOIN and WHERE: identical or not and what is better?, etc.

Hello Halбsz, Aha. So, I should write SELECT `Blogs`.* INNER JOIN `Users` ON `Users`.`Id`=`Blogs`.`UserId` instead of my original WHERE clause? Thanks! -- With best regards from Ukraine, Andre Skype: Francophile My blog: http://oire.org/menelion (mostly in Russian) Twitter: http

LEFT JOIN and WHERE: identical or not and what is better?

, more kosher, I mean, better style...)? Thanks! -- With best regards from Ukraine, Andre Skype: Francophile Twitter: http://twitter.com/m_elensule Facebook: http://facebook.com/menelion -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Changing the timezone

ASE='utf8'") or die ("Unable to change database charset: ".mysql_error()); and a mysql_query("SET NAMES 'utf8'") or die ("Unable to set names: ".mysql_error()); Maybe is there a way to change my timezone to Europe/Kiev? Thank you! --

Re: Insert only if the entry doesn't exist

Hello Rolando, So if I do "INSERT IGNORE INTO `Votes` SET `EntryId`='12345', UserId`='789'"; it *won't* insert the second row if there's a row with EntryId set to 12345 and UserId set to 789? Thanks and sorry!) -- With best regards from Ukraine

Re: Insert only if the entry doesn't exist

Hello Rolando, Sorry, but if I do INSERT IGNORE INTO, then I must indicate a key (typically a unique key or a primary key), or is it false? But I don't know that key and no way to get it without more queries... -- With best regards from Ukraine, Andre Skype: Francophile My blog:

Insert only if the entry doesn't exist

And here is the question (at last!): How can I MySql'ly check whether a vote does exist and if it does, then insert the row, else either do nothing or update several columns? I assume I can't use ON DUPLICATE KEY UPDATE because I have no unique keys... Hope you understood my

Simplify 4 queries into 1

s? If I do "SELECT * FROM `CandidateQuestions` WHERE `Category` IN (1,2,3,4) GROUP BY `Category` LIMIT 4", I think i would get 4 random questions, wouldn't I? Thanks in advance! -- With best regards from Ukraine, Andre Skype: Francophile Twitter: http://twitter.com/

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

ERGE table as suggested here in the list. I am not allowed to. That's why I was thinking to use only a SELECT statement to do the job as I have been doing. Thanks, Andre On 21-Nov-08, at 3:16 PM, Olexandr Melnyk wrote: Hello Andre, I would recommend you to rethink your criteria

Re: SELECT through many databases

Thanks everyone for the help. I was trying to use any API (e.g. PHP, Java, etc). I just gave up because unfortunately the time fly and the user needs this asap. I am doing via script. Thanks! Andre On 21-Nov-08, at 2:34 PM, Jerry Schwartz wrote: "Many MySQL APIs (such as PHP) allo

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

FROM db4 WHERE TaskDoneOn IS NOT NULL UNION SELECT TaskDoneOn, TaskDoneBy FROM db5 WHERE TaskDoneOn IS NOT NULL Today I have 5, but tomorrow I can have 50 and I don't want to forget any database. Thanks for any help. Andre -- MySQL General Mailing List For list arch

Re: Deployment of Database in a DEB package.

(e.g., read access), he/she will see this information. Andre On 2-Oct-08, at 11:57 AM, Heston James - Cold Beans wrote: Dave, This looks like a perfect solution. We can indeed use a shell script for the task in hand and knowing that we an action the .sql script so simply from the

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]

mysql.time_zone_name

Hi List, user wants to do: SELECT COUNT(*) FROM mysql.time_zone_name; problem ist that this table in mysql is empty. I dont know how to fill with data. I tried on testmachine with mysql_install_db but it leaves empty. Where to get sql-data to fill these tables in mysql-db? Thank you Andre

Re: external mysqldump

hmm, i cannot do anything what let users see others data. if there is no possibility then external dumps/inserts of routines using mysqldump/mysql cannot be offered. so routines must separate installed using phpmyadmin over local connect... not satisfying... Thanks for help Andre

Re: external mysqldump

i tried, but always got error: "ERROR 1221 (HY000): Incorrect usage of DB GRANT and GLOBAL PRIVILEGES" i followed this and did found a former discussion. seems to be not possible to give this privileg by this line. http://lists.mysql.com/mysql/198421 hmm, bad case, isnt

Re: external mysqldump

. - Original Message - From: "Ben Clewett" <[EMAIL PROTECTED]> To: "Andre Hübner" <[EMAIL PROTECTED]> Cc: Sent: Wednesday, February 20, 2008 10:26 AM Subject: Re: external mysqldump I use a specific user (backup) for my backups, therefore user privileges are n

Re: external mysqldump

Thank you for answering. is there a way to do without granting super-privileg? for security reasons i cannot grant too high privileges for normal db-users. rights should be limited to own db. Thanks Andre - Original Message - From: "Ben Clewett" <[EMAIL PROTECTED]> T

external mysqldump

o SHOW CREATE FUNCTION `countuser`! It works if i do the same mysqldumLine directly on the server where db is installed. In mysql-table myuser has same privileges for % and locklhost. Are there some further restrictions for external connects? I dont have an idea what to change now. Th

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

about many users doing at the same time. Does the LAST_INSERT_ID() get the correct ID for each user? Is there a better way to do this or this is fine? I will be using this with PHP4. Thanks for any help. Andre -- 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

No George. I took a look there before sent this email to the mysql list. My case it is not a duplicate record. What I want is that if the update in one table happen, it will be proceed by an insert in another table like a log of changes. Andre On 2/11/06 12:48 PM, "George Law" <[EM

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 newb trying to write a trigger...

SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 17 (16 ms taken) Regards, Andre Turpin Sysadmin, New North Networks Inuvik, NT, CA

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

.2 (it was working up to version 2.6.1-pl3), and I found this: "Do not offer unavailable collations". Does this means that if the MySQL is not compiled with the "latin1_general_cs" it will not work even if MySQL loaded it at runtime? Andre On 5/2/05 4:44 PM, "Paul DuBois"

Re: Collation latin1_general_cs

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? Andre On 5/2/05 4:04

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

Thanks for your help Gabriel. I will use the latin1 with case sensitive. Andre On 1/31/05 7:32 AM, "Gabriel PREDA" <[EMAIL PROTECTED]> wrote: > I think you should use: latin1_general_ci and on columns with spanish you > should use latin1_spanish_ci. > > Eng

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

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. Thanks. Andre On 1/17/05 8:14 PM, "Eric Bergen" <[EMAIL PROTECTED]> wrote: > Just let it increment. Keeping it incremented is MySQL's wa

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

I just have finished to install the version 4.1.7 on my Mac and I looked at these directories below and I couldn't find the file "my.cnf" as described on the like that you gave me: /etc/my.cnf DATADIR/my.cnf ~/.my.cnf Do I need to create it or MySQL is suppose to do the job? Than

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

SWORD? I tried to insert: [mysqld] --old-passwords and [mysqld] old-passwords but both didn't work. Does anybody know how to do this? Is any other better way to make PHP5 work with the new password format without recompiling (It is easy on Linux/Unix but not on Windows XP). Thanks for a

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:

Restoring dump file problem

m using MySQL 4.0.18-standard with InnoDB on Mac OS X 10.3.5. Is there any issue related a dumped file size? 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: 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

Hi, Have you tried DBDesigner4? Take a look, it's an OpenSource. http://www.fabforce.net/dbdesigner4/ Andre On Tue, 6 Jul 2004, Daniel Kasak wrote: > Leandro Melo wrote: > > >Hi, > >i created a database with around 20 tables. However i > >created the tables

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

pdate one field from table Y, MySQL save all the information about this change. So, If something happens after the backup, we can recover the database without go back and perform again the insert and the update? If "yes", where can I find documentation about this? Thansk a lot. Andre

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

Hi Sasha, after I sent this email for the list, I did some tests and I realized that the problem could be my firewall, so I just turned off for some tests and it worked. Now I need to reconfigure the firewall to permit access for the MySQL. Thanks a lot. Andre On Tue, 2 Mar 2004, Sasha

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

problem

i have a follow problem, please, help-me [EMAIL PROTECTED] db]# mysql --user=root --password=xx ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) -- *** Carlos Andre Moura

Re: Problem Installation

mic client libraries > (including 3.23.x libraries)". You can find them on > http://www.mysql.com/downloads/mysql-4.0.html > > Best regards, > Mikhail. > > > - Original Message - > From: "Carlos Andre Moura de Amorim" <[EMAIL PROTECTED]>

Problem Installation

I have red hat 9.0, i don't to install mysql RPM appear: erro: Failed dependencies: libmysqlclient.so.10 is needed by perl-DBD-MySQL-2.1021-3 Please Help me!! -- *** Carlos Andre Moura de A

mysqldump

I have problem with mysqldump. This query results an error. mysqldump danamon [trx_temp2] > trx_temp2.sql The error message is : mysqldump : Can't get CREATE TABLE for table '[trx_temp2]' I'm sure the trx_temp2 table in danamon database exists. I'm running MySQL 4.0.13 ___

row-level locking question...

t read the value v2 to put an exclusive lock on that row. But I don't really need the value of v2, I just need to lock it down. Is the above approach the way to go or is there a more elegant/correct way of doing this? Thanks. -- Andre Charbonneau -- MySQL General Mailing List For list

Convert date from .txt file

How do you convert a date dd/mm/ from a .txt file into mysql date format when using LOAD DATA INFILE ? __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- MySQL General Mailing List For list archiv

Full /tmp directory

308109312 Jun 30 20:08 #sql343_2ed63d_0.MYD -rw-rw1 mysqlmysql1024 Jun 30 18:56 #sql343_2ed63d_0.MYI (RedHat 7.3 with rpm mysql 3.23.56-1.72) --- Lars Andre

sub select

Hi, I've just downloaded the version 4.1. I tryed to run my first sub-select : SELECT curso.* FROM curso where curso.cdCurso IN (SELECT EstabMantemCurso.cdCurso FROM EstabMantemCurso) The following ERROR returned: [local] ERROR 1235: This version of MySQL doesn't yet support 'LIMIT &

CAUTION! ALERT! WARNING! Newbie on board :)

not accepting data in the rows? 3) what else might you suggest? Thanks! Andre p.s. This is the only type of info that varies between the installations of php scripts to access mysql server on my local machine vs mysql at my web host: $url = "http://www.economicbooster.com";;

file "mysql.sock"

Hi folk! I would like to know how to create a new file "mysql.sock", because it was deleted of "/tmp" and i perceive that it don't was in the binary file tar.gz. Thanks for reply! -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://list

Problem with ADO, MyOLEDB and BigInt columns

this? Thanks in advance, Andre M. Descombes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTEC

Questions about indexes

Hi, is it possible in the mySQL to have an index that none of the values could be repeated except for a single value that could be repeated? The values of the column would be something like this '123' '245' '233' 'XXX' 'XXX' '027'

Re: How to query a varchar column's value staring with a string?

Hi there, I found a way to do it with the following query select * from theTable where 'test' like concat( theColumn, '%' ); Thanks for the help, Andre --- Andre Kirchner <[EMAIL PROTECTED]> wrote: > thanks for the help, but what I really want is to >

Re: How to query a varchar column's value staring with a string?

;; I think my previous email as a litle bit confusing. Sorry for that :-) Andre --- Jennifer Goodie <[EMAIL PROTECTED]> wrote: > select * from theTable where theColumn like 'test%'; > or > select * from theTable where LEFT(theColumn,4) = > 'test'; > >

How to query a varchar column's value staring with a string?

Hi there, how can I query all the values starting with 'test'? I tried the following query, but it didn't work select * from theTable where ( ( theColumn || '%' ) like 'test' ); Thanks, Andre mySQL __ Do yo

  1   2   >