Problem in setting Table Level Privileges

Hi Everybody Commands: > mysql -uroot mysql> grant select,insert,update,delete on try.TBL_MACIP to 'tryAdmin1'@'localhost'; >mysql -utryAdmin1 mysql> use try mysql> select * from TBL_MACIP; >/etc/init.d/mysql restrat >mysql -utryAdmin1 mysql>use try ERROR 1044 (42000): Access denied for user: ''@'

RE: Set user password by using PowerBuilder

Thanks Martin, But, I want to know the script in PowerBuilder, because my current version of MySQL does not support store procedure, so I don't know how to code the set user password statements in PB. >Basically to set the password you want to effect a GRANT on the Table here >is example > >>

Re: MySQL 4.0 - Download - Viruses ?

At 17:25 -0700 3/16/04, Sasha Pachev wrote: Kevin Carpenter wrote: While downloading this a I got a number of virus warnings from McAfee. I aborted the download. Anyone else experienced this? I emailed MySQL but didn't hear back. Kevin: Were you downloading a Windows or some other binary? If i

Downgrade Mysql from 4 to 3.23

Hi, I am developing a database in mysql 4.Is it possible to downgrade the same into mysql 3.23.If its possible then how? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: revoke question

[EMAIL PROTECTED] wrote: I was trying to allocate a new user and I typed something like: grant all privileges on pail to [EMAIL PROTECTED] identified by 'hill'; Here you grant [EMAIL PROTECTED] all privileges on a table named pail. I realized I made a mistake needing to specify (at least) 'pai

New version of sql-bench is available from BitKeeper

Dear MySQL users, MySQL benchmark team is proud to announce availability of the new version of sql-bench suite. It is currently available only in BitKeeper tree, named "mysql-bench". This is still development release and we would really appreciate your testing, bug reports as well as comment

Re: create sequence

I believe you want an AUTO_INCREMENT column. CREATE TABLE yourtable (customer_id AUTO_INCREMENT NOT NULL PRIMARY KEY, other_columns...); See the manual and for more. Michael jdavis wr

Re: Set user password by using PowerBuilder

Basically to set the password you want to effect a GRANT on the Table here is example > >> >mysql> create database test_dummy; > >> >Query OK, 0 rows affected (0.00 sec) > >> >mysql> grant all on test_dummy.* to dummy; > >> >Query OK, 0 rows affected (0.00 sec) > >> >mysql> set password for 'd

Set user password by using PowerBuilder

Hi, I am using the version 4.01 of MySQL and the Powerbuilder. I want to create a function in PowerBuilder which allows user to reset its MySQL password. Could anybody help me and give me some advices? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re[2]: PHP and using mysql_last_id()

Hello Lorderon, Wednesday, March 17, 2004, 3:39:35 AM, you wrote: L> It is better run a query with: L> SELECT LAST_INSERT_ID(); L> immediately after making the insert query. that way you'll get the exact L> ID.. Why? What difference does that give between using the PHP function that returns

Re: PHP and using mysql_last_id()

It is better run a query with: SELECT LAST_INSERT_ID(); immediately after making the insert query. that way you'll get the exact ID.. ""Elly Wisata"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Does php have a function like mysql_insert_id but support a zerofill auto > incre

RE: PHP and using mysql_last_id()

Does php have a function like mysql_insert_id but support a zerofill auto increment int? ~Elle~ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 17, 2004 5:19 AM To: [EMAIL PROTECTED] Subject: Re: PHP and using mysql_last_id() Hi can anyone te

Re: Full-Text on double rows

"Chris Nolan" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Which version of MySQL?? The difference will be different (!!) depending > on the version in use. > > In general, full text search uses a tree-structure. Doubling the number > of entries in the tree is likely to result in a

Re: Full-Text on double rows

Lorderon wrote: If I got a full-text table with X rows, and some search takes 5 sec.. Now if I got a full-text table with 2X rows, how much time will take the same search on twice amount of rows? Is the difference linear??? thanks in advance, -Lorderon Which version of MySQL?? The difference

Full-Text on double rows

If I got a full-text table with X rows, and some search takes 5 sec.. Now if I got a full-text table with 2X rows, how much time will take the same search on twice amount of rows? Is the difference linear??? thanks in advance, -Lorderon -- MySQL General Mailing List For list archives: http://

RE: Wish List of Features

Dude. http://www.phpmyadmin.net/ Daevid Vincent http://daevid.com > -Original Message- > From: Mark Manning [mailto:[EMAIL PROTECTED] > Sent: Tuesday, March 16, 2004 7:38 AM > To: [EMAIL PROTECTED] > Subject: Wish List of Features > > I downloaded MySQL and began playing with it. I

Re: Got an error reading communication packets - ???

Arunachalam wrote: Hi MySQLians, After such a long span (nearly 1 month) of searching the solution for the server restart while executing C API prepared statments I found that the execution met the error in the server ; 040315 17:48:55 Aborted connection 2 to db: 'test' user: '' host: `lo

Re: Processlist : state "Writing to net"

rekin's janky wrote: Hi listers, Using MySQL 4.0.15-max-debug on Windows 2000, I am working with perlscripts. When one of my program runs, I have an unexpected long time for one query which take at least 10 min (in the best case, but it stayed blocked most of the time) instead of 10 sec when t

Re: MySQL Training in the North West of UK

Andrew McCall wrote: ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error you must delete

Re: Optimise two mysql queries to one query

dr zoidberg wrote: Hello, $a = mysql_query("Select a,b FROM t WHERE category=1") while($a) { $x = $a[a]; //some echo //another query $b = mysql_query("Select * FROM t WHERE subcategory=$x") while ($b) { //some echo } } Not tested and might need some tweaking in the where clause, but should be at

OS X 10.3.3 and byte ordering update

I saw a little blip about issues with MySql when updateing OS X to 10.3.3. It seems the byte order has changed and you will have to export and import all your data. I got the impression this only applies to OS X Server, and not client, so only the MySql installed by Apple. Anyone have any more da

Re: MySQL Cluster Software

Tom O'Neill (MySQL User) wrote: I recently saw and article that says MySQL will be shipping its cluster software starting April 14th during the Users Conference & Expo this year. Does anyone have any information about this? My company is considering using the Emic clustering software. Has anyone

create sequence

hello, I have mysql version 4.0.16. I am trying to create a sequence to use for a customer_id field. Anyway I try this ... CREATE SEQUENCE "new_num" start 1 increment 1 maxvalue 9223372036854775807 minvalue 1 cache 1; or just CREATE SEQUENCE "new_num"; and both give me a sytax error. What am I

Re: Administrator

Hi, On Tue, 2004-03-16 at 21:23, Daniel Kasak wrote: > Newsletter wrote: > > >After install the MySQL Administrator version 1.0.2b alpha there is an error about > >a msvcr70.dll not found. This problem was found in Windows 98SE and Windows 2000 > >server systems. > > > >Thanks for your attenti

select statement question

I know this'll look scary : select distinct book.bid, title, price, condition, author.name, edition from book left join purchase on book.bid=purchase.bid left join student on 1 = 1 left join edition on edition.bid = book.bid left join author on 1 = 1 left join author_book on 1 = 1 where purcha

LDAP Athenticaiton for MySQL

Hello Is there a way I can get a MySQL database to authenticate users against an LDAP database without any 3rd party coding? I want to store mysql usernames and passwords in ldap. Thanks Matt -- Matt Silva Empower Software Technologies, LLC 27851 Bradley Rd. Suite 120 Sun City, CA 92586 PH: (909)

Re: MySQL 4.0 - Download - Viruses ?

Kevin Carpenter wrote: While downloading this a I got a number of virus warnings from McAfee. I aborted the download. Anyone else experienced this? I emailed MySQL but didn't hear back. Kevin: Were you downloading a Windows or some other binary? If it was Windows, I would be concerned - the bu

Re: just the list please!

Scott Haneda wrote: on 3/16/04 1:31 PM, Alan Williamson at [EMAIL PROTECTED] wrote: Can people please just email the list and not the person *AND* the list!!! i get duplicate emails and its very annoying to what is a great list so far. kinda puts me off from answering peoples qu

Re: just the list please!

on 3/16/04 1:31 PM, Alan Williamson at [EMAIL PROTECTED] wrote: > Can people please just email the list and not the person *AND* the list!!! > > i get duplicate emails and its very annoying to what is a great list so > far. kinda puts me off from answering peoples questions! Personally, I like

Re: just the list please!

On 16 Mar 2004, at 22:30, Gabriel Guzman wrote: On Tuesday 16 March 2004 02:19 pm, Tim Cutts wrote: This is something the list admins might be able to sort out. It's common for mailing lists to set a reply-to header... here we go again Oops - is that a bad button to push? :-) If it's the

MySQL Cluster Software

I recently saw and article that says MySQL will be shipping its cluster software starting April 14th during the Users Conference & Expo this year. Does anyone have any information about this? My company is considering using the Emic clustering software. Has anyone had experience with that? W

RE: Wish List of Features

Hi Mark, 1. See the mysqldump utility. (separate to the mysqlcc and mysql). You can dump the whole server, a selected db, or table including or excluding the table data (ie structure only). eg. mysqldump -B -a -d -u -p > dumpfile.sql will dump the structure of database to file dumpfile.sql.

Re: just the list please!

On Tuesday 16 March 2004 02:19 pm, Tim Cutts wrote: > This is something the list admins might be able to sort out. It's > common for mailing lists to set a reply-to header... here we go again -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: PHP and using mysql_last_id()

sgannon60 wrote: Hi can anyone tell me how to use php's mysql_last_id() or MySQL's INSERT_LAST_ID I personnaly think mysql_last_id will never work..., but try mysql_insert_id() This will generate the ID of the PREVIOUS insert query. So it has to be mysql_insert_id()+1 Alex -- MySQL Genera

Re: just the list please!

On 16 Mar 2004, at 21:31, Alan Williamson wrote: Can people please just email the list and not the person *AND* the list!!! i get duplicate emails and its very annoying to what is a great list so far. kinda puts me off from answering peoples questions! This is something the list admins might b

Re: PHP and using mysql_last_id()

Hi can anyone tell me how to use php's mysql_last_id() or MySQL's INSERT_LAST_ID - php's function is mysql_insert_id() and not mysql_last_id(), there is no php function called mysql_last_id()...if you saw that in a manual, i'd email the owner of the document. http://php.net/mysql_

PHP and using mysql_last_id()

Hi can anyone tell me how to use php's mysql_last_id() or MySQL's INSERT_LAST_ID I have a page registration page, using a username, password and member level text box. I want to send the user (upon successful insert) to a member's detail form where the password table primary key is avaliable it

just the list please!

Can people please just email the list and not the person *AND* the list!!! i get duplicate emails and its very annoying to what is a great list so far. kinda puts me off from answering peoples questions! thanks! :) - Original Message - From: "Alan Williamson" <[EMAIL PROTECTED]> To: "

RE: ORACLE to MySQL migration

Perl/DBI is a possibility. --Walt > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Tuesday, March 16, 2004 8:48 AM > To: [EMAIL PROTECTED] > Subject: ORACLE to MySQL migration > > > Hello colleagues, > I have to migrate a lot of ORACLE 8.1.7 databases to

Re: Blocking INSERT/UPDATE on SLAVE (replication)

Another way you can do something similar, rather than messing around with permissions is to use the read-only option. This option exists in MySQL 4.0+. It prevents anyone except for the mysql root user or the replication thread from being able to change data -- regardless of their permissions. Y

Re: Blocking INSERT/UPDATE on SLAVE (replication)

Thank you. I though it could have a way to avoid updates/inserts without touching my 'mysql' database, so it would be a permanent, exact copy of my master server. []s, Conrado - Original Message - From: <[EMAIL PROTECTED]> To: "cvarda" <[EMAIL PROTECTED]> Cc: "Alan Williamson" <[EMAIL

Re: Blocking INSERT/UPDATE on SLAVE (replication)

Add the following line to you slave my.cnf file: replicate-ignore-db=mysql >> Original Message << On 3/16/04, 2:44:53 PM, cvarda <[EMAIL PROTECTED]> wrote regarding Re: Blocking INSERT/UPDATE on SLAVE (replication): > I'm currently replicating all databases, so

Re: Wish List of Features

You already can insert a column before or after another column. ALTER TABLE blah_table ADD COLUMN column_new VARCHAR(25) AFTER column_existing; Don't count on my syntax being perfect, but it is pretty easy to do what you are saying using the MySQL client Daniel Gibby David Griffiths wrote: 1)

Re: Wish List of Features

1) Try, SHOW CREATE TABLE table_name from the mysql client utility. It will give you a create-table command. In MySQL Control Center, you can do the same thing, but for all tables at once. Select the database with your tables, and open the tree. Right click on the Tables item, and choose, Tools->S

Re: Blocking INSERT/UPDATE on SLAVE (replication)

I'm currently replicating all databases, so this would happen. This means that I should change my setup to do not replicate the 'mysql' database. Is there a way to explicity do not replicate only 'mysql' and replicate all others, including new databases? []s, Conrado - Original Message ---

revoke question

I was trying to allocate a new user and I typed something like: grant all privileges on pail to [EMAIL PROTECTED] identified by 'hill'; I realized I made a mistake needing to specify (at least) 'pail.*', intending to grant the user access to a database I created. So to clean up I tried: revo

Optimise two mysql queries to one query

Hello, $a = mysql_query("Select a,b FROM t WHERE category=1") while($a) { $x = $a[a]; //some echo //another query $b = mysql_query("Select * FROM t WHERE subcategory=$x") while ($b) { //some echo } } Poent is thet I have menus, parents with childes (childes are not parents) and I want to display

Re: Blocking INSERT/UPDATE on SLAVE (replication)

First, do not replicate the MySQL database from the master to the slave(s). Then create users on the slave that only have the desired rights. In your case, SELECT only. >> Original Message << On 3/16/04, 2:02:13 PM, cvarda <[EMAIL PROTECTED]> wrote regarding Bloc

Wish List of Features

I downloaded MySQL and began playing with it. It is a very impressive program and many awards should go to everyone who has ever worked on this project. :-) Since I'm mainly just playing around with the server right now I could never be considered a real user until I've created a few database

Re: Administrator

Newsletter wrote: After install the MySQL Administrator version 1.0.2b alpha there is an error about a msvcr70.dll not found. This problem was found in Windows 98SE and Windows 2000 server systems. Thanks for your attention Reinaldo Melo Filho from Brazil I searched for that dll on google and

Re: getting off list

We are programmed to receive You can signup anytime you like, but you can never leave. T Si wrote: Hello. How do I get removed from the mysql e-mail list? Thanks, toney _ FREE pop-up blocking with the new MSN Toolbar –

Blocking INSERT/UPDATE on SLAVE (replication)

Hi there. How could I deny users or applications issuing INSERT or UPDATEs queries on my SLAVE server? This is intended to ensure that slave will not have data which MASTER don't know. Thanks... []s, Conrado -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To uns

Re: 4.1.2.?

Mirza <[EMAIL PROTECTED]> wrote: > > Is there any info on when 4.1.2 is to be released? > Soon. It will be released in two or three weeks. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ _

ROWNUM in mysql

How can I select a mysql version of the Oracle 'rownum' inside a SQL statement? I need to include this for a ranking type functionality - but I don't see this type of analytic functionality. Any help would be appreciated. David

Re: can I get MySQL Source code under Windows OS?

Arunachalam <[EMAIL PROTECTED]> wrote: > > I have downloaded *bk-3.0.4-x86-win32.EXE* from > URL: http://www.bitmover.com/download, for windows > When I try to install it ask for; > > *** > This release of BitKeeper requires the Cygwin version 1.5.5 . If you > have already installed a older cygwi

SELECT/UPDATE and locking issue

Hi, all. I'm doing the following on MySQL 4.0.18: LOCK TABLES b WRITE, a READ LOCAL; SELECT a.id FROM a LEFT JOIN b ON b.id = a.id WHERE a.type = 'foo' AND a.action = 'T' AND b.status IS NULL; UPDATE b SET status = 'Q' WHERE id IN ([list of ids from SELECT]); UNLOCK TABLES; Then I loop t

Re: getting off list

On Tue, 16 Mar 2004 09:45:46 -0800, "T Si" <[EMAIL PROTECTED]> wrote: >Hello. How do I get removed from the mysql e-mail list? It's at the bottom of each email you receive from the list. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://list

Re: ORACLE to MySQL migration

Try SQLyog - http://www.webyog.com/sqlyog Karam --- [EMAIL PROTECTED] wrote: > Hello colleagues, > I have to migrate a lot of ORACLE 8.1.7 databases to > MySQL 3.23 > > I'm looking for a tool or for an algorithm which > fully supports any > ORACLE structures ... > If needed I may use a commerc

getting off list

Hello. How do I get removed from the mysql e-mail list? Thanks, toney _ FREE pop-up blocking with the new MSN Toolbar – get it now! http://clk.atdmt.com/AVE/go/onm00200415ave/direct/01/ -- MySQL General Mailing List For list archive

Re: BETWEEN

Michael Stassen wrote: Jochem van Dieten wrote: However, I expect that would result in doing 2 rangescans and a merge. It might be even faster to use: SELECT * FROM sys WHERE sectorID BETWEEN 1 AND 42 AND sectorID NOT BETWEEN 21 AND 29; That would result in 1 rangescan and a filter. But a lot de

Re: hard boot killed replication execution

Does anyone know what this replication Slave_SQL error means? Error initializing relay log position: Could not find target log during relay log initialization How do I specify the target log other than what I'm doing? See below for details. Daniel Gibby wrote: The problem isn't that it can't

Re: Help with a tough query

Egads you're right! I've been overthinking this. There must something else wrong in my query. Thanks for the hit over the head. I needed it. On Mar 16, 2004, at 10:37 AM, Harald Fuchs wrote: When you specify a left join, you will always get the same number of records as are in your primary joi

Re: Copying a database

Egor Egorov wrote: How would you go about copying a database? I need to make a copy with all the tables and names the same. I just need to name the database something different. If you use only ISAM/MyISAM table, rename database directory. Otherwise create new database, make a dump of tables, re

Re: BETWEEN

Jochem van Dieten wrote: Michael Stassen wrote: SELECT * FROM sys WHERE sectorID BETWEEN 1 AND 20 OR sectorID BETWEEN 30 AND 42; If that's slow (the optimizer doesn't like ORs) and you are using at least mysql 4.0.0, you can change this to SELECT * FROM sys WHERE sectorID BETWEEN 1 AND 20 UN

ORACLE to MySQL migration

Hello colleagues, I have to migrate a lot of ORACLE 8.1.7 databases to MySQL 3.23 I'm looking for a tool or for an algorithm which fully supports any ORACLE structures ... If needed I may use a commercial tool, otherwise a free software / shared software should be very appreciated Can anyone gi

Re: BETWEEN

Matt W wrote: Hi Michael, SELECT * FROM sys WHERE sectorID BETWEEN 1 AND 20 OR sectorID BETWEEN 30 AND 42; If that's slow (the optimizer doesn't like ORs) and you are using at least mysql 4.0.0, you can change this to SELECT * FROM sys WHERE sectorID BETWEEN 1 AND 20 UNION SELECT * FROM sys WHE

[4.0] latin1 accented characters and fulltext

I've been playing around with fulltext searching in 4.0, and I ran into the following weirdness with accented characters. | version | 4.0.14 | character_set | latin1 in my entire colle

4.1.2.?

Hi, Is there any info on when 4.1.2 is to be released? Mirza -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Copying a database

Ed Curtis <[EMAIL PROTECTED]> wrote: > > How would you go about copying a database? I need to make a copy with all > the tables and names the same. I just need to name the database something > different. If you use only ISAM/MyISAM table, rename database directory. Otherwise create new database,

Re: Hierarchical data design

>In a simple tree, one can easily see that using the title of a node as >it's primary key is not smart... names can easily collide: The names can definitely collide. But under a file system paradigm the combination of name with parentID will be unique and define the tree structure you mention:

BLOB 1024

Hi All, How can I define a column of BLOB (or TEXT) with exact length of 1024 bytes? Can I index it? I want to run a select query using FIND_IN_SET function on that column.. but I'm afraid it will be slow.. any suggestions? thanks in advance, -Lorderon. -- MySQL General Mailing List For list

Copying a database

How would you go about copying a database? I need to make a copy with all the tables and names the same. I just need to name the database something different. Thanks, Ed -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[E

Re: Hierarchical data design

> the other option is to parse your info from the URL, tokenizing per '/' character, then do look ups recursively for each entry, finding the node you're looking for. > This strikes me as the most logical solution to this particular problem. With regards, Martijn Tonies Database Workbench - dev

Re: Help with a tough query

The DISTINCT key word works on the whole record, not the field that follows it. So the query actually does return multiple records with the same EventID when there are multiple related contacts/regardings. DISTINCT filters out duplicate records created from the joining of the three tables. Whe

RE: Hierarchical data design

One of the ways around this that I've seen is to maintain an additional field for the 'full path' info. so that you have: table_name --- node_id integer auto_increment node_name varchar(50) not null parent_id integer full_path varchar(255) the obvious downside is that your application

[ot] connection process is very slow under WIN NT 4.0

Hi I realize that this is may be off topic, but the remote connection times to MySQL under Windows NT 4.0 is really slow, while under Unix is quite responsible. Does anyone faced this problem and found a proper solution? because the project needs to reside on Windows and otherwise management wi

Hierarchical data design

Hi all, I've been playing around with the concepts mentioned in this article: http://www.sitepoint.com/article/hierarchical-data-database/ (Short summary: Using Modified Preorder Tree Traversal, resulting in "left and right" values for each tree node to describe the tree structure) With all thi

Re: mysqlgui problem - can't connect via tmp/mysql.sock

Dmitry Rusak writes: > Hi! > I have a problem using musqlgui-1.7.2 under FreeBSD 4.9 STABLE. It "Can't connect to > mysql > server via tmp/mysql.sock" > > My setup: > 1) mysql is installed in /usr/local/mysql > data base directory - /usr/local/mysql/data > socket directory - /usr/local/mysql/tm

Administrator

After install the MySQL Administrator version 1.0.2b alpha there is an error about a msvcr70.dll not found. This problem was found in Windows 98SE and Windows 2000 server systems. Thanks for your attention Reinaldo Melo Filho from Brazil

Re: restoring a database from tape

Tim Cutts <[EMAIL PROTECTED]> wrote: > > On 16 Mar 2004, at 09:06, Victor Pendleton wrote: > >> If the directory structure is the same and the snapshot is consistent >> then >> the answer is yes. If you do not want to purchase a commercial >> utility, one >> method is to schedule mysqldump, com

Re: finding max values

> "Keith" <[EMAIL PROTECTED]> wrote: > had to upgrade mySQL but I got the subquery working for individual entries. > Trouble now is that I can't figure out how to get it to work for more than > one entry. The query currently stands at: > > SELECT SQL_CALC_FOUND_ROWS sys.sectorID, sys.name AS sysNam

can I get MySQL Source code under Windows OS?

Hi, I have downloaded *bk-3.0.4-x86-win32.EXE* from URL: http://www.bitmover.com/download, for windows When I try to install it ask for; *** This release of BitKeeper requires the Cygwin version 1.5.5 . If you have already installed a older cygwin release, you should upgrade to cygwin 1.5.5 *WARN

Re: Great QUERY question

"JR Bullington" <[EMAIL PROTECTED]> wrote: > This is for those who love a challenge. > > I am trying to come up with a query that would calculate the Standard > Deviation and Variance for 15 fields. Although in theory this is easily done > in Access, MySQL does not have the same mathematical calcul

3 node master <-> master <-> master replication?

hi, we have 3 inet servers running mysql: mysql1.mydom.tld mysql2.mydom.tld mysql3.mydom.tld and we also got an dynamicdns entry mysql.mydom.tld. normaly mysql.mydom.tld directs to mysql1.mydom.tld - but if mysql2 detects mysql1 is down it will use a dyndns script to become mysql.mydom.tld. what

Re: restoring a database from tape

On 16 Mar 2004, at 09:06, Victor Pendleton wrote: If the directory structure is the same and the snapshot is consistent then the answer is yes. If you do not want to purchase a commercial utility, one method is to schedule mysqldump, compress the file and then backup that file up. What commerci

Re: composite Keys

"joe collins" <[EMAIL PROTECTED]> wrote: > does MySQL support composite keys? Yes, MySQL supports composite keys: http://www.mysql.com/doc/en/Multiple-column_indexes.html > > I have a table 'Group_Map' > > This has 3 fields > > contact_id (primary key in another table) > group_id (candi

RE: restoring a database from tape

If the directory structure is the same and the snapshot is consistent then the answer is yes. If you do not want to purchase a commercial utility, one method is to schedule mysqldump, compress the file and then backup that file up. -Original Message- From: Ansari, Raza (GEI, GEFA) To: [EMA

Re: How could I do this insert/select?

"stephen" <[EMAIL PROTECTED]> wrote: > > mysql> use zzz > Database changed > > > mysql> create table category >-> ( >-> id tinyint(4) NOT NULL auto_increment, >-> name varchar(20) NOT NULL, >-> parent tinyint(4) NULL, >-> primary key(id) >-> ); > Query OK,

Re: Jumping to prev and next records

Scott Haneda wrote: [...] Is perhaps there some way to get the next id and prev id in a mysql query based on id being sorted? You could do this using LIMIT. For example: SELECT id FROM foo WHERE id > $current_id ORDER BY id ASC LIMIT 1; SELECT id FROM foo WHERE id < $current_id ORDER BY id DESC LI

re: Using Indian languages and working with them using C API()

Thanks for your help. I am no seasoned C programmer so looking into the source code is out of question. I am having RichControl in my application that returs text in Unicode data. So if a user has entered Hindi text in the text control i have to add them in a table. For that I will be using C API