Re: MySQL Daylight Savings Time Patch

Sun, Jennifer wrote: Any answers for the question below ? Is there a DST patch for MySql 4.0.20? Thanks. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, February 09, 2007 9:30 AM To: mysql@lists.mysql.com Subject: MySQL Daylight Savings Time

Re: Alter table - adding constraints?

Jay Paulson wrote: I really don¹t know what to do because I keep getting this error. Any ideas? SQL query: ALTER TABLE pl_reports ADD CONSTRAINT fk_region FOREIGN KEY ( region ) REFERENCES Region( id ) ON UPDATE CASCADE ON DELETE CASCADE MySQL said: Documentation #1005 - Can't create table

Re: Alter table - adding constraints?

Jay Paulson wrote: 2) both tables have data in them. This is most likely your issue then, depending on the table size, go through and make sure that anything in the referenced column matches the referencing column. You should also be able to use SHOW INNODB STATUS to see what's possibly

Re: Numeric sorting within a string

Brian Mansell wrote: This is totally possible... Chris say your table is test, and the column is test_col.. use the following, and if the number is always at the end.. and always has a space in front of it this will work: SELECT test_col, SUBSTRING_INDEX(test_col, '', 1) as test_col_str,

Re: Export Results?

Jesse wrote: Is there a way to export results of a query to a file? In other words, if I do a select * from somefile, is there a phrase like send output to somefile.txt, or something? I've searched the help file, and I guess I don't know what I'm looking for, if it even exists. I'm using

Numeric sorting within a string

I'm wondering if there is a way to do a numeric sort when the number exists in a string. More clearly, take for example: Radius 1200 Radius 1500 Radius 1800 Radius 300 Radius 600 Radius 900 Being that character wise 1 is before 3, I'm wondering if there's a way through the database to

Re: incompatible libmysqld.a

Carlos Soria wrote: Hello, I am working with MySQL 5.0.24 on Mandriva-Linux 2007. I can't compile book example test1_libmysqld due to an incompatibility gcc -g -W -Wall -I/usr/include/mysql -D_THREAD_SAFE -D_REENTRANT -static test1_libmysqld.c -L/usr/lib/mysql -lmysqld -lz -lm -lcrypt

Re: Anywhere to FTP latest mod_auth_mysql?

Jonathan Mangin wrote: File downloads are enabled in IE but refuse to work. Does anyone know where I can FTP the latest version of mod_auth_mysql While this particular apache module does deal with mysql, the question you are asking is more oriented to the module working with apache than

Re: innodb madness

Marten Lehmann wrote: How can I check which tables are using innodb with sql? How can walk through the tables with show databases and show tables. Thanks. This somewhat depends on how the tables were declared. If you used ENGINE=InnoDb; in the CREATE TABLE sequence, you'd be able to loop

Re: UTF-8 collation problem with greek extended characters

Sven Fuchs wrote: These characters are stored/retrieved correctly. But they are wrongly regarded the same character by statements like SELECT * FROM tablename WHERE fieldname LIKE '[greek small eta]' The database's character-set is set to UTF-8 Unicode (utf8) and the table's and varchar

Re: MySQL to Postgres

Jim C. wrote: CREATE TABLE credits ( person integer NOT NULL default '0', chanid int NOT NULL default '0', starttime timestamp NOT NULL default '1970-01-01 00:00:00+00', role VARCHAR NOT NULL, CONSTRAINT role_check CHECK role IN

Re: Innodb, why not?

idea as any to use the table. Another thing to consider is: -- Chris White PHP Programmer Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Innodb, why not?

Another thing to consider is: heh, silly mail client :). Another thing to consider is this: http://dev.mysql.com/doc/falcon/en/index.html Though it's Not recommended for production use, I've heard people still use it in production environments. -- Chris White PHP Programmer Interfuel

Re: Connecting from a remote computer

Just to toss something else in here. A lot of times you have a server that you can connect to by ssh, but because of firewalls, can't access mysql through. If you can, however, connect to the database through ssh, you can do port forwarding. In *nix systems it should be something like

Re: query taht works on mysql4 but doesn't on mysql5?

[EMAIL PROTECTED] wrote: FROM .$tn., bill_info as b LEFT JOIN shipp_info as sh ON (b.bill_id=sh.bill_id That would be the usage of multiple from's combined with a left join. Unfortunately with mysql 5 you can't do this. You're going to have to do bill_info as a left/right/inner join

Re: mysql server has gone away

If I fire a lot of querries, I get an error mysql server has gone away/lost connection with the server . I've seen this error for the second reason you've mentioned, wrong queries. You'll need to show us the query so we can see any possible issues. -- MySQL General Mailing List For list

Re: Date format question

Is it possible in mysql to create a date field that stores year and month only (-MM) without having to zero out the day or use varchar type fields Best here is to just use a DATE field, then use DATE_FORMAT when you want to pull up the customized date. It will get stored as a timestamp

Re: loading files onto MySQL

Scott Yamahata wrote: Newbie question here. Using Mac OSX Server 10.4.4. Do most MySQL tasks in terminal window. Recently purchased software that tells me to go to Control Panel (which I don't think I have--though I have MySQL tools) and load their file onto the MySQL database. Generally

Re: multiple instances of mysql on a given server

bruce wrote: hi... i'm trying to determine if it's safe, or if there are pitfalls to running simultaneous copies of mysql on a given server. assume that the instances are completely separate, dirs/ports/etc... The one reason why is because of the network load and the memory usage. MySQL

Re: automated character set conversions for tables

I did a DB conversion before that with ALTER DATABASE db_name CHARACTER SET utf8 That worked wonderfully, except not as expected. ;-) It basically converted only the database itself. so I had to do a separate ALTER TABLE ... for each table. The database encoding more establishes the default

Re: Does Update allow for aliases?

Richard Reina wrote: I am trying to update from one table to another but I get a syntax error when I try: UPDATE from maindb.orders o, altdb.orders ao SET o.price=ao.price WHERE o.ID=a.ID; First off, it'd be best if possible (I know some cases prevent it) to upgrade your server. The

Multiple table updates (Was: Does Update allow for aliases)

Reading the noted previous thread, I was curious as to updating multiple tables. I read the MySQL docs, which mentions that you can do it: Multiple-table syntax: UPDATE [LOW_PRIORITY] [IGNORE] /|table_references|/ SET /|col_name1|/=/|expr1|/ [, /|col_name2|/=/|expr2|/ ...] [WHERE

Re: Choose a random record from a list of duplicates

zv Green wrote: Hello all, What I want to do is select all the records from the table but where there are duplicate entries (based on say, the surname and postcode fields) pick a random record and then ignore the rest. If you want to pick a random record, you can do ORDER BY RANDOM LIMIT 1

Re: How to pronounce MyISAM and InnoDB

I'll bite.. Sorry for this silly question but I've been always had trouble pronouncing MyISAM and InnoDB. How do you pronunce them? I pronounce MyISAM as give-me-foreign-keys and InnoDB as curse-you-cryptic-foreign-key-errors (currently running far and fast) -- MySQL General Mailing List

Re: how to get (lapse) time in microseconds ?

C.R.Vegelin wrote: Hi List, I need the lapse time in microseconds. I have tried various things, like: SELECT TIME_FORMAT(CURTIME(), '%f'); SELECT TIME_FORMAT(NOW(), '%f'); Your arguments are reversed. It's: SELECT TIME_FORMAT('%f',CURTIME()); SELECT TIME_FORMAT('%f',NOW()); SELECT

Re: Deleting Foreign Key

Mungbeans wrote: ALTER TABLE `mytable` DROP FOREIGN KEY `keyname` #1025 - Error on rename of '.\database\mytable' to '.\database\#sql2-6ec-11' (errno: 152) ALTER TABLE `mytable` DROP INDEX `keyname` #1025 - Error on rename of '.\database\#sql-6ec_13' to '.\database\mytable' (errno: 150 Oh

Re: group by/select issue..

bruce wrote: i'm trying to figure out how to create a select query that groups the tbl around 'name' such that if i want all names that do not have a status=3, i'd get a single row for 'sue' and 'bob' I'm not sure why `SELECT name FROM dog WHERE status = 3 GROUP BY name;` wouldn't give you

Re: 5.1.14-beta with ssl build failure

Duncan Hutty wrote: I attempted to build 5.1.14-beta with ssl support and it failed (output below). It builds quite happily on this system without the ssl support parameter to configure. Since it appears to fail in an area (timezone system) that to me seems rather unrelated, I wondered if

Re: select statement question

Aaron Cannon wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all. I hope this is the right place to ask this. I have two tables, A and B. Each of these tables has a column with integers. The column in table A is C and the one in B is D. SELECT c.value FROM c WHERE c.value NOT

Re: Filling blanks on SELECT

Ashley M. Kirchner wrote: ?php while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) { $mins[] = $row['the_minute']; $temp_f[] = $row['avg_temp_f']; $temp_c[] = $row['avg_temp_c']; } ? I'd try php here, something like: ?php while($row =

Re: Interview questions?

and it fails, what things should you look for to solve the issue? types. That's why it's really hard to find anything like that on google. The best thing to do would be describe what exactly this person will be doing. -- Chris White PHP Programmer Interfuel -- MySQL General Mailing List

Re: Recommended Hardware Configurations

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

Re: Where to get Source Distribution of MySQL Server 5.0 Standard for FreeBSD?

site. You are in a dugeon, there is a door to your left and a torch to your right. The wind of sarcasm slowly blows by you, and you sit and wonder in dispair. 1) Move 2) Jump 3) Fight -- Chris White PHP Programmer Interfuel -- MySQL General Mailing List For list archives: http

Re: Number extraction from a string

is required, you could have something like: SELECT SUBSTRING(value,2) as value_num, value FROM num_test WHERE value x; where x is one of the following depending on the situation: REGEX('N[0-9]+$') REGEX('N[0-9]+') REGEX('N[0-9]{3}$') depends on how specific you want to get really. -- Chris White PHP

Re: Create stored procedures with Query Browser

script editor and do it there. -- Chris White PHP Programmer Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Function problem

for your function, but it doesn't return anything, what you probably want is: WHEN x50 THEN return ceiling(x+x*0.25) and the like for the rest of the cases. -- Chris White PHP Programmer Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Number extraction from a string

| N500 | +---+---+ 2 rows in set (0.00 sec) -- Chris White PHP Programmer Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Number extraction from a string

'N%'; Though this wouldn't work if you had like Night or NIGHT. Is that going to be a choice? -- Chris White PHP Programmer Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Header Files

in advance... Any reason in particular you need that specific functionality? You can always hit one of the standard library time functions (man time.h for example). -- Chris White PHP Programmer Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: Stored procedure parameters problem

, Field2, Field3 From MyTable Where Field3=strVal; End varchar is meant to be variable, so it MUST have a length supplied. If you want the same flexibility without specifying a specific length, use TEXT instead. -- Chris White PHP Programmer Interfuel -- MySQL General Mailing List

Re: Calling Stored Procedures from PHP

a prepared query. -- 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: Calling Stored Procedures from PHP

be received by: SELECT @cur; -- Chris White PHP Programmer Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Book Recommendation

not showing separation of frontend and backend, but the php/mysql interaction stays the same. Take it for that and it's a great book imho. -- Chris White PHP Programmer Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Re: One big table or several smaller tables?

be converted to a timestamp storage wise and would become an indexable integer. Even 1,000,000+ rows shouldn't have that much of an effect. You'll also have the nice functionality of MySQL's date/time functions. -- Chris White PHP Programmer Interfuel -- MySQL General Mailing List For list archives

Re: How to make a sequence field

this in mysql ? I did somewhat of a mock sequence generator using stored procedures: http://www.gen2net.net/articles/mysql-stored-procedures hope that helps. -- Chris White PHP Programmer Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Combined Primary Key and Auto Increment Primary Key

; note that this table will mostly consist of table writes (updates, inserts, deletes). -- Chris White PHP Programmer Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Become mysql user

On Monday 21 August 2006 08:40 am, Karl Larsen wrote: I think I need to su - mysql and it askes for a password. What is that password? If you're root you don't need to enter a password. If you can't become root then the system admin has that information. Karl -- Chris White PHP

Re: Query Question

data_values; +---+++ | int_value | value2 | value3 | +---+++ |11 | 12 | 10 | +---+++ 1 row in set (0.00 sec) You can do like that. -- Chris White PHP Programmer/DBrother Interfuel -- MySQL General Mailing List

Re: Possiable Trigger Use

of tables. Are you sure you didn't mean rows? Removing tables like will accept a table name and that's about it, you can't run conditions for it (as far as I know..). -- Chris White PHP Programmer/DBloomers Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: manual on stored procedures and triggers

The Definitive Guide to MySQL 5 by Michael Kofler (Apress) to be a good resource. Thank you, Vittorio -- Chris White PHP Programmer/DBarbaric Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: how to store quotes in mysql?

to unescape the slashes generally. Unfortunately I can't remember in PHP if that's because of magic quotes or just the way the db has it stored. My gut instinct is the former. thanks for any help. -afan -- Chris White PHP Programmer/DBaboon Interfuel -- MySQL General Mailing List For list

Re: how to store quotes in mysql?

On Wednesday 09 August 2006 08:37 am, Kristen G. Thorson wrote: [ stuff here ] kgt I'm confused.. did you read my email? Most of what you said doesn't seem to correlate with what I said. Can you quote the specific lines that you're disagreeing with? -- Chris White PHP Programmer/DBacillus

Re: cell colors PHP/MySQL

to the respective values. thanks -- Chris White PHP Programmer/DBanjo Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Trouble with using IN for a sub-query statement

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

Re: Trouble with using IN for a sub-query statement

.act_functl_assoc where subj_act_id =24; show? Sorry about that, typo on my part, but I have tried it as above and I get the error I mentioned. -- Chris White PHP Programmer/DBlinds Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Backup SQL

in my opinion is a Bad Idea(tm). -- Chris White PHP Programmer/DBeer Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Backup SQL

questions can easily be answered by a quick skim through the sql before running it. If you believe that to be tiresome, think of how long it's going to take you to get order from chaos when things go down. -- Chris White PHP Programmer/DBirth Interfuel -- MySQL General Mailing List For list archives

Re: Backup SQL

On Friday 04 August 2006 11:26 am, Daniel da Veiga wrote: Think better before you hit send. Dude -- -- Chris White PHP Programmer/DBarn Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: SQL Plus (oracle) and SQL (mysql)

sqlplus (oracle) and sql (mysql) If you change servers it should be as simple as changing connection strings (ie. what host). Not sure if that quite answers your question. -- Chris White PHP Programmer/DBranded Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com

Re: MySQL on AMD Althelon Dual Core processors

to certain custom configuration options required), but the binaries should be the same wrt stability. -- Chris White PHP Programmer/DBoldSansVeraMono Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: how to move datadir to a different file system

. That's the safer bet. -- Chris White PHP Programmer/DBackToTheFuture 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

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

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

Street, _/ ** Adelaide SA 5001 Australia invent --- -- Chris White PHP Programmer/DBreak My Mind Interfuel -- MySQL General Mailing List For list

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

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

  1   2   >