RE: transitioning from ms sql

Hi, There is a white paper on that cery subject available at http://www.mysql.com/why-mysql/white-papers/mysql_wp_mssql2mysql.php -Original Message- From: Arjun Bhandari [mailto:[EMAIL PROTECTED] Sent: Wednesday, 27 September 2006 4:11 p.m. To: mysql@lists.mysql.com Subject:

RE: Question about LOTS of indexes on a table

If the combination of fields that will be subject to 'where' is unknown, and will be unknown forever, then I think you have no choice but to index each one individually and let MySQL make the choice as to which one to use. If, however, you know, or can establish, that certain combinations of

RE: how can I access to mysql fro moutside?

Does it mean the port 3306 is blocked? Not necessarily - it could mean that MySQL didn't respond as your telnet client expected (which is not surprising!). The Access denied for [EMAIL PROTECTED] message comes from the server, so there will be something wrong with your mysql.user or mysql.db

RE: SUM in WHERE

No, I don't think it is. I think you want to have a query that will return 'n' rows where the sum of Total is = 100 If your table is ID Total 1 10 2 20 3 30 4 40 5 50 it would return 1 10 2 20 3 30 4 40 (sum total = 100) but if your table was ID Total

RE: phpinfo() Client API version 3.23.49

Hi, The 3.23.49 is the version of the client that php is using. This may been what it was compiled with, or what it is getting from an external library. If it is compiled that way, you'll need a new compile of php including the newer client library. If its a runtime load, you may get away

RE: Outputting text in a

If you are running a script from the command line, try mysql -BNe select 'some text to print' -Original Message- From: Jesse [mailto:[EMAIL PROTECTED] Sent: Friday, 25 August 2006 2:39 a.m. To: Wai-Sun Chia; Dan Buettner Cc: MySQL List Subject: Re: Outputting text in a You still get

RE: Group by base on latest time field, possible?

Try select thread, subject, max(time) from jos_sb_messages group by thread order by 3 -Original Message- From: The Nice Spider [mailto:[EMAIL PROTECTED] Sent: Thursday, 10 August 2006 4:10 p.m. To: mysql@lists.mysql.com Subject: Group by base on latest time field, possible? I want the

RE: select random ids from list

If you know the list of Ids, try select id, title from content where id in (100, 106, 109); If you want the list to be random, then you can use the RAND() function. Quentin -Original Message- From: kalin mintchev [mailto:[EMAIL PROTECTED] Sent: Tuesday, 1 August 2006 2:10 p.m. To:

RE: change a empty value for 0

Isn't this over-complicated select id_ingenio, sum(cantidad) from ingenio, detalle_transaccion where ingenio.id_ingenio = detalle_transaccion.id_ingenio group by ingenio.id_ingenio or select id_ingenio, sum(cantidad) from ingenio left join detalle_transaccion on ingenio.id_ingenio =

RE: Searching through an alphabetical range

Hi, Tim's point is that you have someone with a last name of 'zebra', they won't be included in your results. Quentin -Original Message- From: Paul Nowosielski [mailto:[EMAIL PROTECTED] Sent: Saturday, 22 July 2006 7:19 a.m. To: mysql@lists.mysql.com Cc: Tim Lucia Subject: Re:

RE: Backup questions

GVIM is a great transition from vi to more 'modern' (read slower and cumbersome!) editors. It allows all the normal vi commands, but also 'standard' Windoze features like Ctrl-C Ctrl-V for copy and paste, drag and drop selection etc. Like all good editors, it takes time to get the most out of

RE: Alter table command don't work

: Monday, 19 June 2006 10:36 a.m. To: Graham Reeds Cc: mysql@lists.mysql.com Subject: Re: Alter table command don't work Graham Reeds wrote: Quentin Bennett wrote: http://dev.mysql.com/doc/refman/4.1/en/alter-table.html From MySQL 4.1.2 on, if you want to change the table default character set

RE: Re: Alter table command don't work

http://dev.mysql.com/doc/refman/4.1/en/alter-table.html From MySQL 4.1.2 on, if you want to change the table default character set and all character columns (CHAR, VARCHAR, TEXT) to a new character set, use a statement like this: ALTER TABLE tbl_name CONVERT TO CHARACTER SET charset_name;

RE: Unknown tables

but I assume you mean to check the information_schema database and the schemata table? No, Rich meant check the mysql data directory for a karate directory. MySQL databases (for MyISAM tables) are stored in their own directory, and each table is a set of 3 files, so its easy to check for

RE: Can I have multiple sockets?

AFAIK, no, you can't do that, but you can have multiple servers on one server, so long as they don't try and control the same data files. Each server could use a different socket. -Original Message- From: Patrick Ben Koetter [mailto:[EMAIL PROTECTED] Sent: Thursday, 15 June 2006 3:04

RE: INESRT ... ON DUPLICATE KEY - rows affected incorrect?

Most likely, MySQL has done a 'DELETE' followed by an 'INSERT' - i.e. two rows. Quentin -Original Message- From: Richard Dale [mailto:[EMAIL PROTECTED] Sent: Friday, 19 May 2006 11:23 a.m. To: mysql@lists.mysql.com Subject: INESRT ... ON DUPLICATE KEY - rows affected incorrect? Mysql

RE: INESRT ... ON DUPLICATE KEY - rows affected incorrect?

Its not a problem with precision is it - 332.25 looks OK to you and me, but who knows what it looks like to the CPU? Maybe it sees one of the doubles as slightly different and updates? -Original Message- From: Richard Dale [mailto:[EMAIL PROTECTED] Sent: Friday, 19 May 2006 11:48 a.m.

RE: Need help with triggers

I've never written a trigger, but the error implies that you can't update the stores table when in a trigger ON the stores table. This makes sense, especially if you consider an 'UPDATE' trigger - the trigger would become recursive. So, rather than deciding which combination are recursive and

RE: PRINT statement?

From Transact-SQL Help file: PRINT Returns a user-defined message to the client. Syntax PRINT 'any ASCII text' | @local_variable | @@FUNCTION | string_expr Arguments 'any ASCII text' Is a string of text. @local_variable Is a variable of any valid character data type. @local_variable must

RE: HELP --- Slow SP

The THEORY behind both statements is fine 1. Have a primary, single column integer index, auto incrementing (probably) for every record 2. Have a primary index that uniquely identifies your data. The advantage of 2 is that it is (usually) obvious what the unique characteristics of your data

RE: HELP --- Slow SP

[snip] Next point is that MySQL will only make use of an index in a join or a where clause if ONLY that field is included in the index. If you pack 3 fields into an index and then try to join on ONLY ONE field, the index can't be used. So look at your joins and where clauses and make sure

RE: HELP --- Slow SP

and recreate index? Many thanks, Hardi On 4/28/06, Daniel Kasak [EMAIL PROTECTED] wrote: Quentin Bennett wrote: I think that you can use the left most columns of the index, without including the remainder. That's wasn't my understanding of how things work, but I've just checked

RE: WHERE doesn'r works

Hi Tom, Have you tried turning on the logging on the MySQL server, and seeing exactly what command the server is receiving - it may be different from the one (you think) you are sending. Quentin -Original Message- From: Tom Lobato [mailto:[EMAIL PROTECTED] Sent: Monday, 24 April 2006

Compiling 5.0.20 on Tru64

Hi, I'm trying to compile on Tru64 using the configure from the reference guide for using the HP/Compaq compiler (corrected for 'inline') CC=cc -pthread CFLAGS=-O4 -ansi_alias -ansi_args -fast -inline all -arch host CXX=cxx -pthread CXXFLAGS=-O4 -ansi_alias -ansi_args -fast -inline all \

Tru64 cluster

Hi, Is MySQL Cluster Aware? Thanks Quentin The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If

FW: 2 SELECTS in 1

Hi, Can you use IF? SELECT iu.time as time, INET_NTOA(iu.ip) as ip, concat(usc.scheme,://,us.server,up.path, if(uq.query= ,,concat(?,uq.query))) as url,uc.category as HTH Quentin From: J S [mailto:[EMAIL PROTECTED] Sent: Tue 6/07/2004 8:22 a.m. To:

Problem Starting mysqld on Tru64

: 3306 ? 040705 9:31:52 Aborting The server was rebooted to ensure no stray processes were holding 3306 open. netstat -a showed nothing on that port. We changed the port to be 3307, and the server is working OK. Does anyone have any method for finding out why port 3306 would not bind. Quentin

RE: mysql sql question

Hi, You've already specified some values, so you can't then add a 'select' clause as well. Try mysql insert into dept (name,collegeid) - select 'tom', id from test where name=sammy; HTH Quentin -Original Message- From: bruce [mailto:[EMAIL PROTECTED] Sent: Monday, 5 July 2004

RE: mysql sql question

) - select name, id from test where name=sammy; -Original Message- From: bruce [mailto:[EMAIL PROTECTED] Sent: Monday, 5 July 2004 10:50 a.m. To: Quentin Bennett Subject: RE: mysql sql question i can't see how this would work at all... unless you're saying the select will return tom

RE: Problem Starting mysqld on Tru64

Hi, Customer has found that port 3306 was open on another server in the cluster, and that seems to be what was causing it. Thanks for listening. Quentin -Original Message- From: Quentin Bennett [mailto:[EMAIL PROTECTED] Sent: Monday, 5 July 2004 9:52 a.m. To: MySQL (E-mail) Subject

Repeated table corruptions

-vvv resulted in 212424 lines of information. Thanks in advance Quentin Bennett # mysqladmin version mysqladmin Ver 8.40 Distrib 4.0.13, for dec-osf5.1 on alphaev67 (-- Binaries from mysql.com --) Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes

RE: Repeated table corruptions

031113 01:18:37 mysqld ended Unix isn't being shutdown, only the Mysql Server program. Thanks Quentin Quentin Bennett Senior Analyst Infinity Solutions Ltd PO Box 3323, Auckland Ph: 09 921 8146 Fx: 09 309 4142 www.infinitytransport.net -Original Message- From: Stephen Brownlow

Database corruption

Quentin Bennett # mysqladmin version mysqladmin Ver 8.40 Distrib 4.0.13, for dec-osf5.1 on alphaev67 (-- Binaries from mysql.com --) Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome

RE: Database corruption

Hi, Compaq Tru64 UNIX V5.1 (Rev. 732) so possibly not the same issue! Thanks Quentin Bennett Senior Analyst Infinity Solutions Ltd PO Box 3323, Auckland Ph: 09 921 8146 Fx: 09 309 4142 www.infinitytransport.net -Original Message- From: Terence [mailto:[EMAIL PROTECTED] Sent

RE: auto increment

Hi, Check the behaviour of auto_increment in the change logs - it changed from using the highest available number to carrying on from where it left off some time ago, but I believe there is a was to reset it manually. Hope this helps. Quentin Bennett Senior Analyst Infinity Solutions Ltd PO Box

RE: command mysql -u $user without typing it - getting shafted and annoyed now.

Hi Again I just did this to check what you did: SKYROAD#mercury1:/mercury/home/quentin:mysql --user=mercury -p mysql Enter password: mysql grant all privileges on mysql.* to matt@%; Query OK, 0 rows affected (0.05 sec) mysql flush privileges; Query OK, 0 rows affected (0.19 sec) mysql quit

RE: 2 GB limit reached

Hi, I had this too - in the documentation, although maybe not highlighted enough, there are instructions for overcoming 4G - you have to set MAX_ROWS for you table to a 'large' number to tell mysqld to use 4 byte pointers for the file. Regards Quentin -Original Message- From: Chris

RE: MYSQL : XML storage

Hi, MySQL, being a relational database (quiet, you guys from other camps), is good at storing relational data. To store purely XML data, you may be better off using an XML database e.g. Tomino from Software AG. The line is a fine one, though. If your XML is purely a representation of

RE: Error 13

Hi Error 13 is from the OS - nothing to do with locks or whatever. However, when you add a new field (or change the table structure in (nearly) any way), mysqld will create a temporary table in the database directory - are you sure that the permissions on the directory are correct? Remember,

RE: command mysql -u $user without typing it ????

Are you doing 'flush privileges' are documented? -Original Message- From: Matthew Darcy [mailto:[EMAIL PROTECTED]] Sent: Thursday, 10 January 2002 8:26 a.m. To: Ho Kam; Gerald Clark Cc: MySql List Subject: RE: command mysql -u $user without typing it query ok I would expect to

RE: Replication and thread priority

Hi, I don't think that you are missing anything. If there is a select in progress, then an insert will block until it has been completed. If there are several selects pending, then the insert will take its place in the queue, unless you are using low-priority-updates, in which case is will

MySQLd Crash

Hi, Doing a mysqldump of a large table to /tmp, I filled up /tmp, which caused mysqld to reset. This is while using 3.23.40 on Solaris 2.6 What additional information should I provide to help address this problem? From: Quentin Bennett To: [EMAIL PROTECTED] Subject: [Mysql crash

RE: load data local infile

Hi, Not quite sure what you mean, but you can use load data infile 'file' into table mytab (col1, col3, col2) to specify in to which columns the data should go. HTH Quentin -Original Message- From: Douglas Potter [mailto:[EMAIL PROTECTED]] Sent: Friday, 4 January 2002 12:27 p.m.

Command Line Editing Mode

MySQL CLI keys (including the ability to search through the history), I would prefer to use these all the time without having to remember the Esc Return Return sequence. Is there a way of doing this, or is this an un-documented feature? 3.23.40 on Solaris 2.6 x86 Thanks Quentin Bennett Transport

RE: 3.23.47 compile problems with sun's forte compiler

Hi, From the cc(1) man page for Forte Developer 6.2 These predefinitions are valid in all modes: __sun __unix __SUNPRO_C=0x530 __`uname -s`_`uname -r` __sparc (SPARC)

RE: configure problems on Solaris 2.6

A link from .a.2.10.0 to just '.a'? so that e.g. {root}blinky:~ ls -l /usr/local/lib/libstdc++.a -rw-r--r-- 1 root root 2153936 Dec 30 16:57 /usr/local/lib/libstdc++.a - libstdc++.a.2.10.0{root}blinky:~ ls -l /usr/local/lib/libstdc++.a.2.10.0 -rw-r--r-- 1 root root 2153936

Windows 95 winsock version

for Win98. Can anyone provide a more definitive link for the upgrade, and also how to establish if a win 95 PC is running winsock 1, 2 or whatever. TIA. Quentin Bennett Transport Systems Division Infinity Solutions web http:\\www.infinity.co.nz mailto:[EMAIL PROTECTED] Phone : +64 9 358 9720 Fax

RE: mysql.sock??

Hi, mysqld will create it when it runs - have you started the server? Quentin -Original Message- From: Mike Blain [mailto:[EMAIL PROTECTED]] Sent: Thursday, 20 December 2001 2:07 p.m. To: [EMAIL PROTECTED] Subject: mysql.sock?? I just recently installed MySQL from source. Trying to

RE: mysql.sock??

Error 13 is permission denied - check the permissions of host.frm. The user running mysqld must be able to read/write to it. Quentin -Original Message- From: Mike Blain [mailto:[EMAIL PROTECTED]] Sent: Thursday, 20 December 2001 4:02 p.m. To: Cal Evans Cc: Quentin Bennett; [EMAIL

RE: Default 1 == Default 16777216?

For those that silently follow these more unusual threads, what was the cause? Quentin -Original Message- From: Michael Widenius [mailto:[EMAIL PROTECTED]] Sent: Friday, 14 December 2001 8:07 a.m. To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Default 1 ==

RE: Anti-SPAM (was: A News Group Perhaps)

Hi, The TurboPower new groups (news://news.turbopower.com) seem to work fine, with little spam. Because they host the news groups themselves, there is no problem with them not being hosted by a particular ISP. It would be really nice to have a new group, but the ground has been covered so many

Feature Requests

difficult, because the client then needs all the separator and terminator options, then simply tab separated using the platform's standard end of line would be fine for me! Would these options prove useful to others? Regards Quentin Bennett Transport Systems Division Infinity Solutions web http

RE: Default 1 == Default 16777216 ?

Hi, The output of mysqlbug might be useful, so we can see what platform etc you are on. Quentin -Original Message- From: Philip Molter [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 12 December 2001 9:08 a.m. To: Nathan Cc: [EMAIL PROTECTED] Subject: Re: Default 1 == Default 16777216 ?

RE: Problem in using in keyword

Hi, It would help if you can post the statement and the error message that you get. Regards Quentin -Original Message- From: TH Leung [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 12 December 2001 4:26 p.m. To: '[EMAIL PROTECTED]' Subject: Problem in using in keyword Hi, I use the

RE: running MySQL on WinXP

Hi, You need to be running the server (mysqld.exe) before you can connect to it from the command line. 10061 means that the TCP/IP service cannot be contacted, either because the IP address isn't correct or that there is no service on the requested port. HTH Quentin -Original Message-

RE: Creating MySQL table w/2 primary keys

Hi, That may have the desired effect of two unique keys, but you stil only have one primary key (probably id1,id2). PRI is listed against each column involved in the Primary key. Regards Quentin -Original Message- From: Etienne Marcotte [mailto:[EMAIL PROTECTED]] Sent: Friday, 7

RE: Symbolically linked database, unknown database problem.

Hi, Try ls -Ll cc, to check that the link is valid and to see the permissions on the destination. HTH Quentin -Original Message- From: Peter Campbell [mailto:[EMAIL PROTECTED]] Sent: Friday, 7 December 2001 12:57 p.m. To: [EMAIL PROTECTED] Subject: Symbolically linked database,

RE: SHOW TABLES; show nothing

Hi, Try myisamchk'ing you mysql tables. Regards Quentin -Original Message- From: Gill, Vern [mailto:[EMAIL PROTECTED]] Sent: Monday, 3 December 2001 5:40 p.m. To: [EMAIL PROTECTED] Subject: SHOW TABLES; show nothing mysql CREATE TABLE faxblast (company VARCHAR(100), phone

Solaris, JDBC and MySQL

(Compiled Code) SQLException: SQLState(08001) *** SSQLException caught *** SQLState: 08001 Message : No suitable driver Vendor : 0 Thanks in advance Quentin Bennett Transport Systems Division Infinity Solutions web http:\\www.infinity.co.nz mailto:[EMAIL PROTECTED] Phone : +64 9 358 9720 Fax

SELECT INTO LCOAL OUTFILE

Hi, Is there a reason why, if I can LOAD DATA LOCAL INFILE 'file' INTO TABLE fred; why I can't SELECT * INTO LOCAL OUTFILE '/tmp/file.txt' FROM fred I know the data has to travel to the client, but it would make scripting easier! Quentin Bennett Transport Systems Division Infinity Solutions

RE: API documentation issue : inconsistency in mysql_real_connect documentation

So, if you pass NULL in as the first parameter to mysql_real_connect, a possibility opened up by the manual, what is the return. If it is a MYSQL* connection handle if the connection was successful, where did the space for that handle come from. I agree with Mario - if someone is going to go

RE: does each database connect cause mysqld to fork?

Hi, From previous message (I don't run linux), I believe that linux ps lists all threads, and mysqld does create a thread for each connection. Regards Quentin -Original Message- From: Bennett Haselton [mailto:[EMAIL PROTECTED]] Sent: Thursday, 22 November 2001 4:15 p.m. To: [EMAIL

RE: File privileges?!

Hi, error 13 is permission denied Remember that the full paths to files are for the server, and the 'user' running the server must have permission to read/write the file as required, not (necessarily) the user running the client. Quentin -Original Message- From: Venugopal Allavatam

RE: Introducing hidden row having duplicated primary key

Hi, Yes - REPLACE is just INSERT with the ability to pre-delete if a UNIQUE key clash is found. This means that you would have to specify all the columns (even if they already had values in them). Update will update records that match the where, changing only the specified columns. HTH Quentin

RE: Storing returned string into variable in C

Hi, Don't you mean strcpy(reseller_prompts, row[0]); not strcpy(row[0], reseller_prompts); Quentin -Original Message- From: Matthew Blacklow [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 14 November 2001 1:30 p.m. To: [EMAIL PROTECTED] Subject: Storing returned string into variable in C

Update Log and Load Data in file

Hi, I just updated a new database with the update log from another server, and the script failed on the LOAD DATA INFILE commands that I have to import data overnight from other sources, because, of course, those files didn't exist. Now, I know I can use --force to allow the script to complete,

Repair with keycache state while ALTERing TABLE

[4] ... * http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:79389 As a result. Does the [4] indicate that there should be 4 messages in the thread, 'cos I can only see 2. TIA Quentin Bennett Transport Systems Division Infinity Solutions web http:\\www.infinity.co.nz mailto:[EMAIL

Quick Question - quick reply please!

Hi, Assuming that a 'table' has been defined with MAX_ROWS high enough to allow the table to be 4Gbytes, does the same size limit apply to the index as the data file, or is the index file subject to a different limit? Thanks for a speedy response Quentin Bennett Transport Systems Division

RE: Quick Question - quick reply please!

. To: Quentin Bennett Subject: RE: Quick Question - quick reply please! I seem to remember some discussion about this, and that the index *is* subject to filesystem limits i.e., it can't be split. It has been discussed rather extensively at some time in the near past; check the list archives

RE: Query speed

Hi, Check the section about How MySQL Optimizes queries for you version - there is a bit about how indices are not used when calling a function that may be relevant. Hope it helps Quentin -Original Message- From: Leon Noble [mailto:[EMAIL PROTECTED]] Sent: Thursday, 1 November 2001

RE: Editing Forms

Hi, If your Paradox Apps are written in a reasonably DB-independent way using Delphi Components, and not expoiting and Paradox-only features (are there any?), then porting those same applications to MySQL via ODBC should be a manageable task. If you do need to start from scratch, and the

RE: Installing Calendar 0.9.33 on Mac OS X

First pointer - what errors are you getting! -Original Message- From: Greg [mailto:[EMAIL PROTECTED]] Sent: Friday, 2 November 2001 9:32 a.m. To: [EMAIL PROTECTED] Subject: Installing Calendar 0.9.33 on Mac OS X Newbie here who has PHP and MySQL going, but can't figure out how to

RE: a bug or intentional? -- problem with multiple table query

Hi, You need to read up on Left Joins, which will insert a 'NULL' row in the results for B where there isn't a real one. Regards Quentin -Original Message- From: Q [mailto:[EMAIL PROTECTED]] Sent: Friday, 2 November 2001 4:40 p.m. To: [EMAIL PROTECTED] Subject: a bug or intentional?

RE: key question

Hi, In the first key, the combination of key1 and key2 must be unique, in the second, key1 must be unique on its own, but key2 does not need to be. Also, using the first primary key a select col1, col2, ... where key2=value cannot use the index but select col1, col2, ... where key1=value

RE: Can't connect to new databases

Hi, What error message do you get. Quentin -Original Message- From: Ryan Booker [mailto:[EMAIL PROTECTED]] Sent: Thursday, 1 November 2001 1:22 p.m. To: [EMAIL PROTECTED] Subject: Can't connect to new databases I have recently installed mySQL 3.23.43. I will be using it to run a

RE: Can't connect to new databases

Hi, I'm not a PHPer, but in 'C', there is an API that can give you the MySQL error message, which I am sure would explain the problem some more. Quentin -Original Message- From: Ryan Booker [mailto:[EMAIL PROTECTED]] Sent: Thursday, 1 November 2001 3:30 p.m. To: Quentin Bennett Subject

RE: Need query help

Hi, You need to self-join payhistory along the lines of select p1.* from payhistory p1, payhistory.p2 where p1.payid = p2.payid and p1.paydate = max(p2.paydate) Something like that, anyway - I know I had to fiddle around a bit to get a similar think going. Hope this help Quentin

RE: Please...... mysql error! please reply~ here is South Korea.

Hi, errno 13 is permission denied. Possibly you installed mysql as root, and are trying to run as a normal user? Change the permissions in you data directory so the user running the mysqld server can read/write the files. Quentin Here is New Zealand! -Original Message- From:

RE: SELECT Query in PHP

Congrats on getting to 48 hours - let us know which platform you prefer when you reach the number of hours that it took to get the 'Must Consult Some Else' tag! :-) QB -Original Message- From: Todd Williamsen [mailto:[EMAIL PROTECTED]] Sent: Saturday, 27 October 2001 5:48 p.m. To:

RE: MySQL Security w/ PHP

Have you tried something like SELECT User,Password from user where (User=$ID AND Password($PW)=password); ie. equate the result of password(string) to the stored, encrypted, password Regards Quentin -Original Message- From: Kevin Maynard [mailto:[EMAIL PROTECTED]] Sent: Monday, 29

RE: PHP Tutorial for total beginner??

http://www.devshed.com/Server_Side/PHP/PHP101 -Original Message- From: Chip Rose. [mailto:[EMAIL PROTECTED]] Sent: Monday, 29 October 2001 12:31 p.m. To: [EMAIL PROTECTED] Subject: PHP Tutorial for total beginner?? Can someone suggest a link to a total beginner PHP/MySQL tutorial?

RE: problem with update

Hi, You'll need to post your query and the error message to get a meaningful response. Quentin -Original Message- From: Prachi Shroff [mailto:[EMAIL PROTECTED]] Sent: Monday, 29 October 2001 1:36 p.m. To: [EMAIL PROTECTED] Subject: problem with update Hi all! I am new to MySQl and

Compile on 3.23.40 OSF1 Digital UNIX 4.0D - HELP PLEASE

!! Quentin Bennett Transport Systems Division Infinity Solutions www: http://www.infinity.co.nz mailto:[EMAIL PROTECTED] Phone: +64 9 358 9720 Fax: +64 9 309 4142 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended

RE: mysql CLI: executing SQL from a file

Hi, Check section 4.8.2 of the (4.0.0-alpha) manual, or type help at the MySQL Command line. Quentin -Original Message- From: Neil Zanella [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 23 October 2001 11:49 a.m. To: MySQL Mailing List Subject: mysql CLI: executing SQL from a file Hello,

Escape in a shell script

on cust_details.account = report_masters.account where cust_details.account = crm_update_cust.account and cust_details.name like '%\'%' limit 10; ! with the result being piped in to another mysql (either directly or via a file) TIA Quentin Bennett Transport Systems Division Infinity Solutions

Altering a big table

to me please. Thanks again Quentin Bennett Transport Systems Division Infinity Solutions web http:\\www.infinity.co.nz mailto:[EMAIL PROTECTED] Phone : +64 9 358 9720 Fax : +64 9 309 4142 The information contained in this email is privileged and confidential and intended for the addressee only

RE: MySQL or MS SQL?

Hi, Agreed Just because software is developed on a 'Free' platform, doesn't mean that the customer expects the application to be free, or even cheap. Our experience is that if you give something away, then people expect the support/upgrades/customisations to be free to. If you charge, even a

RE: Strange queries

Hi, You can't use aliases in a where, but you can in a HAVING clause. Regards Quentin -Original Message- From: Brad Barnett [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 10 April 2001 8:44 a.m. To: [EMAIL PROTECTED] Subject: Strange queries SELECT

RE: REXEXP in select only works with short expressions on Alpha

Hi, Just a guess, but I expect that the first response will be to use gcc 2.95.2 or later Quentin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, 9 April 2001 1:30 p.m. To: [EMAIL PROTECTED] Subject: REXEXP in select only works with short expressions

RE: Problems with Mysql on Sol7 i386

Hi Matt, Probably worth checking the archives for 'restartable' - there are a few messages there. Quentin -Original Message- From: Matt Mueller [mailto:[EMAIL PROTECTED]] Sent: Thursday, 5 April 2001 9:53 a.m. To: [EMAIL PROTECTED] Subject: Problems with Mysql on Sol7 i386 Hello, I

RE: Hello!Help.

The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to

RE: How to recover from accidental 'drop database mysql'

Hi, Its called your backup tape. Quentin -Original Message- From: Anonymous Individual [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 3 April 2001 4:16 p.m. To: [EMAIL PROTECTED] Subject: How to recover from accidental 'drop database mysql' Greetings: I accidently dropped (my thunderous

Mail Marshall E-mail Viruses - An Apology

cher attachment". (What do you mean, I missed the .com revolution ???) Back to work..... Quentin Bennett Transport Systems Division Infinity Solutions web http:\\www.infinity.co.nz mailto:[EMAIL PROTECTED] Phone : +64 9 358 9720 Fax : +64 9 309 4142 The information contained in this

RE: Delete Again?

Hi, No. you can't delete based on a join. Regards Quentin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, 30 March 2001 3:35 p.m. To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Delete Again? Hmmm Well I didn`t manage to get

RE: Dynamic Custom Sort Orders

Hi, This is a bit unclear - any sorting is either based on some combination of values, be they columns, bits of columns, static values or random values, and so can be expressed as an Order BY clause. For example, I have a report that allows the user to say in which order the columns should be

RE: howto: telnet shell

Hi, You don't telnet to the server, you use the mysql command line client $ mysql --host="yourhost" etc. Quentin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, 23 March 2001 12:53 p.m. To: [EMAIL PROTECTED] Subject: howto: telnet shell i have a

RE: [OT] SQL syntax qestion

Hi, Yes, in MySQL you can go select handle, sum(total) as t group by handle order by t; in ANSI (?) you can go select handle, sum(total) group by handle order by 2; 2 being the column number of the result. Regards Quentin -Original Message- From: Curtis Maurand [mailto:[EMAIL

RE: MySQL 3.23.35 is released

Hi, To be fair to the anonymous writer, the main reason for introducing 3.23.25 was Changes in release 3.23.35 -- * Fixed newly introduce bug in `ORDER BY'. Nothing there about 'in Innobase and/or Gemini Tables', and for a release that is declared Stable to have a

RE: problems with mysql table

Hi, Try some of the more aggressive fixing options on isamchk - see the manual for details. Quentin -Original Message- From: Nuno Ferreira [mailto:[EMAIL PROTECTED]] Sent: Friday, 16 March 2001 10:39 a.m. To: [EMAIL PROTECTED] Subject: problems with mysql table Hi there

RE: Full tables...

Hi, The output from mysqladmin variables would be useful. Quentin -Original Message- From: Dave Camarillo [mailto:[EMAIL PROTECTED]] Sent: Thursday, 15 March 2001 7:42 a.m. To: [EMAIL PROTECTED] Subject: Full tables... Hello all, I've run into a minor problem with my schema/mysql.

  1   2   >