Re: Unable to download MySQL (fwd)

to save the file to disk - both appear to be required to open the RPM. Right-click should give you a list of options. Also shift-click should *force* the save operation. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676

Re: Still problem with MyODBC :((

If you are using MyODBC, then the suggestions regarding a 'client prior to 4.1' *DO* apply to you. MyODBC is built against 4.0.x, so you must follow the instructions for connecting with a pre-4.1 client. Either that or downgrade the server to 4.0.x. -- Daniel Kasak IT Developer NUS Consulting

Re: sql problem

=child.parent_id group by parent.id; The 'left join' is important if you want to return a count even if there are no children. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL

Re: sql problem

' to a numeric zero ( 0 ). -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http

Re: sql problem

' then 1 else 0 end end ) as CountChildren which should also work ( untested but looks right ). I use this when I get a couple of layers of if() statements - it's a lot easier to understand. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North

Re: reports slows down network

be a good one to look at too. Dan -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives

Re: Prepared Statement questions/issues

statements ). -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http

Re: reports slows down network

any of your config files or queries, there's not much more to be said. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au

second write process hangs if another one is writing already,!!bu t in another database!!] bug???

' 'CXX=gcc' mit freundlichem Gruß / kind regards Daniel Beuter SIEMENS IS IT PS 221 OP4 Network Solutions Werner von Siemens Str. 60 91052 Erlangen Fon: +49 (9131) -6303-211 Fax: +49 (9131) 7-42234 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto

Problem with database loading

fix that problem. Now I have the only purpose to time the write processes per cronjob :-( P.S: The reading at same time is no problem while writing is on, If I read from web-interface in the tables. Thanxx for help mit freundlichem Gruß / kind regards Daniel Beuter SIEMENS IS IT PS 221 OP4

Mysql-Prozesse lassen sich nicht mehr killen :-(

den mysqld neu zu starten Was kann ich tun um die Zombies ohne reboot zu beenden. Benutze fedora core1 und mysql Ver 12.22 Distrib 4.0.20, for pc-linux (i686) mit freundlichem Gruß / kind regards Daniel Beuter SIEMENS IS IT PS 221 OP4 Network Solutions Werner von Siemens Str. 60 91052 Erlangen

AW: Mysql-Prozesse lassen sich nicht mehr killen :-(

should let me kill all these processes. (but not always) -Ursprüngliche Nachricht- Von: KSTrainee [mailto:[EMAIL PROTECTED] Gesendet: Montag, 16. August 2004 14:56 An: Beuter Daniel Betreff: AW: Mysql-Prozesse lassen sich nicht mehr killen :-( Hallo, ein Hinweis vorweg: Bitte nur

Re: books about mysql tuning

I've just made it through the MySQL Certification Study Guide and have found it to have pretty good coverage of tuning as well as other subjects. There are probably more in-depth sources available, but it might be a good place to start. - Dan-o On Aug 9, 2004, at 12:42 AM, Eko Budiharto

Re: AM software (access dump) and GUI

I am by no means a phpMyAdmin guru, but the version I have (2.5.7) has an option for it, accessible by clicking on the Databases link from the main page. I suspect, however, that they will give you a single database that you will not have the DROP DATABASE privilege for and that you will

Server will only start manually when logged in as root with 4.1.3

I'm unable to get the 4.1.3 server to start automatically at startup or even manually unless I'm logged in as root. I'm on an iBook G4. I downloaded and installed the mysql-standard-4.1.3-beta-apple-darwin7.4.0-powerpc binary and the associated startup item. I've done this successfully with

Re: What would you store in a BLOB field?

Another use for binary columns is for case-sensitive text such as passwords. If you store text in a CHAR, VARCHAR, or TEXT column, comparisons will not be case-sensitive unless you use the BINARY keyword. An example (from section 6.3.22 of the Language Reference: mysql SELECT a = A;

Re: Purpose of (was Re: mysqld_safe)

in the foreground and will remain 'tied' to the console you started it from ... so if you close the console / xterm you may kill the mysqld_safe process. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2

Re: SELECT difficulties

You need to use the 'GROUP BY' clause: SELECT offerid, resellerid, MIN(price) FROM A GROUP BY resellerid; Cheers, Dan On Jul 30, 2004, at 2:37 PM, Haitao Jiang wrote: Hi, there Maybe this question is not MySQL specific, but I just wondering if MySQL has any way to doing this: I have a table A like

Re: what os to use for mysql on amd64?

updates to ALL parts of your system. If you run anything else and you try to upgrade glibc, for example, you are a damned fool! So basically you can install Gentoo on your system and keep it current without re-installing everything. -- sig Daniel Kasak IT Developer NUS Consulting Group Level 5

Show Index Into Cursor?

Is there a way to force the results of Show Index From table Into a table? TIA Dan

RE: Show Index Into Cursor?

] Sent: Friday, July 16, 2004 11:35 AM To: 'Daniel Cummings '; '[EMAIL PROTECTED] ' Subject: RE: Show Index Into Cursor? You will have to put the value in a resultset and scroll through the resultset. Natively you can do this with MySQL 4.0.x but you could use a programming language. -Original

Get Updated Rows

Is there a way of getting the number of updated rows without using the API calls? TIA Dan

RE: Comparisons Through VFP not working properly

Roles This was just to determine how MySql was translating the parameter. It turned out to be a double in this new table. Dan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, July 15, 2004 7:00 AM To: Daniel Cummings Cc: [EMAIL PROTECTED] Subject: Re

Comparisons Through VFP not working properly

I'm using SqlPassthrough In VFP 8.0 Ive got a Sql statement that looks like this. This following fails: Update User Set Active = True Where UserId = ?pnUserId pnUserId is 222 in this instance. The following works fine: Update User Set Active =

Re: Stored Procedure Limitation

libraries that are compiled against MySQL-4.1 or newer, and MyODBC-3.51.x is not. According to the comments at the bottom of my bug: MyODBC 3.53 is near completion but no date has been set yet. ie you will be waiting for quite some time. -- sig Daniel Kasak IT Developer NUS Consulting Group Level 5,

Re: Control Center autoincrement

'. In it, there should be a check box called 'Auto Increment'. Select the field you want, and click the check box. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED

Handling threads

2.4.22 - Red Hat Linux 7.3 2.96-110 #3 SMP - 4GB RAM - 4 Xeon processors Thanks in advance Daniel Eliav Sharvit _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- MySQL General

Re: converting timestamps to US Date format

: date('m/d/Y', $row10['modified']); $row10['modified'] is the timestamp from the mySQL database I want to convert from. Thanks in advance. You want to use MySQL's date_format, eg: date_format(modified, '%m/%d/%Y') From memory anyway. Check the documentation. -- Daniel Kasak IT Developer NUS

Re: ER Diagrams with mysql

time... It's not free. I don't know of any free ER tools. Or at least none I've found and investigated were good enough to remember. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email

ANN: gtk2-gladexml_DBI_helper-0.1

Hi all. I'm pleased to announce the first public release of my first open-source project: a Perl class to automate the synchronization of data from a database server ( via DBI ) with fields on a Glade-generated form ( for a Perl / Gtk2 app ). MS Access users take note: an alternative is on the

Re: referential integrity for MyIsam

dont know how to do it after reading the documentation for some times So anyone ever face such issue?? Thanx Flame Don't like InnoDB? -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email

Using Access as client all fields are marked #Deleted

of diagnostics makes this very difficult. Thanks in advance, Daniel Eliav Sharvit _ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail -- MySQL General Mailing List For list archives

Re: php-mysql RPM

you can get that on the mysql-client package On Wed, 30 Jun 2004 00:35:13 -0500, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hi, I'm installing the php-mysql-4.3.6-1.3.i386.rpm and it's complaining about a dependency libmysqlclient.so.10. My mysql server version is 4.0.20. Can anyone

Collations

Hi Everyone, I used MySQL 4.1.0 and I've just upgraded to 4.1.2. I have noticed that several character sets and collations are just disappeared somehow from the new version. I have checked it with the 'show collation' and 'show character set' command. Is there any switch or configuring option

Re: Newby to loading

Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.704 / Virus Database: 460 - Release Date: 6/12/2004 Daniel Godefroy 3445 Ridgewood, 109 73, Rue Lambert Montreal Petion-ville Quebec, Canada

Re: Returning where COUNT 5

With a join and group by I think you have HAVING. Hi all how to do this in MySQL? Returning only records with COUNT 5? SELECT `groups`.`groupsDescr`, `roles`.`roles_Agroup`, `roles`.`rolesDescr`, COUNT(`roles`.`rolesDescr`) AS TOTAL FROM `roles` INNER JOIN `groups_roles` ON

Re: MySQL Installation Problem

After the phpmyadmin login I got the same error. In the phpmyadmin config files I had to set the local IP address that phpmyadmin was on. Dear Michael, I want to use PHP, Apache, mySQL and phpMyAdmin for evaluation but I m not able to get this rite. I am trying to instal MySQL with

Re: Update problem

echo $updatequery to screen and see what the sql looks like. I am trying to update a table from results generated from a select query, but can't seem to get the queries running right. The select query works fine, but when I try to use the results for an update it error out. Here is my

Re: Erro on Query

Try back ticks around it. `DESC' Dear Friends. when Creating the follow table CREATE TABLE CONHEC_DBF (CON CHAR (7) , SER CHAR (2) , NUMNF CHAR (8) , SERNF CHAR (2) , LOJA CHAR (2) , PAIDF CHAR (12) , QUANT REAL (6,0) , NOP CHAR (10) , TRAN CHAR (4) ,

Re: MySQL vs Oracle

10 seconds !?Unless that query is huge and without indexes, it should run MUCH quicker. I'm using Oracle 8.0.5 and MySQL 4.1.1a I'm not optimizing Oracle nor MySQL, because I don't want future users messing with optimizations. I access through JDBC drivers. Oracle usually needs 10

Re: Learning PHP/MySQL

I like the web site www.phpbuilder.com ... lots of great articles. Hi All, Can someone recommend a good book for learning PHP/MySQL? TIA, Kay -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: DBI and last_insert_id()

with DBI. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http://lists.mysql.com

DBI and last_insert_id()

, and the data is inserted. However the above line that fetches the last_insert_id value from MySQL always returns undef. The table has an auto_increment column. What's going on? Dan -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2

Re: Notifying User when DB is Updated via browser

How about an HTML meta tag refresh set at 20 minutes. This may be slightly off-topic, apologies if so but I was wondering if anyone could point me in the right direction. I'm currently storing applications from a web site into our mysql DB, our client has a web-based backoffice. He has to

Re: autoincrement problem

Nitin wrote: Hi all, What will be the best way to implement auto increment field. I dont want to use auto increment feature, as it only appends the numbers but doesn't check for the values deleted. Suppose, following are the values in table 1abc 2bcd 3cde .. .. .. 9

Re: load data infile

, doesn't make any sense. Any thoughts much appreciated. You're not viewing the data in MySQLCC are you? It only shows the first 1000 records. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989

How do you display last modified date

, I've been looking online as well but thought this may be quicker. Take care. Thanks again. Daniel

Re: error 2013 : Lost connection to MySQL server during query

on the same connection. Anybody writing server-side applications using the C api, please beware of this issue. I can suggest a few workarounds if anybody else out there is having the same problem with their C program. Daniel Daniel Whitener wrote: Hello all, I'm getting the error message 2013

Re: Production release of MySql 4.1

Emmanuel van der Meulen wrote: Hello all, Does anyone have an estimate of when MySql 4.1 will be released for production. MySql.cm says soon. Please advise, would that likely be weeks/months? Kind regards Emmanuel Months. I'd say at least 6 months. -- Daniel Kasak IT Developer NUS Consulting

Re: Asterisks in Integer Columns

One simple option would be to add a footnote column. And add in your code, if footnote column is NOT NULL then add a * on to population and show footnote at the bottom. population footnote 100 null 200*yada yada Suppose I have several columns of numberals -

Re: I'm working on a library redesign, and need help

ask me. Anyway you can safely ignore it if you're not importing data from a fixed-width file. For more info see 'load data infile'. The backticks are there to aid MySQL in parsing the string later in case you have used reserved words or strange characters. -- Daniel Kasak IT Developer NUS

Subquery help...

help :) -Daniel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Subquery help...

cl.name = 'Some Company'; Just in case you are using mysql 4.0 or earlier... Thanks very much! This is what I need :) Also, while I'm at it, any book recommendations for getting to know MySQL better? Thanks again :-) -Daniel -- MySQL General Mailing List For list archives: http

error 2013 : Lost connection to MySQL server during query

coding is the problem. Any help or ideas will be greatly appreciated. Thanks in advance! Daniel Whitener basic config info is below. I can provide more details if needed... I'm using suse 9.1 uranus:~ # uname -a Linux uranus 2.6.4-52-default #1 Wed Apr 7 02:08:30 UTC 2004 i686 i686 i386 GNU

Re: Completely Stumped - phpMyAdmin config

I remember something setting mine up. The phpMyAdmin.ini (I think) had to have the correct IP address of the machine/database it was running on. My machines internal address was 192.168.2.100, but the INI setting had to be the outside resolved IP 24.16.xx.xx if running it from outside. Hello:

Re: RV: Select data from two different databases

Yes Local. SELECT databasename.tablename.columnname Hi, two questions: Is it possible to select data from different Databases on the same server? Is it possible to select data from different Databases on Different servers across the network? I searched for information on how to do it,

Re: Where do exported SQL files go?

Using phpmyadmin, when I select Export, and click the checkbox Save as File, it prompts where for where and what file name. I'm trying to figure out how to get my MySQL databases online. Someone told me to EXPORT my databases as SQL files, then go into my online websites's phpMyAdmin program

Speed differences between joins and subqueries?

, and also a detailed explanation on which is to prefer and why. Cheers Daniel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Perl arrays into MySQL

learning Perl myself. The above code is NOT tested. But you should be able to get the idea anyway :) -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http

Re: Optimizing Queries (specifically with LIMIT)

I found it interesting. Thanks Eric. (reconstructed from archives i accidentally deleted the copy in my mailbox Daniel Clark writes: I don't see how LIMIT would make a difference. LAST_INSERT_ID() only returns one record. But it's worth trying in a big loop to get timing numbers. Well, I

Re: changing an auto_increment value in innodb

if you have foreign keys set up. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives

Re: Optimizing Queries (specifically with LIMIT)

I don't see how LIMIT would make a difference. LAST_INSERT_ID() only returns one record. But it's worth trying in a big loop to get timing numbers. I have a rather simple straightforward question that I was not able to find in any of the documentation. I am in the process of writing an

Re: query with escape characters

Hi, How can I make a query that looks for a city that has a ' in the name? For instance, I am looking for the name S'ARENAL, but the query below does not work: SELECT intl_localidades.id, intl_localidades.codigo_pais, intl_localidades.localidad_es,intl_zonas.zona,intl_paises.pais_es FROM

Re: Optimization

try using explain Hi All, How can we optimize MySQL queries, plz define easy method comparing as well as better performance for data retrieval. Regards: aaziz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

RE: Understanding Explain in 4.1

Victor- It's a little misleading. It looks like it's going to do a full table scan of the Monday table. Dan -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 25, 2004 6:18 AM To: 'Daniel Cummings '; '[EMAIL PROTECTED] ' Subject: RE: Understanding

Large database with High Availability - how to do it?

hardware (if at all possible) or knows other solutions that you can make high availability and share the load to the DB servers please give me some suggestions. Cheers Daniel PS. For those who would like to know more about the GFS: (http://www.google.se/search?q

Adding to a record

Hello. Quick easy question I think? I display a INT value to a page (php) by querying mysql. I want to be able for someone to put a new number and add to that record. How would I go about doing this. Would this be a mysql command or a php thing? Thanks in advance.

Would MySQL 4.1 (Cluster) be a good solution?

of my mail that takes time. The odd part is that it doesn't seem like the machine sets the limit. Does anyone know what could make a difference? I thank you very much for taking the time and effort and looking and hopefully answering my mail Regards Daniel -- MySQL General Mailing List For list

Would MySQL 4.1 (Cluster) be a good solution?

of my mail that takes time. The odd part is that it doesn't seem like the machine sets the limit. Does anyone know what could make a difference? I thank you very much for taking the time and effort and looking and hopefully answering my mail Regards Daniel -- MySQL General Mailing List For list

Understanding Explain in 4.1

These are two simple stock quotes tables that contain a symbol and a close amount. Explain Select Monday.Symbol, Friday.Close, Monday.Close From Monday Force Index(Symbol) Inner Join Friday Force Index(Symbol) ON Monday.Symbol = Friday.Symbol Symbol is a VarChar(20) in both

Locking tables in MyIsam

Hi there, this is a bit of black art, but I would like to setup locks on inserting back queries and updates on MyIsam tables which need fulltext search and other tables are Innodb. I am having issues with this query LOCK TABLE complaint_threads as ct WRITE, complaint_info as ci WRITE; For some

'group by' does a free 'sort by'?

Hi all. I've noticed that if I do a 'group by xxx' I get the results sorted by xxx ( when I'm only grouping on 1 field ). It seems to happen that way every single time. Is this faster than doing both a 'group by' and 'sort by', and is it something I can rely on? Just curious... Dan -- Daniel

OT: anyone had a surge of spam recently?

Hi all. Over the last 2 days, both my home and work email addresses have been hit with a sudden surge in spam, and the content in both cases is the same. Another strange thing is that my home address got basically none - until now. I'm assuming my addresses have been harvested from this list,

Heap table limitations

We want to convert a 200+ meg table to a heap table. We've gotten pretty good performance converting from InnoDb to MyIsam table but converting to a heap table would give an even bigger performance boost. Does making a heap file this large make any sense? Are there size limitations to

Multi-threading problems in MySql

We have one query which takes approximately 2 minutes. MySql seems to be unresponsive to any other threads until this query has completed. Are there some settings that aid with this kind of problem? TIA Dan

Re: Foreign Key problems

' form. Try anything else and you're asking for problems. Dan -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL

Re: Question

Sid Taleb wrote: When I query I dont see the value of some primary key, I dont understand why, Can you tell me? Yes. There is a problem somewhere. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2

Re: WHERE pk1 AND pk2 returns 0 records

Possibly two rows? Can you change the where clause? WHERE CartID=999 OR ProdID=333 I have a simple query: SELECT * FROM cart WHERE CartID=999 AND ProdID=333 The primary key is made of both CartID and ProdID, both integers. The query will not return the record in question This returns

Re: Show table status query

to 574. I am running 4.0.13 on MAC OS/X 10.3 and the table is an INNODB table. Has anybody else ever seen this? Regards Andy Yes that's normal behaviour for an InnoDB table. It's in the docs somewhere. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW

Re: Automatically optimizing a table - how should I so this?

Joshua Beall wrote: Hi All, Is there a way to automatically optimize a table anytime data is changed. I have a table that only has changes made to it occasionally (average over a 1 week period is probably 1 row is updated each day), and I would like it to automatically optimize the table, rather

Re: Inserting in a auto-inremental column

other. Either way, it's a little dodgy, but the above way is better. Dan -- signature Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http

Re: fastest filesystem for MySQL

Sasha Pachev wrote: Based on what I've seen so far, JFS and XFS do not yet have a solid track record of stability with MySQL. This does not mean they could not be good - I just do not trust them yet. I do vaguely remember a support case when a very strange corruption happened on either one of

Re: Connecting to db via win32 (Word or Excel)

Thomas Nyman wrote: Hi all I'm a mysql beginner. I have my database up and running and can query it via php and apache. I would like to set things up so that MSExcel and or MSWord can query the database and extract info from it. For this reason I downloaded the and installed

Re: Database design.. Asking again

both. If you don't need any features of InnoDB, I suppose it wouldn't be too much of a hassle setting up merge tables - just in case. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email

authentication problem on non-standard port

I am having problems authenticating to a machine where there are two database instances running. The instance which listens on the standard port allows me to authenticate correctly whereas the instance listening on the non-standard port only works: if I am on the same box as the database; or

Re: authentication problem on non-standard port

Victor Pendleton wrote: Are you specifying either the socket or the host/port combination? What types of error messages are you getting Here is an example of it working and not working (with machine, usernames omitted) $ mysql -h HOSTNAME -u USERNAME -p Enter password: Welcome to the MySQL

problems with foreign keys revisited

Hi there, I am having some issues between two tables and foreign keys. Here is the two tables I have setup. | complaints |CREATE TABLE `complaints` ( `complaintID` int(11) NOT NULL auto_increment, `ticket_number` varchar(20) NOT NULL default '', `complainant_name` varchar(100) NOT NULL

Re: Problem with a Select Query

SELECT user_id, rep_nurse_1, rep_nurse_2 FROM Users WHERE User_ID = 'x' I have a problem with a SELECT query. I have a users table and each user can be a Rep, Nurse or Administrator defined by User_Type. Each Rep has two Nurses allocated to them and the User_ID of the nurse is held in column

Re: Range query on datetime with index - any optimization?

I wonder if mysql isn't trying to process where GMTBase DATE_SUB(CURRENT_DATE, INTERVAL 2 DAY) What about doing this date subtracting in PHP and adding the result to the SQL statement. Hello folks, I'm usinng MySQL 4.0.17. I have a table something like: RuleID int, GMTBase datetime,

Re: Use of AVG in where clause

I believe you have to add your AVG() to your GROUP BY clause. I have a sql query as follows: ** SELECT DB_ESTABLISHMENT_NAME, AVG(DB_GRADE) FROM ESTABLISHMENTS ES LEFT OUTER JOIN GRADES GR ON ES.DB_ESTABLISHMENT_ID=GR.DB_ESTABLISHMENT_ID WHERE

Re: AVG function in order by clause

In Oracle you can reference the second field AVG() by the field #. ORDER BY 2 Thanks a lot for the replies. I have changed the query as follows: ** SELECT DB_ESTABLISHMENT_NAME, AVG(DB_GRADE) FROM ESTABLISHMENTS ES LEFT OUTER JOIN GRADES GR ON

Should I trust my data after an InnoDB recovery?

gotten around to it. So anyway, should I bother with a restore? What's the chance of having data corrupted / missing after a power 'failure' and recovery as above? Thanks! Dan -- signature Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia

Re: Last inserted ID

no need to use 'distinct' - you will only ever get one record ( as far as I know ). Actually, I don't think you need a 'from' clause either, ie it doesn't affect the result. You only ever get the *very* last inserted ID returned. -- signature Daniel Kasak IT Developer NUS Consulting Group

Re: Should I trust my data after an InnoDB recovery?

? The only "missing" data should be uncommitted transactions unless you've changed InnoDB's default flushing frequency. Cool. Thanks! -- signature Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+

Re: INSERT INTO dropping slashes from strings

I think you want chr(39) (single quote). Every time I think I've got it, I am reminded thatI don't got it. Hello all, once again! Can anyone tell me why the following takes place? In my VB app I am adding records to the table Jobs with this code (trimmed way down - my actual INSERT

Re: INSERT INTO dropping slashes from strings

erroneous string. Using the ascii-code equivalent (Chr(34) does the same. It's just soodd!! Daniel Clark wrote: I think you want chr(39) (single quote). -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: INSERT INTO dropping slashes from strings

How about: (I reversed on set of quotes) sqlstr = INSERT INTO Jobs VALUES(' txtSceneFile ') Err...what I meant to say here was ascii code equivalent (chr(39) (I tried single *and* double quotes). Sorry about that. Steve Pugh wrote: Hi Daniel, I tried that to no avail (I had actually

Re: INSERT INTO dropping slashes from strings

Hum. I've never tried inserting without the field names. Serves me right to type this stuff instead of copying/pasting - my previous post was indeed wrong but also wasn't the exact code I used (yours was, with the single quote embedded in the doubles). It's been a very dyslexic week for me.

Re: urban myth?

Yes it is a myth. The records will come back in the same order IF there have been not inserts and deletes. Depends on the database product to. My boss says that if you do a select statement against a table the result set always comes back in the same order. I say that this is a myth and

Re: Need correct 'order by' syntax where field does not contain NULL

select * from navigation WHERE id = '.$category.' AND active='y' AND order IS NOT null ORDER BY order, title Hi. I had a MySQL DB set up and recently added a field 'order' to allow for exceptions in a web site menu heirarchy. Fields should be ordered by 'order' field first where it does not

<    1   2   3   4   5   6   7   8   9   10   >