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

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: 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

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

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

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: 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

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: 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

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: 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

'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,

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: 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

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: Reading MS Access tables from MySQL or Perl

) and client ( ie machine you'll be running the Perl scripts from ) and it *somehow* works. Sorry I'm a bit lean on the details. I've seen it working. Google for it. Dan -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922

Re: XFS or ReiserFS?

for a MySQL server. -- sig 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: Learning curve

, MUCH more stable and we can provide remote access to the DB. But it certainly is more work to get it running and to make changes. I've seen code floating around for uploading images to a MySQL DB via a PHP-driven web site. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific

Slightly OT: MySQL + PHP and escaping data to output to a web page

currently using: replace(replace(NoteText, '', '#060'), '', '#062') as NoteText to replace the offending characters with HTML escape codes. Is there a cleaner way of doing this? Thanks! Dan -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia

Re: Slightly OT: MySQL + PHP and escaping data to output to a web page

Mark Susol | Ultimate Creative Media wrote: On 4/15/04 11:49 PM, Daniel Kasak [EMAIL PROTECTED] wrote: I'm currently using: replace(replace(NoteText, '', '#060'), '', '#062') as NoteText to replace the offending characters with HTML escape codes. Is there a cleaner way of doing

Re: compiling mysql on a pentium

, Andy Check the INSTALL-SOURCE file in your source distribution. -- 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: compiling mysql on a pentium

found somewhere else on the net? You haven't actually told us what processor ( 'pentium' is a marketing term, not a processor type ... there are many different types of pentiums ) you have, but you should be able to use -march=pentium4 or whatever matches your processor. -- Daniel Kasak

Re: MySQL and Ms Access - a better description of the problem

Patrick Kirk wrote: Hi all, I've installed the latest MDAC and Jet service packs on Windows 2000. On Linux I've the latest MySQL and MyODBC3.51. Using the ODBC Administrator I've set up a connection and made sure to check Don't Optimize columns width, Return Matching Rows, Allow BIG Results,

Re: to_days() error?

a date addition function. 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: Sort a Sum

Ed Reed wrote: Thanks Jeff, After a little more investigation it turns out that the problem only exists when I run the query through a MS Access database attached to MySQL via ODBC. If I run the query in MySQLCC or MySQL-Front it runs just fine. Any ideas for a work around? - Ed Use an

Re: How stable is 4.0.18?

cache is very good at handling this. Anyway, it's never gone down on decent hardware. Can't say much more than that :) 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

Re: MyODBC and Windows XP

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

Re: Mysql 4.0 -Oracle Stored Procedure Trigger Conversion

to the DB server. This is more flexible, but slower. Anyway, it's the only option currently. 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

Re: Administrator

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

Re: just the list please!

more than a few hours. What I have a problem with is people piggy-backing off other people's threads. If you have a new topic, start a new topic... -- signature Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676

Re: synopsis of the problem (one line)

-ldflags=-lstdc++' '--with-embedded-server' '--with-vio' '--with-openssl' '--without-docs' '--without-bench' '--without-readline' '--with-extra-charsets=all' '--with-berkeley-db' '--with-innodb' Yeah, I know what's wrong with that. -- signature Daniel Kasak IT Developer NUS Consulting Group

Re: Backward compatable?

Mulugeta Maru wrote: I am using MySQL 5.0 at the moment with a number of databases. These databases are created to learn MySQL. Some of the tables are Innodb. I would like to remove MySQL 5.0 and install 4.0.18. What do I need to do to reserve the databases so that I can continue to use them in

Re: @@identity

Aaron wrote: How can I select the last record that was inserted? An ASP/VB example would be great too! I believe you have it already. I use: select last_insert_id() as MyID but from memory @@identity is a synonym of last_insert_id() Dan -- sig Daniel Kasak IT Developer NUS

Re: SELECT ... GROUP BY

t opposing the FTA. See http://yro.slashdot.org/article.pl?sid=04/03/05/229228mode=thread for the latest Slashdot story on it... Sorry about the political rant, but this stuff is important and we don't have much time. -- signature Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacif

Re: Mysql version 4.0.x ,LOCKS and Transactions

Luiz Rafael Culik Guimaraes wrote: Dear Friends Talking with an friend, he told he that mysql 4.0.x has many problems with lock and transactions, is this true. All table that i use are innodb Regards Luiz I haven't had any problems. Did your friend elaborate? -- signature Daniel

Re: Query Speed in Terminal vs. PHP

g an index that the console query is. Try doing an 'explain' on the query from the processlist and comparing it to an 'explain' from the console query to see if they are using the same indexes. Dan -- signature Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North S

Re: The very first day of march :-) (select (curdate()-1);)

Campanella Danilo wrote: Hi, Look at what happened today : mysql select curdate(); ++ | curdate() | ++ | 2004-03-01 | ++ 1 row in set (0.00 sec) mysql select (curdate()-1); +---+ | (curdate()-1) | +---+ | 20040300 |

Re: Error 1064 in Access95

it, and then join it to your original query. 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://www.nusconsulting.com.au

Re: transaction

. -- 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/mysql

Re: transaction

to innodb by issuing the command: alter table MyTable type=innodb; Or you can use the GUI MySQLCC to change table types. -- 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

Re: Performance Benchmarks

;safe" working under SQL Server 2000. Sorry is this is a newbie question, this is my first work mySQL. Cheers, http://www.eweek.com/article2/0,4149,293,00.asp Click on the links for graphs. -- signature Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific High

Re: Migration question

Brian L. Walter wrote: Thanks for your reply. Let me try again. In access, you can create views. These are called 'queries' in Access. The current version of MySQL does not support views, as I understand it. Using DBManager, I import all my tables and data to MySQL from Access. One of the

Re: MS-Access queries port to MySql 5 Stored Procedures

Mihalidis Yes. I have tried. MyODBC isn't up to the task yet. Have a look at bug #2273 at http://bugs.mysql.com/bug.php?id=2273 and PLEASE vote for the bug so it gets some priority. -- signature Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW,

Modified Preorder Tree Traversal

to the tree. I can't see the error... No-one actually posted a correction, just made comments that the original code was wrong. Anyone care to have a look and tell me what's up with the method of adding a child ( on page 3 of the article )? Thanks! Dan -- Daniel Kasak IT Developer NUS Consulting

Re: Migration question

Brian L. Walter wrote: Greetings, I'm in the process of migrating from Access to MySQL. I've imported access queries into MySQL, and they do show up (using a third party db manager, they show up under tools). In Access, queries can be used like views. I.e. you can select from them. Now, the

Re: SQL select help required please

places, without brackets too. Any help would be appreciated. TIA Mat What problem are you having exactly? An error, or just not getting the results you expected? Maybe you need to format the date in mmdd format before giving it to MySQL. -- Daniel Kasak IT Developer NUS Consulting Group

Re: Application using mysql, perl, Excel

of people using Perl from inside Excel. Check back through the list archives - it wan't long ago. It may give you what you need if you want to use Perl for this. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676

Re: Left Join takes too long

Jacque Scott wrote: I have a fairly simple query where I feel it takes too long to run. SELECT Products.NSIPartNumber,Products.Cost, Products.ModelNo, Products.USPrice, Products.VendorPart, Products.Description , Products.ProductID, Sum(tblInvTransaction.Qty) AS SumOfQty FROM Products LEFT JOIN

Re: Export Database Structure sans data

David Perron wrote: Im looknig for the function that will allow me to export the database structure into a static file, without the actual data. I would like to create an ERD diagram with the output file. David mysqldump -d -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77

Re: Database design

Duke, Brian wrote: Can someone explain a 1:n non identifying relation? Brian Duke Yes. I'm Dan, and I'm unique; there's only one of me. However if I like a store after an initial purchase from them, I may go back and another purchase. 1:n User:Purchase Dan -- MySQL General Mailing List

Re: temporary table in 4.0.17 on Windows W2000 and NT4

the above behaviour too, but probably not. -- 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

Re: why: mysqldump and mysqlimport?

finally don't have a valid backup around. 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

Re: Mysql Socket Error

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] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http

Re: Importing a dumpfile

and type password ) Or you can edit the backup file and insert a: use name_of_database at the top. You may need to turn off foreign key constraint checking first: |SET FOREIGN_KEY_CHECKS=0 ( insert this into the dump file ). Dan | -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77

Re: mysql.sock

the mysql.sock file ). Good luck. -- 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: Mysql Socket Error

and this is the reason which you can't connect through the socket. What do the mysql logs say? Maybe examine / post them. -- 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

Re: mysql.sock

to communicate with MySQL. What problem(s) are you having with it? -- 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

Re: odbc

delimited file, and import that into Access. -- 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

Re: Mysql by itself?

server; have I overlooked that it really is a server by itself? EP asking for a friend, I'm much smarter than this MySQL does not run on Apache. They are completely separate and independant projects. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW

Re: Bet the Business

Ian O'Rourke wrote: I've been playing with MySQL for a bit now (and it is playing) and I'm using it for a number of personal sites (ie not many users, and only I really post stuff). I've also adopted it at work, and we use it to dump Lotus Domino information into for more structured reporting.

Re: transaction support

other than M$ toys. I suggest you get another software developer, or at least threaten to. -- 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: transaction support

a rollback command when the error is detected. -- 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

Re: insert: auto increment field

an autoincrement field ( I believe this does a drop table / recreate table 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 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au

Re: insert: auto increment field

Mike Mapsnac wrote: It solved the problem. But what truncate does? Just deletes the rows? It's the same as doing: drop table create table ( schema from dropped table above ) -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060

Re: Importing dates from access

. That works best for me 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://www.nusconsulting.com.au -- MySQL General Mailing List For list archives

Re: insert: auto increment field

what it is. -- 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: Regd Sub Queries

Sandeep N Seshadri wrote: hello every one, i am in the process of converting my database from access to mysql ... now tat i have started working with mysql i have realized that my subqueries wont work here ... i read the article on how to handle some of the simple subqueries with joins ... my

Re: Regd Sub Queries

Sandeep N Seshadri wrote: Could you please tell me more about the pass through queries. i dont have an idea abt it sandeep Sure. Create a new query in Access. Instead of adding tables to the query design view like normal, simply click the 'query' menu, and select 'SQL Specific', and then

FIXED: Access crash when connected to MySQL and left inactive

Summary of Service Pack: http://support.microsoft.com/default.aspx?scid=kb;[LN];829558 Summary of the bug that concerns us: http://support.microsoft.com/default.aspx?kbid=282349 Dan -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61

Re: integer not being inserted correctly

... look a bit more than half-way down for 'fixed-row'. -- 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

Re: Production problem porting from PHP to ASP

:-( -- 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/mysql

Re: Exportation

with the mysql client: mysql my_dump_file.sql -- 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

Re: MySql40, MSAccess2003, MyODBC3.51, and white spaces.

Duke, Brian wrote: I have a question about spaces in fieldnames. locally running Access03 and using MyODBC3.51 to populate a MySQL40 database. The Database name and table names are ok. It's the field names I am having trouble with. The tables are huge and there are 26 tables. The ODBC process

Re: MySql40, MSAccess2003, MyODBC3.51, and white spaces.

Duke, Brian wrote: I agree with that. the LERG does not get generated by us. I push it immediately to Mysql every week. so you are recommending: $query=SELECT LERG_6.SWITCH, `LERG_6.SHA INDICATOR` FROM LERG_6 WHERE `LERG_6.SHA INDICATOR` = 00; (the backticks are around `LERG_6.SHA INDICATOR`)

Re: automate MSAccess into MySQL

' decisions about what column types to use. Carefully review their source before using them yourself; even more so if your customers will be the ones using the app. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F

Off Topic: MySQL Icons

Hi all. I'm prettying up my Gnome desktop, and I'm after a MySQL icon for my MySQLCC launcher. Anyone know of some icons? -- 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: sub query format...

Subquery is supported in MySQL-4.1.0 and above. -- 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

Re: How to pass syslog data to a MySql Database?

. Thank you for your help. I'm sure there are apps and perl modules and things that do this already. I've seen at least 1 on freshmeat.net Have a look around. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F

Re: Error 2002

it on mine 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://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http

Re: Adding mysql to the subject line would improve clarity and ease of classification.

of viewing messages in the list, why not start your own thread instead of piggy-backing onto a completely unrelated thread? -- 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: Mysql 4.0.16 stop working

installed MySQL into? -- 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: Rekall and associated software go GPL

packages for the major distributions. -- Daniel Kasak IT Developer * NUS Consulting Group* Level 18, 168 Walker Street North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com -- MySQL General Mailing List For list

<    1   2   3   4   5   >