Sum and Total Query

What's the proper way to query for a total for a value and also the total for all values for a particular set of parameters? For example, I have a table of orders that customer service reps make. The reps place multiple orders per day for various products. I'm trying to pull a report that displays

Re: Sum and Total Query

Sorry... The dates were incorrect in my previous post. They are corrected below. --- Josh <[EMAIL PROTECTED]> wrote: > What's the proper way to query for a total for a > value > and also the total for all values for a particular > set > of parameters? > > For e

Stored Procedure Problem

I posted this same item on the mysql forum but the only place that looked remotely appropriate was under the Newbie section... I'm not sure if it will be answer there so I thought I might toss it out here to see if there were any takers. I'm baffled as to why this stored procedure is acting this

Re: Stored Procedure Problem

Peter, nice catch. Changing the parameter names did the trick. Thanks. --- Peter Brawley <[EMAIL PROTECTED]> wrote: > Josh wrote: > > I posted this same item on the mysql forum but the > > only place that looked remotely appropriate was > under > > the Newbie

Re: Compare lists Query?

Here's one method: SELECT cl1.list_name, count(*) as count FROM customerList cl1 WHERE cl1.id IN (SELECT cl2.id FROM customerList cl2 WHERE cl2.list_name='CA10') and cl1.list_name != 'CA10' GROUP BY cl1.list_name --- Yesmin Patwary <[EMAIL PROTECTED]> wrote: > Good morning all, > >

Re: Compare lists Query?

SELECT statements. --- Yesmin Patwary <[EMAIL PROTECTED]> wrote: > Dear All, > > I had some issues in past with timestamp fields as a > result I am unable to upgrade to mysql 4.1 version. > I am sure below the query recommended by Josh works > with 4.1 or above. Would i

Re: Problems with timestamp field after upgrading MySQL Server.

Sure is... SELECT DATE_FORMAT(dateField,'%Y%m%d') as dateField Take a look at: http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html -Josh --- Yesmin Patwary <[EMAIL PROTECTED]> wrote: > Dear All, > > First of all, I would like to thank to Jos

Table Size

Hello, I have a database that is growing at a rate of 4-5 MB per day (that number is getting larger as well). Not too bad but I'm trying to clean up the tables to minimize the amount of space they take up. I have one particular table that has 2 columns: rolID int(10) unsigned repID int(10) u

Re: Table Size

sec) - Original Message From: Baron Schwartz <[EMAIL PROTECTED]> To: Josh <[EMAIL PROTECTED]> Cc: mysql@lists.mysql.com Sent: Saturday, October 27, 2007 10:17:32 AM Subject: Re: Table Size Josh wrote: > Hello, > > I have a database that is growing at a rate of 4-5 MB per day (t

Re: Table Size

ment: NULL Create_time: 2007-05-19 21:17:58 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL - Original Message From: Baron Schwartz <[EMAIL PROTECTED]> To: Josh <[EMAIL PROTECTED]> Cc: mysql@lists.mysql.com Sent: Satu

Re: Table Size

of thousands of rows and could potentially have many null values... I'm trying to get an idea of whether or not those null values are taking up much space. Thanks. - Original Message From: Baron Schwartz <[EMAIL PROTECTED]> To: Dan Nelson <[EMAIL PROTECTED]> Cc: Josh

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

uences - in MySQL you do have AUTO_INCREMENT columns, but they are not as robust as sequences. 4.) MySQL does not support CHECK constraints inside CREATE TABLE clauses. I'm sure there are others, but as long as your application uses pretty generic SQL and you are not getting into Oracle-spec

query logging is making me mental!

Hello Everyone, I am hoping that someone can help me. Before I jump off the roof! I installed MYSQL 5 along with PHP and apache 2 as part of the XAMPP stack put out by ApacheFriends. I am putting together a few CMS sites and think the product is great. But I am having a simple problem

RE: query logging is making me mental!

I figured it out. Thanks for listening. I maybe just needed to vent. -Original Message- From: Josh Milane [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 08, 2006 12:46 PM To: mysql@lists.mysql.com Subject: query logging is making me mental! Hello Everyone, I am hoping that

logging

Hello, I realize that this is a silly question, but I cannot figure it out. I don't know why. Id really appreciate your help. I cannot get mysql to do general logging. My my.ini reads like this: -- #This File was made using the WinMySQLAdmin 1.4 Tool

silly trigger question

Hi, Would something like this make it so that every time there was a new row inserted on TEST, a row with the new values was inserted on LOG_TABLE? I am not sure if you can reference NEW.id and all the NEW values directly and send them in a trigger... Thanks... CREATE TRIGGER test.data_table_au

resources for tuning

but these seem horribly out-dated. (The my-large.cnf assumes you have a whopping 512 mb of memory). I was thinking of modelling my.cnf after the provided my-innodb-heavy.cnf file, but I am worried these files might be out-dated so I figured I'd ping the mailing list for other resources for tun

Re: ORACLE and Mysql: Create tables, constraints, swquences, storage. ..?

ation-toolkit/ One of the ways I like to use it is to reverse engineer the Oracle schema, and then have the MySQL schema definition script created for further modification. Note we do not have support for sequences, and its typical to just use AUTO_INCREMENT columns for these. Regards, Josh --

Re: very slow inserts on InnoDB [InnoDB Performance Tuning]

help via our commercial offerings: http://www.mysql.com/network/ - OR - http://www.mysql.com/consulting/packaged/performance.html http://www.mysql.com/consulting/packaged/rapidresponse.html Regards, Josh -- Josh Chamas Director, Professional Services MySQL Inc., www.mysql.com Get More

Re: query on a very big table [MySQL partitioning of large tables]

t of memory when you partition your tables. If you continue to need help, then you might want to enlist our on-site consulting for your project needs: http://www.mysql.com/consulting/packaged/performance.html Regards, Josh -- Josh Chamas Director, Professional Services MySQL Inc., www.mysql.com

Re: MySQL vs Plone/Zope/Python

k Python is a bad language for web apps, I'm actually starting to like Python more and more. Josh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL db size using "show table status"

.frm file using a command line tool should do this. Usually, .frm table definition files are negligible to the size of the actual database. Qus 2. Is there any other way to compute the db size (other than disk quota). du -s mysql_data_directory Regards, Josh -- Josh Chamas Director, Pr

Re: Locks acquired with get_lock() persisting, even after MySQL thread has exited

() reports that the lock is held by a particular thread ID. This does not seem like expected behavior. I would either file this as a bug at http://bugs.mysql.com/ with a nice reproducible test case, or file a ticket with MySQL Support at https://support.mysql.com/ Regards, Josh -- Josh Chamas

Re: MySQL Users

ould change in the future. Regards, Josh -- Josh Chamas Director, Professional Services MySQL Inc., www.mysql.com Get More with MySQL! www.mysql.com/consulting -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: innodb thread concurrency size [mysql performance tuning]

these packages: http://www.mysql.com/consulting/packaged/performance.html http://www.mysql.com/consulting/packaged/rapidresponse.html Regards, Josh -- Josh Chamas Director, Professional Services MySQL Inc., www.mysql.com Get More with MySQL! www.mysql.com/consulting #use this line mfor mysq

Re: Too Many Queries Have "Writing To Net" Status [mysql performance tuning]

to complex to diagnose simply, and if you want expert help, I would recommend you engage with our professional services team with either of these packaged consulting solutions: http://www.mysql.com/consulting/packaged/performance.html http://www.mysql.com/consulting/packaged/rapidresponse.

Re: 45 minutes to check table to complete

kely what you are seeing here. Once you have the extra memory the next step is tuning MySQL to take advantage of it depending on the storage engine you are using. Regards, Josh -- Josh Chamas Director, Professional Services MySQL Inc., www.mysql.com Get More with MySQL! www.mysql.com/consulting

Re: The Intel MySQL compiled Server

our system, then revert back to the normal binaries. Regards, Josh -- Josh Chamas Director, Professional Services MySQL Inc., www.mysql.com Get More with MySQL! www.mysql.com/consulting -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists

Re: Intelligent Converters product: MSSQL-to-MySQL

efore with it and it seemed fine. I would also stay tuned for our MySQL Migration Toolkit to support MSSQL migrations. You can find it here: http://www.mysql.com/products/tools/migration-toolkit/ Regards, Josh -- Josh Chamas Director, Professional Services MySQL Inc., www.mysql.com Get More with

Re: MySQLHotCopy Error

is documented here: http://dev.mysql.com/doc/mysql/en/not-enough-file-handles.html If this does not help, and you need further support, you could work this up with MySQL Support at: https://support.mysql.com Regards, Josh -- Josh Chamas Director, Professional Services MySQL Inc., www.m

Re: Behaviour of like expression

here a pattern is nothing matches everything. Use LIKE for pattern matching, and = for equivalency. I don't know what the ANSI SQL spec says here, and whether our behavior is correct there, but this behavior makes sense to me at least. I would expect similar behavior from perl, for example:

Re: URGENT --- OSX 10.4 ODBC driver error

his was an urgent request. If you need urgent help, please contact MySQL Support at: https://support.mysql.com Regards, Josh -- Josh Chamas Director, Professional Services MySQL Inc., www.mysql.com Get More with MySQL! www.mysql.com/consulting -- MySQL General Mailing List For list archive

Re: Differences Between ORACLE SQL PLus and MYSQL SQL

e, but for PhP you'd want to look at something like ADOBD (http://adodb.sourceforge.net) or PDO/MDB/Metabase, etc. Good luck, Josh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Foreign key support in MyISAM

-out link to the home page: http://dev.mysql.com/doc/mysql/en/todo-mysql-5-1.html This still shows it in 5.1, though it's very vague, but it also shows other items in 5.1. http://dev.mysql.com/doc/mysql/en/roadmap.html So my guess / hope is 5.1. Josh -- MySQL General Mailing List For list arc

Re: Foreign key support in MyISAM

Thanks - now that 5.0 is release candidate I wonder how soon it will be before 5.1 alpha is released? Josh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Next alpha release?

I don't think I remember a time when MySQL only had stable production releases available for download (at least not off the website) since v3. Any idea if the next alpha is on the way? Thanks, 5.0 looks great, I've been using it for over a year with very few problems. Josh -- MyS

Status of OUTER JOIN bug 1591?

7 and 3765. But bug 1591 is still listed as "To be fixed later". Is that correct? If it is is there a different bug against how MySQL 4 handled OUTER JOINS which was fixed in MySQL 5 that I can reference in my justification letter? Thanks, Josh Trutwin FWIW - here is an off-list co

Re: Reason for Auto-increment primary keys?

o post a copy of the INT column "parent_id". In my mind it's always good to use UNIQUE in these cases so your real primary keys are in your table structure to prevent getting bad data. My $0.02 Josh -- MySQL General Mailing List For list archives: http://lists.mysq

MySQL query question

I have several tables, all with many-to-many joining tables. users users_teams teams teams_projects projects --- So, with a projects.id = 1, I want to get all the usernames of people on teams assigned to that project. SELECT DISTINCT username FROM users, users_teams, teams, projects_te

Re: backup from a slave

slave properly. Remember to issue a 'start slave;' after taking the backup, but also after you obtain the master log file and position. HTH, -- Josh Miller, RHCE/VCP Seattle, WA Linux Solutions Provider Website: http://itsecureadmin.com/ -- MySQL General Mailing List For list ar

Re: backup from a slave

s the value which determines where in the binary logs you're slave is currently at. -- Josh Miller, RHCE/VCP Seattle, WA Linux Solutions Provider Website: http://itsecureadmin.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscrib

Re: backup from a slave

in the binary logs you're slave is currently at. These values are accessible via 'show slave status\G'; -- Josh Miller, RHCE/VCP Seattle, WA Linux Solutions Provider Website: http://itsecureadmin.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.

Configuration and improvement advice.

ation? Should I simply take an outage and alter table to set the engine type to InnoDB, or should I rename the table, and select into a new table? What are the upper limits of MySQL performance in terms of data set size using MyISAM vs InnoDB? TIA, -- Josh Miller, RHCE -- MySQL General Mailing

innodb/myisam performance issues

ing moving back to MyISAM. Thanks! Josh Miller, RHCE -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: innodb/myisam performance issues

Tom Horstmann wrote: Hello Josh, why you moved your table to InnoDB? Your description doesn't sound like the tables rows are accessed concurrently and need to be locked? Are you sure you need InnoDB for this table? If you need InnoDB you probably need to redesign your queries and

Re: innodb/myisam performance issues

innodb_log_buffer_size. Try something between 16-32MB if you have many transactions. Ok, we've increased the innodb_log_file_size to 500M, and that has not changed the IO wait at all so far (after 1 hour). Thanks! Josh Miller, RHCE -- MySQL General Mailing List For list archives: http://lists.mysq

Re: innodb/myisam performance issues

work on re-designing the queries and indexes. We have a less than 50% index usage rate which is disastrous. We'd like to prove InnoDB and move onto that storage engine for the transaction support, MVCC, etc.. but we're finding that performance is poor. Thanks! Josh Miller, RHCE -- M

Re: innodb/myisam performance issues

og_at_trx_commit=0 +#innodb_flush_method = O_DIRECT +#skip-innodb-doublewrite +#innodb_support_xa = 1 +innodb_autoextend_increment = 4 innodb_data_file_path = ibdata1:40G:autoextend [mysqldump] So, we're going to take a break from the InnoDB stuff while I recover the slave and try again

Re: MySQL not running on fresh LAMP install

restart mysqld. Also, mysqld safe is a daemon which provides some safety features to mysql and is the recommended method of starting mysql, AFAIK. http://dev.mysql.com/doc/refman/5.0/en/mysqld-safe.html HTH, -- Josh Miller, RHCE/VCP Seattle, WA Linux Solutions Provider http://itsecureadmin

innodb_read_only issues

apped with a if (!srv_read_only_mode) Is this a bug I am hitting or am I holding it wrong? -- Thanks, Josh Paetzel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: innodb_read_only issues

On Thu, Sep 7, 2017, at 02:04 PM, shawn l.green wrote: > Hello Josh, > > > What appears to be missing on that page is a discussion what to do with > the "temporary tablespace" used to hold intrinsic (internal) temporary > tables created by different types

Re: MySQL vs PostgreSQL

luate for yourself. Have fun, Josh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL 5.0.4-beta has been released

status 1 tar: Error exit delayed from previous errors Something amiss or am I losing it? Thanks, Josh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL 5.0.4-beta has been released

I tried about 4 different mirrors. I'll keep at it and see if I get a better download. Thx, Josh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysql_fix_privilege_tables error

econds enum('Y','N') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL thd->thread_id=6 The manual page at http://www.mysql.com/doc/en/Crashing.html contains information that should help you find out what is causing the crash. Number of processes running now: 0 Josh -

Re: mysql_fix_privilege_tables error

On Fri, 22 Apr 2005 22:44:44 +0300 Gleb Paharenko <[EMAIL PROTECTED]> wrote: > Hello. > > > > Make a bug or feature report at http://bugs.mysql.com. Already did - 10098 - it was recently closed, guess it was already fixed in 5.0.5. Josh -- MySQL General Mailing List Fo

Re: Export from Access

g to CSV. Otherwise you can skip phpMyAdmin and just use ODBC - check out MyODBC on mysql.com. Josh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL 5.0.6-beta has been released

a release? The last beta I had was 5.0.4 unless I missed a release announcement... Thanks, Josh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: [Nevermind!] MySQL 5.0.6-beta has been released

On Wed, 1 Jun 2005 10:40:10 -0500 Josh Trutwin <[EMAIL PROTECTED]> wrote: > On Tue, 31 May 2005 18:01:48 -0500 > Matt Wagner <[EMAIL PROTECTED]> wrote: > > > > > This is the third published Beta release in the 5.0 series. All > > attention will now be foc

Re: Seriously.. When are we going to get subqueries?!

th your hosting admin to see if they would be willing to change this system-wide setting since there is no per-user control over this. If this is something you cannot live with then choose a different RDBMS. > I have to say, MySQL still looks like a tinker-toy to me. Good luck, Josh

Re: Seriously.. When are we going to get subqueries?!

;The first TIMESTAMP column in table row automatically is updated to the current timestamp when the value of any other column in the row is changed, unless the TIMESTAMP column explicitly is assigned a value other than NULL." Josh -- MySQL General Mailing List For list archives: http://lists.mysql

user defined table constraint

Hi all, I have a table with these fields: user_id dept_id is_primary ('Y' or 'N') I want to make sure that there are never two rows in this table with the same user_id and is_primary='Y'. For any user_id, there can only be one primary record. In MS SQL I would define a user constra

compare schemas

Does anybody know of any free tools to compare two mysql schemas? Thanks.

what is wrong woth this statement?

if (select count(*) from z_mail_systems > 0) then [insert statement] endif; How do I do this kind of conditional insert? Thanks.

RE: user defined table constraint

Thanks, but I don't think a unique index is what I want. I need to allow any number of records with the same user_id and a value of 'N' in is_primary. -Original Message- From: Gary Richardson [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 13, 2004 11:18 PM To: Josh

RE: what is wrong woth this statement?

f ([record exists]) then Do some sql End If How can I do this? Thanks. -Original Message- From: Leo [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 19, 2004 11:38 PM To: Josh Howe Cc: [EMAIL PROTECTED] Subject: Re: what is wrong woth this statement? i didnt fully catch you... i

RE: what is wrong woth this statement?

nesday, October 27, 2004 3:25 PM To: Josh Howe Subject: Re: what is wrong woth this statement? > How can I do this? By using the CASE staement? On Wed, 27 Oct 2004 15:15:11 -0400, Josh Howe <[EMAIL PROTECTED]> wrote: > Sorry, I don't think I was very clear. I'm asking a more

RE: what is wrong woth this statement?

e each script directly I can execute each via an intermediate perl script that updates the db to indicate which change scripts have been applied. That's more complex though. Any ideas would be greatly appreciated. Thanks! From: [EMAIL PROTECTED]

RE: what is wrong woth this statement?

Sent: Wednesday, October 27, 2004 4:51 PM To: Josh Howe; [EMAIL PROTECTED] Cc: Leo; [EMAIL PROTECTED] Subject: Re: what is wrong woth this statement? Have you considered doing what you want to do in Ant? I haven't done exactly what you want to do but Ant supports properties and conditions. I could

mysqldump

Hi, Can anybody help me with a linux newbie question. I want to use mysqldump to backup all of the tables in a database that start with z_. Can I do this in linux with a single line? Thanks.

RE: mysqldump

Thanks Spenser, but I'd already tried something similar. What I get when I try this is: mysqldump: Can't get CREATE TABLE for table `z_*` (Table 'sinu_com.z_*' doesn't exist) -Original Message- From: Spenser [mailto:[EMAIL PROTECTED] Sent: Monday, November

RE: mysqldump

er 02, 2004 1:44 PM To: 'Josh Howe'; [EMAIL PROTECTED] Subject: RE: mysqldump Did you try this one? I simplified it for you. You just need to put this in a file and chmod +x the file. Then you can execute it from a crontab or with the shell. ~~~ Copy/paste after this ~~~ #!/bin

Re: FOREIGN_KEY CHECKS

anually to your dump file. Personally I wish MySQL would add this as an option to mysqldump as I can never remember the syntax to this command when I do an import with InnoDB tables. Josh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: FOREIGN_KEY CHECKS

FOREIGN_KEY_CHECKS=0 > */; > /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, > SQL_MODE="NO_AUTO_VALUE_ON_ZERO" */; Great, thanks for the info! Josh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: libmysqlclient name library wrong

our faster, I just finished rebuilding everything that links against mysql (php, perl dbd, courier imap, etc) because of this. I thought maybe the library version number just bumped up one. Erg, now I'll have to do that all again when 4.1.9 fixes this... Josh -- MySQL General Mailing List

Re: Mysql-4.1.8 library name bug

Yes, this has been reported on this list a couple times already. Really baffling how this one made it out of QA. Josh On Thu, 23 Dec 2004 21:43:27 +0200 (EET) Andrey Kotrekhov <[EMAIL PROTECTED]> wrote: > SQL > > Hello, All! > > IMHO this the bug in 4.1.8 to create lib

Re: MySQL and PHP

indows (or whatever systemroot directory you use) before the PhP MySQL extension will work. Josh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: [OT] MySQL and PHP

out=main&cslot_1=2 Anyway, this is now OT for a MySQL list Josh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Views Syntax for MySQL 5

ndex.html First hit for searching on "views": http://dev.mysql.com/doc/mysql/en/ANSI_diff_Views.html Sounds like it will make it into the 5.0 branch, but has not yet. Another good link: http://dev.mysql.com/doc/mysql/en/Roadmap.html Josh -- MySQL General Mailing List For list

Re: triggers or stored procedures

ey can get these features in there without losing the characteristics that make MySQL so appealing, great, otherwise forget it. Josh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

UNION with INTO OUTFILE and ORDER BY

#x27;out.txt' ORDER BY a; Is this normal/intentional? MySQL 4.0.20 on Debian Linux. Josh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

InnoDB tablespace fragmentation bug in MySQL 4.0.20

more than routine maintenance on tables by adding/dropping indexes, one will eventually run out of disk space regardless of whether one is actually using that disk space! Also, I have a linux 2.4 kernel that this is running on, with mys

InnoDB, odd "insert error" shared row locking behavior

matters. Also for documentation purposes, I have included below the output from "show innodb status" regarding one such deadlock. Regards, Josh ____ Josh Chamas, Founder| NodeWorks - http://www.nodeworks.com Chamas Ent

Re: iptables and mysql...

our GRANTs are incorrect. Make sure connections are still denied by your firewall on ports you have closed, turn on logging, etc. Josh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Error 1005 when adding a Foreign Key

ATUS to display a detailed explanation of the latest InnoDB foreign key error in the server. So, you should check "show innodb status" for some more about this error it seems. Also, one of the more common errors is a lack of an index on testplans.PlanName, so make sure you have one

Re: Concurrency Question

carefully under load to make sure that your code does not result in any dead locks. Regards, Josh Josh Chamas, Founder| NodeWorks - http://www.nodeworks.com Chamas Enterprises Inc. | NodeWorks Directory - http://dir.nodeworks.com

Re: When is mysql 4.1.x , production?

Help the developers out by testing it in your enviornment. Josh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Multiple Foreign Keys

osite) primary key. > I setting up my tables as INNODB types. Good. All my create tables should have had the ENGINE=InnoDB but I'm lazy. Josh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Difference between PostgreSQL and MySQL

7;ll be really interesting to compare pg and mysql in a couple years... Josh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Difference between PostgreSQL and MySQL

supports several types of data storage > > (memory only, ISAM, full-relational) and both transacted and > > non-transacted execution models. That's just about everything you > > could want a database to do. > > No, not really: http://sql-info.de/mysql/gotchas.html Good li

Re: Difference between PostgreSQL and MySQL

On Tue, 10 Aug 2004 23:34:49 +0200 Jochem van Dieten <[EMAIL PROTECTED]> wrote: > On Tue, 10 Aug 2004 16:00:12 -0500, Josh Trutwin wrote: > > > > One area where MySQL beat Postgres is in Windows installation. > > Installing postgres on Windohs is like pulling your

Re: [OT] PostgreSQL / MySQL Data Dictionary

MySQL in the future? Doesn't appear to be from: http://dev.mysql.com/doc/mysql/en/Roadmap.html Josh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL Data Dictionary (INFORMATION_SCHEMA)

to mention it. Excellent, do you know anything else about it? Will it be in the next 5.0 alpha release? I'm very curious to try it out. Thx, Josh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: html in a text field - good practice?

On Wed, 18 Aug 2004 11:37:03 -0400 "leegold" <[EMAIL PROTECTED]> wrote: > Question I have wondered about: Is it a good practice to put html in > a text field, then (eg. via php) when the marked-up text renders in > a user's browser it's good looking html. If not, then I'd just > sandwitch field co

OUTER JOIN bug in 5.0.1?

ated frequently? If so I guess I could try to download and install again. Josh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: OUTER JOIN bug in 5.0.1?

> on e.tech_ID = sa.tech_ID Yes, I tried re-arranging things like this, and as it is above I think it's more readable, but I was unable to get any results that resembled an outer join. Unfortunately I cannot test this out at the moment due to other issues. Thanks for yo

Re: OUTER JOIN bug in 5.0.1?

sa.a_id = '$a_id' LEFT JOIN assignment a ON a.a_id = sa.a_id WHERE e.term_id = '3' ORDER BY s.full_name; It didn't seem to work with the "AND sa.a_id = '$a_id'" in the assignment join condition - but this works. I don't understand why that

Re: OUTER JOIN bug in 5.0.1?

AND c.class_date < NOW() ORDER BY week_no; This acts like an INNER JOIN though, I can only get two rows. I've tried mucking around with it, but I just cannot get the "outer" row for class id = 2 to show. This was so much easier with the bug! :) Thanks for your help, Josh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: OUTER JOIN bug in 5.0.1?

en at for my ICS311 course. Here's what kind of results I'd like: Student Id: 123123 Name: Josh class_id attended 1 1 2 NULL 3 1 4 1 5 NULL 6 1 So this particular student missed classes 2 and 5 because they did not have a recor

MySQL 5.0 and Stored Procedures

I have just recently compiled Mysql 5.0 onto my redhat linux box, and have been trying to set up some store procedures, but have yet to be able to figure out how. Can anyone help me on this on how to go about creating a stored proc in Mysql 5.0?? Any help or suggestions would be great.

  1   2   >