user permissions to all DB

Hello, I want to grant a user all permissions to all DBs on the system as well as any new DBs that show up. I want to avoid having to modify permissions everytime a new DB is added. Is there a way to do this? Thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysq

Re: user permissions to all DB

Just to verify, will that include all new databases? On 8/20/07, Jay Pipes <[EMAIL PROTECTED]> wrote: > Terry wrote: > > Hello, > > > > I want to grant a user all permissions to all DBs on the system as > > well as any new DBs that show up. I want to avoid

RE: mysqld shows high cpu usage over extended time, restart = normal

ql. it happens even on freebsd 5.0 regards, terry -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: problem with linuxthreads on FreeBSD

th-named-thread-libs='-DHAVE_GLIBC2_STYLE_GETHOSTBYNAME_R -D_THREAD_SAFE -I/usr/local/include/pthread/linuxthreads -L/usr/local/lib -llthre ad -llgcc_r' of course alter those to match your paths etc it should help regards, terry SQL > -Original Message- > From: Sumit Mittal [mailto:[EMAIL PROTECTED] &g

difference between libmysql and libmysql_r

Hi, I have a question. I know that the code in libmysqld is for the <http://www.mysql.com/doc/en/libmysqld.html> Embedded MySQL Server Library. Would anyone mind to direct me where I can find what the folder libmysql and libmysql_r for? Thanks Terry

RE: replication problem

o master '[EMAIL PROTECTED]:3306',replication resumed in log 'FIRST' at position 35 020603 14:49:18 Slave: received 0 length packet from server, apparent master shutdown: (0) what am i doing possible wrong ? please help, terry -

RE: MySQL + cygwin

hi, i have mysql compiled with cygwin with gcc version 2.95.3 you can fetch installed version from http://www3.ibt.com.pl/mysql.tar.gz it is prepared to be installed in /opt in cygwin's directory structure best regards, terry > -Original Message- > From: Yegor N. Bryuk

repair problem

check | error| 0 when updateing keyfile | | gbook.ksiegi | check | error| Corrupt | +--+---+--+--+ 2 rows in set (0.01 sec) what can i do about it ? thanks in advance,

replication problem

8 Slave: Failed reading log event, reconnecting to > retry, log 'FIRST' position 35 > 020531 14:04:08 Slave: reconnected to master > '[EMAIL PROTECTED]:3306',replication resumed in log 'FIRST' at position > 35 > 020531 14:04:08

RE: replication question

be my mysql rpm is broken ? ... regards, terry - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTEC

RE: replication question

openbsd: mysql build from sources: /opt/mysql/libexec/mysqld, Version: 3.23.49-log, started with: Tcp port: 3306 Unix socket: /tmp/mysql.sock 2 win2k machines: mysql installed by installer: MySql, Version: 3.23.49-max-debug-log, started with: Tcp port: 3306 Unix socket: /tmp/mysql.sock

replication once again

rpm and now it works! i can make linux either master or slave with no problems at all. this is really strange... regards, terry - Before posting, please check: http://www.mysql.com/manual.php (the manual) ht

RE: Serwer MySQL 3.23.51 sometime acts as zombie on my linux 6.2 machine

t takes some time if parent is doing some other stuff. If zombie processes stay in the process list for a long time, then you have a problem probably with parent process. Someone correct me if I'm wrong. Regards, Terry --

mysql crashing

s etc to no avail. what else can i do to debug the problem or resolve the issue ? regards, terry - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list ar

RE: mysqld crashing

tried running freebsd, linux and sco binaries using openbsd's emulation. they all start but do not accept incoming connections. please help, terry - Before posting, please check: http://www.mysql.com/manual.php (the manual

RE: "Commands out of sync" using PHP

I dont know why it happens, bu i found that using connect() instead of pconnect() solves the problem till its fixed regards, terry SQL - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

complicated query

t might be possibly wrong with the query? how can i make it work in mysql ? thanx in advance, terry - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list ar

RE: How to port MS Access to MySQL ??

MyODBC works fine, but what to do if you have hundreds of tables?=20 its painful job, maybe theres some easier way to do that ? regards, terry sql - Before posting, please check: http://www.mysql.com/manual.php (the

Re: How to select the last entry per item

On 4/27/06, Brian J. Matt <[EMAIL PROTECTED]> wrote: > As the items move new time stamped entries are added to the > database. How would you query to find the current location of all > the items currently in the system. As you might expect we don't want > to replace the entry for an item when a l

Re: UPDATE question

On 5/3/06, Barry <[EMAIL PROTECTED]> wrote: Cummings, Shawn (GNAPs) schrieb: > > If I have 4 Fields (FIELD1, FIELD2, FIELD3 & FIELD4) > > I can do this easily; > > UPDATE TABLE_NAME SET FIELD4 = FIELD1; > > But -- how do I do it so that FIELD4 = FIELD1 & FIELD2 ??? I can't seem > to find any

RE: Hour counts

_TIMESTAMP() and subtract one form the other. Divide the result by 3600 (60*60 = seconds in an hour) to obtain the fractional hours. Terry -Original Message- From: Gyurasits Zoltán [mailto:[EMAIL PROTECTED] Sent: 27 July 2005 17:12 To: mysql@lists.mysql.com Subject: Hour counts Hello Al

Connect issues

message # find / -name mysql.sock /tmp/mysql.soc Setting the location of mysql.sock in my.conf [client] socket = /tmp/mysql.sock Causes error Any suggestions? Thanks Terry

Flushing logs on replication setup

e taken before flushing, or you won't ever see that logged data again. Is this the way it is meant to be? I don't want to institute any log rotation policy on the slave of the live setup if this happens. Regards Terry Riley -- MySQL General Mailing List For list archives: http:/

Re: Flushing logs on replication setup

- Original Message - > Terry Riley wrote: > > I'm running 4.1.13 on Linux as master, with 4.1.12 on XP as slave (in > > house test setup). > > > > This vaguely duplicates what is set up on the live servers, except > > that the slave is 4.1.3 on N

Replication problem

elect' into a 'create table temp select from...'/'insert ... select from temp'/ 'drop table temp' set. This insert ... select stuff is not done on a regular basis, and then only by an administrator. Ideas welcome Cheers Terry -- MySQL General Mail

Re: Replication problem

ppear in logs on either server. This GUI has been in use for over a year, but we only switched on the replication system a couple of weeks ago, and this is the first 'occasional' update - that was frequently used on the old master-only system without problems. Thanks again for the hint

Re: Row Count Discrepency

row count in admin (or SQLyog or whatever), not an actual count, because of the way it does (or doesn't) store row information. MyISAM tables, on the other hand, show accurately because they store the rowcount as part of the table data. Terry -- MySQL General Mailing List For li

join question

JOIN B b ON (a.id = b.id AND a.date > b.date AND ?) Any suggestions would be appreciated. Terry -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: working on Microsoft® Windows Server™ 2003

- Original Message - > hi, > > can new mysql work on Microsoft® Windows Server™ 2003 > > regards > > prao > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAI

-help

Terry Spencer Haigh Consultancy Services Tel: +44 (0)116 262 3966 Fax: +44 (0)116 262 3946 (Leciester Office) Fax: +44 (0)870 052 4572 (Terry) Mob: +44 (0)7796108244 www.haigh-cs.co.uk <http://www.haigh-cs.co.uk>

CREATE TABLE x AS with ENGINE = ARCHIVE

Hi, I'm using MySQL 4.11. Is it possible to use the CREATE TABLE x AS syntax alongside the ENGINE = x pragma, since this would make archiving of tables very simple. I require something along the lines of this: CREATE TABLE old AS SELECT * FROM request_log ENGINE=ARCHIVE If this cannot be done t

Re: CREATE TABLE x AS with ENGINE = ARCHIVE

On 3/28/06, Pure Web Solution <[EMAIL PROTECTED]> wrote: > I dont think that it is possible to specify the engine when creating a table > this way, you could however create the table using the: > > CREATE TABLE old AS SELECT * FROM request_log > > and then issue an alter table command setting the e

Re: CREATE TABLE x AS with ENGINE = ARCHIVE

On 3/28/06, Peter Brawley <[EMAIL PROTECTED]> wrote: > >I require something along the lines of this: > > >CREATE TABLE old AS SELECT * FROM request_log ENGINE=ARCHIVE > > CREATE TABLE tblname ENGINE=archive SELECT * FROM request_log; > > PB Excellent. Exactly what I need. Thanks :-) -- MySQL Gene

mySQL Backups

On 4/11/06, Dana Diederich <[EMAIL PROTECTED]> wrote: > We use a dedicated replicated instance for backups. > > Every night, we lock all of the tables, and dump all of them to > compressed files, and unlock them afterwards. It takes a while to catch > up, but that doesn't hurt anything. I too use

Re: mySQL Backups

On 4/12/06, Tim Lucia <[EMAIL PROTECTED]> wrote: > Would you not lock tables on the slave? The idea of catching it up implies > this is way it is done. Catching up means once replication can proceed once > the tables are unlocked (on the slave). > > At least that is the way I read it... On the s

Migrate HUGE Database

this? Thanks, Terry Terry Babbey Infrastructure Specialist Information Technology, Lambton College of Applied Arts & Technology [EMAIL PROTECTED], 519.542.7751 x3293

RE: Migrate HUGE Database

Thanks to all for the quick replies. Yes, the mysqldump worked perfectly. Boy do I feel like a newbie now! If I use the method below, will that transfer the mysql admin database too with the user information? Thanks, Terry -Original Message- From: Rolando Edwards [mailto:[EMAIL

Re: DATATYPES

atabase (VPS): 080908-0, 08/09/2008 > Tested on: 09/09/2008 13:40:08 > avast! - copyright (c) 1988-2008 ALWIL Software. > http://www.avast.com > > > Terry http://www.confexdb.co.uk/ --- avast! Antivirus: Outbound message clean. Virus Database (VPS): 080908-0, 08/09/2008 Tested

Re: DATATYPES

andra Prajapati > > > > --- > avast! Antivirus: Inbound message clean. > Virus Database (VPS): 080908-0, 08/09/2008 > Tested on: 09/09/2008 13:40:08 > avast! - copyright (c) 1988-2008 ALWIL Software. > http://www.avast.com > > > Terry http://www.confexdb.co.

Re: MySQL Daylight Savings Time Patch - easy check

these time zone tables - are they ever used, should I > populate them or not? > > -Ryan This may depend on where you live? I tried your select above and got two different answers. Trying: SELECT UNIX_TIMESTAMP('2007-03-25 01:00:00'), UNIX_TIMESTAMP('2007-03-25 02

Re: seoparator help

decimal places number_format($fieldvalue, 2) Regards Terry http://booksihaveread.awardspace.co.uk - Original Message - > *From:* coolcoder <[EMAIL PROTECTED]> > *To:* mysql@lists.mysql.com > *Date:* Thu, 23 Aug 2007 03:55:27 -0700 (PDT) > > Was wondering if anyo

RE: seoparator help

n scanned for viruses by BlackSpider MailControl > - www.blackspider.com > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > > > -- > No virus found in this incoming messa

Re: Selecting just 'N' first rows

Look up the LIMIT clause of SELECT statement, also ASCENDING/DESCENDING - depending on how you want it. Remember LIMIT can take a number and an offset. Terry - Original Message - > *From:* Renito 73 <[EMAIL PROTECTED]> > *To:* mysql@lists.mysql.com > *Date:* Sun, 9 Se

New to MySQL on Linux

load? I am confused by the plethora of options available for Linux. Just need something that is relatively simple to install (either 4.1.9 or 5.0.x). Suggestions, please? Cheers Terry Riley -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists

Re: New to MySQL on Linux

Thanks to all who replied - food for thought... Cheers Terry - Original Message - > Having inherited an elderly PIII/500MHz box with an 8Gb SCSI disk, that > had an apparently unusable XP SP2 OS on it, I decided to wipe the disk > and install my first Linux instead, using a

Re: New to MySQL on Linux

Thanks, Joshua - just the sort of info I needed. Off to find a more recent distro Cheers Terry - Original Message - > On Friday 11 February 2005 09:15, Terry Riley said something like: > > Having inherited an elderly PIII/500MHz box with an 8Gb SCSI disk, > > that ha

Explain and indexes

sible keys, but none used by the query; key = null. Can anyone suggest why? How can I optimise this? Thanks Terry -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: lost connection DURING query?

ive MySQL datasource connection, and dispense with ODBC? I know it doesn't help the immediate problem, but it would remove one less reliable link in the chain. Terry > > > [MySQL][ODBC 3.51 Driver][mysqld-4.0.20-log]Lost connection to MySQL > server during query > >

RE: Compressing after Deletion

David, According to the documentation, OPTIMIZE will also work on InnoDB tables. Will that produce the same result as your ALTER TABLE ? Cheers Terry - Original Message - > Hi Chris, > > For MyISAM/BDB tables use OPTIMIZE TABLE ; > For InnoDB tables try ALTER TABLE

Slightly Off Topic - MySQL Administrator

's not being destroyed by the 'rpm -e'. Does anyone out there happen to know what that is? I've looked at the archives for the MySQL-GUI and find no reference to this... Cheers Terry Riley -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

compiling mysql on macosx 10.4

does anybelly know why the following happens? i am using macosx 10.4 and ./configure --prefix=/usr/local/mysql --with-unix-socket-path=/usr/local/mysql/run/mysql_socket --with-mysqld-user=mysql --with-comment --with-debug sql_list.h: At global scope: sql_list.h:401: warning: inline function `ba

a question about MySQL installation

Dear, I have installed MySQL4.1. But why it can not startup when I open my computer? Also, how can I test MySQL can run or not? Thanks for your advice. Best Regards, Terry

Running 4.0.17 and 5 on same machine

Currently running 4.0.17 InnoDB on XP/Apache 2.0.47; client wants to investigate using capability for stored procs in v5, but doesn't have another machine on which to experiment. Can these two be run on the same machine (though not at the same time)? Regards Terry Riley -- MySQL Ge

Re: Running 4.0.17 and 5 on same machine

Thanks, Bruce, Roger Terry Riley --Original Message- > Currently running 4.0.17 InnoDB on XP/Apache 2.0.47; client wants to > investigate using capability for stored procs in v5, but doesn't have > another machine on which to experiment. Can these two be run

Installation of 4.1.1 on XP

. How can I upgrade from 4.0.17, please? Or even start again from scratch with 4.1.1? Regards Terry Riley -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Problem while installing MySQL, etc.

Thanks, Matt - I managed by unzipping it all to a new directory then renaming the directories so that the new one was c:\mysql and the old one became c:\mysql_4017, then run the mysql_fix_privilege_tables script. Cheers Terry --Original Message- > Sharma and Terry, >

Re: SQL Query

I think it should be: SELECT * FROM articles WHERE sectionID=1 ORDER BY Entrydate Desc LIMIT 1,10 Terry --Original Message- > Any idea what is wrong with the following: > > > SELECT * From articles ORDER BY EntryDate DESC > LIMIT 1,10 > WHERE SectionI

Re: any ideas about it

Try ABS() Terry --Original Message- > Hi all, > > I m looking for any function or a work around to fetch numerical data > without its sign (-10 --10, 10 --> 10). Any ideas? > > Thanx -- MySQL General Mailing List For list archives: http://lis

Re: uppercase field constraints

Think that is for your script to work on, i.e. INSERT INTO table (field1, field2) VALUES (UCASE('form.field1'), form.field2) depending on the syntax of your programming language (and which MySQL version you are using). The above works on 4.1.1. Terry

Server variables

y ISP, who is running W2K/IIS5, none of these appear. Is this normal? I had some neat things going on a navigation bar using $REQUEST_URI, but now can't use them. If I'm on the wrong list with this, please forgive me. Cheers Terry -- MySQL General Mailing List For list archiv

How to run a script? Newbie alert..

try, in my ignorance, ends with a 'SQL query error' or similar. Help, please, I'm not used to this command-line stuff! Terry Riley -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: IN function

Yes --Original Message- > Hi, > > I have written a program that creates statments for me, and sometimes I > end > with > SELECT..WHERE number IN(1) > instead of > SELECT... WHERE number IN(1,2,3,4) > would number IN(1) works, > for the moment i have no mean to test it, it

Re: AW: How to run a script? Newbie alert..

Vielen Dank, Mark Cheers Terry --Original Message- > Use "source " from the mysql command line > Start mysql in the bin directory, switch to the db in use via "use > " > and run the command "source " > > Or read the manual sec

Not an Ad

a solution has been found, so why not? Cheers Terry -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: unknow SQL Error!

at line 13 > Thanks very much.Marcelo---Outgoing mail is certified Virus > Free.Checked by > AVG anti-virus system (http://www.grisoft.com).Version: 6.0.491 / Virus > Database: 290 - Release Date: 18/6/2003 Terry -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

KEYS error 1216

error? Thanks Terry Terry Spencer Haigh Consultancy Services +44 (0)2073007329 www.haigh-cs.co.uk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Faster reindexing

order. With the help of EXPLAIN, you can see when you must add indexes to tables to get a faster SELECT that uses indexes to find the records." http://www.mysql.com/doc/en/EXPLAIN.html Terry Spencer Haigh Consultancy Services +44 (0)2073007329 www.haigh-cs.co.uk -Original Message-

Re: PHP multiple SQL statements

As far as I'm aware, in php you can only do one statement per call. Terry --Original Message- > Hi there, > > When i try to do the following in PHP I get errors. Is this not > permitted or is this due to a setting somewhere? Can i do only one SQL > s

RE: Regular expresion replace possibility?

>From the manual: REPLACE(str,from_str,to_str) Returns the string str with all occurrences of the string from_str replaced by the string to_str: mysql> SELECT REPLACE('www.mysql.com', 'w', 'Ww'); -> 'WwWwWw.mysql.com' This function is multi-byt

RE: Finding Table and database size

Dan What you may be looking for (and I had to hunt around to find it myself!) is myisamchk -eis table_name Hope that helps - just because you don't get an answer doesn't mean we don't care - it probably means we don't know. Terry --Original Message-

Re: A final Windows MySQL PHP plea

Gary Does your php code use persistent connections? mysql_pconnect() rather than mysql_connect() ? If so, that would ramp up the CPU usage fairly quickly, AFAIAA. Just a thought Terry --Original Message- > Hi all > > Is there anybody out there who has m

Partial Restore

ng 4.1.3/Apache/WinNT, with hopes of upgrading to 4.1.7 before going live, though I doubt if the MySQL sub-version is relevant. I'd appreciate any help or guidance or advice on suitable tools. Cheers Terry -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Re: Partial Restore

.select sequence took about 20 seconds on my beat-up, memory-starved machine. Took me longer doing the backup/transfer to dummy. So I have found *a* method for doing what I need, while quite a few of you have been away enjoying (hopefully) your Thanksgiving holiday. It would be useful if anyone c

Locking Issue?

et=16M set-variable=key_buffer=8M log-bin= log_slow_queries= [mysql] local-infile=1 Any pointers as to what I may be doing wrong? Please? Yes, I know we should upgrade to 4.1.7, and we will - soon. Cheers Terry Riley -- MySQL General Mailing List For list archives: http://lists.mysql.com

RE: Locking Issue?

- Original Message - Thanks for those hints, Dathan (see below): > > -Original Message- > From: Terry Riley [mailto:[EMAIL PROTECTED] > Sent: Monday, December 06, 2004 10:12 AM > To: [EMAIL PROTECTED] > Subject: Locking Issue? > > Can someone help,

Re: Locking Issue?

Heikki, - Original Message - > Terry, > > - Original Message - > From: "Terry Riley" <[EMAIL PROTECTED]> > Newsgroups: mailing.database.myodbc > Sent: Monday, December 06, 2004 8:15 PM > Subject: Locking Issue? > > > > Can so

Re: Flush_time question and related item

y-write, so I assume therefore that there is no harm in changing flush_time to zero. Any ideas on the second part of my question (which tables are counted)? Cheers Terry > > > Terry Riley <[EMAIL PROTECTED]> wrote: > > We're running mostly with InnoDB tables, about 5% > &

Flush_time question and related item

is 130. What other tables are counted in the opened_tables calculation; does this include tables that may be opened twice under different aliases? Does this include temporary tables (created by MySQL)? Cheers Terry Riley -- MySQL General Mailing List For list archives: http://lists.mys

Re: Excluding Rows

, vapall where fh1109.state = ssa1202.state and fh1109.cd = ssa1202.cd and fh1109.state = vapall.state and fh1109.cd = vapall.cd and ssa1202.state = vapall.state and ssa1202.cd = vapall.cd AND ssa1202.state NOT IN('TX','PA','ME') Terry - Original Message -

DATE_FORMAT & DISTINCT

MX)? Can't see why the DISTINCT clause should change a string to a ByteArray Any help would be appreciated. Terry Riley -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Small Bug in 4.1.3 beta ?

alpha. SELECT COUNT(*) retrieves the correct number, however. This is not the case for the MyISAM tables, which show the correct numbers at all times. Is this supposed to happen? Terry Riley -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Small Bug in 4.1.3 beta ?

No problem, Heikki. It's just a bit disconcerting to see '1' when '0' is expected. As for larger numbers, I realise that the rowcount is only an estimate for InnoDB. Cheers Terry - Original Message - > Terry, > > thank you for reporting this. Sinc

MySQL user passwords and ColdFusion MX6.1

passwords. Killing these off, restarting with --old-passwords and redoing them as 16-char passwords allowed CF to register the DSNs. Hope this might help someone else who's going prematurely bald. Cheers Terry Riley -- MySQL General Mailing List For list archives: http://lists.mysql.com/mys

Bin-log strangeness

ed by the documentation), but I'm still miffed by this set of entries. Any hints would be gratefully accepted. Cheers Terry Riley -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Query Cache

if the cached query is called before the timeout. Regards Terry Riley -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Query Cache

Thanks to all who replied. Regards Terry Riley - Original Message - > We have the query cache turned on, and it appears to be working well. > > However, there appears to be no indication in the manual as to the time > that a cached query remains in memory. In the abs

Re: type=heap problem...

I think the error is self-explanatory - you can't use auto_increment in a heap table (but you can have an index) Terry - Original Message - > I couldn't get temporary table to load into memory using type=heap, > here's > the sample error as following: >

Re: Joing two fields in a query

CONCAT() is what you need! SELECT CONCAT(Firstname,' ',Lastname) AS Name FROM Users; Terry - Original Message - > Hi, > > Is it possible to join two fields in a query so that they are displayed > as one column? For exmaple: > > SELECT Firstname + '

Re: recommended books for web app.

I'd go along with that recommendation. Terry - Original Message - > Welling & Thomson is terrific. > - Original Message - > From: Kerry Frater > To: "MySQL List" > Sent: Thursday, August 12, 2004 8:09 AM > Subject: recommended book

RE: Strange Text Field

Stuart Could this be something as simple as the fact that you have a field with a space in its name ('Contact Email'), which is sometimes called as 'Contact Email' and sometimes as 'Contact_Email'? I'm not even sure if a blank space is actually allowed in

Re: Fairly lame question

field in the manual for how to create it. Cheers Terry - Original Message - > I think this can be done, but tried a few times with > no success. I want a column in a table that sets a > timestamp. > Instead of passing a value from the form though is > there a way mySql woul

Re: Help: Retrieving time stamp

t is useful in testing to have php output the full SQL query text to the browser, just so you can see it is correct before proceeding. Cheers Terry - Original Message - > Is there something wrong with this code ? > Still confused after reading the manual. > > $rsJo

Re: Using CREATE PROCEDURE/FUNCTION

I think you'll find that 'create procedure' and 'create function' don't appear until version 5.0 of MySQL. Which is why you get a syntax (are you sure you have the right version?) error. Regards Terry - Original Message - > Hi! > Anybody knows ho

4.1.4 still reports itself as 4.1.3b-beta

mysql. Have I done something stupid, or are others seeing this, too? Terry Riley -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: 4.1.4 still reports itself as 4.1.3b-beta

s for 4.1.4gamma, so it does look as though the upgrade went through, as far as copying files is concerned. Just restarted again with no change (just in case). Any other clues? Terry - Original Message - > Terry Riley <[EMAIL PROTECTED]> wrote: > > I have tried several instals

RE: 4.1.4 still reports itself as 4.1.3b-beta

Victor C:\MYSQL\BIN\mysqld-opt --defaults-file="C:\WINDOWS\my.ini" MySql is what the path-to-executable states. If I remember rightly, the new version should be mysqld, period. Is that what's wrong? Will I have to tweak the registry to change that? Cheers Terry - O

RE: 4.1.4 still reports itself as 4.1.3b-beta

ePath\ Never having had to fiddle with the registry much in the past, can I presume that if I ignore the first two and change the third one to read 'mysqld' instead of 'mysqld-opt', save and reboot, I should get the right one started? As you can tell, I'm a litt

Re: 4.1.4 still reports itself as 4.1.3b-beta

y it continued to use the older beta, though I thought I had. (FX: talks to self - 'must read the instructions *first* next time'). Thanks for your help, guys. Running the 'mysqld --version ' on the command line convinced me that I had actually installed it. Cheers Terry

RE: 4.1.4 still reports itself as 4.1.3b-beta

All sorted now, Ian. - Original Message - > Hope this helps > > If not try this (joking): > > http://foldoc.doc.ic.ac.uk/foldoc/foldoc.cgi?RTFM > > Ian > -- That's what was missing. LOL > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsub

Assertion failure (MySQL Administrator)

the Server and the Administrator, but am unable to until we have some downtime. Can I assume that, as the server is still running (apparently without problems) that the reported fault is only to do with Admin trying to read the log files, and nothing more serious? TIA Terry Riley -- MySQL Gener

  1   2   >