• [Threads by date]
• [Messages by date]

By: Peter Brawley

Jan 2005

• Re: doing SELECTS and keeping the array intact with php
• Re: Stored Procedure for advance reporting
• Re: Importing data from MS Access
• Re: Getting info about db columns
• Re: create sequence
• Re: counting records in 2 tables using 1 query
• Re: MySQL & Perl
• Re: create view not working on mysql 4.1.8

Feb 2005

• Re: Social Networking querys
• Re: Rowcount?
• Re: Syntax diagram, where is it located in the doc?
• Re: Recursive category table problem (whatever you define it). Help!
• Re: select where multiple joined records match
• Re: Where's my ODBC icon?
• Re: join speed vs. 2 queries
• Re: join speed vs. 2 queries
• Re: select columns in full text index
• Re: backing up Databases in Mysql
• Re: List of tables.
• Re: MYSQL_RES & ......
• Re: modulo operation
• Re: getting type of field
• Re: how can I do instead of using subselects?
• Re: Fwd: how can I do instead of using subselects?
• Re: Geologic Time

Mar 2005

• Re: Replication only DB
• Re: subquery fails when a NOT IN operator tests a subset with NULLvalu
• Re: 5.0.2 alpha crashes with Query Browser
• Re: Select previous group
• Re: SELECT rows from the previous business day
• Re: Passing Arrays between pages
• Re: How to import data from Dbase3?
• Re: search through one/several tables
• Re: search through one/several tables
• Re: Regarding NULL and '' (null string) treatment in MYSQL

Apr 2005

• Re: Need help with Stored Procedures iin MySQL 5.0.3-beta
• Re: Need help with Stored Procedures iin MySQL 5.0.3-beta
• Re: Newbie: MYSQL nested query question
• Re: [Q] Database design
• Re: [Q] Database design
• Re: Setting up a Chemical database
• Re: Duplicated records
• Re: Need help in Stored procedures and functions
• Re: Need help in Stored procedures and functions
• Re: Does such a JOIN exist that can create a pivot table?
• Re: ERROR 1064: You have an error in your SQL syntax....
• Re: MySQL vs. DB2
• Re: Recreating primary index on MyIsam table
• Re: Display 1st row of every group?
• Re: Display 1st row of every group?
• Re: Display 1st row of every group?
• Re: LEFT JOINS same data twice?
• Re: Database design question
• Re: just dumping table definitions, not data
• Re: LEFT JOINS same data twice?
• Re: Relative Numeric Values
• Re: mysql_performance
• Re: Query question
• Re: Query question
• Re: Query question
• Re: Query question
• Re: Query question
• Re: Query question
• Re: Crosstab in Mysql
• Re: why NOT NULL in PRIMARY key??
• Re: Get a Random Row on a HUGE db
• Re: why NOT NULL in PRIMARY key??
• Re: why NOT NULL in PRIMARY key??
• Re: getting hours from two datetime columns
• Re: query question
• Re: determing number of Tuesdays within a date range

May 2005

• Re: Checking Results from Query
• Re: NEED HELP IN IF STATEMENT
• Re: joining six tables by mutual column
• Re: NEED HELP IN IF STATEMENT
• Re: table that keeps info on tables in a DB
• Re: Multi-user bookmark system
• Re: Comparing to null queries
• Re: possible join
• Re: possible join
• Re: possible join
• Re: table optimisation
• Re: write a spatial queary
• Re: What's wrong with this code?
• Re: why does this query work??!!!
• Re: constraints

Jun 2005

• Re: Open source DBMS evaluation study
• Re: Need Help on C with MySQL in win2000...
• Re: discuss: user management
• Re: discuss: user management
• Re: Primary Key Question
• Re: selecting more sum()

Jul 2005

• Re: Another generalization hierarchy problem
• Re: Stored function problems (Was: UDF failure)
• Re: SQL 'clustering' query?
• Re: Problem with some querys
• Re: Make a report like this...
• Re: Totals Across Multiple Records
• Re: How to select first 1000 records like MySQL Control Center 0.9?
• Re: Where on count(*)
• Re: Database equivalent to NorthWind for M$ SQL
• Re: Phone Number Column Advice

Aug 2005

• Re: export data as sql inserts
• Re: Mysql 5.x Trigger Examples
• Re: Query HELP!
• Re: SELECT vs SET for creating variables
• Re: spatial extensions - SRID
• Re: Dates & Schedule Problems
• Re: now i am getting confused (i could not think of a better title)
• Re: how to arrange my table in another direction
• Re: how to arrange my table in another direction
• Re: Deleted rows
• Re: Deleted rows
• Re: Trigger exception handling
• Re: renaming a database
• Re: SQL help
• Re: Treating Two Fields Like One
• Re: Treating Two Fields Like One
• Re: Date arithmetic: 2005-08-31 - 1
• Re: UK Bank Holidays
• Re: INSERT IGNORE Doesn't Seem To Work
• Re: Compare two tables
• Re: newbee question
• Re: newbee question
• Re: hierarchical db/depth?

Sep 2005

• Re: LIMIT alternative
• Re: string->array question. ( 2 query questions)
• Re: string->array question. ( 2 query questions)
• Re: question on how to create a subset table
• Re: Newbie needs info!
• Re: Select ALL rows with WHERE statement
• Re: Select ALL rows with WHERE statement
• Re: Query matches twice, but not simultaneously...
• Re: A Complicated Report
• Re: Stored procedures MS SQL Server to MySQL
• Re: Documenting and visualizing a database
• Re: Documenting and visualizing a database
• Re: Stored Procedures and Functions
• Re: add a column if not exists
• Re: money fields

Oct 2005

• Re: Joins Tutorial Anywhere?
• Re: deleting unwanted rows
• Re: deleting unwanted rows
• Re: Query Question
• Re: Detect if table exists from within MySQL?
• Re: Generating an Error in a Trigger
• Re: Joining tables, duplicating none
• Re: databse design and table join problems
• Re: databse design and table join problems
• Re: databse design and table join problems
• Re: Append one table to another?
• Re: possible bug in mysql 5.0.13
• Re: possible bug in mysql 5.0.13
• Re: MySQL sw for reverse engineering
• Re: MySQL 4.1.13 lint?
• Re: renaming the database
• Re: renaming the database
• Re: Function to show when a field's value was last updated
• Re: query help
• Re: one product in more categories
• Re: the difference between server option and Server System Variables
• Re: I can't find any variables used "show variables"
• Re: Multiple INNER JOINS
• Re: Multiple INNER JOINS
• Re: one product in more categories
• Re: Spatial Extensions to make a Dealer Locator?
• Re: one product in more categories
• Re: one product in more categories
• Re: help with query
• Re: Sum of Sales
• Re: Sum of Sales

Nov 2005

• Re: mysql.user table is not updated to new password format ???
• Re: PHP/MySQL vs ASP/MSSQL?
• Re: How to rename a database
• Re: Stored Procedure Conversion
• Re: Stored Procedure Question
• Re: Stored Procs, functions
• Re: MySQL .NET Connector
• Re: GROUP BY / HAVING / Aggregrates
• Re: A bit of SQL help for a MySQL novice.
• Re: A "key" question
• Re: "Function Does Not Exist"
• Re: Mysql Finding the country name from country prefix
• Re: BIIIIIIIIIIG query
• Re: Inner Join & Search on Two (2) fields ?
• Re: BIIIIIIIIIIG query
• Re: Getting no of different rows by group by clause
• Re: LEFT JOIN not working on 5.0.16 - urgent help
• Re: Using a Stored Procedure that returns a resultset
• Re: Using a Stored Procedure that returns a resultset
• Re: How to use Logic in View Statment?
• Re: comma-separated JOINS
• Re: SQLquery: delimiter // - #1064 error
• Re: SHOW commands.
• Re: Date increment
• Re: Newbie Question on Update

Dec 2005

• Re: Cursor support
• Re: parse error creating table
• Re: parse error creating table
• Re: How to Square a number?
• Re: Filtering join
• Re: Matching phone numbers to addresses
• Re: Reason for Auto-increment primary keys?
• Re: MySQL query question
• Re: upgrading to mysql 5
• Re: Need Help Writing a Trigger
• Re: Need Help Writing a Trigger
• Re: LIMIT on GROUP BY?
• Re: issue with subquery

Jan 2006

• Re: I can't find the missing rows in a table--
• Re: I can't find the missing rows in a table--
• Re: question about "sql security"
• Re: Can someone tell me why this fails?
• Re: Calendar table workaround
• Re: SELECT help.
• Re: Getting # of days until expiration
• Re: Cant access my files through the web site
• Re: Problem using IN statement MySQL 5
• Re: Help crafting an SELECT
• Re: Histogram from tables.
• Re: Huge number of tables with InnoDB
• Re: Procedure / Prepared statements error converting table
• Re: Selecting based on serialized field...
• Re: [SPAM] - convert help - Bayesian Filter detected spam
• Re: Comparing 2 Tables
• Re: Query Help
• Re: Query: Order for the Earliest Latest date
• Re: NOT IN vs IS NULL
• Re: display a hierarchic tree
• Re: Sort before grouping
• Re: How to restrict this query... (need subquery?)
• Re: NOT IN vs IS NULL

Feb 2006

• Re: NOT IN vs IS NULL
• Re: Totally different join-behaviour in mysql 4 and 5?
• Re: Query Speed
• Re: Kinda OT: Book database question
• Re: items quantity
• Re: How to Find the Max/Min from Multiple Columns (in each row)
• Re: problem with excluded days in date range query.
• Re: Visual database design system
• Re: How to create an application for managing users
• Re: Can't Create Foreign Key Constraints
• Re: question about locking
• Re: Passing db names to a stored proc in MySQL 5
• Re: How to select data if not in both tables?
• Re: InnoDB and locking
• Re: How to select data if not in both tables?
• Re: Passing db names to a stored proc in MySQL 5
• Re: arbitrary ORDER BY
• Re: Multiple many-to-many SELECT
• Re: copy db to external host
• Re: How to select data if not in both tables?
• Re: copy db to external host
• Re: selecting min, max
• Re: General DB Design Question - How to avoid redundancy in tablerelationships
• Re: joining 3 tables
• Re: Stored procedure issue.
• Re: showing zero counts in select statements with group by
• Re: showing zero counts in select statements with group by
• Re: Need Update Query Help (Urgent)
• Re: help with query
• Re: Different result with subquery
• Re: confused...
• Re: "Nested Set Model" or "modified preorder tree traversal" mySQL/PHPcode wanted
• Re: Inner join with left join
• Re: selecting based on a max() condition
• Re: Inner join with left join
• Re: Query returns to many results
• Re: Inner join with left join
• Re: Connecting to queries into one
• Re: Some general questions
• Re: Help with Query Optimization
• Re: Some general questions
• Re: UPDATE from monthly to yearly rows

Mar 2006

• Re: Some general questions
• Re: trouble finding WinMySQLadmin, and opening MySQLadmin
• Re: optimization - directories and sub-directories (with descendants)
• Re: query problem
• Re: Need help with a Basic Query.
• Re: php and mysql
• Re: Stored Procedure Problem
• Re: mysql_commect or die
• Re: Query help
• Re: Compare lists Query?
• Re: Help regarding a simple query
• Re: E/R Tool
• Re: Complex Query
• Re: select from multiple tables
• Re: mysql query and version problem .... Help!
• Re: Comparing x.x.x.x strings
• Re: Is there anyway to return an array?
• Re: Loading Data File into Database Table
• Re: Loading Data File into Database Table
• Re: Find records not in many-to-many table?
• Re: Complicated select query
• Re: JOINs-- need some expertise on this one
• Re: Summing tables and fields Please help,,,
• Re: CREATE TABLE x AS with ENGINE = ARCHIVE
• Re: Li'l problem with count()
• Re: Customer Recommendation Query

Apr 2006

• Re: very long query for such a simple result
• Re: very long query for such a simple result
• Re: very long query for such a simple result
• Re: very long query for such a simple result
• Re: Making result rows to one row
• Re: How to pass parameters in MYSQL
• Re: Making result rows to one row
• Re: Error on T_echo ?? what is this ?
• Re: How to connect to mySQL?
• Re: My Left Joins are Doubling the SUM()
• Re: My Left Joins are Doubling the SUM()
• Re: select records not in a *particular* many-to-many relationship
• Re: where group and inner join
• Re: Form value editing
• Re: WHERE doesn't work
• Re: WHERE doesn't work
• Re: totalizing of Rows please help!!
• Re: If exists query.
• Re: totalizing of Rows please help!!
• Re: Stumped again by joins
• Re: Accumilating Blog Comments
• Re: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude)
• Re: How to select the last entry per item
• Re: How to select the last entry per item
• Re: How to select the last entry per item
• Re: How to select the last entry per item

May 2006

• Re: Finding duplicates, etc.
• Re: sorting with php/mysql
• Re: Missing information Search
• Re: How to rename a DB
• Re: [Fwd: Getting next birthdays]
• Re: Case confusion
• Re: comparing postgis with mysql
• Re: Reporting child tables referencing a parnet table
• Re: SQL:2003 standard
• Re: Reporting child tables referencing a parnet table
• Re: Reporting child tables referencing a parnet table
• Re: PRINT statement?
• Re: PRINT statement?
• Re: Need help with procedure
• Re: Need help with triggers
• Re: Baffled by error
• Re: Baffled by error
• Re: duration query: how to ?
• Re: Recursive query
• Re: Find invalid email formats using MySQL query.
• Re: LEFT JOIN Multiple Tables
• Re: LEFT JOIN Multiple Tables
• Re: I think I need a join
• Re: Noob: Converting to Inner Join
• Re: Noob: Converting to Inner Join
• Re: Fun with Dates and Incentives.
• Re: Fun with Dates and Incentives.
• Re: Fun with Dates and Incentives.
• Re: Fun with Dates and Incentives.
• Re: Joining multiple tables with grouping functions
• Re: where more than 2 column not in a table
• Re: ugly SQL for a report...
• Re: Need help querying a database of polynomials
• Re: where more than 2 column not in a table

Jun 2006

• Re: Help with query: Row number / Rank from a query...
• Re: help on SQL JOIN
• Re: hierarchical sql
• Re: Joins - Multiple rows from a single table
• Re: functions in AS
• Re: functions in AS
• Re: MS access query in mysql
• Re: error in copy data from mysql 4.1 to mysql 5.0 server
• Re: error in copy data from mysql 4.1 to mysql 5.0 server
• Re: Find rows in table A where table B = 'hello' AND table B = 'world'
• Re: Math problem
• Re: Exclusion Query
• Re: Left Join Help
• Re: selecting data from 2 local DBs with same table structure
• Re: DELETE based on JOIN
• Re: Tough query to crack
• Re: Use of @ in Stored Procedure
• Re: Tough query to crack
• Re: Tough query to crack
• Re: Distinct problem
• Re: Distinct from two tables
• Re: summing values

Jul 2006

• Re: Need way to see all relations?
• Re: need one query
• Re: Query multiple tables
• Re: Comparison problem
• Re: Comparison problem
• Re: Pivoting the result set.
• Re: arrays in stored procedures - pl. help
• Re: Returning results as a field name
• Re: Returning results as a field name
• Re: Checkboxes
• Re: JOIN table where not in other table
• Re: Newbie
• Re: Stored procedures
• Re: Finding the closest value

Aug 2006

• Re: logic/db question
• Re: logic/db question
• Re: Running Totals?
• Re: Finding the closest value
• Re: Tricky query
• Re: Limiting a Join
• Re: Limiting a Join
• Re: joining tables
• Re: How to create a table of dates?
• Re: PHP script to simply manage tables
• Re: Do I really need a subquery?
• Re: Audit trail
• Re: Finding field in all tables
• Re: Finding field in all tables
• Re: Finding field in all tables
• Re: Occurrence-based ranking [solved?]
• Re: Group By question

Sep 2006

• Re: rename a DB schema?
• Re: Null !?
• Re: Question about LOTS of indexes on a table
• Re: Question about LOTS of indexes on a table
• Re: SUM in WHERE
• Re: Count of children
• Re: AW: Count of children
• Re: Need to find last price and date product was sold
• Re: comparing two databases

Oct 2006

• Re: SQL statement work in mysql4 but not mysql5
• Re: moving to other web server
• Re: sql query
• Re: Some trouble with a Join after upgrade from 3.23 to 5.0
• Re: Simple JOIN on three tables
• Re: Simple JOIN on three tables
• Re: Can Primary Key be added with ALTER?
• Re: How to summarize weekly totals?

Nov 2006

• Re: Pulling Percentages From Query
• Re: How do I do this query efficiently?
• Re: How do I do this query efficiently?
• Re: Find foreign key for a table
• Re: How do I do this query efficiently?
• Re: Simple doubt
• Re: Simple doubt
• Re: Many-Many relation, matching all
• Re: Simple doubt
• Re: Simple doubt
• Re: Many-Many relation, matching all

Dec 2006

• Re: SUM() of 1 and NULL is 1 ?
• Re: recursing Folders adding to mysql
• Re: query help
• Re: MySQL Data Vanishing with FireFox
• Re: Count the number of specific rows

Jan 2007

• Re: Selecting records based on max and value
• Re: Having problems with what appears to be a simple query.
• Re: Having problems with what appears to be a simple query.
• Re: Query skips one set of records
• Re: MySql Version difference

Feb 2007

• Re: detecting the table type by sql?
• Re: grouping
• Re: Select Primary Key
• Re: Qustion
• Re: return all dates between two dates
• Re: How to get query result...

Mar 2007

• Re: Need sql optimization help
• Re: Need sql optimization help
• Re: Table doesn't exist from stored function
• Re: Group By / Order BY
• Re: about limit
• Re: Finding a record in a result set

Apr 2007

• Re: Stdev calculation for aggregrate tables
• Re: Deleting pseudo-duplicates...
• Re: creating a function in mysql
• Re: creating a function in mysql
• Re: problem with Procedure and Cursor
• Re: Storing forests in tables.
• Re: What is the equivalent of the minus function?

May 2007

• Re: View select results
• Re: View select results
• Re: View select results
• Re: Printing
• Re: adding 3 values
• Re: SELECT statement returning columns for a given table?
• Re: Weird connection timed-out
• Re: Sub query help
• Re: Select question
• Re: expanding hierarchies
• Re: Integrity on large sites
• Re: expanding hierarchies
• Re: expanding hierarchies
• Re: Does mysql support groups?

Jun 2007

• Re: External Program Execution
• Re: Issue with SubSelect Quey
• Re: Sorting by a list of possible results in a column....
• Re: MySQL 5 & W2K
• Re: date function question
• Re: Help with AVG query
• Re: Storing a linked list
• Re: Best Database Representation of a Chain of Command

Aug 2007

• Re: [mysql] reverse join
• Re: Joining question
• Re: Joining question
• Re: Joining question
• Re: Joining question
• Re: [MYSQL]Time formatting for cycle time.
• Re: [MYSQL]Time formatting for cycle time.

Sep 2007

• Re: Problem with query
• Re: Linking tables
• Re: recursion or something recursion-esque
• Re: more elegant way to store/find phone numbers
• Re: Ordering by unrelated column in a GROUP BY
• Re: Many-to-many query (chained)

Oct 2007

• Re: LIMIT within GROUP BY
• Re: DOCUMENTATION ABOUT SHOW PROFILE
• Re: Slow Subquery
• Re: Why can't I still not use an ALIAS in the SELECT portion of anSQL statement?
• Re: Comparing keys in two tables
• Re: Comparing keys in two tables
• Re: Record Counting
• Re: Replace on Join
• Re: Sort results by order in list
• Re: query question
• Re: Sort results by order in list
• Re: Group by time range.

Nov 2007

• Re: Problems with create procedure
• Re: Simple Query

Dec 2007

• Re: Order table by org heirarchy (emp-mgr)
• Re: Help with SQL query construction
• Re: Query help, please..

Jan 2008

• Re: Transactions with ODBC
• Re: Transactions with ODBC
• Re: left join in version 5.0.45
• Re: Can these two queries be combined into one?

Feb 2008

• Re: Decimal - Maximum is 30
• Re: Convert Dbase file to mysql and enter data
• Re: stored procedure, parameter type help needed
• Re: stored procedure, parameter type help needed
• Re: stored procedure, parameter type help needed
• Re: Inefficient query processing?
• Re: Inefficient query processing?
• Re: Inefficient query processing?
• Re: Inefficient query processing?
• Re: Inefficient query processing?
• Re: Query two different databases for differences
• Re: Query two different databases for differences
• Re: group a select * and a select COUNT from 2 different tables usingresult of first table to do the COUNT ... is it possible ?
• Re: group a select * and a select COUNT from 2 different tables usingresult of first table to do the COUNT ... is it possible ?

Mar 2008

• Re: Efficiently storing a directed graph
• Re: Efficiently storing a directed graph
• Re: Multiple revision of a record
• Re: Select Statement
• Re: MSQL Installed and running in background
• Re: [OT] When MySQL Bites: Quirks to Watch Out For
• Re: Group by function and avg on char

Apr 2008

• Re: Incorrect results from sum
• Re: A SQL Query Question
• Re: History of changed rows

May 2008

• Re: GROUP & ORDER BY Question

Jun 2008

• Re: subselect logic
• Re: Query - One-to-Many question
• Re: Query - One-to-Many question
• Re: Query - One-to-Many question
• Re: Query - One-to-Many question
• Re: Query - One-to-Many question

Jul 2008

• Re: delete query question
• Re: Calendar creation
• Re: WHERE .... IN
• Re: how to Get file modified time and date of file by using builtinfunction or procedure in sql?
• Re: how to optimize: max(timetstamp) where a.foo=b.foo ?

Aug 2008

• Re: SELECT N records from each category
• Re: SELECT N records from each category
• Re: SELECT N records from each category
• Re: Is there a GROUP function that can help me with this?
• Re: escape a dash in table name

Sep 2008

• Re: valid chars mysql db username
• Re: Finding gaps
• Re: valid chars mysql db username
• Re: Tables are too wide
• Re: Many to many to too many relation.

Oct 2008

• Re: Foreign Keys
• Re: Finding gaps
• Re: Finding gaps
• Re: Problem with GROUP BY
• Re: MySQL Sort by Array

Nov 2008

• Re: Question about Averaging IF() function results
• Re: Row before and after?
• Re: normalised designs: customer database
• Re: Creating table syntax error with mysql 5.0!
• Re: SELECT through many databases
• Re: How to find last price of items that were sold?

Dec 2008

• Re: Intersect question
• Re: Trying to Create a Trigger
• Re: Uptimize: join table on if()
• Re: SUMIF
• Re: Question on default database for stored functions
• Re: Can't get expected SELECT GROUP BY results
• Re: Can't get expected SELECT GROUP BY results

Jan 2009

• Re: Group by question
• Re: Need to pivot rows into columns
• Re: Help with a query.

Feb 2009

• Re: Algorithm for resolving foreign key dependencies?
• Re: db setup - correction
• Re: db setup - correction
• Re: db setup - correction
• Re: db setup - correction
• Re: Codd's rule 8 (physical data idependence)
• Re: Left join does not work with Count() as expected

Mar 2009

• Re: using a subquery/self-join to recursively retrieve a tree
• Re: Does MySQL 5.1 store queries?
• Re: IBM could buy Sun?
• Re: Data structure for matching for company data
• Re: Data structure for matching for company data

Apr 2009

• Re: One to many relationship
• Re: displaying a specific row within a "group by"
• Re: Sun bought by Oracle
• Re: Two "COUNT"s in one query
• Re: 1064 errors
• Re: my final 1064 error
• Re: dynamic table name
• Re: Totalling Counts done in Subqueries

May 2009

• Re: cannot alter table - rather urgent
• Re: Is it possible to convert column data into rows

Jun 2009

• Re: Question about query - can this be done?
• Re: Finding the creation date of an existing database in MySQL 5?
• Re: Half Hour Sub-query in MySQL vs. 5 Seconds in VFP?
• Re: how to efficiently query for the next in MySQL Community Edition5.1.34?
• Re: how to efficiently query for the next in MySQL Community Edition5.1.34?
• Re: how to efficiently query for the next in MySQL Community Edition5.1.34?
• Re: how to efficiently query for the next in MySQL Community Edition5.1.34?

Jul 2009

• Re: Stored Procedures from SQL Server
• Re: tracing table updates

Aug 2009

• Re: Group by optimization
• Re: Select clause using from and to (like rownum in Oracle)

Sep 2009

• Re: Stupid GROUP BY question

Nov 2009

• Re: 2 Queries need to combine into one
• Re: Oracle, Sun and MySQL
• Re: Query!
• Re: Techniques for queries on a series?

Dec 2009

• Re: Join Statement
• Re: Join Statement
• Re: error while creating trigger
• Re: Lesser of two values in list
• Re: Fwd: Re: Help Save MySQL
• Re: Fwd: Re: Help Save MySQL
• Re: Database fundamentals: wanna learn.
• Re: Weeks

Jan 2010

• Re: Ordering field names in a "DESC / DESCRIBE table" or "SHOW COLUMNSfrom table" command
• Re: Better that `NOT IN`
• Re: Subquery performance slow to non-existent...

Feb 2010

• Re: version 5 to 4
• Re: count children nodes

Mar 2010

• Re: Has Query optimizer improved in 5.4/5.5?
• Re: 5.1.44 community version select ordno>=' ' error (2)
• Re: Front End Application For MySQL
• Re: Populating dataset

Apr 2010

• Re: Downloading MySQL
• Re: How to compute the min and max of two numbers?
• Re: Pivot Query in

May 2010

• Re: How to Get Running Totals.
• Re: Where to index - over 15m records and growing
• Re: Impossible Out Param Return Value
• Re: Impossible Out Param Return Value

Jun 2010

• Re: normalization

Jul 2010

• Re: Retrieving table and field a foreign key references
• Re: Problem with IF() inside of a select statement
• Re: Select w/ group by question
• Re: [MySQL] Re: MySQL select matching

Aug 2010

• Re: Fixture List generation using MySQL
• Re: Fixture List generation using MySQL
• Re: Complex Select Query
• Re: dynamic alias?

Oct 2010

• Re: Adding a subquery
• Re: Selecting all minimum values

Nov 2010

• Re: numeric comparisons
• Re: mysql_upgrade fails with "Access denied"
• Re: mysql_upgrade fails with "Access denied"

Jan 2011

• Re: Trying to Generate Dynamic Sequence IDs as Stored Function orStored Procedure.
• re: I/O read performance
• Re: Rewrite SQL to stop table scan
• Re: Organisational question: surely someone has implemented manyBoolean values (tags) and a solution exist
• Re: [PHP] Organisational question: surely someone has implementedmany Boolean values (tags) and a solution exist

Mar 2011

• Re: trigger-dumping
• Re: "IF"
• Re: Need help with query
• Re: A common request
• Re: A common request

May 2011

• Re: How to find top 25 selling products for each day of year?
• Re: [MYSQL] need simple help
• Re: Using where; Using temporary; Using filesort

Jul 2011

• Re: Mysql Trigger
• Re: Facebook Trapped In MySQL a 'Fate Worse Than Death'

Aug 2011

• Re: Query Optimization
• Re: Best Way to store Hierarchical Data in Mysql
• locked non-existent row
• Re: locked non-existent row

Sep 2011

• Re: locked non-existent row
• Re: locked non-existent row
• Re: locked non-existent row
• Re: mysql listed as "attach page" by google?

Oct 2011

• Re: Variables in stored procedure
• MySQL fora overrun by spam
• Re: Inconsistent query result.
• Re: Inconsistent query result.
• Re: What is wrong with this outer join?
• Re: How to dynamically create database and tables on mysql?

Nov 2011

• Re: how to check how big a database is

Dec 2011

• Re: Query query
• Re: errors running WHILE loop

Jan 2012

• Re: Date and Time
• Re: Parent/Child - Linked List
• Re: Parent/Child - Linked List
• Re: mysql guru??
• Re: cannot pass time to function
• Re: setting the default of a date field
• Re: setting the default of a date field

Feb 2012

• Re: how to changing default '-' character in Datetime in MySQL?
• Re: Indexed Query examining too many rows!
• Re: weird difference in workbench and CLI query
• Re: MySQL Session Variables with PHP

Apr 2012

• Re: The most elegant/efficient way to pull this SQL query

May 2012

• Re: Query help,,,
• Re: Query assistance...
• Re: category with parentid

Jul 2012

• Re: Subquery taking too much time on 5.5.18?
• Re: Subquery taking too much time on 5.5.18?

Aug 2012

• Re: suggestion needed for table design and relationship
• Re: suggestion needed for table design and relationship

Sep 2012

• Re: function INTERVAL in view
• Re: getting certain rows from a group by

Nov 2012

• Re: Dynamic crosstab got me lost.
• Re: Stored Procedure Question?

Dec 2012

• Re: MUltiple value in single insert is not working in mysql procedure
• Re: Help with left outer join
• Re: Help with left outer join
• Re: Get lowest value
• Re: sales data every publisher

Feb 2013

• Re: Complex MySQL Select Statement Help
• Re: Complex MySQL Select Statement Help
• Re: Major MySQL Revision Takes on NoSQL

Mar 2013

• Re: Foreign key on multiple columns
• Re: Show ROUTINE body, not PROCEDURE
• Re: Show ROUTINE body, not PROCEDURE
• Re: Show ROUTINE body, not PROCEDURE
• Re: Show ROUTINE body, not PROCEDURE

• [Threads by date]
• [Messages by date]

General Discussion

The main list for general MySQL discussion. Please note that some topics are better discussed on the more-specialised lists. If you post to the wrong list, you may not get an answer!

To post to the list, send email to mysql@lists.mysql.com.

If you are having problems unsubscribing from the list, please check our troubleshooting page.

© 1995, 2013, Oracle Corporation and/or its affiliates

• Legal Policies
• Your Privacy Rights
• Terms of Use
• Contact Us

Page generated in 0.070 sec.