By: Martijn Tonies
Oct 2003
- WANTED: Betatesters for a MySQL Developer Tool
- Re: WANTED: Betatesters for a MySQL Developer Tool
- Re: Install MySQL and MS SQL on Same Server
- Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1
- Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1
- Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1
- Re: alternate syntax for UNION?
- Re: Foreigner keys in MySQL?
- Re: Is MySQL Relational? (was: Foreigner keys in MySQL?)
- Re: Is MySQL Relational? (was: Foreigner keys in MySQL?)
- Re: Is MySQL Relational? (was: Foreigner keys in MySQL?)
- Re: Finding information in the last record
Nov 2003
- Re: "not null" and default values confusion
- Re: Too Many Columns ERROR 175..
- Re: How to generate data sequences simple way?
- Re: Need help comparing MySQL to MS SQL Server
- Re: Need help comparing MySQL to MS SQL Server
- ANN: Database Workbench 2.4 released
- Re: ANN: Database Workbench 2.4 released
- Re: GUI interface
- Re: CRASH AND ROLLBACK SIMULATION
- Re: problem running the following query
- Re: [SOLVED]Re: LEFT JOIN problem
- Re: [SOLVED]Re: LEFT JOIN problem
- Re: [SOLVED]Re: LEFT JOIN problem
- Re: Inefficient use of index (was: Big difference in MyISAM and InnoDB SELECT speed)
- Re: Inefficient use of index (was: Big difference in MyISAM and InnoDB SELECT speed)
- Re: What's best
- Re: help needed!
- Re: help needed!
- Re: help needed!
- Re: Functions and Procedures in Mysql
- Re: Multiple Primary key
- Re: off into the weeds
- Re: CHECK constraint
Dec 2003
- ANN: Database Workbench v2.4.1 released
- Re: on delete|update
- Re: innodb transactions
- Re: WHERE with CASE colums?
- Re: what about foreign keys?
- Re: In need of a dummy select statement ...
- Re: Specs for a dedicated MySQL server
- Re: primary key type is BLOB
- Re: key is not used
- Re: Re[2]: key is not used
- Re: MySQL -- Sequences -- Do they exist
- Re: MySQL 4.1.1 Internationalization (ENUM)
- Re: How to READ/WRITE directly on MyISAM data files ?
- Re: How to READ/WRITE directly on MyISAM data files ?
- Re: How to READ/WRITE directly on MyISAM data files ?
- Re: Getting Records where date is LESS THAN today, AND...
- Re: CREATE VIEW
- Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?
- Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?
- Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?
- Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?
- Re: Getting Records where date is LESS THAN today, AND...
- Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?
- Re: Re[2]: Comparing date fields
- Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?
- Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?
- Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?
- Re: please give me help in important decision!
- Re: please give me help in important decision!
- Re: Comparing date fields (Delphi programmers take note)
- Re: Column name: CHECK
- Re: Query gift ?
- Re: Column name: CHECK
- Re: foreign keys plz?
- Re: Create Tables In MySQL
Jan 2004
- Re: Primary Key
- Re: Multiple Roles
- Re: Enum default values
- Re: Enum default values
- Re: Enum default values
- Re: Enum default values
- ALTER Charset/collation for columns/tables
- Current server charset?
- Re: Current server charset?
- Re: Bet the Business
- Re: max length of primary key
- Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?
- Re: Automatic conversion from `char` TO `varchar`
- Re: Automatic conversion from `char` TO `varchar`
- Re: Automatic conversion from `char` TO `varchar`
- Re: metric conversions
- Re: hierarchical records, I need some help!! ;(
- Re: Automatic conversion from `char` TO `varchar`
- Re: Newbie - from Oracle
- Re: table without primary key
- Re: table without primary key
- Re: table without primary key
- Re: Order by problem
- Stored Procedure and the procs.db column
- Stored Procedure and the procs.db column
- Re: FKs in InnoDB
- Re: porting Oracle schema to MySQL
Feb 2004
- ANN: Database Workbench 2.4.2 released
- Re: column being created as varchar() when char() requested.
- MySQL 5 Stored Procedures are server wide?
- Re: MySQL viewer
- Re: MySQL 5 Stored Procedures are server wide?
- Re: MySQL 5 Stored Procedures are server wide?
- Re: MySQL 5 Stored Procedures are server wide?
- Re: [Q] setting DATE field with default NOW value?
- Re: [Q] setting DATE field with default NOW value?
- Re: A challenge I think
- Re: SQL2000 and MySql
- Re: SQL2000 and MySql
- Re: SQL2000 and MySql
- Re: SQL2000 and MySql
- Re: SQL2000 and MySql
- Re: SQL2000 and MySql
- Re: Alias *all* columns in a joined table?
- Re: Field name length
- ANN: Advanced Data Generator beta 3, including specialized database versions
- Possible values in "COMMAND" for SHOW PROCESSLIST
- Re: Possible values in "COMMAND" for SHOW PROCESSLIST
- Re: Possible values in "COMMAND" for SHOW PROCESSLIST
- Re: SHOW PROCESSLIST
- Re: SHOW PROCESSLIST
- Re: uppercase field constraints
- Re: Import Access DB into MySQL
- Re: Import Access DB into MySQL
Mar 2004
- ANN: Advanced Data Generator, MySQL Edition, 1.0.3 released
- "explain" tree like structure? Code available? Examples?
- Re: no one can log on any more
- Re: "explain" tree like structure? Code available? Examples?
- Re: PgSQL vs MySQL
- Re: Can't seem to get to run properly - Checked by Vexira - - Checked b
- Re: Major problem converting MyISAM to InnoDB
- Re: constraints within a table
- Re: mySQL, mySQL Max and stored procedure support (version problem?)
- Re: Mysql Eval Information
- Re: can MySql run over windows os?
- Re: Hierarchical data design
- Re: MyISAM vs. INNODB for a single blob table
- Re: Migrating Access databases to MySQL
- Re: Guru's advice needed ........[Security: SQL injection]
- Re: Stored Procs and Commit/Rollback Transactions
- Re: Tough Query for this New DBA
- Re: CHAR problem ...
- Re: Unique from this point forward
- Re: MySQL 5.0 - What is really available?
Apr 2004
- Re: Download
- Re: InnoDB!!
- Re: Create my First Stored Procedure ...
- Re: MSSQL Server to MYSQL migration problems
- ADO driver?
- Re: ADO driver?
- Re: NOT NULL column behaves strangely
- Re: Converting from MS SQL Server to MySQL
- Re: Query 2 DBs
- Re: Foreign Keys
- ANN: Advanced Data Generator 1.0.4 released
- Re: Create table results in (errno: 121)
- Re: column names in select
May 2004
- Re: Accessing DBMS remotely: MySQL? FireBird?
- Unofficial MySQL 5.0.x Windows Build?
- Re: Accessing DBMS remotely: MySQL? FireBird?
- Re: Foreign Key Constraints
- Re: Foreign Key Constraints
- Re: Foreign Key Constraints
- Re: Foreign Key Constraints
- Re: Foreign Key Constraints
- Re: Foreign Key Constraints
Jun 2004
- ANN: Advanced Data Generator 1.1.0 released
- Re: Know of a MySQL powered Instant Messaging system
- Re: Last Modified
- Re: Last Modified
- Re: Error 1250 Table from one of the SELECT's cannot be used in global ORDER clause
- Re: How to COUNT rows when they have a COUNT in them
- Re: Delphi 7 and MySQL
- Re: VIEW
- Re: Delphi 7 (&6) and MySQL
- Re: Error 1250 Table from one of the SELECT's cannot be used in global ORDER clause
- Re: Re[2]: Delphi 7 and MySQL
- Re: Error 1250 Table from one of the SELECT's cannot be used in global ORDER clause
- MySQL 5.0.1?
- Re: SQL challenge
- Re: triggers or stored procedures
Jul 2004
- Re: How to get count(id) when count is zero?
- "high priority" messages (Re: How to query an oracle table from a mysql database)
- Re: Cost of joins?
- Re: Cost of joins?
- Re: Cost of joins?
- Re: Cost of joins?
- Re: Cost of joins?
- Re: anyone help with this query? Returning tooooo many results
- Re: Cost of joins?
- Re: 2 Questions - DateTime fractional seconds and Transactions
- Re: IFNULL returns NULL when it shouldn't
- Re: Relational Integrity
- Re: Foreign keys
- Re: how to deal with a string of categories
- Re: why use MySql instead of Firebird or SQL Server express? (long)
- Re: why use MySql instead of Firebird or SQL Server express? (long)
- SHOW TABLE STATUS in MySQL 4.1.latest different from 4.1.1 !?
- Re: SHOW TABLE STATUS in MySQL 4.1.latest different from 4.1.1 !?
- Re: SHOW TABLE STATUS in MySQL 4.1.latest different from 4.1.1 !?
Aug 2004
- Re: MySQL 5.0.1-alpha-snapshot has been released
- VIEWS and SHOW TABLE STATUS in MySQL 5.0.1
- Re: concatenation
- Re: Where are the Foreign Keys?
- Re: Where are the Foreign Keys?
- Re: infos over the internal meta-data for mysql-databases
- Re: Selecting data from 2 tables.
- Re: Selecting data from 2 tables.
- Re: get extended infos over table-columns
- Re: get extended infos over table-columns
- Re: get extended infos over table-columns
- Re: Difference between PostgreSQL and MySQL
- Re: Difference between PostgreSQL and MySQL
- Re: MySQL Tables
- Re: GUI for MySQL
- Re: quoting keywords
- Re: MYSQL RECORDS AND ALPHABETICAL ORDER
- Re: MYSQL RECORDS AND ALPHABETICAL ORDER
- Re: Database Stats
- Re: Which ports
- Re: Migration tools/plan from oracle 7.3 to Mysql 4.0
- Re: Migration tools/plan from oracle 7.3 to Mysql 4.0
- Re: SHOW foreign keys
- Re: Migration tools/plan from oracle 7.3 to Mysql 4.0
- Re: Migration tools/plan from oracle 7.3 to Mysql 4.0
- Re: SHOW foreign keys
- Re: What is the best MySQL manager?
- Re: What is the best MySQL manager?
- Re: Calculated fields - is there any way to do this?
- Re: How to get the last record from the slected record set
- Re: Why "VARCHAR" TO "CHAR" automatically when the length less than 4.
- Re: Why "VARCHAR" TO "CHAR" automatically when the length less than 4.
- Re: Debating over table types
- Re: Create procedure problem
- Re: How do I find out a table's constraints ?
- Re: Shared column name
- Re: db design for hosting site
- Re: Concat
Sep 2004
- Re: Is their still any reason why Stored Procedure calls are not supported in MySql?
- Re: Is their still any reason why Stored Procedure calls are not supported in MySql?
- Fetch-on-demand
- Re: Fetch-on-demand
- ANN: Database Workbench 2.5.0 released
- Re: In search of a good MySQL GUI client
- Re: The UNION makes us strong^H^H^H^Hcrazy
- Re: Best way to get Access DB structures into MySQL ??
- ANN: Advanced Data Generator 1.2.0 released
- Re: List of Questions
- Re: AutoResponders (was: Unable to download MySQL (fwd))
- Sample MySQL 5 scripts wanted
- CREATE VIEW gets all mangled up when doing SHOW CREATE VIEW
- Re: views/cursors in mysql 4.0
Oct 2004
- Re: Telephone number column not working
- Re: MySQL Order by 2 date fields
- Re: CREATE VIEW gets all mangled up when doing SHOW CREATE VIEW
- Re: CREATE VIEW gets all mangled up when doing SHOW CREATE VIEW
- Re: Unknown table ... in where clause
- Re: CREATE VIEW gets all mangled up when doing SHOW CREATE VIEW
- Re: CREATE VIEW gets all mangled up when doing SHOW CREATE VIEW
- Re: Naming constraints
- Re: Naming constraints
- Re: InnoDB and foreign keys
- ANN: Database Workbench 2.5.5 released
- Re: Innodb foreign keys names
- Re: Sequences and Synomyms
- Re: Ask for help on a mysql problem
- Re: Ask for help on a mysql problem
- Re: Ask for help on a mysql problem
- Re: Innodb foreign keys names
- Re: Innodb foreign keys names
- Re: Char to Varchar on Innodb
- Re: SELECTING Non existing Dates
- Re: Transfering data from postgresql to MySQL
- Re: Extract MySQL Version
- Re: bug or feature, <> 'blah' does NOT work with null records
- Re: Converting table type
- Re: Converting table type
- Re: Converting table type
Nov 2004
- Re: mysql admin clients
- Re: Foreign Key
- Re: Changing Date Type
- Re: Changing Date Type
- ANN: Advanced Data Generator 1.2.5 released!
- ANN: Database Workbench 2.6.0 released
- Re: detect rows that has zero values
- Re: How to retrieve constraints and links from MySQL tables?
- Re: How to retrieve constraints and links from MySQL tables?
- Re: How to retrieve constraints and links from MySQL tables?
Dec 2004
- Re: unique key <-> primary key
- Re: unique key <-> primary key
- Re: unique key <-> primary key
- MySQL 5.0.2-alpha-nt highly instable?
- Re: MySQL 5.0.2-alpha-nt highly instable?
Jan 2005
- ANN: Advanced Data Generator 1.2.6 released
- List down?
- Re: Logging Data: Should I use MyIsam or InnoDB?
- Re: Logging Data: Should I use MyIsam or InnoDB?
- Re: Undo function?
- Re: How to select every second record
- Re: FULLTEXT index on InnoDB tables
- Re: FULLTEXT index on InnoDB tables (looking for a workaround)
- Re: Why MySQL is very slow in dropping indexes?
Feb 2005
- Re: ms sql server to mysql migration
- Re: How to specify autoincrement primary key value
- Re: Experience with MySQL 5
- Re: global object-id
- Re: one hour is/is not 60 minutes, that's the question...
- Re: How to make so I only need to specify the id once..
- Re: MySQL constraint question
- Re: UNIQUE Key Allowing Duplicate NULL Values
- Re: UNIQUE Key Allowing Duplicate NULL Values
- Re: UNIQUE Key Allowing Duplicate NULL Values
Mar 2005
- Re: field varchar and char truncate the ended blank characters
- Re: Inserting Other Binary data into DB (NOT IMAGES)
- Re: Use MySQL with Microsoft Office
- Re: Use MySQL with Microsoft Office
- Re: where to get a mysql licence
- Re: Better option then polling ?
- Re: Better option then polling ?
- Re: 5.0.2 alpha crashes with Query Browser
- Re: Which one of these two queries would be fastest?
- Re: functions md5, crypt
- Re: how to rollback in MySql?
- Re: 5.03 Still crashes on win32
- Re: MSSQL Import from MySQL
- Re: Index on boolean column
- Re: Index on boolean column
- Re: Index on boolean column
- Re: Index on boolean column
- Re: Index on boolean column
Apr 2005
- Re: problem with table design
- Re: problem with table design
- CSV storage engine
- Re: CSV storage engine
- Re: CSV storage engine
- Re: CSV storage engine
- Re: Auto SQL
- Re: How to retain "Key" order when Deleting a Row
- Re: MySQL bottleneck
- Re: MySQL 5.0.4-beta has been released
- Re: Query question
- Re: why NOT NULL in PRIMARY key??
- Re: why NOT NULL in PRIMARY key??
- Re: why NOT NULL in PRIMARY key??
- Re: why NOT NULL in PRIMARY key??
- Re: why NOT NULL in PRIMARY key??
- Re: why NOT NULL in PRIMARY key??
May 2005
- Re: why NOT NULL in PRIMARY key??
- Re: Unique Index on multiple columns that can contain NULL in MySQL
- ANN: Database Workbench 2.7.0 released
- Re: Read past Equivalent in MySQL
- Re: Read past Equivalent in MySQL
- Re: Read past Equivalent in MySQL
- Re: Read past Equivalent in MySQL
- Re: Read past Equivalent in MySQL
- Re: Single vs Multiple primary keys
- ANN: Database Workbench 2.7.1 released
- Re: DB design question
- Re: DB design question
- Re: InnoDB to MyISAM
- Re: InnoDB to MyISAM
- Re: InnoDB to MyISAM
- Re: InnoDB to MyISAM
Jun 2005
- ANN: Advanced Data Generator 1.5.0 released
- Re: mirroring oracle database
- Re: noob question
- Re: Seriously.. When are we going to get subqueries?!
- Re: ORDER BY and ENUM -- not alphabetical
- Re: microsoft sequel server
- Timestamp and it's usage (Re: Seriously.. When are we going to get subqueries?!)
- Re: Timestamp and it's usage (Re: Seriously.. When are we going to get subqueries?!)
- Open source DBMS evaluation study
- Re: Prepared Statements in Stored Procedures.
- ANN: Advanced Data Generator 1.5.1 released
Jul 2005
- Re: View onto tables w/ identical key names
- Re: View onto tables w/ identical key names
- Re: Network drive
- Re: null data in table question
- ANN: Database Workbench 2.7.5 released!
- Re: ORACLE and Mysql: Create tables, constraints, swquences, storage. ..?
- Re: Hour counts
- Re: Migration from ORACLE 9i to MySQL
- Re: Phone Number Column Advice
Aug 2005
- Re: STORED PROCEDURE
- Re: DROP VIEW Syntax
- MySQL 5 and 'delimiter'
- Re: MySQL 5 and 'delimiter'
- Re: MySQL 5 and 'delimiter'
- GRANTS for tables - why is "create" possible?
- Re: mysql 5.0.10 compilation error
- Re: Uninstalling the MySQL cleanly.
- GRANT EXECUTE in MySQL 4.1
- "mysql" database characterset
- Re: GRANT EXECUTE in MySQL 4.1
- Re: cannot drop database
- Re: Native XML Support
- Re: Native XML Support
- Re: Why can't I revoke usage from user?
- Re: Why can't I revoke usage from user?
- Re: Why can't I revoke usage from user?
- Re: Compare two tables
- Re: Compare two tables
- Re: DIV-function?
Sep 2005
- Re: Mysql to Oracle migration
- Re: Stored function
- Re: Differences Between ORACLE SQL PLus and MYSQL SQL
- Re: Yet another null question
- Re: possible MySQL bug - insert into 'double' column problem with mysql 4.1
- Re: Foreign keys across databases?
- Re: "Lost connection to MySQL server during query" when calling stored procedure
- Federated engine and "comment"???
- Re: Federated engine and "comment"???
- Re: I forgot the admin password
- Re: Federated engine and "comment"???
- Re: I forgot the admin password
- Re: I forgot the admin password
- Re: I forgot the admin password
- Re: good database design
- Re: good database design
- Re: good database design
- Re: good database design
- Re: good database design
- Re: foreign keys in MyISAM?
- Re: create database link in MySQL
- Re: Table names with periods
- Re: Table names with periods
- Re: Table names with periods
- Re: Table names with periods
Oct 2005
- Re: Double indexes on one field
- Re: Joins Tutorial Anywhere?
- Re: Duplicate column error when creating view on 5.0.13
- Re: ALTER TABLE - how to fix truncated data?
- Re: ALTER TABLE - how to fix truncated data?
- Re: ALTER TABLE - how to fix truncated data?
- Re: ALTER TABLE - how to fix truncated data?
- Re: Checking Multiplicity Constraints and Retrieving Details from Error Messages
- Re: Checking Multiplicity Constraints and Retrieving Details from Error Messages
- Re: Checking Multiplicity Constraints and Retrieving Details from Error Messages
- Re: Checking Multiplicity Constraints and Retrieving Details from Error Messages
- Re: sum of time?
- Re: sum of time?
- Re: sum of time?
- Re: Date storage format
- Re: DELETE Trigger
Nov 2005
- Re: Does BLOB=Memo?
- Re: PK or simple key?
- Re: Does MySQL Support '=' Sign?
- Re: Does MySQL Support '=' Sign?
- Re: Creating a view from a join
- Re: UNIQUE constraint, proper use
- Re: Tips for better performance
- Re: Tips for better performance
- Using a Stored Procedure that returns a resultset
- Re: Using a Stored Procedure that returns a resultset
- Re: Using a Stored Procedure that returns a resultset
- Re: Seeking Opinions
- Re: Seeking Opinions
- Re: Seeking Opinions
- Re: How to use Logic in View Statment?
Dec 2005
- Re: Assigment sign not work on Delphi
- ANN: Database Workbench 2.8.0 released!
- ANN: Database Workbench 2.8.0 update
- Re: PHP4 or PHP5?
- Re: Trapping MySQL Database Errors
- Re: SQL Statement Help
- Re: check a table column
- Re: invalidation rollback?!
Jan 2006
- BIT datatype and trying to use it: data too long error. Could this be a bug?
- BIT datatype and prepared statements
- Re: UPDATE Date Column
- Re: Altering column syntax help/and repare
- Re: Mysql and Oracle
- Re: count(*) send a wrong value
- ANN: Advanced Data Generator 1.6.0 released
- Re: Type conversion from Mysql to Oracle
- Re: Type conversion from Mysql to Oracle
Feb 2006
- Re: MySQL 5.0 probleam with show table status
- Re: 4.0.20 vs 4.1.16 issue
- Re: 4.0.20 vs 4.1.16 issue
- Re: Passing db names to a stored proc in MySQL 5
- Re: Passing db names to a stored proc in MySQL 5
- Re: Migration
- Re: MySQL 5.0.x and Delphi
- ANN: Database Workbench 2.8.1 released!
- Re: MySQL 5.0.x and Delphi
- Re: primary key
- Re: Query returns to many results
- It's party time!
- Re: It's party time!
- Re: It's party time!
- Re: Some general questions
Mar 2006
- Re: What is the rowsize limitation in MySQL?
- 1 day left: 75% discount on MySQL/Firebird/InterBase/Oracle/SQL Server developer tool!
- Re: 1 day left: 75% discount on MySQL/Firebird/InterBase/Oracle/SQL Server developer tool!
- Re: selecting records newer than say 20 min
- Merge tables: how to know the base tables?
- Re: Merge tables: how to know the base tables?
- Merge tables: how to get the "insert_method"?
- Re: Merge tables: how to get the "insert_method"?
- Re: mysql 5.0 too new?
- Re: SQL Foreign Key
- Re: Merge tables.
- Re: Merge tables.
- Re: Merge tables.
- Re: Accountability with MySQL
- Re: Accountability with MySQL
- Re: Accountability with MySQL
- Re: Accountability with MySQL
- Re: Accountability with MySQL
- Re: Accountability with MySQL
- Re: Accountability with MySQL
- Re: Accountability with MySQL
- Re: What is the proper (least expensive) way to do this
- Re: Accountability with MySQL
- Re: Accountability with MySQL
- Re: Accountability with MySQL
- Coalesce (was: Re: Accountability with MySQL)
- Re: Accountability with MySQL
- Re: Accountability with MySQL
- Re: Accountability with MySQL
- True Propositions (was Re: Accountability with MySQL)
- On MySQL Views (Re: Accountability with MySQL)
- Re: NULL columns
- Re: MySQL ROLLBACK question.
- Re: getting table metadata
- Re: getting table metadata
- Re: Discussion: the efficiency in using foreign keys
- Re: RIGHT JOIN better than INNER JOIN?
- Re: RIGHT JOIN better than INNER JOIN?
- Re: Constraint checking
- Re: sequences
- ANN: Advanced Data Generator 1.6.1 released
- Re: Question about autoincrement ID
- Re: Stored procedures and views
- Re: Stored procedures and views
- ANN: Database Workbench 2.8.5 released!
- SP Debugger (was: Re: ANN: Database Workbench 2.8.5 released!)
- Re: foreign key creation on MyISAM storage engine
- Re: Table Type For PK/FK
- Re: Table Type For PK/FK
Apr 2006
- Re: Syntax Question Constraint, Index
- Re: MySQL 5.0.18-standard - Wrong record (sorry, I cannot find a better subject)
- Re: Many Attributes Required Design Query
- Re: New MySQL Transaction Engine Announced
- Re: timestamp & not null
- Re: AS in a statement
- Re: timestamp & not null
- Re: A complex JOIN scenario
- Re: A complex JOIN scenario
- Re: A complex JOIN scenario
- Re: My Left Joins are Doubling the SUM()
- Re: Reply / Return Address of this List
- Re: getting unique results
- Re: problem with coalesce function
- Re: problem with coalesce function
- Re: Top N selections + rest row
- Re: Top N selections + rest row
- Re: HELP --- Slow SP
May 2006
- Re: EXPORTING results to CSV
- Re: The MySQL Stored Procedures and Functions is ready ?
- Re: 1' and '1' or '1
- Re: Need help with triggers
- Re: Converting varchar field into primary key
- Re: Converting varchar field into primary key
- Re: Is This A Redundant Info Example?
- Re: Is This A Redundant Info Example?
- Re: how to default column value to lower( )
- Re: Is This A Redundant Info Example?
- ANN: Database Workbench 2.8.6 released
Jun 2006
- Re: Problem with querie
- ANN: Advanced Data Generator 1.6.2 released
- ANN: Multi DBMS tool "Database Workbench" version 2.8.7 released
- Re: stored procedure TYPE
- Re: suggestions
- Re: TINYTEXT != VARCHAR(255) ? (Advanced Data Generator related)
- Re: CREATE TABLE Failure
Sep 2006
- ANN: Advanced Data Generator 1.7.0 released
- Re: Varchar mystery
- Re: South American timber products.
- Re: South American timber products.
- Re: How to sort last n entries?
- Re: comparing two databases
Oct 2006
- ANN: Database Workbench 2.8.8 available
- Re: join vs subqueries
- Re: too many enum values?
- Re: MSSQL to MySQL DB Syncronisation/Repl
- Re: MSSQL to MySQL DB Syncronisation/Repl
- Re: multiple primary keys on one table?
- Re: Bug or No bug - Composite Unique Key using null values
- Re: How to not repeat fields
- Re: How to not repeat fields
- Re: Simple JOIN on three tables
- Re: Import oracle
- Re: Re: CREATE TABLE Inv_Id
- Re: Does 'insert' return a value?
- Re: Does 'insert' return a value?
- Re: finding NULL records
- Re: finding NULL records
- Re: finding NULL records
Nov 2006
- Re: MyISAM vs InnoDB
- Re: Automatic Removal
- Re: MyISAM vs InnoDB
- Re: MyISAM vs InnoDB
- Re: MyISAM vs InnoDB
- Re: MyISAM vs InnoDB
- Re: Convert hex to decimal?
- Re: Default Column Value
- Re: MyISAM vs InnoDB
- Re: MySQL Front
- Re: Index effectivity for a 2-valued field (was Re: Should I use an index in this case?)
- ANN: Advanced Data Generator 2.0 released
Dec 2006
- Re: unable to create function in MySQL 5.0
- Re: unable to create function in MySQL 5.0
- Re: SUM() of 1 and NULL is 1 ?
- Re: Function problem
- Re: Syntax Problem
- Re: UNIQUE KEY vs NULLs
- Re: What is your favorite GUI tool for creating and querying tables in MySQL?
- Re: Primary field do I need one
Jan 2007
- Re: sequences and auto_increment
- Re: sequences and auto_increment
- Re: best way to query this table
- Re: Query Two Databases
- Re: Query Two Databases
- Re: Innodb, why not?
Feb 2007
- Re: Duplicating contents of DB within same DB with different prefix
- Re: [Fwd: search issue] Duplicating contents of DB within same DB with different prefix
- Re: using contraints on Mysql
- Re: Does casing of Table names matter on Linux
Mar 2007
- Re: migrating 4.0 to 5.0
- Re: migrating 4.0 to 5.0
- Re: tool to migrate data from oracle to mysql
- Re: Is there a professional quality mySQL GUI for Linux?
- Re: Are there any tools to get "diff" (alter commands) between tow tables ?
- Re: SPAM ?
Apr 2007
- Re: when rebuilding keys?
- Re: when rebuilding keys?
- Re: Can I create a index on a column of Type datetime?
- Re: when rebuilding keys?
- Re: when rebuilding keys?
- Re: Is it possible to either update or insert in a single query?
- Re: Query Pls
- Re: Max columns in a tabel in MyISAM storage engine
- Re: Max columns in a tabel in MyISAM storage engine
- Re: Max columns in a tabel in MyISAM storage engine
- Re: View with Subselect for User ID
May 2007
- Re: IS NULL Question
- Re: MySQL Workbench
- Re: Enforcing Data Format
- Re: Enforcing Data Format
- Re: Enforcing Data Format
- Re: Query problem
- Re: Query problem
- Re: Databases are used to store data,
- Re: design choice - quite many tables
- Re: Integrity on large sites
- Re: Integrity on large sites
- Re: CSV import
Jun 2007
- Re: Administrative Tools
- Re: Administrative Tools
- Re: Before I shoot myself in the foot...
- Re: Before I shoot myself in the foot...
Jul 2007
- Re: off-topic unsubscribe concern
- Re: Foreign key constraints - Known issues ?
- Re: What is the maximum length of "TEXT" column?
- Re: regarding BFILE datatype from Oracle
- Re: Migration from Oracle to MySQL
- Re: Migration from Oracle to MySQL
- Re: Migration from Oracle to MySQL
Aug 2007
- ANN: Advanced Data Generator 2.1.0 released
- ANN: Database Workbench 2.8.9 released!
- Re: index, unique index question
- Re: Recreate Table With Sorted Data
- Re: Recreate Table With Sorted Data
- Re: Recreate Table With Sorted Data
- Re: creating buddy list. request for help
- ANN: Database Workbench 2.8.10 released
- Re: what if i need the primary key of a row that is to be inserted?
- Re: what if i need the primary key of a row that is to be inserted?
Sep 2007
- Re: Editing fields in bulk
- Re: Simple questio SQL
- Re: transaction problem
- Re: Left join problem
- Re: Problem creating a Trigger
- Re: Question related to INSERT statement into table1 and SELECT statement from table1 to populate a column field into table1
- Re: Question related to INSERT statement into table1 and SELECT statement from table1 to populate a column field into table1
- Re: more options for MySQL tools by MySQL
- Re: using column "comment" to store metadata
- Re: using column "comment" to store metadata
- Re: using column "comment" to store metadata
- Falcon and Foreign Key Constraints
- Re: Falcon and Foreign Key Constraints
- ANN: Database Workbench Pro 3.0 released
- Re: Ouch! ibdata files deleted. Why no catastrophe?
- Re: What is MYSQL's equivalent to Oracle's DBMS_OUTPUT
- Re: Ouch! ibdata files deleted. Why no catastrophe?
- Re: DB Schema Comparison Utility ?
Oct 2007
- Re: My first trigger in MySQL
- Re: Query not returning Data
- Re: Trigger
- Re: Trigger
- Re: Trigger
- Re: Trigger
Nov 2007
- Re: Foreign keys on non-unique columns (problem)
- Re: Transactions and locking
- Re: Transactions and locking
- Re: indexing tables using my owns functions
- Re: indexing tables using my owns functions
- Re: Transactions and locking
- Re: Transactions and locking
- Re: IMAGES/PICTURES-MYSQL
- Re: Oracle is acquiring...............................
- Re: Oracle is acquiring...............................
- Re: Oracle is acquiring...............................
Dec 2007
- Re: trigger question...
- Re: Bug: Different data for different connections
- Re: Bug: Different data for different connections
- Re: Bug: Different data for different connections
Jan 2008
- ANN: Advanced Data Generator 2.2.0 released!
- Re: why in procedure truncate table do not reset auto_increment?
- Re: why in procedure truncate table do not reset auto_increment?
- Re: why in procedure truncate table do not reset auto_increment?
- Re: Did NOT condition on VARCHAR change with 5.0.45?
- Re: database theory book recommendations?
- Re: Sun and mysql
- Re: Sun and mysql
- ANN: Database Workbench Pro 3.1 released
- Re: comapring schemas
- Re: feature request: statement SELECT...(INSERT|UPDATE) :)
- Re: Data folder copying problem
- Re: Data folder copying problem
Feb 2008
Apr 2008
- Re: We have just moved to a new web server where we arerunningmysql version: 5.0.45
- Re: We have just moved to a new web server where wearerunningmysql version: 5.0.45
- Re: We have just moved to a new web server wherewearerunningmysql version: 5.0.45
- Re: We have just moved to a new web server wherewearerunningmysql version: 5.0.45
- MySQL 5.0.51a and SHOW ENGINES
- Re: MySQL 5.0.51a and SHOW ENGINES
- Re: MySQL 5.0.51a and SHOW ENGINES
- Re: MySQL 5.0.51a and SHOW ENGINES
- Re: get all my newest messages
- Re: get all my newest messages
- Re: get all my newest messages
- Re: get all my newest messages
May 2008
- Timestamp and the On Update Current_Timestamp clause
- Re: Timestamp and the On Update Current_Timestamp clause
- ANN: Database Workbench Pro v3.1.1 released
Jun 2008
- Re: sort_buffer_size
- Re: Function Still Not Working
- Re: MS SQL to MySQL select
- Re: delete a data from 3 tables
- Re: create view not working
- Re: How to guarantee an integrity in this case?
Jul 2008
- ANN: Advanced Data Generator 2.3.0 released!
- Re: How do I get the file names from a certain directory in SQL?
- Re: SET vs. ENUM
- Re: SET vs. ENUM
- Re: Re-arranging fields
Aug 2008
- Re: SET vs. ENUM
- Re: Table aliasing
- Re: Table aliasing
- Re: Transplanting table structure changes
- Re: Transplanting table structure changes
- Re: Normalization vs. Performance
Sep 2008
Oct 2008
- Re: Insert static column into VIEW
- ANN: Database Workbench Pro 3.2 released
- ANN: Free Database Workbench Lite for MySQL
Nov 2008
- Stored Routines, INFORMATION_SCHEMA and parameters
- Re: Stored Routines, INFORMATION_SCHEMA and parameters
- Re: Primary key / foreign key question
- Re: normalised designs: customer database
- Re: normalised designs: customer database
- Re: normalised designs: customer database
- Re: normalised designs: customer database
- Re: normalised designs: customer database
- Re: normalised designs: customer database
- Re: normalised designs: customer database
- Re: normalised designs: customer database
- Re: normalised designs: customer database
- Re: Finding not quite duplicates
- Re: Finding not quite duplicates
Dec 2008
- Re: Alter Table - InnoDB
- Re: Trying to Create a Trigger
- Re: Trying to Create a Trigger
- Re: Trying to Create a Trigger
- Re: Trying to Create a Trigger
- Re: --safe-updates and DELETEs
Jan 2009
Feb 2009
- Re: WHERE vs. ON
- Re: Is the Relational Database Doomed?
- Re: Codd's rule 8 (physical data idependence)
- Re: When will MySQL support array datatype?
Mar 2009
- 75% discount during the Database Workbench pro Secret Super Sale!
- Re: Does MySQL 5.1 store queries?
- ANN: Database Workbench Pro Super Sale has started!
- ANN: Database Workbench 3.3 Pro released!
Apr 2009
- Free "Database Workbench 3.3 Lite for MySQL" available!
- Re: Are equi-joins faster than left joins?
- Re: One to many relationship
- Re: AMD64
- Re: AMD64
- Re: AMD64
- ANN: Advanced Data Generator 2.5.0 released!
- Re: Oracle , what else ?
- Re: Oracle , what else ?
- Re: Oracle , what else ?
May 2009
Jun 2009
- Re: AW: creating databases in different folders
- Re: How to specify CHAR column to accept specific characters
Jul 2009
Aug 2009
- ANN: Database Workbench Pro 3.4 released
- Re: How to Detect MySql table update/difference
- ANN: Free Lite versions of Database Workbench 3.4 available!
- Re: foreign keys: Cannot create InnoDB table
- Re: Is there a way ?
- Re: Query Question
- Re: Query Question
Sep 2009
Oct 2009
- Re: Adding Fields To Table
- Transations? (was: Re: login issue..pls help)
- GRANT USAGE (was: Re: login issue..pls help)
- Re: MySQL GUI Tools
- ANN: Database Workbench 3.4.1 Pro released!
- Re: START TRANSACTION COMMIT ROLLBACK
- ANN: Free Database Workbench 3.4.1 Lite released
- Re: START TRANSACTION COMMIT ROLLBACK
- Re: START TRANSACTION COMMIT ROLLBACK
Nov 2009
- ANN: Database Workbench 3.4.2 released!
- Re: storage difference in VARCHAR(size)?
- Re: storage difference in VARCHAR(size)?
- Re: LIMIT/OFFSET to paginate results
Dec 2009
- Re: ERROR 1235 (42000): This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
- Re: Update Doesn't Update!
- Re: Help saving MySQL
- Re: Help saving MySQL
- Re: Help saving MySQL
- Re: Help Save MySQL
- Re: Help Save MySQL
- Re: Help saving MySQL
- Re: Database fundamentals: wanna learn.
- Re: Is anything ever equal to NULL?
- Re: Is anything ever equal to NULL?
Jan 2010
- ANN: Advanced Data Generator 2.5.1 released
- Re: Best way to synchronize two database schemas
- Re: Need an extra pair of eyes
- ANN: Database Workbench 3.4.3 released
- Re: Good source for sample data?
- Re: 50 things to know before migrating from Oracle to MySQL
- Re: Good source for sample data?
- Re: 50 things to know before migrating from Oracle to MySQL
Feb 2010
- Re: 50 things to know before migrating from Oracle to MySQL
- Re: 50 things to know before migrating from Oracle to MySQL
- Re: 50 things to know before migrating from Oracle to MySQL
- Re: MyISAM to InnoDB
- Re: how things get messed up
- Re: how things get messed up
- Re: how things get messed up
- Re: how things get messed up
- Re: how things get messed up
- Re: how things get messed up
- Re: how things get messed up
- Re: how things get messed up
Mar 2010
Apr 2010
- ANN: Database Workbench 3.4.4 released
- Re: Tokutek Acquires Oracle
- ANN: Database Workbench 3.4.4b released
- ANN: Database Workbench Pro 3, 25% discount for two more weeks!
- ANN: New version of Database Workbench, the multi-DBMS IDE now available!
- Re: How to select rows from only the first N rows in a table?
- Re: How to select rows from only the first N rows in a table?
- Re: order by numeric value
- ANN: Database Workbench 4.0.1 Pro released
May 2010
Jun 2010
Jul 2010
- Re: Triggers and "FOR EACH ROW"
- ANN: Database Workbench 4.0.3, the multi-DBMS IDE now available!
- Re: Which tool to use for developing Pl/Sql on MySQL?
Dec 2010
Jan 2011
- ANN: New Year's Sale at Upscene Productions, 25% discount!
- Re: Which row in which table has been accessed at which time?
Feb 2011
Mar 2011
Apr 2011
Jun 2011
Aug 2011
- ANN: Database Workbench 4.1.3, the multi-DBMS IDE now available!
- Re: ANN: Database Workbench 4.1.3, the multi-DBMS IDE now available!
Dec 2011
- Database Workbench 4.2.0, the multi-DBMS IDE now available!
- ANN: Discount December - 40% discount on all products!
Feb 2012
Mar 2012
- ANN: Database Workbench 4.2.2, the multi-DBMS IDE now available!
- ANN: Database Workbench 4.2.3, the multi-DBMS IDE now available!
- Re: Database Workbench 4.2.3, the multi-DBMS IDE now available!
- ANN: Very early preview movie of Hopper, Stored Routine Debugger
Apr 2012
May 2012
- ANN: Database Workbench 4.2.4 released, 70% discount!
- ANN: 70% Ten Year Anniversary discount on all our products!
- ANN: Hopper for MySQL, first public beta available!
- ANN: Only 2 days left, 70% discount on all products!
- Re: ANN: Hopper for MySQL, first public beta available!
Jun 2012
- ANN: Database Workbench 4.2.4, free Lite Editions now available!
- ANN: Hopper (stored procedure debugger), version 1.0.1 released
- Re: ANN: Hopper (stored procedure debugger), version 1.0.1 released
- Re: ANN: Hopper (stored procedure debugger), version 1.0.1 released
Jul 2012
Aug 2012
- ANN: Hopper (stored procedure debugger), version 1.0.3 released
- Re: create roles/groups in MYSQL
- ANN: Database Workbench 4.3.0, the multi-DBMS IDE now available!
- ANN: Database Workbench 4.3.1, the multi-DBMS IDE now available!
Sep 2012
Nov 2012
Jan 2013
Feb 2013
Mar 2013
- ANN: beta 1 of Advanced Data Generator 3 released
- ANN: Hopper - Stored Routine debugger - v1.2.0 released
- ANN: beta 2 of Advanced Data Generator 3 released
- ANN: beta 3 of Advanced Data Generator 3 released