Re: date problem

-do you have any index covering this query? -this is not a good practice to have function call(s) in the where clause, since mysql will make the fucntion call for every rows scanned. select count(*) as c from users_table where user_regdate 2002-06-01 00:00:00 -furthermore, in the where clause, =

MYSQL Relation n-m

I have a database on MySql divided into 3 tables books (idbook, and other fields) author (idauthor, and other fields) bookauthor (idauthor,idbook) This is to have more than 1 author for every book How can I make a query to select on one row all the authors of abook? Thanks Antonio

Re: replication problem

Hi, I already had a similar problem. I did the following things: I zipped my master database to unzip it on the slave and then I did a reset master,that's it. The reason why you have this problem it's certainly due to the fact that your master and slave database are not identical. you didn't

Re: MYSQL Relation n-m

I have a database on MySql divided into 3 tables books (idbook, and other fields) author (idauthor, and other fields) bookauthor (idauthor,idbook) This is to have more than 1 author for every book How can I select with a query on one row all the authors of abook? Thanks Antonio

RE: support UTF-8

Hi Shahzad, I also want to know whether mySQL support Unicode, utf-8 or not. If you know anything about this please answer me as soon as possible, Sincerely, Mehdi Zare -Original Message- From: shahzad sarwar [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 8:35 PM To: [EMAIL

RE: Select DATE, help ...

* Tom Jones I have a table with 2 columns StartDate and EndDate. I can't seem to figure out how to write a select statement that will tell me if the date I'm searching on is between the Start and the End date. Like, I want to know if 7/4/2002 is between 6/1/2002 (startDate) and 8/1/2002

RE: Maximum JOINED tables

* Harald Fuchs In article [EMAIL PROTECTED], Roger Baklund [EMAIL PROTECTED] writes: Yes... that is strange. There could be a bug in the crashme report, or the limit may have been lowered after 3.23.39, but neither of those seems very likely (to me, anyway)... anyone got a clue? I

Re: I have problem with a Cyrillic

Anelia, Thursday, June 06, 2002, 12:25:25 AM, you wrote: AT Description: AT I have problem with a Cyrillic when I use clauses ORDER BY AT and LIKE. AT They didn't work correctly. What character set do you use? Change you charset to cp1251 or win1251 or koi8_ru. -- For technical

Tinytext vs. char()

Hi! I store firstname, lastname, telephone etc in a table Is there any drawback with using tinytext? As I can see when I store strings that differ in length, the best would be to use tinytext, or? http://www.mysql.com/doc/n/o/node_369.html In terms of fulltextsearch/index etc. What is the

Re: RE: support UTF-8

Mehdi, Thursday, June 06, 2002, 11:27:24 AM, you wrote: MZ Hi Shahzad, MZ I also want to know whether mySQL support Unicode, utf-8 or not. MZ If you know anything about this please answer me as soon as possible, Unicode support will come in 4.1. Unicode in 4.1 will use UTF-8 and UCS2 with a

Re: More normalization

I think what you're getting at is that you're trying to consider both 'contactInfo' and 'entity' to be superclasses, with subclasses like 'phoneContactInfo', 'addressContactInfo', etc. and you'd like other tables to have fields which reference the superclass. Inheritance relationships are a

Re: mysql client

Jetaime, Wednesday, June 05, 2002, 11:45:56 PM, you wrote: J how can i setup a mysql server on a machine that is on the network to accept J connections from my machine. I downloaded the client and there is currently J a server running on a nother machine on the LAN. I inputed it's ip address J

Insert into longblob column, it's limitation

Good Day I will attempt to give you as much information about the software as I can before I ask the question. OS : RedHat 7.1 MySQL : Version 3.23.49a for Linux - binary distribution for pc-linux I want to insert into longblob column very big large data. but.. I have strange Errors...

Is View supported?

Is View supported by MySQL? if not supported, is there any other way to achieve it? I have a table of history data because the table is growing too much so I will divide it into 12 but I therefore have to modify all the programs if I can have a view of the original name that select from all

RE: Is View supported?

* Borus.Kung Is View supported by MySQL? no. if not supported, is there any other way to achieve it? I have a table of history data because the table is growing too much so I will divide it into 12 but I therefore have to modify all the programs if I can have a view of the original

Users

Hi all How do i create users in mysql.. After installing i just start mysql and connect to it.. Whats the default username and password it uses.. -Arul - Before posting, please check: http://www.mysql.com/manual.php (the

Re: Users

Hi! A little effort please http://www.mysql.com/doc/A/d/Adding_users.html and http://www.mysql.com/doc/D/e/Default_privileges.html EG Hi all How do i create users in mysql.. After installing i just start mysql and connect to it.. Whats the default username and password it uses..

RE: Mysql newbie show table question

* marc malacarme I can¹t seem to make any of the describe or show queries work when I apply a search statement: Query=show table status from demo; Works fine. Now I¹m trying to get info from only one table: Query=show table status from demo where name like user_access; Does no work. The

New additions on MySQL++ page

Hi! There have been some new additions on the MySQL++ page. First of all, thanks to the efforts of Clint Savage [[EMAIL PROTECTED]] and Arturs Aboltins [[EMAIL PROTECTED]] we have two new files : * mysql++1_7_1win32_borland_1_2.zip a new version of MySQL++ for Borland C++ with many bug

RE: MySQL or MS Access ?

[snip] Lastly only a few people will be able to use you application before MS Access fails... Therefore limiting access to your mission critical applicaiton I do not really think MS Access is for Mission-Critical databases...but I guess that depends on ther definition of mission critical. Most

Mysql text search and fulltext

(first some info and 'things that I want', then a few questions) Hi I'm actually using MySQL 4.0.1-alpha in a production system now. Only using MyISAM tables. ( http://www.gnist.no ) The only problem I have is that sometimes the database crash with some fulltext searches... And with only some

Re: processlist

If you include the following flag in the startup command, the logfile will be generated in the given location: --log=/var/log/mysqld.log Eivind sql, query - Original Message - From: Ritu Singla [EMAIL PROTECTED] To: Eivind A. Sivertsen [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]

Re: Users

Grant select, insert, delete ... on db.tb || db || * to username@host identified by password Alexander -- Mensagem Original -- Hi! A little effort please http://www.mysql.com/doc/A/d/Adding_users.html and http://www.mysql.com/doc/D/e/Default_privileges.html EG Hi all How do i

Merging Databases (Newbie)

Dear all, it's our first time to realize a project, based on mySQL Database and now we have a problem i hope we can solve easily. There are different partners in this project and the actual solution is based on a MS-Access Fronten (arrrggh!). Now the partner have to do some input and they all

Re: processlist

If you include the following flag in the startup command, the logfile will be generated in the given location: --log=/var/log/mysqld.log Eivind sql, query - Original Message - From: Ritu Singla [EMAIL PROTECTED] To: Eivind A. Sivertsen [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]

Re: Users

Arul, Thursday, June 06, 2002, 1:35:26 PM, you wrote: A How do i create users in mysql.. A After installing i just start mysql and connect to it.. A Whats the default username and password it uses.. Check our manual: http://www.mysql.com/doc/A/d/Adding_users.html

Re: Mysql text search and fulltext

Erlend, Thursday, June 06, 2002, 2:53:02 PM, you wrote: EHS I'm actually using MySQL 4.0.1-alpha in a production system now. Only using EHS MyISAM tables. ( http://www.gnist.no ) EHS The only problem I have is that sometimes the database crash with some EHS fulltext searches... And with only

Re: Tinytext vs. char()

Peter, Thursday, June 06, 2002, 12:29:53 PM, you wrote: PE I store firstname, lastname, telephone etc in a table PE Is there any drawback with using tinytext? PE As I can see when I store strings that differ in length, the PE best would be to use tinytext, or? PE

mysql query help

I need some help... The query below runs fine in access, when running it in mysql it tells me the column wrainfo.wuc doesn't exist in the having clause.. can't figure out why its giving me this error. the column is in the select statement... any ideas? The column does exist.. I'm looking at

on update problem?

When I try to change the id field in the parent table below, I get the error: 1217 - Cannot delete a parent row; a foreign key constraint fails. What have I got wrong? Shouldn't it cascade the changes that were made to the parent down to the child table? This is done with Mysql 3.23.50-max

RE: mysql query help

I've not looked over your query in-depth so I may be off-base here. Try removing the parentheses from the FROM clause and see if that makes it work. =C= * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.com * -Original Message- From: Scott Raley [mailto:[EMAIL

Re: on update problem?

Hi! don't think ON UPDATE is supported. The manual : http://www.innodb.com/ibman.html doesn't mention anything about it except : Starting from version 3.23.50 you can also associate the ON DELETE CASCADE or ON DELETE SET NULL clause with the foreign key constraint. EG When I try to change

ANN: EMS MySQL Manager 1.76 released

EMS HiTech company is announcing the next version (1.76) of MySQL Manager -- A Powerful MySQL Administration and Development Tool for Windows95/98/ME/NT/2000/XP. You can download the latest version from http://www.mysqlmanager.com/download.phtml What's new in version 1.76? 1. An ability to

RE: mysql query help

Actually it was the alias, but the query is producing the wrong results. It should produce 3 results which I get in Access I cut and paste this query into mysql and get 12371 results. Same databases. Cal Evans [EMAIL PROTECTED] on 06/06/2002 08:50:51 AM Please respond to [EMAIL

installing mysql++-1.7.9 on Suse-Linux 8.0

hello, I hav compiled and installed mysql++ without automake or autoconf just by typing ./configure make make install (Typing auto... bevore compiling makes everithing worse and make does not work - I don't know if that is the reason for following issues...) I want to build a program with

I KNOW one of you LISTers has experienced this

I've asked this question once before with no response (and have asked on other lists), I'll give it one more try before giving in to semi-Gates domination (my last holdout is the Apache server I'm running): Upon installing MySQL as a service, why will it not start for all users? Only my

Are FOREIGN KEYs used?

I studied the MySQL and InnoDB manual, but I did not find anything about the internal usage of foreign keys. I mean if I define a foreign key it is good for me, because the InnoDB engine does not let the database to get integrity errors. But I think the foreign key definitions could be used in

RE: I KNOW one of you LISTers has experienced this

[snip] I've asked this question once before with no response (and have asked on other lists), I'll give it one more try before giving in to semi-Gates domination (my last holdout is the Apache server I'm running): Upon installing MySQL as a service, why will it not start for all users? Only my

Re: Installation problems on AIX 4.3.3

Borus, Thanks for responding. I am attempting to install a binary release not build from source. Do you have any information regarding the errors in my original post? Thanks Morris Ford --- é¾?æf æ¨?(Borus.Kung) [EMAIL PROTECTED] wrote: FYI this may help Borus - Original

Re: still not-empty set

Maybe if (!($result)) { Try print STDERR RESULT=$result\n; to see what you are comparing to. Chris Hohimer wrote: thanks for all the replies!! but it is not working. here is the loop: if($result == EMPTY SET){ $Scheduled = NULL; } else{ $Tech = mysql_result($result, 0,

Re: Is it possibile to have something similar?

No you can't, but check out LIMIT. Marco Stagno wrote: IMHO, The Right Thing to do this, is to create the additional data in your application (as you said you won't change the table). (...) thank you! If you want this with SQL for sure, using user-defined variables will work: cool.

[MyODBC]Access denied for user: 'ODBC@localhost'

Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = S1000 (General error) [TCX][MyODBC]Access denied for user: 'ODBC@localhost' (Using password: NO) The error occurred while processing an element with a general identifier of (CFQUERY), occupying document

Re: SV: building tree view in mysql?

Hello I think, there's a better solution: Use one database - field for sorting (for example SORT). Then you need to fill in values in this field, that satisfy your needs: Root - Item 1. Hello You 1.1. test1 1.2. test2 2. cool 2.1 cool i 2.2 cool ii ... The values of the

Installing MySQL++

hello, I hav compiled and installed mysql++ without automake or autoconf just by typing ./configure make make install (Typing auto... bevore compiling makes everithing worse and make does not work - I don't know if that is the reason for following issues...) I want to build a program with

MYISAM Compressed table corruption

Hi, I've observed some table corruption: How-To-Repeat: no idea, but maybe you might have one ;) $ mysql -hxxx Escherichia_coli_O157_H7 Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Didn't find any fields in

UDF problems

Hi all, I have tried several times to integrate the lookup functiction into mysql but with no luck. :( I have REDHAT 7.3 with gcc 2.96 and with mysql-3.23.49 I compiled udf_example.so and copied into /usr/lib folder. When I try to do CREATE FUNCTION lookup RETURNS STRING SONAME

Re: SV: building tree view in mysql?

Hello I think, there's a better solution: Use one database - field for sorting (for example SORT). Then you need to fill in values in this field, that satisfy your needs: Root - Item 1. Hello You 1.1. test1 1.2. test2 2. cool 2.1 cool i 2.2 cool ii ... The values of the

How to rotate replication logs

I have a question about how to rotate replication logs in MySQL V 3.23.49. I've tried to use the command purge master logs to 'logname', however, I'm unclear what to specify for 'logname'. On my master, I have several old log files which are no longer being used (by issuing the command show slave

Re: [MyODBC]Access denied for user: 'ODBC@localhost'

ok, rebooting didn't fix it, reinstalling myodbc didn't fix it, creating a user ODBC@localhost fixed it. all off a sudden i need a user named ODBC@localhost, and last i checked, i'm the only one here that knows anything about how to use mysql here at the office. so what might have been

Re: Installation problems on AIX 4.3.3

Morris, Thursday, June 06, 2002, 6:17:57 AM, you wrote: MF I am having a problem installing version 3.23.50 MF on AIX 4.3.3. When I execute mysql_install_db or MF try to start mysqld I get errors like MF 0509-036 Cannot load program MF ./bin/my_print_defaults because of the following MF errors:

Re: RE: Maximum JOINED tables

Roger, Thursday, June 06, 2002, 12:08:13 PM, you wrote: I just tried a multiple self join on 4.0.1 and got the following DBD::mysql::st execute failed: Too many tables. MySQL can only use 31 tables in a join at ./x2.pl line 47. RB Me too, running 3.23.30-gamma on w2k: mysql desc select *

Re: [MyODBC]Access denied for user: 'ODBC@localhost'

Ray, Thursday, June 06, 2002, 4:39:11 PM, you wrote: R Error Occurred While Processing Request R Error Diagnostic Information R ODBC Error Code = S1000 (General error) R [TCX][MyODBC]Access denied for user: 'ODBC@localhost' (Using password: NO) R The error occurred while processing an

Re: Insert into longblob column, it's limitation

¼ÛÅÂÈ£, Thursday, June 06, 2002, 1:08:07 PM, you wrote: ¼ I will attempt to give you as much information about the software as I can ¼ before I ask the question. ¼ OS : RedHat 7.1 ¼ MySQL : Version 3.23.49a for Linux - binary distribution for pc-linux ¼ I want to insert into longblob column

Re: SV: building tree view in mysql?

This problem is already solved in Oracle. It it the CONNECT BY PRIOR statement which recursively queries a table. The good news is that I read in the MySQL manual, that this feature will be implemented in MySQL in the Real Near Future :-). (MySQL manual: 1.8.2 Things That Must be Done in the

mysqlhotcopy broken ???

It appears the v4.0.1 mysqlhotcopy perl script has been modified and broken. When using cp for the backup it's passing a null value for the file(s) to be copied. Below is a session clipping of an execution with --debug turned on: #

Newbie MySql

Hi Everyone. I need to run an extract of some data from our Oracle DB's. One of the restrictions is that I need to write a SQL script that will parse through a particular field for a / and if found, I have to remove it and output the data without the slash. I have minor experience with selecting

mysqlshow incompatibility (3.23.39 -- 4.0.1-alpha) ?

Dear listmembers, I've got 2 hosts running Linux: hostnames are 'hegel' and 'fidel' me@hegel:~mysqladmin version mysqladmin Ver 8.21 Distrib 3.23.39, for pc-linux-gnu on i586 me@fidel:~mysqladmin version mysqladmin Ver 8.23 Distrib 4.0.1-alpha, for pc-linux-gnu on i686 When logged in to

faster update

Hello, I was wondering if there was a better way to speed up my update statement in my perl script. It goes through all the entries in the database , which is around 800, 000, and then updates the email field. The problem is that it takes to long. thanks in advance for any help here

MySQL back-up methodology

Hello, I am trying to develop a back-up procedure for our MySQL database. The database is housed on our production Web server. My thought is to simply make a slave on our file server that is backed up. I use InnoDB type tables and my application uses transactions. I am wondering how

Re: faster update

On Thursday 06 June 2002 9:51 am, Greg D. wrote: I was wondering if there was a better way to speed up my update statement in my perl script. It goes through all the entries in the database , which is around 800, 000, and then updates the email field. The problem is that it takes to

Re: faster update

On Thursday 06 June 2002 08:53 am, you wrote: On Thursday 06 June 2002 9:51 am, Greg D. wrote: I was wondering if there was a better way to speed up my update statement in my perl script. It goes through all the entries in the database , which is around 800, 000, and then updates

RE: answer to MySQL service problems

[snip] I've asked this question once before with no response (and have asked on other lists), I'll give it one more try before giving in to semi-Gates domination (my last holdout is the Apache server I'm running): Upon installing MySQL as a service, why will it not start for all users? Only my

Re: [MyODBC]Access denied for user: 'ODBC@localhost'

in the DSN settings, each datasource has a different username and password. and looking over the DSNs, none of them should be using the username ODBC@localhost. On Thursday 06 June 2002 9:18, you wrote: Ray, Thursday, June 06, 2002, 4:39:11 PM, you wrote: R Error Occurred While

installing mysql++-1.7.9 on Suse-Linux 8.0

hello, I hav compiled and installed mysql++ without automake or autoconf just by typing ./configure make make install (Typing auto... bevore compiling makes everithing worse and make does not work - I don't know if that is the reason for following issues...) I want to build a program with

RE: answer to MySQL service problems

[snip] All of this is occuring on the same W2K machine (with Apache, MySQL, etc). When I log off admin and log on as a power user (same machine) I have the aforementioned problems. [/snip] Kirk, OK, this makes sense. The power-user(s) needs to be given permissions to start and stop services on

Size of BLOB and TEXT columns

In SQL DDL, what are the maximum sizes of the various BLOB and TEXT column types? TINYBLOB, BLOB, MEDIUMBLOB and LONGBLOB and the corresponding TEXT types? I've searched the manual but couldn't find these specs. At what point should I choose BLOB over TINYBLOB, and so on? TIA, Arthur

Re: Problems starting MySQL as a Service for all users

Kirk, I am somewhat confused by your question. I must misunderstand what it is that you are trying to ask, because what it appears that you are asking makes no sense. Once MySQL was installed as a service, why does it matter which account starts it? Are you not the admin on the box? Are

Re: faster update

I'm a bit confused by what you mean here; are you just updating the 'ktjnews' column, or are you attempting to reset the 'email' column as well? (The source says the first, your comments suggest the second.) Further, exactly which part of this is too slow? Obviously, each query will require

RE: Size of BLOB and TEXT columns

[snip] In SQL DDL, what are the maximum sizes of the various BLOB and TEXT column types? TINYBLOB, BLOB, MEDIUMBLOB and LONGBLOB and the corresponding TEXT types? I've searched the manual but couldn't find these specs. At what point should I choose BLOB over TINYBLOB, and so on? [/snip]

RE: WHERE-ing an alias...

[snip] WHERE ap_type='Original Movie Poster' ORDER BY sort_title ASC HAVING sort_title LIKE 'G%' ORDER BY sort_title ASC You may have to swap the HAVING and ORDER BY lines of the query, [/snip] Thanks so much. There was a slight syntax change, replacing your first ORDER BY with a GROUP BY, but

Re: Maximum JOINED tables

* Victoria Reznichenko [...] RB So... is the crashme report wrong? Or was the limit really 32 RB in 3.22.39, got lowered to 31 in later versions (like 3.23.30- RB gamma), raised to 63 in version 3.23.39, and then lowered to RB 31 again (at least in versions 3.23.47 and 4.0.1)...? RB URL:

make of mysql 3.23.37 --with-debug fails on AIX 4.3.3 with xlc_r/xlC_r compiler

Summary: On AIX 4.3.3, using xlc_r/xlC_r compiler, configured with --with-debug, make all in client directory fails with: ld: 0711-317 ERROR: Undefined symbol: ._db_enter_ ld: 0711-317 ERROR: Undefined symbol: ._db_return_ ld: 0711-317 ERROR: Undefined symbol: _db_on_ ld: 0711-317 ERROR:

Re: I KNOW one of you LISTers has experienced this

Only users of the Administrators group on NT can start system services by default. Have a look in your user manager for domains, policies, user rights Kind Regards, Chris Knipe MegaLAN Corporate Networking Services Tel: +27 21 854 7064 Cell: +27 72 434 7582 - Original Message - From:

Re: Is it possibile to have something similar?

No you can't, but check out LIMIT. Ops, but I did it! grin Using a variable and a temporary table as Benjamin and Keith wrote in the prev. messages ciao ciao! MAS! -- I love MySQL :-) -

Re: faster update

Hello Greg, maybe it can be of some help: - Try ( if memory is not a problem ) to read the entire file in memory, inside an array, and use foreach() in the array. It is quicker than reading line by line from the HD; - And you may try to mount your

RE: Problems starting MySQL as a Service for all users

I don't think this makes sense either, but you will see what I mean: FOR MY ADMIN ACCOUNT C:\netstat -a -p tcp Active Connections Proto Local Address Foreign AddressState TCPdynamic:http dynamic:0 LISTENING TCPdynamic:epmap

Re: on update problem?

It would seem strange to implement one and not the other? The help does say that you can use it and does keep the create options now. Does anyone know if this will be implemented in the next .5x release? Ross Me writes: Hi! don't think ON UPDATE is supported. The manual :

Re: Problems starting MySQL as a Service for all users

FOR MY ADMIN ACCOUNT C:\netstat -a -p tcp TCPdynamic:3306 dynamic:0 LISTENING FOR THE REGULAR USER ACCOUNT C:\netstat -a -p tcp TCPdynamic:3306 dynamic:0 LISTENING

Re: SQLPrepare problems

Problem Solved. Thx! Mateus Begossi - Original Message - From: Mateus Begossi [EMAIL PROTECTED] To: [EMAIL PROTECTED]; MySQL List [EMAIL PROTECTED] Sent: Wednesday, June 05, 2002 10:27 PM Subject: SQLPrepare problems Hello everyone, I´m writing a VC++ 6.0 App that among many other

sub-queries

Lo all, are sub-queries supported on mysql-max 3.23.49 ?? If they are, what's wrong with the following statement? SELECT monitorhosts.HostID FROM monitorhosts WHERE monitorhosts.HostID NOT IN (SELECT HostID FROM monitorhostgroupdetails WHERE

Re: sub-queries

I'm sorry to disappoint you, but subqueries are NOT supported int any MySQL version, yet. You can read the MySQL manual about it. You can find there when and how it will be implemented. Bye Daniel At 21:39 2002.06.06. +0200, you wrote: Lo all, are sub-queries supported on mysql-max

Re: sub-queries

Fair enough (and also what I thought) Does anyone have any idea how I can implement the below in a similar fashion then? I have a list of items, and a list of groups. I want to retrieve all the items from a table that is not in a specific group... - Original Message - From: Kiss

Re: sub-queries

SELECT monitorhosts.HostID FROM monitorhosts, monitorhostgroupdetails WHERE monitorhosts.HostID = monitorhostgroupdetails.HostID AND monitorhostgroupdetails.HostGroupID != '1'); Gruss Sabine Chris Knipe wrote: Lo all, are sub-queries supported on mysql-max 3.23.49 ?? If they are,

RE: sub-queries

Select monitorhosts.HostID from monitorhosts left join monitorhostgroupdetails on monitorhostgroupdetails.HostID = monitorhosts.HostID where monitorhostgroupdetails.HostGroupID !='1'; * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.com * -Original Message-

Re: sub-queries

*MWAH*!!! Thanks a million, tested and working beautifully Can't believe in two days I didn't think of this... -- me - Original Message - From: Sabine Richter [EMAIL PROTECTED] To: Chris Knipe [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, June 06, 2002 10:14 PM

Normilazation and Optimization

Hey all, I've been searching for references on the web and even been to stores ;) regarding the above subject. But I am reluctant to purchase ATM because there are so many books out there on the subject. So I figured I'd go to the list and ask the question. What are peoples opinion's on the

A design question

Hi, I have a design question for mysql database that I am wanting to create a my movies collection. I was going to do as one-to-one database, but I see now that I need to do as a one-to-many. I have never done a one-to-many but I see that is the way to go. I guess then is can someone show me

Re: sub-queries

Ok, I spoke to soon... And this is starting to drive me up the walls now... i.e. getting REALLY irritating and frustrating. mysql DESCRIBE monitorhosts; +--+--+--+-+-+-- --+ | Field| Type | Null | Key | Default |

Thanks

Thanks Charles for your patience and help. I removed winmysqladmin from startup and ALL problems went away! When winmysqladmin started up on the other user accounts it would somehow block connections to MySQL (since before I uninstalled, on normal [non-admin] user accounts, I could not

Re: Thanks

Strange indeed... Might be worth checking if this can be reproduced... This can perhaps be something worth mentioning in winmysqladmin (possible bug?) - Original Message - From: Kirk Brannan Babb [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, June 06, 2002

InnoDB Hot Backups... ALL OR NOTHING ???

Can you backup/restore just one MySQL database with InnoDB hot backup? From what I gather it's an all or nothing proposition. As I understand it, there's only one tablespace (with any number of data files) and all database tables of type 'InnoDB' are comingled in the one tablespace. Therefore, if

Thread based optimization?

Dear list, After doing a good bit of reading, the details are still hazy. I have a web-based application (about 20 tables, with up to 100,000 records per table - but most tables are much smaller). 99% of select queries are very very fast. However, there is the occasional select query that

Re: Thanks

You are very welcome. I am glad I was able to help. Charles Q. At 03:58 PM 6/6/2002 -0500, k wrote: Thanks Charles for your patience and help. I removed winmysqladmin from startup and ALL problems went away! When winmysqladmin started up on the other user accounts it would somehow block

mysql binding to a port

We have a situation that I was wondering if anyone had an answer to. We have a situation where we have multiple mysql boxes being used in random order for load balancing and fault tolerance. Basically the app chooses one of the machines at random, and if it can't get a connection, it tries

Re: mysql binding to a port

On Thu, Jun 06, 2002 at 02:49:05PM -0700, Shakeel Sorathia wrote: we start up mysql. Mysql binds to the port, then it takes about 15 seconds for innodb to startup and get ready to start serving requests. Problem is that in this 15 seconds a few hundred connections have queued up to

full text with union pb

Hi all, I ve got some errors while making a query that managing match (full text) and union, both on boolean mode and the other mode. When I m working with like i get no error. I m working with mysql 4.01 4.02. Tables have the sames number of fields ... Indexes seems to have been created ...

RE: sub-queries

Chris, sounds like you're looking for an exclusive left outer join. You want to see records from monitorhosts, where there is no corresponding record in monitorhostgroupdetails, right? Use: Select * from monitorhosts left join monitorhostgroupdetails on monitorhosts.HostID =

Re: sub-queries

- Original Message - From: Kevin Fries [EMAIL PROTECTED] To: 'Chris Knipe' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, June 07, 2002 12:38 AM Subject: RE: sub-queries Chris, sounds like you're looking for an exclusive left outer join. You want to see records from

mysql database quota problems.

Hello, I want to set quota to mysql database by every database or by every user, I can not find any issues from mysql official website, and I don't think the Linux or FreeBSD File System quota solution is effective, who can help me? Thank you in adanced. Regards, Asong.

where i can write my script

i want to know where a can write my script in running and use mysql. recently i save in a file a two statement and it work what i expect to be done, i'm wondering what is the most easiest programming language could i use to write my script. for ur info i'm using win98 mysql 3.29.49

  1   2   >