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

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

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

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: how can I access to mysql fro m"outside"?

>>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.d

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

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 = detalle_tr

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

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 i

RE: Alter table command don't work

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

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 f

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: 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 a.m

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. T

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 4.

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 w

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 b

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 are

RE: HELP --- Slow SP

ry key 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 thi

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 your

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 5

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 a

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.

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 r

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

RE: mysql sql question

mysql> insert into dept (name,collegeid) -> 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 wor

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

Problem Starting mysqld on Tru64

running on port: 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

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

RE: Repeated table corruptions

able, with subsequent disaster, but that is not the issue here - the issue is why does the table get corrupted in the first place. Regards Quentin Bennett Senior Analyst Infinity Solutions Ltd PO Box 3323, Auckland Ph: 09 921 8146 Fx: 09 309 4142 www.infinitytransport.net > -Ori

Repeated table corruptions

in the first place. Myisamchk -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 A

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

Database corruption

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 with ABSOLUTELY NO WARRANTY. This is free softwa

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

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

Just to check: you are doing GRANT ALL PRIVILEGES ON *.* to user@localhost; FLUSH PRIVILEGES; previous examples have had grant all privileges _to_ *.* to user@localhost or is _to_ a synonym for _on_? Quentin -Original Message- From: Matthew Darcy [mailto:[EMAIL PROTECTED]] Sent: Thu

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

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

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 relational

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 W

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 wait

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

Command Line Editing Mode

ore powerful than the standard 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 Tha

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

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

doesn't apply 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 :

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

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 == De

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 t

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 M

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 ? O

Feature Requests

file command - if that is too 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 Div

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: 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, "unknow

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 Decemb

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 VARCHAR(12

Solaris, JDBC and MySQL

piled 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 : +64 9 309

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 Di

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 th

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 PRO

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

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

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

gi?1:mss:79389>[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.infini

RE: Quick Question - quick reply please!

: Saturday, 3 November 2001 11:47 p.m. 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

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 Sys

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

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 functio

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

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

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

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 webs

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 can

RE: Can you use a Unix MySql db file on Windows?

If possible, update your UNIX DB to 3.23, and convert the tables to MYISAM - the tables can then be freely copied between platforms. Alternatively, you could use ODBC to update the UNIX tables directly. Otherwise, you would have to use mysqldump to copy the data to windoze and back again, assumi

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

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 am

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? I've

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 O

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

Compile on 3.23.40 OSF1 Digital UNIX 4.0D - HELP PLEASE

d also compiled 3.22.27 on the OSF1 - that version has recently taken to not responding, which is why I am now desparate to get the (what was) latest version up and running. Help!! Quentin Bennett Transport Systems Division Infinity Solutions www: http://www.infinity.co.nz mailto:[EMAIL PROTECTED

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

Hi, I want to escape single quotes in the result of a query run in a shell script. I think REPLACE is the right function to use. If, at the mysql prompt, I enter mysql> select replace(name, '\'', '\\\'') from cust_details where name like '%\'%' limit 10; I get +---

Altering a big table

copy replies 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 a

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 no

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 url,newwebsites.description,newwebsites.

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

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 a

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 s

Mail Marshall E-mail Viruses - An Apology

ocket launcher 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 i

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 a

ODBC Installation

? Thanks 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. If you are not

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

  1   2   >