Re: select lock - How reliable?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Roger Baklund wrote: [snip] > A connection pooling implementation without this isolation, where multiple > users can share the same database connection at the "same time" is either > broken or intended for a special purpose (some non-multi-statement p

Re: select lock - How reliable?

* Hassan Schroeder > Roger Baklund wrote: > > > Ouch. Very special, imo... this means the connection is > > re-negotiated for each statement? Sounds strange. Maybe the > > client connection is 'virtual' or 'by proxy', so that multiple > > users actually share the same connection at the same time? >

Re: Certification Question

I'm also interested to take up the certification exam on Mysql, pl. guide me how to proceed to get certification on the same, I'm in India (chennai). -aman. Arjun Subramanian wrote: I took the MySQL core certification exam on the 2nd of January and Passed. I was just wondering when MySQL actually

Certification Question

I took the MySQL core certification exam on the 2nd of January and Passed. I was just wondering when MySQL actually sends out the Certificate and other stuff they said they would send out? Does anyone here have any experience with this ? Thanks in advance. Arjun Subramanian Georgia Tech Station 3

Re: New INstall of MySQL

Hi, make sure the existing directories has been removed fully, then continue with new installation, after installation is over, pl. restart the system, if mysql daemon has not started, pl. go to ..\mysql\bin\ directory & run winmysqladmin.exe. mysql service will be strated to work.. -Aman. Ch

Re: Table lock statistics by TABLE not just server,db

On Fri, Jan 09, 2004 at 01:43:53PM -0800, trevor%tribenetwork.com wrote: > Mysqlians, > I am trying to determine in some of my database tables should be > converted from MyISAM to Innodb. I have read that a collusion on 10-20% is > the threshold at which one should convert( current # a

Re: MySQL Service starts and then Stops

Could you post the contents of you my.cnf (or my.ini) file? What OS are you trying to run the server on? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: NOT NULL fields in INNODB Tables

* Donal Murtagh > My DB consists of INNODB tables, such as... > > > CREATE TABLE user > ( > name VARCHAR(255) NOT NULL > > ) TYPE = INNODB; > > > The NOT NULL qualifier doesn't have the effect I expected. Although I > can't do this... > > INSERT user VALUES (null); > > > I can do this: > > INSERT u

Re: select lock - How reliable?

Roger Baklund wrote: Ouch. Very special, imo... this means the connection is re-negotiated for each statement? Sounds strange. Maybe the client connection is 'virtual' or 'by proxy', so that multiple users actually share the same connection at the same time? If you want to think of it that way, y

Re: Problems loading a TEXT field

mark wrote (1/9/2004): On Friday 09 January 2004 01:44 pm, Diana Soares wrote: From the manual, check: * the file must be on the server * you must specify the full pathname to the file (ok, you did this) * you must have the FILE privilege Ahhh! Misunderstood that one. Got it, now. Thanks. Stil

Re: select lock - How reliable?

* Hassan Schroeder > Roger Baklund wrote: > > > ok... If you did this: > > > > - create temp table > > - use temp table > > - drop temp table > > > > for each session, I would expect it to work. (atleast until a session > > crashes before it drops the temp table.) > > This is straying from the orig

Re: select lock - How reliable?

Hassan Schroeder said: > Roger Baklund wrote: > >>>Maybe I don't understand connection pooling, then. Isn't its purpose >>> to allow a client -- say, a webapp running in Tomcat -- to multiplex >>> requests for *multiple* end users over a single connection? >> >> Almost... except for the 'single con

Re: mysql database, user table, two root accounts

As [EMAIL PROTECTED] and [EMAIL PROTECTED] are separate entries in the user table, each with its own password and privileges, they are 2 separate root accounts from mysql's perspective. You could choose to think of them as the same account by keeping their settings the same, or you could choose

NOT NULL fields in INNODB Tables

Greetings, My DB consists of INNODB tables, such as... CREATE TABLE user ( name VARCHAR(255) NOT NULL ) TYPE = INNODB; The NOT NULL qualifier doesn't have the effect I expected. Although I can't do this... INSERT user VALUES (null); I can do this: INSERT user VALUES (""); I appreciate

Re: Problems loading a TEXT field

On Friday 09 January 2004 01:44 pm, Diana Soares wrote: > From the manual, check: > > * the file must be on the server > * you must specify the full pathname to the file (ok, you did this) > * you must have the FILE privilege Ahhh! Misunderstood that one. Got it, now. Thanks. Still don't understa

MySQL Service starts and then Stops

OK this may be weird. I still have got no further than my last post, but when I start the service it starts it then it appears to stop it 10 seconds later I see this in the MySQLAdmin screen> I am totally lost on this. Chris L. White Network Administrator Coe-Truman Technologies, Inc. Email: [E

Re: select lock - How reliable?

Roger Baklund wrote: ok... If you did this: - create temp table - use temp table - drop temp table for each session, I would expect it to work. (atleast until a session crashes before it drops the temp table.) This is straying from the original question :-) but my understanding of temp tables is

Table lock statistics by TABLE not just server,db

Mysqlians, I am trying to determine in some of my database tables should be converted from MyISAM to Innodb. I have read that a collusion on 10-20% is the threshold at which one should convert( current # around .3%). However the table_locks_waited and table_locks_immediate coun

Re: Time Zone

Roger Baklund wrote: * Jochem van Dieten Functionally, I believe it is much cleaner as it abstracts the problem away from the developer. Especially around DST changes this can be an important issue. I agree again. But it doesn't answer my question... I suppose you can live without timezones untill

Re: select lock - How reliable?

* Hassan Schroeder [...] > Not errors, just the same temp table being shared across end > user requests. ok... If you did this: - create temp table - use temp table - drop temp table for each session, I would expect it to work. (atleast until a session crashes before it drops the temp table.) >

Re: tuning key_buffer_size

 Thomas wrote: > > Hello all, > > My mySQL 4.1.0 server is currently set to use a key_buffer_size of 32M. My > server has 1GB of RAM, and is now using only InnoDB tables. > > The manual says that 'Key_reads/Key_read_request ratio should normally be < > 0.01'; mine is ~ 0.12; the manual also say

Re: compiling mysql with ssl

Thanks for your reply, I do that but it's was unsuccesful. With theses options i get the following error when i do MAKE: ../readline/libreadline.a -lncurses ../libmysql/.libs/libmysqlclient.so -L/usr/lib -lz -lcrypt -lnsl -lm -lssl -lcrypto -Wl,--rpath -Wl,/usr/local/compiled/lib/mysql ../libmysq

RE: mysql database, user table, two root accounts

Yes, this helps thank you. -Original Message- From: Arjun Subramanian [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 2:16 PM To: 'Leo Donahue'; [EMAIL PROTECTED] Subject: RE: mysql database, user table, two root accounts That's not two root accounts. What that means is this: T

RE: mysql database, user table, two root accounts

That's not two root accounts. What that means is this: The first line defines privileges for root connecting from localhost The second line defines privileges for root connecting from any remote host. Hence the "%". It implies [EMAIL PROTECTED] Hope this helps. Arjun Subramanian Georgia Tech Sta

Re: select lock - How reliable?

Roger Baklund wrote: OK, but the "user" here is the servlet container (Tomcat), *not* the human end user. That should not make a difference, as seen from the server a client is a client. Huh? OK, Tomcat is the client of the MySQL server; "user" or "client", same situation. As would temporary table

Re: select lock - How reliable?

* Hassan Schroeder [...] > OK, but the "user" here is the servlet container (Tomcat), *not* > the human end user. That should not make a difference, as seen from the server a client is a client. > As would temporary tables, which is why I stopped using them for > request-specific data :-) Right.

mysql database, user table, two root accounts

I am less than 24 hours new to MySql. I have executed the following sql scripts: use mysql; delete from user where User=''; delete from db where User=''; flush privileges; select host, user, password from user; The last sql query yields the following: hostuserpassword -

RE: New INstall of MySQL

OK I actually did as you described and it started up fine, well at least I think it did. I open the WinMySqlAdmin 1.4 window and it says not found: Driver Version:03.51 Driver: C:\windows\system32\myodbc3.dll API Level:2 Setup: C:windows\system32\myodbc3.dll SQL Level:1 It has no ot

Re: select lock - How reliable?

Roger Baklund wrote: Maybe I don't understand connection pooling, then. Isn't its purpose to allow a client -- say, a webapp running in Tomcat -- to multiplex requests for *multiple* end users over a single connection? Almost... except for the 'single connection' part. It will maintain a pool of c

Re: Time Zone

* Jochem van Dieten > > Woudn't the "proper way" be the way that leads to a result you can live > > with? Of course support in the server would have been better, > > but why can you not use a mechanism as described above? > > Using AT TIME ZONE is the way supported by SQL:1999, which makes > it the

Re: select lock - How reliable?

... and of course the _point_ of connection pooling: one assumes that there is overhead involved connecting to the server, thus you would avoid a lot of "connect/one-small-session/close" and instead have fewer "connect/many-small-sessions/close". It is relatively fast to connect to MySQL, making c

Re: New INstall of MySQL

Comment out this line: datadir = c:/SQLData in the my.ini file in your windows (winnt) folder and remove the my.cnf from your c:\. Start the server. The default location of the data folder is c:/mysql/data. You told it to look in c:/SQLData and it can't find it's security database. Also you s

Re: select lock - How reliable?

* Hassan Schroeder > > In what situation is this unsafe? In general, you would not call > > LAST_INSERT_ID() without first having done an INSERT in the > > same session, and even with connection pooling you would usually > > use the same connection for all statements related to a session. > > What

Re: Time Zone

Roger Baklund wrote: * Jochem van Dieten The proper way to program this would require MySQL to support the AT TIME ZONE construct, but I haven't found it on the MySQL roadmap yet. Woudn't the "proper way" be the way that leads to a result you can live with? Of course support in the server would ha

Re: Problems loading a TEXT field

>From the manual, check: * the file must be on the server * you must specify the full pathname to the file (ok, you did this) * you must have the FILE privilege * the file must be readable by all and be smaller than max_allowed_packet If the file doesn't exist or can't be read due to one of the

Problems loading a TEXT field

Table's defined with ... "content TEXT" field, but when I issue the command insert into content values ( 'test', '', 'index.html', 1.000, 'index.html','','', load_file('/home/projects/URCMS/test/index.html'), 'import', now(), 'test', 'import', 0,''); either as script input, or from the sql comma

Re: select lock - How reliable?

Roger Baklund wrote: LAST_INSERT_ID() is connection specific, so it is safe from the concurrency issue. Note: "safe" may not apply if you're using connection pooling :-) In what situation is this unsafe? In general, you would not call LAST_INSERT_ID() without first having done an INSERT in the sam

Re: select lock - How reliable?

* Hassan Schroeder > > LAST_INSERT_ID() is connection specific, so it is safe from the > > concurrency issue. > > Note: "safe" may not apply if you're using connection pooling :-) In what situation is this unsafe? In general, you would not call LAST_INSERT_ID() without first having done an INSERT

Re: mysqld without LinuxThreads

On Fri, 2004-01-09 at 05:14, Chris Nolan wrote: > On Fri, 2004-01-09 at 20:58, Andy Bakun wrote: > > On Thu, 2004-01-08 at 05:24, Chris Nolan wrote: > > > > > 3. Wait for a while. Linux 2.6 includes (as does the RedHat 9.0 and > > > ES/WS/AS 3.0 kernels) NPTL - the Native POSIX Threads for Linux >

Re: Subtracting date fields

On Sat, 2004-01-31 at 14:57, Kenneth Letendre wrote: > Hello, > >I'm trying to get the difference (in days) between dates stored in two > date fields. >My query: > > SELECT id,(firstdate- postdate) AS diff FROM calendar > >This works fine if the two dates are in the same month, but

Re: Time Zone

* Jochem van Dieten [...] > > The $usertimezone contains an integer between -12 and +12, > > representing the offset in hours of the user timezone compared > > to the server timezone. A user in the same timezone as the > > server would have $usertimezone=0. > > Some locations have timezone offsets

Re: compiling mysql with ssl

I had the same problem, just don't know what is wrong with the red hat ssl packages. I did this: 1.- download a fresh copy of openssl, configure with --prefix=/opt/OpenSSL, compile and install, everything will go to /optOpenSSL, so, the new version won't conflict with the red hat's 2.- compile m

Re: compiling mysql with ssl

You'll want this: --with-openssl-libs=/usr/local/ssl/lib (not /usr/lib) -Greg G Cion Chen wrote: I have Redhat 9 with openssl-0.9.7a-20 tring to re-compiling mysql-4.0.17 again with the options: ./configure --with-openssl --with-openssl-includes=/usr/include/openssl --wi th-openssl-libs=/usr/li

Re: New INstall of MySQL

OK!, first of all, do you have a complete-working directory of mysql in whatever drive you installed mysql?, this is usually in c:\mysql. I asked this because the installer doesn't seems to work. Also there is no need for a my.cnf and a my.ini, you should only use one, one is enough, i rather use m

Re: compiling mysql with ssl

I have Redhat 9 with openssl-0.9.7a-20 tring to re-compiling mysql-4.0.17 again with the options: ./configure --with-openssl --with-openssl-includes=/usr/include/openssl --wi th-openssl-libs=/usr/lib --with-vio --prefix=/usr/local/compiled There is messages that is coming: checking if we should

Re: Time Zone

Roger Baklund wrote: The date/time returned by the server is in the timezone of the server. If you need to convert it to a different timezone, you must do this within your application. It can be done directly in the SELECT statement. PHP example: $usertimezone = get_user_prefs('timezone'); $res = m

Re: Problem with 'OR' statement

Your current statement, with the OR, says to select a record if its name is not FIND_ME or if its name is not OPEN. That will be all of them. I expect you want all of them except the ones named FIND_ME and OPEN. So, you want AND instead of OR, because logically, "NOT (this OR that)" = "NOT t

Re: Problem with 'OR' statement

Jess, You should use an AND (&&) instead of the OR. You result is everything, correct? When the query is doing the machinename != 'FIND_ME', the record(s) with machinename = 'OPEN' are being returned. Likewise, when the machinename != 'OPEN' is being performed, the records(s) with machinename =

Re: Problem with 'OR' statement

Am Friday 09 January 2004 17:57 schrieb Stefan Kuhn: > Am Friday 09 January 2004 17:22 schrieb Hunter, Jess: > > Could someone have a look at this syntax and give me some guidance what I > > may be overlooking? > > > > SELECT * from $TableName WHERE machinename != 'FIND_ME' OR machinename != > > 'O

Re: Problem with 'OR' statement

Am Friday 09 January 2004 17:22 schrieb Hunter, Jess: > Could someone have a look at this syntax and give me some guidance what I > may be overlooking? > > SELECT * from $TableName WHERE machinename != 'FIND_ME' OR machinename != > 'OPEN' Some other thing: Instead of saying "where x!=a and x!=b" y

Re: Problem with 'OR' statement

Am Friday 09 January 2004 17:22 schrieb Hunter, Jess: > Could someone have a look at this syntax and give me some guidance what I > may be overlooking? > > SELECT * from $TableName WHERE machinename != 'FIND_ME' OR machinename != > 'OPEN' A query like "where x=a or s=b" will always return all valu

Re: select lock - How reliable?

LAST_INSERT_ID() is connection specific, so it is safe from the concurrency issue. Note: "safe" may not apply if you're using connection pooling :-) -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com

Re: Converting an Access Table to MySQL

Victor, It's at the same URL www.mysqlfront.de I'm not sure it's stable yet Subject:Re: Converting an Access Table to MySQL From: Victor Medina <[EMAIL PROTECTED]> To: zzapper <[EMAIL PROTECTED]> Copies to: [EMAIL PROTECTED] Date

Problem with 'OR' statement

Could someone have a look at this syntax and give me some guidance what I may be overlooking? SELECT * from $TableName WHERE machinename != 'FIND_ME' OR machinename != 'OPEN' I can make the statement work individually, but when I try to add the 'OR' statement it fails to 'remove' the designated

Re: Knowing the real size of a column

In the last episode (Jan 09), Director General: NEFACOMP said: > I have tried it but it failed to give me that size. It only works > when the content is a CHAR or VARCHAR. It just returns the number of > characters, not the disk size. Isn't that the same thing? LENGTH() would really be better, si

New INstall of MySQL

Ok I have a question. This is the first time any of us here in our office have installed MySQL or for that fact worked with MySQL. So I got stuck with trying to figure it out. Ok here is the problem. I completely removed the previous MYSQL installation attempt. I started new to install MYSQL.

Re: select lock - How reliable?

LAST_INSERT_ID() is connection specific, so it is safe from the concurrency issue. See and for more. Michael Alfredo Cole wrote: El Jue 08 Ene 2004 19:56, Paul DuBois escribió: At 19:

Re: Time Zone

* Hassan Shaikh > How do I change datetime from one time zone to another? I've a > column in one of my tables having the type DATETIME and I need to > show date AND time to end-user based on his/her preference. The date/time returned by the server is in the timezone of the server. If you need to c

Re: Converting an Access Table to MySQL

thanxss! :) On Fri, 2004-01-09 at 12:04, zzapper wrote: > On Fri, 09 Jan 2004 11:48:42 -0400, Victor Medina <[EMAIL PROTECTED]> > wrote: > > > > > > >hey hey hey! wait a second there! is there a new mysqlfront? :o where > >can i download it? :) 3.0??? I already love and worship mysq

Re: apostrophe error

I don't use ASP and VBScript with Macromedia Dreamweaver, but I think the problem here is that you've misunderstood what is needed, rather than that Dreamweaver's escaping mechanism doesn't work. Let me try to explain. Mysql has no trouble with apostrophes in the data. The problem comes when

Re: Converting an Access Table to MySQL

On Fri, 09 Jan 2004 11:48:42 -0400, Victor Medina <[EMAIL PROTECTED]> wrote: > >hey hey hey! wait a second there! is there a new mysqlfront? :o where >can i download it? :) 3.0??? I already love and worship mysqlfront 2.5, >i thought it was dead :( >do you have a link? Victor, It's at the same

Re: Converting an Access Table to MySQL

On Fri, 2004-01-09 at 11:44, zzapper wrote: > On Fri, 9 Jan 2004 20:40:44 +0530, "Nitin Mehta" > <[EMAIL PROTECTED]> wrote: > > >you need not write any scripts, just use MySQL Front to Import/Export dat from M$ > >Access > > Are you using MySqlfront2.5 (the original) or the new 3.x? > > BTW I

Re: Converting an Access Table to MySQL

On Fri, 9 Jan 2004 20:40:44 +0530, "Nitin Mehta" <[EMAIL PROTECTED]> wrote: >you need not write any scripts, just use MySQL Front to Import/Export dat from M$ >Access Are you using MySqlfront2.5 (the original) or the new 3.x? BTW I already use/love 2.5. That's why I post to Usenet to be told t

RE: Converting an Access Table to MySQL

I have ported several table from access to MySQL with good results. Within Access right click on the table you are interested in and export, then select odbc data sources and off you go Regards John B -Original Message- From: Nitin Mehta [mailto:[EMAIL PROTECTED] Sent: 09 January 20

Re: import data from text files

Armin, 1)When you say that the records are duplicate, do you mean the record number(first field) or or do you mean the entire record is a duplicate? 2)Now to load a file made out of comma separated fields into a table that was created in the same field format, here are 2 ways: a)mysql> USE

Time Zone

Hi, How do I change datetime from one time zone to another? I've a column in one of my tables having the type DATETIME and I need to show date AND time to end-user based on his/her preference. TIA. Hassan

Re: Converting an Access Table to MySQL

you need not write any scripts, just use MySQL Front to Import/Export dat from M$ Access "zzapper" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi Ya, > > How to this has always been somewhat fuzzy in my head. I looked around > for tools unsuccessfully . So I thought I'd share

Re: Convert query from v4 syntax to v3

On 9 Jan 2004 at 15:33, Roger Baklund wrote: > * Rory McKinley > [...] > * Odhiambo Washington > >> I have a query that executes well when run on MySQL-4.x, but not 3.23.x: > [...] > > I can't see what is throwing the syntax error..p'raps I am just > > being dense. > > "Note that INNER JOIN synta

Re: import data from text files

* Armin > I've got two problem with mysql , maybe it is not a real > 'problem' but i need help hardly ! :) > > 1 > in a table , we got many record ( 1400 ) , some of them are > equal , i want to delete just one of them , in other word , i don't > want two record equal . Take a look at SELECT

tuning key_buffer_size

Hello all, My mySQL 4.1.0 server is currently set to use a key_buffer_size of 32M. My server has 1GB of RAM, and is now using only InnoDB tables. The manual says that 'Key_reads/Key_read_request ratio should normally be < 0.01'; mine is ~ 0.12; the manual also says 'Key_write/Key_write_requests i

Re: apostrophe error

Man I have been banging away at this for a week and I am only just getting to a point where I am finding a resolution. There seems to be a lot of info out there for this kind of thing, but very little on how to implement it. I use ASP and VBScript with Macromedia Dreamweaver so with asp I can

Re: Convert query from v4 syntax to v3

* Rory McKinley [...] * Odhiambo Washington >> I have a query that executes well when run on MySQL-4.x, but not 3.23.x: [...] > I can't see what is throwing the syntax error..p'raps I am just > being dense. "Note that INNER JOIN syntax allows a join_condition only from MySQL 3.23.17 on. The same i

Re: Convert query from v4 syntax to v3

On 9 Jan 2004 at 16:48, Odhiambo Washington wrote: > * Rory McKinley <[EMAIL PROTECTED]> [20040109 13:21]: wrote: > > On 7 Jan 2004 at 11:04, Odhiambo Washington wrote: > > > > > > > > Hello, > > > > > > I have a query

Re: Mysql by itself?

On Thu, 2004-01-08 at 21:23, EP wrote: > OK, I need to ask a stupid question. > > I normally run MySQL on Apache. I have a second machine [a laptop] which I > can't get Apache to run on [the ports are restricted/closed]. Is there a > way to run MySQL without a server like Apache underneath it?

import data from text files

hi list , I've got two problem with mysql , maybe it is not a real 'problem' but i need help hardly ! :) 1 > in a table , we got many record ( 1400 ) , some of them are equal , i want to delete just one of them , in other word , i don't want two record equal . 2 > i got a text file , which m

Re: Convert query from v4 syntax to v3

* Rory McKinley <[EMAIL PROTECTED]> [20040109 13:21]: wrote: > On 7 Jan 2004 at 11:04, Odhiambo Washington wrote: > > > > > Hello, > > > > I have a query that executes well when run on MySQL-4.x, but not 3.23.x: > > > > SELECT popbox.loca

Re: select lock - How reliable?

El Jue 08 Ene 2004 19:56, Paul DuBois escribió: > At 19:16 -0600 1/8/04, Alfredo Cole wrote: > >Hi: > > (...) > >The code I use is: > > > >select lock > > Sorry. It's select get_lock... > >get code > >add one to code > >write code > > > >release lock and select release_lock... > > That

ON UPDATE CASCADE

Hello, If I change the value of a reference a , for instance by means of updating or inserting values, I'd expect both updated values and inserted values to cascade, hence to change b, where FOREIGN KEY (b) REFERENCES A(a) ON UPDATE CASCADE In this example foreign key and reference are

embedded MySQL on arm

hi, I'm working on a project with an arm-CPU in an embedded system, so there are a few hardware limits like slow CPU, little RAM and very little ROM (Flash). I hope to get a MMC-Interface running to use for data storage. I'm very free to chose a db and version and don't need much features. Now i

Re: Mysql by itself? [err: 10061]

I think the point is, that when you installed it, there was a "dependency" was it mysql? or was it apache? I am thinking it was apache, maybe the auth_mysql was compiled with it, so it needed the mysql to run porperly. Apche has a module that allows it to authenticate users against a db server li

Converting an Access Table to MySQL

Hi Ya, How to this has always been somewhat fuzzy in my head. I looked around for tools unsuccessfully . So I thought I'd share my solution. I've just written a simple Perl script to do this, this uses DBI:mysql to write to mysql and DBI:ODBC to read from Access. I suppose it could be rewritten i

Re: apostrophe error

Try using QUOTE function. Asif Iqbal wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi All I have been using mysql database to collect my syslog data. It was working fine. However recently I had few logs that had apotrophe and I failed to insert those lines into my database. It said syntax e

Re: Recommended Course

Hey why not travel to Dhaka in my tour & learn package. I teach 1. C/C++ on Unix/Win32/MFC 2. MySQL C API uses with MySQL 3. C+CGI+MySQL+MySQL C API 3. MySQL Administration Tour & learn package available vice-versa tooo!!! If you can provide passage. Marc Dver wrote: This might be a bit of a repe

Re: Problems with fulltext search in boolean mode

Mark van Herpen <[EMAIL PROTECTED]> wrote: > Sure, > > SELECT ID, companyName, streetName, houseNo, postalCode, city, firstName, > lastName, debNo, houseNoExt , MATCH (companyName, streetName, city, > postalCode, lastName, firstName) AGAINST ('Mark -Nijmegen' IN BOOLEAN MODE) > AS score > FRO

Re: Free software to design forms and report

I am a new to MySQL. Would like to find out if there is any free software out in the market to design forms and report that links to MySQL. I am looking at a local database, forms and report. How about DBForms? http://jdbforms.sourceforge.net/ DbForms enables developers to build sophisticated w

Re: mysqld without LinuxThreads

On Fri, 2004-01-09 at 20:58, Andy Bakun wrote: > On Thu, 2004-01-08 at 05:24, Chris Nolan wrote: > > > 3. Wait for a while. Linux 2.6 includes (as does the RedHat 9.0 and > > ES/WS/AS 3.0 kernels) NPTL - the Native POSIX Threads for Linux > > implementation which is superior in many ways and does

Re: MYSQL Aborting

"Chris L. White" <[EMAIL PROTECTED]> wrote: > Need some help on this one. We are using the MYSQL on Server 2003. This > is what I keep getting: > > Microsoft Windows [Version 5.2.3790] > (C) Copyright 1985-2003 Microsoft Corp. > > C:\MySQL\bin>mysqld --console > > InnoDB: The first specified dat

Re: Knowing the real size of a column

Yes, I am using ADO. But, I wanted to know the size so that the application may decide to download the content. I wanted to download the content if its size is below 1MB. ADO will know the size after downloading it; is it right? I might be wrong!!! Thanks Emery - Original Message - From:

Re: Knowing the real size of a column

I have tried it but it failed to give me that size. It only works when the content is a CHAR or VARCHAR. It just returns the number of characters, not the disk size. Thanks Emery - Original Message - From: "Egor Egorov" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, January 0

Unknown character set: 'latin1_swedish_ci'

"040109 11:06:17 Unknown character set: 'latin1_swedish_ci'" I get thousands of this Messages in the Errorlog, since I switched from 4.1.0 to 4.1.1 SHOW COLLATION LIKE 'latin1%' Collation | Charset |Id |Default |Compiled |Sortlen latin1_german1_ci | latin1 | 5 | |

Re: Convert query from v4 syntax to v3

On 7 Jan 2004 at 11:04, Odhiambo Washington wrote: > > Hello, > > I have a query that executes well when run on MySQL-4.x, but not 3.23.x: > > SELECT popbox.local_part, popbox.password_hash, popbox.domain_name, CONCAT(domain.path,'/',popbox.mbox_name) AS path FROM popbox JOIN domain USING (do

Re: mysqld without LinuxThreads

On Thu, 2004-01-08 at 05:24, Chris Nolan wrote: > 3. Wait for a while. Linux 2.6 includes (as does the RedHat 9.0 and > ES/WS/AS 3.0 kernels) NPTL - the Native POSIX Threads for Linux > implementation which is superior in many ways and does not use clone() > at all. As you'll no longer want to use

Re: mysqld without LinuxThreads

Thanks a lot for your kind and amusing explanation! I will have a look at MySQL thread layer AND of course wait for kernel 2.6.. Chris Nolan wrote: On Thu, 2004-01-08 at 21:10, [EMAIL PROTECTED] wrote: Andy Bakun wrote: On Wed, 2004-01-07 at 10:38, [EMAIL PROTECTED] wrote: Hi al

Re: how to determine user Privilege fields

Can I create a php script like: No. Try this: $privSQL = "SHOW GRANTS FOR 'paul'@'localhost';"; $priv_result = mysql_query($privSQL) or die("Couldn't Select Priv"); while($myrow = mysql_fetch_row($priv_result)) { echo "$myrow[0]"; } I believe this only returns a single row with the grant sta