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 f

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

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

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 achieve

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 usin

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

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 help

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 lo

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 ('actor','director','producer','executive_pro

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 fie

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 P

Re: Innodb, why not?

Java for example), it makes it a good 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: 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 this:

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 lis

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 ins

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 (i

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 h

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 th

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 /|where

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

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 defa

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

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 MIC

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 som

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 wha

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 t

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 IN

Re: Filling blanks on SELECT

Ashley M. Kirchner wrote: I'd try php here, something like: $mins[] = empty($row['the_minute']) ? 'blank value' : $row['the_minute']; $temp_f[] = empty($row['avg_temp_f']) ? 'blank value' : $row['avg_temp_f']; $temp_c[] = empty($row['avg_temp_c']) ? 'blank value' : $

Re: Interview questions?

quot; types and "You go to create a foreign key constraint on an InnoDb table 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 th

Re: Recommended Hardware Configurations

pgrade the server later on (if you get 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?

> > Actually the source tarball IS on the mysql download 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 -- MyS

Re: Number extraction from a string

ow they compare. If a regex 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}$') de

Re: Number extraction from a string

M num_test WHERE value like '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: Number extraction from a string

--+---+ | value_num | value | +---+---+ | 400 | N400 | | 500 | 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: Function problem

t;=200) then (ceiling(x+x*0.09)) You've declared a return value for your function, but it doesn't return anything, what you probably want is: > WHEN x<50 THEN return ceiling(x+x*0.25) and the like for the rest of the cases. -- Chris White PHP Programmer Interfuel -- MySQL Gene

Re: Create stored procedures with Query Browser

y and paste from console into the 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: Header Files

ng MySQL in C/C++. > > Thanks 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://lis

Re: Stored procedure parameters problem

edure MyTest(strVal VarChar) > Begin > Select Field1, 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

Re: Calling Stored Procedures from PHP

am.php which has an example as to how to utilize 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: One big table or several smaller tables?

which would 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

Re: Book Recommendation

27;t agree with is the example code 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

Re: Calling Stored Procedures from PHP

al: CALL CURVAL(@cur) and the value can 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: How to make a sequence field

t; How can I do 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

Combined Primary Key and Auto Increment Primary Key

nnoDb; 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. > K

Re: Possiable Trigger Use

t the deleting 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 arc

Re: Query Question

(int_value - 1) as value3 FROM 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 Inte

Re: cell colors PHP/MySQL

use the class attribute, setting them 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: 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? --

Re: how to store quotes in mysql?

TE FROM table; SELECT('ah]'); where [] is what the user inputs. Now when displaying, you'll have 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

Re: manual on stored procedures and triggers

#x27;re looking for book form, I found "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/

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

j_act_id from c2iedm_dev2.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.co

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

7;re not using IN anywhere 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: 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: Backup SQL

n of "what if" type 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 -- M

Re: Backup SQL

27;d really see this as an issue is if you were trying to run both at once, which 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: MySQL on AMD Althelon Dual Core processors

A note though that it was compiled (Due 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 uns

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

an say what are # between 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 l

Re: how to move datadir to a different file system

mport the tables again. 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

ou using phpMyAdmin? I 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 Gener

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 -

Re: JOIN table where not in other table

LIMIT 0, 100' at line 1 What's 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:

Re: JOIN table where not in other table

FROM table 1 WHERE id 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: change a empty value for 0

saccion SET cantidad = 0 WHERE cantidad IS NULL; -- 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: Stored procedures

riations myself hoping it would. You know, 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: Segmentation fault error accrued when gcc -o test -L/usr/lib/mysql -lmysqlclient test.c

your client is inserting that < in there, that may be what's causing your problem (not to mention it's <...) > printf("%s\n",row[i] != NULL ? row[i] : "NULL"); > } > } -- Chris White PHP Programmer/DBanned! Interfuel -- MySQL General Mailing List For

Re: Compilation Failure

f things worked before, check if any updates to glibc were done. Otherwise I'd just google around a bit for AIX+mmap64 and see what comes up. -- 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: retrieve value from an external file?

tion to the file, then grab 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: Images Table

dd comments. You'd have 2 choices: 1) 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. >

Re: How to disable foreign_key_checks when using mysqlimport?

s use the ever efficient test database to test things first: mysql -u [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: 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 -- My

Re: Error when creating Foreign Key

y this is happening, 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]

Permissions Weirdness

s ahead of time 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: 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

or #60718 Can't open and lock 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 initia

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

sunny Tuesday and want to try something new out. Fat32/NTFS Well, 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 Programme

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

er as if the main one goes down, I've got a real physically separated backup to work with. In the end that's what matters. -- 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.

ere doing a substantial amount of logging, or db 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.

gt; I am more than willing 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 m

Re: Dynamic link

CES 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: Dynamic link

ULL, and you'd have to verify that the columns were not NOT NULL, 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: PostgreSQL or mySQL

r "Postgres MySQL comparison" 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

SELECT is not cut has it is in the INSERT ? SELECT probably doesn't care about 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 TA

Re: LIMIT Question

the > dates in this scenario. 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

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

Re: multi-column indexes on InnoDB tables

UPS system to keep your things 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: How to Output to Screen in Procedure

;message", but you're 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: How can I connect to mysql server using PHP?

mysql/bin/mysqld -uroot -S/var/lib/mysql/mysql.sock > 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? &g

Re: Multiple Entries

> sport_name text not null, Woh there! TEXT is probably overkill, I'd recommend VARCHAR for that (120 or so, 255 if you're feeling lucky). As far as the sport_name, you could store it as lowercase, and use the ucwords (http://www.php.net/ucwords) function in PHP to make it upperca

Re: ¿mysql_stmt_bind_param under windows bug?

allocated MYSQL_BIND 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: Embedded MySQL

-server Build the embedded 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

t because of certain glibc functions: > ../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 -- Chr

Re: Aborting a greedy querry from the command line

3 > _/ _/ _/_/_/ Mobile: 0417 268 665 > *_/ ** > ** _/ Postal: 148 Frome Street, > _/ ** Adelaide SA 5001 > Australia > invent > ---

Re: Aborting a greedy querry from the command line

m the command line and have it really > stop that query? > -- > - > Scott HanedaTel: 415.898.2602 > <http://www.newgeo.com> Novato, CA U.S.A. -- Chris White PHP Pro

Re: Server Load Question

port can only be used by one 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: [mysql] Attention List

u want in there. So I could say: 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 Programme

Re: Problem With Join Syntax

do they need to be in a single row? There MIGHT 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

u might want to just check the MySQL manual entry on fulltext searches for more information (and user comments): http://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: Stored Procedures and DECLARE weirdness

m > Madison, Wisconsin, USA > MySQL AB, 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]

  1   2   >