Re: JOIN table where not in other table

NOT IN (SELECT id FROM table2); -- Chris White PHP Programmer/DBacardi Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: JOIN table where not in other table

the full query look like right now (btw, there was a typo earlier, that should have been table1 and not table 1 :/)? -- Chris White PHP Programmer/DBarkTree Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: JOIN table where not in other table

On Wednesday 26 July 2006 11:00 am, Peter Lauri wrote: The query in full was exactly as you wrote it (but without the typo) :) Alright, yes, what is your version of MySQL? I'm in the 5.0.22 series here and that works just fine. -- Chris White PHP Programmer/DBackItUp Interfuel -- MySQL

Re: JOIN table where not in other table

was told by a coworker that phpMyAdmin adds those limits in. Wondering if taking the LIMIT out might do it. Also, are the tables really named table1 and table2 (Yah, I know.. but I have to make sure :( )? -- Chris White PHP Programmer/DBoy Interfuel -- MySQL General Mailing List For list

Re: Can Innodb reuse the deleted rows disk space?

leo huang wrote: hi, Chris Thank you for your advice! I know that Innodb use the logfiles circularly. Can Innodb re-use the deleted rows' disk space in tablespace? I'm sure it will, what makes you think it won't? You might need an 'optimize table' or something to see a reduction

Re: hi, I am not able view all the records in the tabel

Annam Srinivas wrote: Hi, Problem is like this. There is table with 'table_name-1' where, when I am executing the query like ' select * from table_name-1;' it is showing only 432 records but acctually there are 539 records in the table. when I select individual records from the table it is

Re: Stored procedures

, I'd almost LIKE someone to go No you're wrong, you just need to do this... ;) -- Chris White PHP Programmer/DBlast Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: change a empty value for 0

; -- Chris White PHP Programmer/DBamBam Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Can Innodb reuse the deleted rows disk space?

leo huang wrote: hi, Dilipkumar Thank you very much! I think I know the fact: The Innodb can't reuse the deleted rows' disk space. And a solution is: dump the data; shutdown mysql; delete the files; restart mysql; import the data. InnoDB does re-use the space inside the database, it's the

Re: Will UPDATE block on SELECT?

Ratheesh K J wrote: I would like to know whether a SELECT query would block an Update on the same table. The table is of InnoDB type. Since InnoDB tables apply row level locks should the Update queries be blocked until the select query completes? I experienced such a scenario wherein an

Re: Returning results as a field name

, n.question_id, n2.answer from blah n, blah n2 where n.name=n2.name and n.answer=n2.answer; +---+-++ | name | question_id | answer | +---+-++ | chris | 1 | yes| | chris | 2 | no | +---+-++ 2 rows

Re: How to control the number of sql dameons?

Prem wrote: Hi All, Could you please explain why some one needs multiple sql daemons and how to control the number of dameons. It forks so it can handle multiple queries at the same time. The main process (mysqld_safe) handles starting up the other processes and various other things (I

Re: Struggling with the logic

, equally. Sorry - I don't buy that. :-) Myself: I've never let local standards stand in the way of my using international ones. Excellent. -- Cheers... Chris Highway 57 Web Development -- http://highway57.co.uk/ To see tomorrow's PC, look at today's Macintosh -- Byte 1995 -- MySQL General

Re: Compilation Failure

. -- Chris White PHP Programmer/DBit Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Segmentation fault error accrued when gcc -o test -L/usr/lib/mysql -lmysqlclient test.c

is inserting that lt in there, that may be what's causing your problem (not to mention it's lt;...) printf(%s\n,row[i] != NULL ? row[i] : NULL); } } -- Chris White PHP Programmer/DBanned! Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Struggling with the logic

. Over here in Europe we at least use dd/mm/ (increasing unit size order), which is the next most logical, but to start with the middle-sized unit, put the smallest unit in the middle and end with the largest is just... weird! -- Cheers... Chris Highway 57 Web Development -- http

Re: Is a set current TIMESTAMP operation atomic when updating/inserting multiple rows?

a large set of data where an update would take a long time. I'm pretty sure it will do what you need though and set them all the same. -- Chris W KE5GIX Gift Giving Made Easy Get the gifts you want give the gifts they want One stop wish list for any gift, from anywhere, for any occasion! http

Re: mysqld-nt 100% CPU Utilization?

Robinson, Eric wrote: Our MySQL-based medical application has been running fine for 3 years. Last week, mysqld-nt started jumping up to 100% CPU and staying there until someone restarts the service. mysqlcheck found no errors in the database. I dumped it to disk and read it back in to create a

Re: How to disable foreign_key_checks when using mysqlimport?

[user] -h [host] -p test fixme.sql Thanks for your help. Dominik -- Chris White PHP Programmer/DBlankRounds Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Images Table

) Shove all the comments in one column (get ready for a HUGE table) 2) Create a separate image row for each comment (lots of duplicate data, bad!) KEY (img_id); Not needed, you already declared it a key above (PRIMARY KEY) Thanks for any help. nick -- Chris White PHP Programmer/DBoo

Re: retrieve value from an external file?

that and use it to open the file and get the contents, using that for whatever purpose you may have. -- Chris White PHP Programmer/DBlarg Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Incremental Backup

Kaushal Shriyan wrote: Hi ALL Can we have incremental backup of MySQL Database and if its there How do we do it Reposting your question again won't change the responses you have received (it'll actually annoy people more than anything else). -- MySQL General Mailing List For list

Re: Error when creating Foreign Key

, and how to fix it? Thanks, Jesse -- Chris White PHP Programmer/DBlankSlate Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Error when creating Foreign Key

On Wednesday 19 July 2006 01:07 pm, Jesse wrote:   `ID` int(10) unsigned NOT NULL auto_increment,   `CTID` int(11) NOT NULL, the storage types aren't the same. change CTID to INT(10) UNSIGNED NOT NULL and it should work. -- Chris White PHP Programmer/DBank Interfuel -- MySQL General

Re: Incremental Backup

Dan Trainor wrote: Kaushal Shriyan wrote: Hi ALL I would like to know following 2 things. 1) if i would like to take mysql incremental backup weekly cp /var/lib/mysql/ /backup/mysqlbak/ how can i do it by above command as i would like to run cron weekly for take mysql backup. i would like

Re: Can not find mysql_config

Fauzan Azhary wrote: Hi All, I've tried to upgrade mysql from MySQL 4.1.12 to MySQL 5.0.22. Before upgrading, I have like below : # rpm -qa | grep mysql mysql-4.1.12-3.RHEL4.1 mysql-server-4.1.12-3.RHEL4.1 mysqlclient10-3.23.58-4.RHEL4.1 mysql-devel-4.1.12-3.RHEL4.1 And after upgrading, I

Re: Converting TEXT to BLOB with special chars

going to have a chat with my boss... You could, it seems to me, get round all this by doing everything, from soup to nuts, in utf-8. Is there a reason why it can't all be in utf-8? -- Cheers... Chris Highway 57 Web Development -- http://highway57.co.uk/ ...but discriminating against Windows

Re: Converting TEXT to BLOB with special chars

connect script after connecting to the db: mysql_query (set names 'utf8'); or, better: if (!mysql_query (set names 'utf8')) { // handle the error } I hope that helps! -- Cheers... Chris Highway 57 Web Development -- http://highway57.co.uk/ Computers in the future may weigh no more than 1.5 tons

Re: Mysql ver. 5.0.22-standard for sun-solaris2.10 (SPARC): Error #60718 Can't open and lock privilege tables: Table 'mysql.host' doesn't exist

privilege tables: Table 'mysql.host' doesn't exist Did you install the initial database as stated in: http://dev.mysql.com/doc/refman/5.0/en/unix-post-installation.html ? (yes it's unix, but the installation process for the initial database still is the same). -- Chris White PHP Programmer/D(a)B

Permissions Weirdness

for any ideas. mysql 5.0.22-standard -- Chris White PHP Programmer/DBouncingAtTheClub Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Database or table level logging?

David Felio wrote: Is it possible to have general query type logging on just a specific database or table? I don't want all queries to all databases, I just need a log of accesses to a specific table. I figure I can use stored procedures or a separate mysql instance as a workaround if I need

Re: multiple InnoDB read-only server instances on same file system

pradhuman jhala wrote: I use MySQL version 4.1.18 with redhat-linux-gnu (i686). I have created a InnoDB database consisting of 210 GB ibdata files. I used InnoDB to allocate more memory and speed up the load. I want use it for read-only purpose and it works fine with one MySQL server instance.

Re: slow mysql...

Ritesh Shetty wrote: Hello, My mysql server sometime just slows responding to database queriesIt is as slow as less than 1 per sec. But it speeds up by itself after some time , I have noticed that when it speeds up there are lot more MYsql thread than just one thread when it is slow.

Re: Help: PHP won't connect to MySQL

Kay C. Tien wrote: Hi All, The simple script I'm testing works on a Linux server. I got tired of having to upload and test them, so I decided to install MySQL on my computer, which is running Win XP. MySQL works fine on it's own, I've set the the database and etc., but nothing happened

Re: Mysql cluster so slow...

Xueron Nee wrote: Hi all, There is a table contains about 60,000 rows. where select from this table with 'order by xxx' statement, it is tooo slow. but if i do it without 'order by xxx', it works fine. Is there any tips and suggestion for me? Thanks! Add an index to the 'xxx' column?

Re: Table 'mysql.host' doesn't exist

thomas Armstrong wrote: I created this very-simple '/etc/my.conf': [mysqld] basedir=/usr/local/mysql datadir=/usr/local/mysql/var socket=/tmp/mysql.sock --- But it doesn't still work. '/usr/local/mysql/var' hosts the data, but within 'mysql' subdirectory, there are only two

Re: arrays in stored procedures - pl. help

L P wrote: Folks, say I have a need to add multiple rows at the same time. for instance, say I'm collecting customer information and I want to add 3 addresses and 3 phone numbers at the same time for a customer. The above is quite straightforward to accomplish when there is only one set of

Re: load-file() doesn't work

[EMAIL PROTECTED] wrote: I'm using MySQL 3.23.36 on RH 7.1. I've created a table photos (in database album) with the following colums: ID NUM AUTO_INCREMENT PRIMARY KEY IMAGE MEDIUMBLOB I'm running mysql from the command line: mysql -u root 'root' has all privileges. The file I'm trying to

Re: Help: PHP won't connect to MySQL

Kay C. Tien wrote: At 05:37 PM 7/17/2006 Monday, Chris wrote: Kay C. Tien wrote: Hi All, The simple script I'm testing works on a Linux server. I got tired of having to upload and test them, so I decided to install MySQL on my computer, which is running Win XP. MySQL works fine on it's own

Re: problem with double data

Obed Soto Déctor wrote: Hi, i'm sorry for my english, i'm from México and i'm gonna do my best, i've made a store procedure but i have some problems becouse when a make a simple operation with double datas the result is not what i wait. We can't tell much without seeing at least the stored

Date comparisons

datefield = '2006-03-01' and datefield = '2006-03-31', but are there pitfalls I should know about? -- Cheers... Chris Highway 57 Web Development -- http://highway57.co.uk/ Is there something that sticks out that makes you an exceptional pole-vaulter? -- Adrian Chiles (to Sergei Bubka), BBC Radio

Odd join questing

` FROM serviceplanfeaturelink WHERE `SID` = '$SID' SELECT `PID`, `psoc`, `pName` FROM product WHERE pTypeID IN ($_FEATURES_TYPE_IDS) Just in case your aren't familiar with PHP the $SID is just a php variable. Any suggestions -- Chris W KE5GIX Gift Giving Made Easy Get the gifts you want give

Re: Odd join questing

Chris W wrote: It may not be odd to many but I can't seem to think of how to do this I have 2 queries below that give me exactly what I want each to do but now I want to combing them is such a way that in the second query I have one additional column that gives me a 1 on a row where

Re: I don't understand why SCSI is preferred.

dumping to disk. Then yes, you'd want a nice fast disk at that point. -- Chris White PHP Programmer/DBlowMeAway Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: I don't understand why SCSI is preferred.

. -- Chris White PHP Programmer/DBloomingOnions Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: I don't understand why SCSI is preferred.

, this is kind of a quick answer. Most will straightup go NTFS nowdays (iirc because of speed and security labels, but I haven't dealt with windows filesystems in awhile). -- Chris White PHP Programmer/DBooyah! Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: I don't understand why SCSI is preferred.

to be called Wrong, slapped, and cast from a bridge. Be careful on that, databases do more work in memory than anything else. That said, I'd be more worried about your memory capacity. Now, if you rely mainly on swap(virtual) memory, then you might worry more on that :). -- Chris White PHP

Re: I don't understand why SCSI is preferred.

better. -- Chris W KE5GIX Gift Giving Made Easy Get the gifts you want give the gifts they want One stop wish list for any gift, from anywhere, for any occasion! http://thewishzone.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: order desc problem

. -- Cheers... Chris Highway 57 Web Development -- http://highway57.co.uk/ But what ... is it good for? -- Engineer at the Advanced Computing Systems Division of IBM, commenting on the microchip, 1968 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Date functions

know that is just 3 days but other times I will want to find records that are a few hours old so I like using the formula. -- Chris W KE5GIX Gift Giving Made Easy Get the gifts you want give the gifts they want One stop wish list for any gift, from anywhere, for any occasion! http

Re: Date functions

Addison, Mark wrote: From: Chris W Sent: 07 July 2006 09:23 It's late and I just gave up reading the manual. Can someone please tell me the easiest way to do a query that will return all rows with a time stamp that is X number of seconds older than the current time? Something like

Re: add users in mysql 5.0 ubuntu dapper drake

Always CC the list. You will get better / faster responses. CREATE USER user [IDENTIFIED BY [PASSWORD] 'password'] thats is the syntax it tells me to use so i typed CREATE USER dimitri [IDENTIFIED BY [PASSWORD] '**']; were the starts are my password, i hav tried fiddling with the syntax

Re: Error in statement

Neil Tompkins wrote: I've the following SQL statement which I created in MS Access. My table layout is the same in mySQL but it says I have an error and the query doesn't run SELECT AccommodationOverview.Title, AccommodationOverview.AccommodationOverviewID,

Re: Dynamic link

, but the application logic should remain the same with regards to that. -- Chris White PHP Programmer Interfuel 805.642.2200 x110 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Dynamic link

user_status ( id ); -- Chris White PHP Programmer/DBoo Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: automatic timestamp

Nestor wrote: People, I have the following table: DROP TABLE IF EXISTS bid; CREATE TABLE bid ( bid_id int(11) NOT NULL auto_increment, bid_proj_name varchar(100) NOT NULL default '', bid_prop_name varchar(100) NOT NULL default '', bid_amount varchar(20) NULL default '', bid_sub_name

Re: Question on mysqldump --single-transaction

Dominik Klein wrote: Hi everyone I'm wondering about the --single-transaction option on mysqldump. Documentation says --- This option issues a BEGIN SQL statement before dumping data from the server. ... --- So does this include the entire dump in one transaction? Or is it one transaction

Re: add users in mysql 5.0 ubuntu dapper drake

Dimitri Mallis wrote: hi list firstly am in the right place to ask this sort of question i installed mysql 5.0 from the repos on ubuntu dapper drake i could only go in to mysql when i was root, then i guess i am suposed to add users there. You've got things confused. 'mysql' the service,

Re: Dynamic link

z247 wrote: Is this the only option? I get Access denied. CREATE TRIGGER ins_sum BEFORE INSERT ON account FOR EACH ROW SET @sum = @sum + NEW.amount; MySQL said: Documentation #1227 - Access denied; you need the SUPER privilege for this operation Read the error message. You don't have super

Re: binary select - case sensitive

kalin mintchev wrote: hi all... i found this on the mysql dev manual site: MySQL 4 and later string comparisons, including DISTINCT, aren't case sensitive unless the field is declared as BINARY or you use BINARY in your comparison. so here i tried it but no good. any ideas?! the field is not

Re: PostgreSQL or mySQL

or something of the like. -- Chris White PHP Programmer/DBlameSomeoneElse Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Getting unique values

... Chris Highway 57 Web Development -- http://highway57.co.uk/ When you've seen one shopping centre, you've seen a mall. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: varchar(5) and select question

the display width with regards to WHERE clauses, it just wants to see if the field matches and be done with it. The real answer to your issue would be to increase the display width, possibly through ALTER TABLE. -- http://www.w-fenec.org/ -- Chris White PHP Programmer/DBlame Me Interfuel

Re: Getting unique values

picid. Like I said - it wasn't an ideal setup in the first place, but anyway it seems to be solved now. See my post earlier today. Thanks for the interest though. -- Cheers... Chris Highway 57 Web Development -- http://highway57.co.uk/ Everything Is More Difficult Than It Appears -- Adam C

Re: LIMIT Question

. That's why ORDER BY id DESC is used, it basically flips your table reverse, so that last inserted (in essence the highest ID) is first, all the way down to the first inserted (the lowest ID). Then LIMIT 50 will give you 50 from highest id to lowest ID, or the last 50. -- Chris White PHP

Getting unique values

MySQL 5-type answer I'd be interested in that too. -- Cheers... Chris Highway 57 Web Development -- http://highway57.co.uk/ The less a statesman amounts to, the more he loves the flag. -- Kin Hubbard -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: How can I connect to mysql server using PHP?

But when I call mysql_pconnect(localhost,root,) in my web page, the server return me an error, saying Can't connect to socket:/var/lib/mysql/mysql.sock(13). How can I do? Fang -- Chris White PHP Programmer/DB Freeloader Interfuel -- MySQL General Mailing

Re: How to Output to Screen in Procedure

gonna get rather tacky output. I'm using MySQL 5. Thanks, Jesse -- Chris White PHP Programmer/DBad Boy Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: multi-column indexes on InnoDB tables

running until the generators kick in, or you pay more than that for data loss. -- Chris White PHP Programmer/DBrain Freeze Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Please Help - Stored Procedure Issue

On Tuesday 27 June 2006 01:52 pm, Jesse wrote: @cInvNo replace all instances of this with just cInvNo. cInvNo is already declared as an OUT variable, and @cInvNo will be set to that value when you run: CALL sp_GetNextInv(-1,@cInvNo); -- Chris White PHP Programmer/DBBD Interfuel -- MySQL

Re: ¿mysql_stmt_bind_param under windows bug?

in bind[0]. Take that line out and things should work. -- Chris White PHP Programmer / DBlair Witch Project Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Multiple Entries

the ucwords (http://www.php.net/ucwords) function in PHP to make it uppercase for the values. primary key (sports_id) ); -- Chris White PHP Programmer/DB BD Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: PHP mysql_connect

At 15:47 +0200 23/6/06, Jørn Dahl-Stamnes wrote: Yes, I forgot to say that I was using PHP... Oh, I think the clue was in the subject line. :-) -- Cheers... Chris Highway 57 Web Development -- http://highway57.co.uk/ Revolution: an abrupt change in the form of misgovernment. -- Ambrose

Re: Embedded MySQL

server (libmysqld). -- I'm assuming this is what you want -- TIA, Asif -- Chris White PHP Programmer/DB Jaguar Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Math problem

a dollar amount to another number. Has anyone else seen this problem? What does a show create table give for the price column? I bet it is varchar. The only way to make it work then would be to trim off the dollar sign and cast it to a float or double. -- Chris W KE5GIX Gift Giving Made Easy

Re: New to the group

for. -- Cheers... Chris Highway 57 Web Development -- http://highway57.co.uk/ Some speakers electrify their listeners, others only gas them. -- Sydney Smith -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Problems when compiling the source

: ../mysys/libmysys.a(mf_pack.o)(.text+0x4ef): In function `unpack_dirname': : warning: Using 'getpwnam' in statically linked applications requires at runtime the shared libraries from the glibc version used for linking -- Chris White PHP Programmer/DB Carrier Interfuel -- MySQL General Mailing List

Re: Server Load Question

server -- Chris White PHP Programmer/Dances With DB's Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Aborting a greedy querry from the command line

stop that query? -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Novato, CA U.S.A. -- Chris White PHP Programmer/DB Overclocker Interfuel -- MySQL General Mailing List

Re: Aborting a greedy querry from the command line

On Monday 19 June 2006 04:08 pm, Logan, David (SST - Adelaide) wrote: Hi Chris, I've noticed that a Ctrl-C will also leave the query running (5.0.22 - Linux) and I've had to use the kill from mysqladmin or mysql client to get rid of it. Huh, that's odd, it should abort everything entirely

Re: [mysql] Attention List

: From: mysql@lists.mysql.com Through some magic mojo and become the MySQL mailing list. So in conclusion, don't take what you see worth a grain of salt when it comes to who things are from in the email world. -- Chris White PHP Programmer/DB PLEASE NO MORE LEFT JOINS ;( Interfuel -- MySQL

BBEdit tip (was: Differences between MySQL 4 and 5 for scripts)

as grey bullets where you expect normal spaces. -- Cheers... Chris Highway 57 Web Development -- http://highway57.co.uk/ Empty warhead found in White House -- Sign carried on New York peace rally, April 2003 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: Problem With Join Syntax

be a way to do it with stored procedures, I'm just not sure how.. Thanks. Albert Padley -- Chris White PHP Programmer/DB Fighter Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: increase the search speed

://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html -- Chris White PHP Programmer/DB Fawn Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: database size

. Although I'm not sure why this question isn't in the FAQ as often as it is posted here. -- Chris W KE5GIX Gift Giving Made Easy Get the gifts you want give the gifts they want One stop wish list for any gift, from anywhere, for any occasion! http://thewishzone.com -- MySQL General

Re: How To Pronounce MySQL

-- Chris White PHP Programmer/DB Howler Monkey Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How To Pronounce MySQL

are for I personally will avoid these situations. I don't, I like to live on the edge -- Chris White PHP Programmer/DB Fly Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How To Pronounce MySQL

On Friday 09 June 2006 11:27 am, Samuel C Flores wrote: Um, did anyone actually answer Jesse's question? Um, did you read the all the threads? If you'll notice the first message by Jimmy Guerrero pretty much answers it, all he did was quote the MySQL site. -- Chris White PHP Programmer

Books on MySQL 5

might have missed. I know there's: Beginning MySQL Database Design and Optimization: From Novice to Professional (Apress, 2004) And it does say it covers MySQL5, I'm just not sure to what extent. -- Chris White PHP Programmer/DB Virus Interfuel -- MySQL General Mailing List For list archives

Stored Procedures and DECLARE weirdness

else I'm missing? -- Chris White PHP Programmer/DB Knight Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Stored Procedures and DECLARE weirdness

, www.mysql.com -- Chris White PHP Programmer/DB Unofficial Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: How To Pronounce MySQL

At 7:38 -0500 8/6/06, Jimmy Guerrero wrote: The official way to pronounce MySQL is My Ess Que Ell (not my sequel), but we don't mind if you pronounce it as my sequel or in some other localized way. Miss Quill? -- Cheers... Chris Highway 57 Web Development -- http://highway57.co.uk/ Among

Full text search novice

no change. -- Cheers... Chris Highway 57 Web Development -- http://highway57.co.uk/ Among the things money can't buy is what it used to. -- Max Kauffmann -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: myisamchk (was: name 'Szczech' returns more rows then 'Szczec%')

saw your message - with the server running - and I've just run it again after stopping the server, and got identical results. You must be logged in as root or mysql. sudo does the trick. :-) -- Cheers... Chris Highway 57 Web Development -- http://highway57.co.uk/ Among the things money

Re: ERROR 1064 (42000): You have an error in your SQL syntax;

, maybe you need to specify the type even if it's unchanged (I assume all you want to do is rename the column?). So supposing director_id was a SMALLINT(3) UNSIGNED, try: ALTER TABLE actors CHANGE director_id actor_id SMALLINT(3) UNSIGNED; Any good? -- Cheers... Chris Highway 57 Web Development

re: ERROR 1064 (42000): You have an error in your SQL syntax;

is. Wow! I was right. I'm learning... :-) -- Cheers... Chris Highway 57 Web Development -- http://highway57.co.uk/ If at first you don't succeed, try, try again. Then quit. No use being a damn fool about it. -- W.C. Fields -- MySQL General Mailing List For list archives: http://lists.mysql.com

Re: DateTime limits

-01 00:00:00' I only have 4.1 so I don't know what would happen in 5 -- Chris W KE5GIX Gift Giving Made Easy Get the gifts you want give the gifts they want One stop wish list for any gift, from anywhere, for any occasion! http://thewishzone.com -- MySQL General Mailing List For list

XML - DB Conversion

Hi all, I'm currently looking for a tool that will take XML and produce a database from it. Not really looking for anything in particular at this point, just sort of scoping around. Anyone know of such a tool? -- Chris White PHP Programmer/DB Sloth Interfuel -- MySQL General Mailing List

myisamchk (was: name 'Szczech' returns more rows then 'Szczec%')

' - might be at data/aptguserdb/attractions.myd (and .myi for the index), but when I try the myisamchk command with the full path to there I get 'file does not exist'. I'm stumped! How exactly do I go about this? -- Cheers... Chris Highway 57 Web Development -- http://highway57.co.uk/ Despite

Re: myisamchk (was: name 'Szczech' returns more rows then 'Szczec%')

At 18:34 +0100 4/6/06, Chris Sansom wrote: I'm stumped! How exactly do I go about this? It's OK - I sorted it out. Turns out I needed to use upper case for the .MYI. Doh! -- Cheers... Chris Highway 57 Web Development -- http://highway57.co.uk/ Old professors never die; they just lose

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