RE: Field type conversion question

I would suggest having EmpTable (PRIMARY KEY=empID) EventsTable (PRIMARY KEY=eventID) AttendantsTable (PRIMARY KEY=[empID,eventID]) >From there you can build queries to find persons who attended an event or which events a person went to. Adolfo > -Original Message- > From: Brad Harr

RE: BEGINNER: in mysql, better to do 1 table for one relationship, even with a one to one relation ?

I would really prefer a little variation of the third way you mention: 1) table person personID primary int 11 autoincrement 2) table car carID primary int 11 autoincrement 3) table relation_person_car personID int 11 carID int 11 PRIMARY KEY (personID,carID) Adolfo > -Original

[MySQL] InnoDB Lock status

I'am working with MySQL 3.23.51-Max in a linux box and Visual Fox and Delphi in a WinXP box, mostly using InnoDB tables. Is there a way to know wich rows are lockedin a table? is there a function that returns if a row is locked, or the rows locked in a table? It can be done with a UDF? My questio

Re: 3.23.54 compile error

Maybe I'm paranoid > I reply to myself... > >> I've tried to build mysql-3.23.54 from rpm sources. >> [...] >> error: Bad exit status from /var/tmp/rpm-tmp.34718 (%build) >> >> Any hint? >> >> Maybe a newer libtool is required? < > Got a clean compile with libtool-1.4-8 and automake-1.5-1. >

Re: 3.23.54 compile error

I reply to myself... > I've tried to build mysql-3.23.54 from rpm sources. > [...] > error: Bad exit status from /var/tmp/rpm-tmp.34718 (%build) > > Any hint? > > Maybe a newer libtool is required? Got a clean compile with libtool-1.4-8 and automake-1.5-1. Now I'll test it. -

Question about MySQL and lwp_mutex_lock and lwp_mutex_wakeup

Hello, I am running MySQL 4.0.5b 64 bits on a Solaris 2.8. The server used has 8 CPUs. MySQL DB has access (and menage) in that system 2DBs. The first DB is only is accessed only through SELECTS and the second one has been used for UPDATES and INSERTS. Initially I was running a process that was

Temp table / join problem, just keeps saying copy to tmp...

Hi all. I'm having trouble this a process that just keeps running. To view this process I'm using the msql SHOW PROCESSLIST command. Here's the message I'm seeing: 38 | bb50 | localhost | bb50 | Query | 197 | Copying to tmp table | select a.pk1,a.sos_id_pk2, a.name, count(q.pk1)

3.23.54 compile error

I've tried to build mysql-3.23.54 from rpm sources. My system is a RedHat 6.2 with glibc-2.1.3-28 and the compiler is gcc-2.95.4-4h. Had no problems at all building mysql until mysql-3.23.53, but now I get this error: [...] Making distclean in . make[1]: Entering directory `/usr/src/redhat/BUILD/

BEGINNER: in mysql, better to do 1 table for one relationship, even with a one to one relation ?

The way I've always done it, and I wonder if I am not doing lots of things wrong: i have 2 tables, one person and one address for a one to one relation, the way I do it: table person personID primary int 11 autoincrement addressID int 11 table address addressID primary int 11 autoincrement if it

RE: newbie - linking queries with dynamic where conditions

You´re missing the GROUP BY clause select a.domain, a.transport, sum(c.recipient_count) sum(c.recipient_size) from transport as a, acl as b, recipientstats as c where a.id=b.transportId and b.adminId='1' and c.recipient_email like '%a.domain' GROUP BY a.domain,a.transport; > -Original Mess

RE: Sorting UK Postcodes (WAS Sorting Results)

Sorting by number is not important, it was more a general question about sequences of "variousnameXXX" and how to order them correctly with a simple query. Splitting in 2 fields seems the only way then. For the postcode it's just to provide the user with an easy lookup table, but it's not *that* im

RE: Sorting UK Postcodes (WAS Sorting Results)

Hi, yes, that would do, except that I don't know how many letters are in front of the numbers. And since they're not the same letters perhaps ORDER by 1,2 would have done it perfectly, if only we could substring() intelligently first. Cheers, Damien COLA > -Message d'origine- > SQL: > sel

RE: Collective Row Concatenation

Hi, I'm pretty sure that's not possible in MySQL - sounds like the kind of thing that would be way easier to write a bit of script for instead. I don't think you'll get away with using 'order' as a column name either - I'm fairly sure it's a reserved name in MySQL. Cheers, Andrew Mysql,query

RE: Sorting UK Postcodes (WAS Sorting Results)

Thank you and Yes, separating the postcodes into field letters and numbers may be the only way to be able to order a sequence like that: CV1,CV2,..,CV10,.. It would also work since there could as many letters as needed Anyone has a simple query for odering sequences correctly ? Cheers, Damien COL

Re: MySQL 3.23.54 safe_mysqld fix

what an important piece of information, thanks, Nick! tibyke On Thu, 12 Dec 2002 12:46:10 -0600 "Nick" <[EMAIL PROTECTED]> wrote: N> The following code is incorrect in safe_mysqld on 3.23.54 at least (that N> is all I have checked) N> N> Line 162: N> if $NOHUP_NICENESS -gt 0 N> then N>

RE: Sorting UK Postcodes (WAS Sorting Results)

At 22:53 12/12/2002 +0100, Alliax wrote: Sorry, I forgot to say that postcode can be one or 2 letters in front of the numbers. > -Message d'origine- > They can be E1,E2,..,E12,E13 > Order by name would do: > E1,E10,E11,E12,E13,E2,E3,E4,... > how can I get with a simple ORDER BY query > E1

Re: Compiling 3.23.54-1

On Thu, 12 Dec 2002 13:15:05 -0500 "Michael T. Babcock" <[EMAIL PROTECTED]> wrote: MTB> tibyke wrote: MTB> MTB> >the funny this is that 3.23.53 just worked (and compiled) fine, and '53 and '54 have exactly the same spec file. MTB> > MTB> > MTB> MTB> Did the mysql team change tools versions?

Re: Mail Abuse

On 12 Dec 2002, at 22:42, Stefan Hinz wrote: > Has anyone observed something like this before? I keep getting unsubscribe > mails from the list (at least five times this month only). The reason it happened is that you've posted several messages in which you've quoted the unsubscribe text that th

Re: Compiling 3.23.54-1 - new tools installed !

On Thu, 12 Dec 2002 21:29:40 - "Jocelyn Fournier" <[EMAIL PROTECTED]> wrote: JF> Hi, JF> JF> You should downgrade automake to 1.5 and if it still doesn't work, try with JF> autoconf 2.52. JF> JF> Regards, JF> Jocelyn hi, MySQL folks! :) it works for me with (redhat 6.2):: - autom

mysql-max-3.23.54-pc-linux-i686 doesn't work!

I downloaded the new binary version (3.23.54) mysql-max from the website but the safe_mysqld seems buggy .. Moreover when I try to start it up i got these errors: /usr/local/mysql-max-3.23.54-pc-linux-i686/bin/mysqld: /lib/libpthread.so.0: version `GLIBC_2.2' not found (required by /usr/local/my

RE: Sorting UK Postcodes (WAS Sorting Results)

Hi, Could you seperate the letters into one column and the numbers in another... Then you could group by the Alphabetical column, and order by the numerical column... Regards, Chris Stark -Original Message- From: Alliax [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 12, 2002 4:53 P

Re: Sorting UK Postcodes (WAS Sorting Results)

Damien -- What about: select substring(code, 1, 1) as letter, substring(code, 2, 2) + 0 as number from epost order by 2 +++ | letter | number | +++ | E | 1 | | E | 2 | | E | 3 | | E | 4 | | E | 10 | | E

Re: load data local infile

Thanks, it works after we recomplied it the enable-local-infile. By default, it is truned off. Cheers, yuyi Rich Allen wrote: try adding these line to your my.cnf file (mysql config file) [mysqld] local-infile=1 [mysql] local-infile=1 - hcir On Thursday, December 12, 2002, at 09:52 AM, Yuyi G

Re: New database doesn't show up in phpMyAdmin

This is a problem I had before with phpMyAdmin... Try closing your browser, flush all cachefiles in the browser and log on to your database again. If this helps, I can help you with a cure for this problem. If it doesn't help, you probably have no permissions reading your database via phpMyAdmin.

RE: Sorting UK Postcodes (WAS Sorting Results)

Sorry, I forgot to say that postcode can be one or 2 letters in front of the numbers. > -Message d'origine- > They can be E1,E2,..,E12,E13 > Order by name would do: > E1,E10,E11,E12,E13,E2,E3,E4,... > how can I get with a simple ORDER BY query > E1,E2,E3,E4,E5,... ? -

Re[2]: Compiling 3.23.54-1

Hello, > Yes. You need automake 1.5 / libtool 1.4. It appears this made it into > the CHANGES for the 4.0.x series, but not the 3.23.x series. I'm BCC'ing > this to our build engineer, so he can correct the manual. > Thanks! > -Mark well, [root@kula-szpiegula /root]# libtool --version

Re: Mail Abuse

Dear Alistair, dear list, >> someone with your e-mail address is trying to unsubscribe me from a >> mailing list. Please make sure this abuse will stop. > thanks for the note, I tried to unsubscribe myself earlier today but how > that got turned into unsubscribing you beats me, anyway apologies f

Re: Can't find hosts.frm -- *directory* permissions now okay?

> mysql still doesn't own the mysql directory. > OK, I changed that for /usr/libexec [root@server /]# ls -la /usr/libexec/ total 4008 drwxr-xr-x7 root root 4096 Dec 11 15:28 . drwxr-xr-x 16 root root 4096 Nov 27 09:32 .. ... drwxr-xr-x3 mysqlmysql40

Re: newbie - linking queries with dynamic where conditions

So I am trying to accomplish something like this: select a.domain, a.transport, sum(c.recipient_count) sum(c.recipient_size) from transport as a, acl as b, recipientstats as c where a.id=b.transportId and b.adminId='1' and c.recipient_email like '%a.domain'; But I know I am missing something beca

Re: Compiling 3.23.54-1 - new tools installed !

Hi, You should downgrade automake to 1.5 and if it still doesn't work, try with autoconf 2.52. Regards, Jocelyn - Original Message - From: "gnu_is_not_unix" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, December 12, 2002 8:52 PM Subject: Re: Compiling 3.23.54-1 - new tool

Re: Group by problem

Dmitry, - Original Message - From: "Dmitry Kosoy" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Thursday, December 12, 2002 8:02 PM Subject: Group by problem > Hi, > > The following sql operators caused to incorrect results: > > CREATE TEMPORARY TABLE temp_list ( > CurrI

Sorting UK Postcodes (WAS Sorting Results)

Hi, What about if you want to sort UK Postcodes ? They can be E1,E2,..,E12,E13 Order by name would do: E1,E10,E11,E12,E13,E2,E3,E4,... how can I get with a simple ORDER BY query E1,E2,E3,E4,E5,... ? Cheers, Damien COLA - Before

Re: Can't find hosts.frm -- permissions now okay?

Lefevre, Steven wrote: I'm still getting the error 'Can't find hosts.frm' when I try to laund the mysql daemon. I've run the mysql_install_db script several times. I've changed the user and group ownership for all the files in the /usr/libexec/mysql directory, and also in /var/lib/mysql to 'm

Re: Can't find hosts.frm -- permissions now okay?

I had a similar experience right down to the error message you are getting. Based on that experience, I am inclined to recommend the following: 1) Abandon your current installation which I perceive that your are attempting from a MySQL tarball. 2) Download the webmin-1.030 tarball and execute ./

Re: Compiling 3.23.54-1 - new tools installed !

Hello, > Yes. You need automake 1.5 / libtool 1.4. It appears this made it into > the CHANGES for the 4.0.x series, but not the 3.23.x series. I'm BCC'ing > this to our build engineer, so he can correct the manual. > Thanks! > -Mark well, [root@kula-szpiegula /root]# libtool --version

RE: Sorting Results

ORDER BY col [ASC|DESC] http://www.mysql.com/doc/en/SELECT.html -Original Message- From: Mike(mickako)Blezien [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 12, 2002 11:45 AM To: MySQL List Subject: Sorting Results Hello all, Is there away, within the sql query, to sort the query r

boolean type

Does there exist a boolean column type? I checked the documentation, and it says that there exists a BOOL but it is a tinyint(1). Should I use that as a boolean? thanks in advance, prashant. query to go through filter. - Before

insert record x 2

Hi, I have a form with two sections on it. The user either completes one or both sections. (The validation is controlled by JavaScript) at the moment no matter how many sections they complete all the information is added to one record(through asp). But what I want to happen, is if the

Re: load data local infile

try adding these line to your my.cnf file (mysql config file) [mysqld] local-infile=1 [mysql] local-infile=1 - hcir On Thursday, December 12, 2002, at 09:52 AM, Yuyi Guo wrote: Hi: I am using mysql v4_0_5 both clinet and server. I cannot get load data local infile to work after many differen

Re: Field type conversion question

On Thu, 12 Dec 2002 08:59:45 -0500, Brad Harriger wrote: >like to have a field in Events that will store multiple names with both fields from >EmpTable concatenated into one string (i.e. "FirstName LastName") What is the most >efficient way to do this in MySQL? > One approach is an Eve

Re: More locking issues

>From MySQL Reference Manual: ... Normally, you don't have to lock tables, as all single UPDATE statements are atomic; no other thread can interfere with any other currently executing SQL statement. There are a few cases when you would like to lock tables anyway: * If you are going to run many

Problem compiling MySQL-3.23.54 on OpenUNIX 8.0.0

I can not compile the release of MySQL-3.23.54. Below is the errors. make[4]: Entering directory `/home/build/ou8/mysql-3.23.54/sql' source='mysqld.cc' object='mysqld.o' libtool=no \ depfile='.deps/mysqld.Po' tmpdepfile='.deps/mysqld.TPo' \ depmode=none /bin/bash ../depcomp \ CC -Kthread -DUNIXWA

Re: Sorting Results

Mike(mickako)Blezien wrote: Hello all, Is there away, within the sql query, to sort the query results in alphabetical order, IE... going from A... to ..Z. This would be like titles of mailing lists. Well... you mean other than "... ORDER BY 'fieldname' " ?? - Csongor --

Can't find hosts.frm -- permissions now okay?

I'm still getting the error 'Can't find hosts.frm' when I try to laund the mysql daemon. I've run the mysql_install_db script several times. I've changed the user and group ownership for all the files in the /usr/libexec/mysql directory, and also in /var/lib/mysql to 'mysql' (it was 'root'). (

Re: Load Data Infile command

> I'm new to the list so I apologize if this subject has been answered > already, I couldn't find a mailing list archive. Where did you look? http://www.mysql.com/documentation/searchlists.html PB - Before posting, please ch

newbie - linking queries with dynamic where conditions

Hi- I am trying to write a sql query that will output (domain, transport, sum(count), sum(size)) from multiple tables for many records. When the domain field is dynamic based on the adminId passed to the query, how do I execute the second query at the same time? Thanks in advance, Max select a.

RE: Sorting Results

ORDER BY field ASC|DESC --Joe -- Joe Stump <[EMAIL PROTECTED]> http://www.joestump.net -Original Message- From: Mike(mickako)Blezien [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 12, 2002 11:45 AM To: MySQL List Subject: Sorting Results Hello all, Is there away, within the sql

Re: Sorting Results

Cancel this! :) after reading it again, I realized a simple ORDER BY will do the trick nicely... Happy Holidays, >>Mike(mickako)Blezien wrote: Hello all, Is there away, within the sql query, to sort the query results in alphabetical order, IE... going from A... to ..Z. This would be like titl

Sorting Results

Hello all, Is there away, within the sql query, to sort the query results in alphabetical order, IE... going from A... to ..Z. This would be like titles of mailing lists. TIA -- MikeBlezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that

Re: Load Data Infile command

Try this when your logging into mysql, not when starting mysql. This works for me on Linux. mysql --local-infile=1 -u username-p - Original Message - From: "Jon Bertsch" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, December 12, 2002 12:02 PM Subject: Load Data Infile comman

Re: Remote Connection, please help

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Muhammad Salman wrote: > Dear Mark, real thanks , Are you refering to this > issues: > > Issue: > > "When I try to connect to the database with MySQL > Connector/J , I get the > following exception: > Yes. [snip] >>>Thanks Mark for your real quic

RE: problem with replication

Hi ... i have just tried by nothing's changed! ... i mean ... now in the "show slave status" i can see the right master_log_filename, log_position etc. but the error persists! What's wrong? help me please! Thanks and bye --- Maxime LEMAIRE <[EMAIL PROTECTED]> ha scritto: > hi, > try this : > >

Collective Row Concatenation

Hi, I am having a bit of a problem with my MySQL database, and I am hoping someone can help me out. I have a table, that currently contains 350 million rows, all of which basically contain a String (VARCHAR) of size 60 characters or less, and a bunch of other identifiers. These 350 milli

Re: More locking issues

Hi, Is not the same caseJeff didn't said anything about TRANSACTIONS. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message

Query from5tables

Hi I want to get data from 5 tables to a form..the tables are linked in the following way. AppointmentTable 1 to 1 client ClientTable one to many ClientStaffTable SaleStaffTable one to many ClientTable AttendantsTable many to one AppointmentTable AttendantsTable one to one ClientStaffTable And

Re: Compiling 3.23.54-1

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Michael T. Babcock wrote: tibyke wrote: the funny this is that 3.23.53 just worked (and compiled) fine, and '53 and '54 have exactly the same spec file. Did the mysql team change tools versions? automake/autoconf? Yes. You need automake 1.

load data local infile

Hi: I am using mysql v4_0_5 both clinet and server. I cannot get load data local infile to work after many different tries. Does anyone make it work with this version? It worked for when I used v3.23.52. Thanks for any tips, Yuyi --

MySQL 3.23.54 safe_mysqld fix

The following code is incorrect in safe_mysqld on 3.23.54 at least (that is all I have checked) Line 162: if $NOHUP_NICENESS -gt 0 then $NOHUP_NICENESS="nice --$NOHUP_NICENESS nohup" This needs to be: if test $NOHUP_NICENESS -gt 0 then NOHUP_NICENESS="nice --$NOHUP_N

Re: More locking issues

Gelu Gogancea wrote: If you have more than one user connected to the database which handled the same tables, you need to use LOCK/UNLOCK tables. MySQL daemon don't lock tables or records if you don't require this. Can I ask if this is in fact accurate? As I understand it, MySQL does a fairl

combine data from two tables

Hi, I'm hoping that someone can give me some pointers on this problem. I have two tables that contain similar data (eg, people.employees and people.volunteers). I need to run a select statement to retrieve names from both tables, and then display the data sorted by name so that it doesn't matt

Re: Remote Connection, please help

Subject: Remote Connection, please help I am using the official type 4 mysql driver from www.mysql.com but unable to make a remote connection with the mysql database running on our companie's remote server. I mailed some mailing mailing lists but didnt find out the right answer yet. I am using

Re: Compiling 3.23.54-1

On Thu, 12 Dec 2002 13:15:05 -0500 "Michael T. Babcock" <[EMAIL PROTECTED]> wrote: MTB> tibyke wrote: MTB> MTB> >the funny this is that 3.23.53 just worked (and compiled) fine, and '53 and '54 have exactly the same spec file. MTB> > MTB> > MTB> MTB> Did the mysql team change tools versions?

Re: Migration from Oracle

Dear Satish, > Thank you for your help. Your welcome. > I used MyODBC 3.51, and successfully migrated to MySQL. Is this a MySQL user stories case, or just a small migration? Regards, -- Stefan Hinz <[EMAIL PROTECTED]> Geschäftsführer / CEO iConnect GmbH Heesestr. 6,

Re: Compiling 3.23.54-1

tibyke wrote: the funny this is that 3.23.53 just worked (and compiled) fine, and '53 and '54 have exactly the same spec file. Did the mysql team change tools versions? automake/autoconf? -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock --

order results by count of searched expression

Hello mysql, I am trying to figure out sql command for ordering results descending by counts of searched expressions found in result. like this: $search="some"; TEXT | COUNTS | - Something has..| 4| Some have..| 3| Some take..| 1|

Re: More locking issues

Hi, If you have more than one user connected to the database which handled the same tables, you need to use LOCK/UNLOCK tables. MySQL daemon don't lock tables or records if you don't require this. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanen

Re: Remote Connection, please help

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 first a note: this is a topic best discussed on [EMAIL PROTECTED] * On Thu, Dec 12, 2002 at 08:35:40AM -0800, Muhammad Salman wrote: > I am using the official type 4 mysql driver from > www.mysql.com but unable to make a remote connection > with the m

Re: Remote Connection, please help

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Muhammad Salman wrote: I am using the official type 4 mysql driver from www.mysql.com but unable to make a remote connection with the mysql database running on our companie's remote server. I mailed some mailing mailing lists but didnt find out the ri

Group by problem

Hi, The following sql operators caused to incorrect results: CREATE TEMPORARY TABLE temp_list ( CurrID char(42) NOT NULL, OriginalID char(42) NOT NULL , DocRevision int(16) unsigned NOT NULL ) TYPE=InnoDB; insert into temp_list select CurrID, OriginalID, max(DocRevision) from some_tab

RE: Remote Connection, please help

I've never connected your way before. I'm using J/Connector from the MySQL site (http://www.mysql.com/downloads/api-jdbc-stable.html). That way I have no problems connecting. I do it this way: // connect to the database Class.forName("com.mysql.jdbc.Driver"); Connection dbConnection = Drive

Re: Compiling 3.23.54-1

hi, i get the very same problem with: rh 6.2 2.4.17 glibc-2.1.3-28 the funny this is that 3.23.53 just worked (and compiled) fine, and '53 and '54 have exactly the same spec file. what could be the problem then? regards, tibyke GP> I`m trying to compile 3.23.54-1 from src.rpm with error: GP>

Load Data Infile command

HI all, I'm new to the list so I apologize if this subject has been answered already, I couldn't find a mailing list archive. We just upgraded (?) mysql to 3.23.49. We are running it on Linux Redhat 7.3 The load data local command is turned off by default. I have attempted to follow the instru

More locking issues

Hi, I'm new to MySQL. I see you all talking about locking databases etc... but isn't that the point of having a database server? So you don't have to worry about record locks? I'm designing the backend for a popular site where a user's visit will result in multiple read/write operations on a d

Remote Connection, please help

I am using the official type 4 mysql driver from www.mysql.com but unable to make a remote connection with the mysql database running on our companie's remote server. I mailed some mailing mailing lists but didnt find out the right answer yet. I am using the following code for simple remote connect

RE: Select Where !=

> So... > Select n.uid, n.name from names_table n > LEFT JOIN exclude ON n.uid = exclude.n_uid > WHERE exclude.n_uid IS NULL; OK... this works, but I thought I would go a bit further... I have added a field in the exclude-table, "cat_id". This shows which catalogue the names have been excluded fr

RE: Select Where !=

> So... > Select n.uid, n.name from names_table n > LEFT JOIN exclude ON n.uid = exclude.n_uid > WHERE exclude.n_uid IS NULL; OK... this works, but I thought I would go a bit further... I have added a field in the exclude-table, "cat_id". This shows which catalogue the names have been excluded fr

re: Re: INNODB still not working Re: Does mysql support foreign keyon delete cascade and on update cascade?

On Thursday 12 December 2002 01:45, Jing Dai wrote: > I tried on delete cascade, it didn't work either. First of all , if you create table as you described in your previous mail, foreign key will not be created. You can check it with SHOW TABLE STATUS. Why? Because you specify .. FOREIGN

re: create table ... select ... w/ index

On Thursday 12 December 2002 05:52, Amittai Aviram wrote: > When you copy a table using CREATE TABLE ... SELECT ..., the indexes do not > get copied automatically. Is there a convenient way to transfer all > indexes, other than looking them up with DESCRIBE or SHOW INDEX and then > using either A

re: RE: RE: UPDATE

On Thursday 12 December 2002 03:32, Cesar Aracena wrote: > Exaclty, 0 rows affected, but no password changed... why's that? Thanks, If 0 rows were affected it's normal that password was not changed :) If you do a SELECT with the same condition, does MySQL find the any matched rows? -- For tec

re: locking issues

On Thursday 12 December 2002 14:06, Greg_Cope at sandwich dot pfizer dot com wrote: > I may be confused here but it would appear that when you issue a LOCK > TABLES tbl_name { READ|WRITE }; You cannot read from another unlocked table > in the same connection eg: > > mysql> LOCK TABLES users read

re: Re: MySQL user privilages

On Thursday 12 December 2002 10:03, Ryan McDougall wrote: > Alright I have tried to do the grant like the following: > > GRANT ALTER,CREATE,DELETE,DROP,INDEX,SELECT,UPDATE > ON "user%".* TO user@% IDENTIFIED BY "password"; > > GRANT ALTER,CREATE,DELETE,DROP,INDEX,SELECT,UPDATE > ON user%.* TO user@

RE: problem with replication

hi, try this : mysql > SHOW MASTER STATUS; +--++--+--+ | File | Position | Binlog_do_db | Binlog_ignore_db | +--++--+- + | some-file| XX | | |

Re: READ-COMMITTED does not behave as expected

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Horst Scheruga wrote: If I use the transaction isolation level of READ-COMMITTED, I have the problems that I do not see changes to the table made within another connection (and commited) until I call commit in my connection. As of my understanding

Re: MySQL4 on Linux with Intel Hyperthreading CPUs?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Keith Sauvant wrote: Hi Group, I have a new dedicated mysql 4.0.5 server running redhat 8.0 that we are testing. The new server is a dual Intel Xeon 2.4GHZ with hyperthreading enabled, so Linux thinks there are 4 cpu's rather than the 2 re

Re: Am I Violating Any Rules ?

In the last episode (Dec 12), Insanely Great said: > Dan Nelson wrote: > > In the last episode (Dec 11), Karam Chand said: > > > I want to statically link libmysql.dll with my closed source > > > application, which I have not planned to distribute freely or > > > commercial ? > > > > If you are not

Fwd: problem with replication

Any suggestion about this error? Thanks to all. --- Natale Babbo <[EMAIL PROTECTED]> ha scritto: > Data: Wed, 11 Dec 2002 17:03:51 +0100 (CET) > Da: Natale Babbo <[EMAIL PROTECTED]> > Oggetto: problem with replication > A: [EMAIL PROTECTED] > > Hi all, > > I have a problem with replication be

MySQL/InnoDB-3.23.54 is released

Hi! InnoDB is a MySQL table type which provides transactions, row level locking, foreign key constraints, and a non-free hot backup tool. InnoDB is included in MySQL-Max-3.23.54 and all downloadable versions of MySQL-4.0. You can download a free GPL version of these from http://www.mysql.com. 3.

Re: The Manual on MySQL is not updated...

Hi, About "bk -r get -Sq", after a bk pull, is "bk -r edit" still needed or "bk -r get -Sq" could replace it ? Thanks and regards, Jocelyn - Original Message - From: "Lenz Grimmer" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, December 12, 2002 2:56 PM Subject: Re: The Man

Re: porting MS SQL to mySQL

Here's some info that might help: nvarchar = MS$ variable character string, up to 4000 characters, stored as UNICODE UCS-2. AFAIK, MySQL doesn't (yet) support UNICODE directly. However, M$ SQL often forces the nvarchar/ntext types on by default. So, if you don't need UNICODE, use varchar. If you

Re: mysql-3.23.53 compile issue

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Tue, 10 Dec 2002, Darren Beale wrote: > I've an Sun Ultra Enterprise 2 desktop that is running a new (Patched) > build of Solaris 9 with GCC3.2, GNU Binutils (latest) and a few packages > like GNU Make, GNU sed, GNU tar from sunfreeware > > PA

Re: The Manual on MySQL is not updated...

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Wed, 11 Dec 2002, Dyego Souza do Carmo wrote: > http://www.mysql.com/doc/en/Installing_source_tree.html > > In the manual , to compile a "source" tree only type: > > shell> cd mysql-4.0 > shell> bk -r get -Sq > shell> aclocal; autoheader; auto

MySQL 3.23.54 is released

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, MySQL 3.23.54, a new version of the world's most popular Open Source Database, has been released. It is now available in source and binary form for a number of platforms from our download pages at http://www.mysql.com/downloads/ and mirror sites.

porting MS SQL to mySQL

Hi all- I need to know what the mySQL equivalents are to the following MS SQL datatypes: nvarchar smallint bit int ntext real datetime float money smalldatetime numeric decimal Thanks for your help! Tom - Improve your reimbursement rate and lower your risk for audit. The MMI Coding Hotline

RE: MySQL4 on Linux with Intel Hyperthreading CPUs?

If the OS can use hyperthreading, fortunately, benchmarks are showing that there's no preformance hits because of overhead created trying to keep resource contention down. This is good! So if your system _can_ support hyperthreading, leaving it on won't hurt, if it doesn't improve your system's per

Field type conversion question

I need to create a table that will store employees that attended certain events. I have two tables set up for this purpose. One (EmpTable) stores employee demographic information. The other (Events) stores information about the events (date, time, location, etc.) In EmpTable, the employee na

Compiling 3.23.54-1

Hi ! I`m trying to compile 3.23.54-1 from src.rpm with error: ... + mv Docs/manual.ps.save Docs/manual.ps + automake aclocal.m4: 1272: `AM_PROG_INSTALL' is obsolete; use `AC_PROG_INSTALL' aclocal.m4: 1273: `AM_PROG_INSTALL' is obsolete; use `AC_PROG_INSTALL' aclocal.m4: 1379: `AM_PROG_INSTALL' is

add multiple records as a result from an if statement

Hi, I have a form with two sections on it. The user either completes one or both sections. (The validation is controlled by JavaScript) at the moment no matter how many sections they complete all the information is added to one record(through asp). But what I want to happen, is if the user

re: Re: Mysql Hogging ram?

On Wednesday 11 December 2002 18:45, Benjamin Pflugmann wrote: > > These problems are causing me serious pain as whenever a large > > process starts my load avg jumps throught the roof. I run radius > > off of this database, and when the load jumps users fail to authenticate. > > Any help/sugestio

re: Newbie - auto_increment multiple table insert help

On Thursday 12 December 2002 07:23, Max Clark wrote: > I would like to run an insert query across two tables at the same time. The > first table has a primary key that is auto_increment, the second table > needs to insert the primary key from the first table as a reference? > > How do I auto-popul

re: Can't find file: './mysql/host.frm'

On Wednesday 11 December 2002 22:41, SLefevre at i-m-i-international dot com wrote: > OK, I'm making progess on my MySQL problem. The log file says this: > > "021211 15:32:05 mysqld started > 021211 15:32:05 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' > (errno: 13) > 021211 15:32:05

  1   2   >