Select through characters
Hello list I have a list of names with english and greek characters. How can select them separately? I mean, only greeks or only english. thank you, Nikos
Re: Select through characters [SOLVED]
I find a solution that works: SELECT writer_id, writer FROM writer WHERE writer REGEXP '^[A-Z]+' ORDER BY writer Thank you all Nikos misiaQ wrote: Hi, If the efficiency is the key factor I would suggest to create a trigger on insert and update and mark the rows in a separate column instead of executing some fancy string checks during select. Regards, m. -Original Message- From: nikos [mailto:ni...@qbit.gr] Sent: 19 November 2009 08:41 To: mysql@lists.mysql.com Subject: Select through characters Hello list I have a list of names with english and greek characters. How can select them separately? I mean, only greeks or only english. thank you, Nikos -- Wst?p do Klubu Gracza, wygraj telefon! Sprawdz http://link.interia.pl/f243a
full text search on multiple tables
Hello list I have to make a full text search and I want to do it in many tables. I have deferent tables for books authors and news. Any ideas how to do it? Thank you Nikos
Re: full text search on multiple tables
That is a grate solution. The problem is that I must have deferent links for each response. That's the tricky thing! Thank you Sebastian Mendel wrote: nikos schrieb: Hello list I have to make a full text search and I want to do it in many tables. I have deferent tables for books authors and news. Any ideas how to do it? three separate queries or an UNION
select first letters
Hello list. I want to select discinct the first letters of titles in a UTF8 table but only the greek ones. There are both english and greek charakter titles. How can I exclude the english from selection? My table is: CREATE TABLE `odigos_details` ( `id` int(11) NOT NULL auto_increment, `cat` tinyint(3) default NULL, `territory` tinyint(3) default NULL, `title` varchar(150) default NULL, `story` text, `link` varchar(100) default NULL, `address` varchar(150) default NULL, `tel` varchar(50) default NULL, `fax` varchar(11) default NULL, `photo` varchar(100) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 and I run: SELECT DISTINCT LEFT(title,1) FROM odigos_details ORDER BY title witch is working fine. Thank you. Nikos
Re: select first letters
Seems that work in v. 4.1.21 but not in 5.0.27 Thank you Dusan Dus(an Pavlica wrote: I'm not sure, but I think that greek characters are sorted after English chars so try this: SELECT DISTINCT LEFT(title,1) FROM odigos_details WHERE LEFT(title,1) 'z' ORDER BY title HTH, Dusan nikos napsal(a): Hello list. I want to select discinct the first letters of titles in a UTF8 table but only the greek ones. There are both english and greek charakter titles. How can I exclude the english from selection? My table is: CREATE TABLE `odigos_details` ( `id` int(11) NOT NULL auto_increment, `cat` tinyint(3) default NULL, `territory` tinyint(3) default NULL, `title` varchar(150) default NULL, `story` text, `link` varchar(100) default NULL, `address` varchar(150) default NULL, `tel` varchar(50) default NULL, `fax` varchar(11) default NULL, `photo` varchar(100) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 and I run: SELECT DISTINCT LEFT(title,1) FROM odigos_details ORDER BY title witch is working fine. Thank you. Nikos
Re: select first letters
It was my first thought Jerry, but it didn't work to me... Thanks anyway! Jerry Schwartz wrote: Aren't all of the Greek characters distinct from all of the English characters? If so, you could test just the first letter of the field against an IN condition, where the IN (...) lists all of the Greek characters. If it's easier to type, you could use a NOT IN (...) test and list the English letters. The former would be safer, just to guard against the possibility that some non-Greek Latin characters have crept in. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: nikos [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 25, 2007 9:28 AM To: mysql@lists.mysql.com Subject: select first letters Hello list. I want to select discinct the first letters of titles in a UTF8 table but only the greek ones. There are both english and greek charakter titles. How can I exclude the english from selection? My table is: CREATE TABLE `odigos_details` ( `id` int(11) NOT NULL auto_increment, `cat` tinyint(3) default NULL, `territory` tinyint(3) default NULL, `title` varchar(150) default NULL, `story` text, `link` varchar(100) default NULL, `address` varchar(150) default NULL, `tel` varchar(50) default NULL, `fax` varchar(11) default NULL, `photo` varchar(100) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 and I run: SELECT DISTINCT LEFT(title,1) FROM odigos_details ORDER BY title witch is working fine. Thank you. Nikos
Re: select first letters
Jerry do you know if there is a php command that returns ascci number of a letter? I'll want to use chr() command because I want to transfer via link the letter to next page but greek characters transformed to something like %CE%9C. Thank you Jerry Schwartz wrote: It would depend upon the collating sequence for the field. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: nikos [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 25, 2007 10:07 AM To: Dus(an Pavlica; mysql@lists.mysql.com Subject: Re: select first letters Seems that work in v. 4.1.21 but not in 5.0.27 Thank you Dusan Dus(an Pavlica wrote: I'm not sure, but I think that greek characters are sorted after English chars so try this: SELECT DISTINCT LEFT(title,1) FROM odigos_details WHERE LEFT(title,1) 'z' ORDER BY title HTH, Dusan nikos napsal(a): Hello list. I want to select discinct the first letters of titles in a UTF8 table but only the greek ones. There are both english and greek charakter titles. How can I exclude the english from selection? My table is: CREATE TABLE `odigos_details` ( `id` int(11) NOT NULL auto_increment, `cat` tinyint(3) default NULL, `territory` tinyint(3) default NULL, `title` varchar(150) default NULL, `story` text, `link` varchar(100) default NULL, `address` varchar(150) default NULL, `tel` varchar(50) default NULL, `fax` varchar(11) default NULL, `photo` varchar(100) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 and I run: SELECT DISTINCT LEFT(title,1) FROM odigos_details ORDER BY title witch is working fine. Thank you. Nikos
Re: select first letters
Finaly I use ord(). Thank you. Jerry Schwartz wrote: The multi-byte extension doesn't seem to include one, but it appears that somebody put one together and posted it in the notes on chr(). http://us2.php.net/manual/en/function.chr.php#69082 Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 *From:* nikos [mailto:[EMAIL PROTECTED] *Sent:* Wednesday, April 25, 2007 11:41 AM *To:* Jerry Schwartz; mysql@lists.mysql.com *Subject:* Re: select first letters Jerry do you know if there is a php command that returns ascci number of a letter? I'll want to use chr() command because I want to transfer via link the letter to next page but greek characters transformed to something like %CE%9C. Thank you Jerry Schwartz wrote: It would depend upon the collating sequence for the field. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: nikos [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 25, 2007 10:07 AM To: Dus(an Pavlica; mysql@lists.mysql.com Subject: Re: select first letters Seems that work in v. 4.1.21 but not in 5.0.27 Thank you Dusan Dus(an Pavlica wrote: I'm not sure, but I think that greek characters are sorted after English chars so try this: SELECT DISTINCT LEFT(title,1) FROM odigos_details WHERE LEFT(title,1) 'z' ORDER BY title HTH, Dusan nikos napsal(a): Hello list. I want to select discinct the first letters of titles in a UTF8 table but only the greek ones. There are both english and greek charakter titles. How can I exclude the english from selection? My table is: CREATE TABLE `odigos_details` ( `id` int(11) NOT NULL auto_increment, `cat` tinyint(3) default NULL, `territory` tinyint(3) default NULL, `title` varchar(150) default NULL, `story` text, `link` varchar(100) default NULL, `address` varchar(150) default NULL, `tel` varchar(50) default NULL, `fax` varchar(11) default NULL, `photo` varchar(100) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 and I run: SELECT DISTINCT LEFT(title,1) FROM odigos_details ORDER BY title witch is working fine. Thank you. Nikos
about limit
Hello list. Does any body knows how to select not the LIMIT 20 records but the rest of them? MySQL version is 4.1.21-standard and I cant make a VIEW. Thank you Nikos -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: about limit
Hmm! Clever! Thanx Rolando Edwards wrote: SELECT ... FROM ... LIMIT 20,1; 100 million is a little exaggeration but you can other reasonably high numbers. Remember, LIMITs are zero-based not 1-based. - Original Message - From: nikos [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Tuesday, March 20, 2007 12:50:49 PM (GMT-0500) Auto-Detected Subject: about limit Hello list. Does any body knows how to select not the LIMIT 20 records but the rest of them? MySQL version is 4.1.21-standard and I cant make a VIEW. Thank you Nikos -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Function problem
Thank you for you answer. I try your suggestion but I'm getting the followin error: Error Code : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'return ceil(x+x*0.25) when x=50 AND x100 then ceiling(x+x*0.20) when x=100 ' at line 3. The full syntax is: DELIMITER $$ DROP FUNCTION IF EXISTS `qbit`.`myprice_xondr`$$ CREATE FUNCTION `qbit`.`myprice_xondr`(x float(7,2)) RETURNS DECIMAL BEGIN CASE x WHEN (x50) THEN return ceil(x+x*0.25) when x=50 AND x100 then ceiling(x+x*0.20) when x=100 AND x150 then ceiling(x+x*0.15) when (x=150 AND x200) then (ceiling(x+x*0.10)) when (x=200) then (ceiling(x+x*0.09)) end case; END$$ DELIMITER ; -Original Message- From: Chris White [mailto:[EMAIL PROTECTED] Sent: Thursday, December 07, 2006 6:02 PM To: mysql@lists.mysql.com Subject: Re: Function problem On Thursday 07 December 2006 04:57, nikos wrote: WHEN x50 THEN ceiling(x+x*0.25) when x=50 AND x100 then ceiling(x+x*0.20) when x=100 AND x150 then ceiling(x+x*0.15) when (x=150 AND x200) then (ceiling(x+x*0.10)) when (x=200) then (ceiling(x+x*0.09)) You've declared a return value for your function, but it doesn't return anything, what you probably want is: WHEN x50 THEN return ceiling(x+x*0.25) and the like for the rest of the cases. -- Chris White PHP Programmer Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Function problem
Hello list. Can somebody tells what's wrong with this fuction? DELIMITER $$ DROP FUNCTION IF EXISTS `qbit`.`myprice_xondr`$$ CREATE FUNCTION `qbit`.`myprice_xondr`(x float(7,2)) RETURNS float(7,2) BEGIN CASE x WHEN x50 THEN ceiling(x+x*0.25) when x=50 AND x100 then ceiling(x+x*0.20) when x=100 AND x150 then ceiling(x+x*0.15) when (x=150 AND x200) then (ceiling(x+x*0.10)) when (x=200) then (ceiling(x+x*0.09)) end case; END$$ DELIMITER ; Thanx Nikos
character_set_client in v4.1
Hello list I've just install v4.1. Every thing works fine exept SQLyong shows all non-latin characters as question marks and the old Mysql-Front can't connect with tables after mysql_fix_privilege_tables. How can I change character_set_client=greek or UTF8 than to latin? I thing this will solve my problem Is that right? Thank you -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
character_set_client in v4.1
Hello list I've just install v4.1. Every thing works fine exept SQLyong shows all non-latin characters as question marks and the old Mysql-Front can't connect with tables after mysql_fix_privilege_tables. How can I change character_set_client=greek than to latin? I thing this will solve my problem Is that right? Thank you -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Access 2002 hangs with MyODBC 3.51.11
Dear sir Thank you for your answer. You help me much. I replace msjet40.dll with an oldest from ServicePackFiles/ and works fine -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 18, 2005 7:12 PM To: mysql@lists.mysql.com Subject: Fw: Access 2002 hangs with MyODBC 3.51.11 The attachment was stripped by the list manager: forwarded to list for general information Shawn - Forwarded by Shawn Green/Unimin on 10/18/2005 12:07 PM - Shawn Green/Unimin 10/18/2005 11:48 AM To nikos [EMAIL PROTECTED] cc mysql@lists.mysql.com Subject Re: Access 2002 hangs with MyODBC 3.51.11 nikos [EMAIL PROTECTED] wrote on 10/18/2005 10:58:51 AM: Hello list I recently update my Access 2002 with Office SP3 (Access 10.6501...) and all connections with MySQL through MyODBC 3.51.11 have problems I install the Access on a pc without updating and the driver works fine. This version of Access is 10.25... something. I download again MyODBC driver but I get the same problem: access still hangs up. In the event viewer there is the following problem: Faulting application msaccess.exe, version 10.0.6501.0, faulting module msjet40.dll, version 4.0.9025.0, fault address 0x000e9f60. Does any body know what's the problem? Thank you Nikos Microsoft distributed a security hotfix, updating MSJET40.DLL to version 4.0.9025.0, which broke every version of MyODBC I test with (I have gone back as far as 3.51.2). Actually, AFAIK, it may only break the process of creating linked tables from MS Access. All other functions may remain functional. However, that's primarily what my users need the library to do, so for me it's broken. Related MySQL bug reports: http://bugs.mysql.com/bug.php?id=9932 http://bugs.mysql.com/bug.php?id=11698 http://bugs.mysql.com/bug.php?id=12386 Workaround: On each affected user's machine, replace newer MSJET40.DLL with previous version (4.0.8618.0), attached. (attachment probably stripped during list distribution). This effectively undoes part of the security hotfix but restores the ability to create and repair table links from MS Access through MyODBC to MySQL. Due to Microsoft's file protection system (FPS), you have to replace the backup version first. The backup can be in an i386 folder, a DLLCACHE folder or in several other possible places (depending on the version of the OS and how FPS has been configured). After you make sure that MS Access is turned off, you can replace the main version in the SYSTEM32 folder. Check the version tab in the properties of each file after you make the copy to make sure your intended changes have taken effect. [attachment msjet40.dll deleted by Shawn Green/Unimin] Last I heard, MySQL was still working on a full fix for the problem. Shawn Green Database Administrator Unimin Corporation - Spruce Pine -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Access 2002 hangs with MyODBC 3.51.11
Hello list I recently update my Access 2002 with Office SP3 (Access 10.6501...) and all connections with MySQL through MyODBC 3.51.11 have problems I install the Access on a pc without updating and the driver works fine. This version of Access is 10.25... something. I download again MyODBC driver but I get the same problem: access still hangs up. In the event viewer there is the following problem: Faulting application msaccess.exe, version 10.0.6501.0, faulting module msjet40.dll, version 4.0.9025.0, fault address 0x000e9f60. Does any body know what's the problem? Thank you Nikos -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Got error 127 when reading table cat
Hello list Can somebody infor me what is the Got error 127 when reading table cat? Thank you Nikos -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Got error 127 when reading table cat
Ok, I get it... Thanx everybody.. _ Qbit Γατσής Νίκος - Gatsis Nikos Web developer tel.: 2108256721 - 2108256722 fax: 2108256712 email: [EMAIL PROTECTED] http://www.qbit.gr -Original Message- From: Jay Blanchard [mailto:[EMAIL PROTECTED] Sent: Thursday, June 30, 2005 2:44 PM To: nikos; mysql@lists.mysql.com Subject: RE: Got error 127 when reading table cat [snip] Can somebody infor me what is the Got error 127 when reading table cat? [/snip] It means the table is crashed. See http://dev.mysql.com/doc/mysql/en/repair.html for how to repair the table. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MyODBC 3.5.9 and MySQL 4.1.8
Hello list and happy new year. Recently I've install mysql 4.1 on win 2000 with IIS 5 and works perfect. My problem is that when i'm trying to make a connection with myodbc (latest release) as localhost I got the following message: Client does not support authentication protocol requestet by server. Consider upgrading mysql client. MyODBC whorks fine because I 've allready make connection throw lan on a Linux RH-9 with apache and mysql 4.0.22 Any suggestions? Thanky you -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Replication options.
Hi again, i have one DB called MY_DATABASE and one table called CUSTOMERS. What I want is to backup the table customers in another machine in a new database called MY_DATABASE but the issue is that I want the table to renamed to CUSTOMERS1 Which means LOCAL MACHINE - MY_DATABASE - CUSTOMERS will be copied to a slave machine, remotely REMOTE MACHINE - MY_DATABASE - CUSTOMERS1 can you please tell me what options i have to add in my.ini to do this? Of course I want to exclude all others tables and update only CUSTOMERS table. Thanks
2 questions about Replication
Hello, i have 2 questions about Replication. 1) I managed to make one slave and one master. The replication works fine and it updates only one table from one database (cause of the replicate-do-table=db.table1). The first question is can I tell mysql that table1 from master to be named table2 on slave? I already have another table1 and I dont want to overwrite it. 2) As far as I read I can have as many slaves as I want and one master. Can I have the opposite? Imagine the follow scenario: I have 3 Shops with 3 Database (same structure) and they all contain a table CUSTOMERS. I want to put all those customers from 3 shops to a central database. So, I was thinking to inverse the master/slave logic and backup each shop to the slave computer. Thats why I need to change the name of table. Because i want to backup customers of first shop to CUSTOMERS1, customers of second shop to CUSTOMERS2 etc etc. Your comments are welcomed. Thanks
Re: [mysql-php] mysqlimport error
is that a problem? I want to avoid ftp db.txt files and then mysqlimport them - Original Message - From: Egor Egorov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 02, 2004 4:38 PM Subject: Re: [mysql-php] mysqlimport error nikos [EMAIL PROTECTED] wrote: I'm trying mysqlimport --local -d --fields-enclosed-by=| --fields-terminated-by=; - -lines-terminted-by=\n -unikos -p mydb c://temp//programs.txt but i get an Error: File 'c:/temp/programs.txt' not found (Errcode: 2), when using table: programs What I'm doing wrong? RH-9 - APACHE v2 - mysql 3.23.54 Looks like you run mysqlimport on the server host but file is located on Windows box. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[mysql-php] mysqlimport error
Hello list I'm trying mysqlimport --local -d --fields-enclosed-by=| --fields-terminated-by=; - -lines-terminted-by=\n -unikos -p mydb c://temp//programs.txt but i get an Error: File 'c:/temp/programs.txt' not found (Errcode: 2), when using table: programs What I'm doing wrong? RH-9 - APACHE v2 - mysql 3.23.54 Thanx -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Administrator
Hello list I have download the MySQL Administrator twice and when trying to gzip It collapse. Does anybody know how and why? Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL 4.1 Installation
Hello list I'm trying to install MySQL-server-4.1.1-1.i386.rpm on a RH-8 Linux. System after systme check says than need LIBMYSQLCLIENT.SO.10 file to continue. Can somebody help me with this situation please? Thanx in advance Nikos -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [PHP-DB] TABLE_PRIV
And the columns: Grantor, Timestamp Table_priv, Column_priv what is up to? Thanx again - Original Message - From: Victor Pendleton [EMAIL PROTECTED] To: 'Nikos Gatsis' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, November 17, 2003 3:37 PM Subject: RE: [PHP-DB] TABLE_PRIV table_privs is going to assign privileges at the individual table level grant select on database.tablename to user@'192.168.0.10' IDENTIFIED BY 'password' -Original Message- From: Nikos Gatsis [mailto:[EMAIL PROTECTED] Sent: Monday, November 17, 2003 7:20 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] TABLE_PRIV Hello List. Does anybody knows how to configure table_priv table of Mysql? I didn't find something in manual I have v. 3.23.41 in Linux Thanx Nikos -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [PHP-DB] TABLE_PRIV
ok thanx - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: Nikos Gatsis [EMAIL PROTECTED]; Victor Pendleton [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, November 19, 2003 2:58 AM Subject: Re: [PHP-DB] TABLE_PRIV At 9:02 +0200 11/18/03, Nikos Gatsis wrote: And the columns: Grantor, Timestamp Table_priv, Column_priv what is up to? Ignore the Grantor and Timestamp columns. They're not used. Thanx again - Original Message - From: Victor Pendleton [EMAIL PROTECTED] To: 'Nikos Gatsis' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, November 17, 2003 3:37 PM Subject: RE: [PHP-DB] TABLE_PRIV table_privs is going to assign privileges at the individual table level grant select on database.tablename to user@'192.168.0.10' IDENTIFIED BY 'password' -Original Message- From: Nikos Gatsis [mailto:[EMAIL PROTECTED] Sent: Monday, November 17, 2003 7:20 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] TABLE_PRIV Hello List. Does anybody knows how to configure table_priv table of Mysql? I didn't find something in manual I have v. 3.23.41 in Linux Thanx Nikos -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[PHP-DB] TABLE_PRIV
Hello List. Does anybody knows how to configure table_priv table of Mysql? I didn't find something in manual I have v. 3.23.41 in Linux Thanx Nikos -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
compare db's
GlacierHello list I have 2 mysql databases. The first is on the internet (under RH linux 7,2). The second is on a local network (under RH linux 7,2 also). The two databases have some common tables and I wish to compare them and copy the new record of the Internet tables to the local database. Any ideas how to do that; I use mysql 3,23,33 and php 4,06 Thanx Nikos -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]