- Best way to get the SUM/GROUP BY and ORDER BY
- ANN: DBForms from MS Access to PHP + MySQL v.2.1.1 released
- Update Statement Continues to give me an error
- Moving a database between 5.0 and 5.1
- TRUNCATE TABLE * ?
- Installed MySQL - updating charsets
- SQL Select statement
- server time != my time
- INSERT and SELECT how can I do this.
- Multiple threads connection
- error in starting mysql server ...
- Is MySQL more ansi compatible now?
- displaying grouped items when using count()
- Group by Top x ?
- mysql performance
- Vista
- how to write sql to map attributes in one table to attributes in another table?
- replace non numerical caracters in field
- 'unauthenticated user' x 100 in SHOW PROCESSLIST
- Most basic php/mysql test?
- name and surname in a single field
- returning only numerical portion of varcar
- mysqldump error
- MySQL Performance issues
- JOINing derived tables, with incomplete records
- MySQL PHP Code problem. Please help!
- LOAD DATA INFILE fails
- Problem of "Incorrect information in file: '.\xxx\xxx.frm'"?
- Order by the biggest of 2 fields
- prepare statement with date parameter
- is it better to not index a high-write, low-read table?
- I'm Sorry To Ask, But I'm Stumped
- SQL query to get UP and Down jobs ignoring subseqent dups
- my.cnf and default charsets
- External web access to mysql
- what can this be ?
- JOB: MySQL DBA, London, UK
- Searching Google n-gram corpus?
- How many of one string in another
- help about 'on query cache'
- function and procedure
- Getting a list of updated rows?
- Query too slow, please help optimize
- character encoding problems with export/import
- Different behavior when using aliases in 4.1.21 vs. 4.1.22 version
- Good Solid Books on SQL?
- Ordered lists
- mysql format function
- Selecting rows from a table based on the highest value in a field
- Newbie: Indexing Words from a Field
- Workaround for missing "DROP USER IF EXISTS" ?
- Select number
- Help needed with SQL query.
- updating with regexp
- compute the ratio from two tables with a common column
- CREATE PROCEDURE
- Combining Queries
- Does the password in the ConnectionString travel encrypted?
- making mysqldump faster, or an alternative backup?
- Counting Query Problem
- charset problem... sigh
- mysql < dumpfile.sql problem
- free tool to dreate ER diagram
- Select second max record..
- Performance comparison between mutliple tables and multiple databases
- Unique constraint across columns?
- unable to use aliases in SELECT
- [MySQL 5] DBDesigner 4
- how do you know which indexes are actually used
- Trace SQL Statements
- How to enforce an ENUM ?
- Unique constraint for the columns does not work when one of values is null.
- Performance Problems With JOINS - Tunnng required or upgrade hardware?
- Profiling (not racial)
- MySQL
- MySQL table got temporarily locked up? how to monitor this kind of event?
- newbie: installing MySQL Connetor .NET driver in Ubuntu Linux
- adding LIMIT 1 to improve performance?
- Re: Table design
- Converting Query from MSSQL to MySQL
- newbie: "using System.Data.MySql" in Mono
- Irregular stored proc results giving me headaches, please help
- Everything about MySQL Certification
- Slow connections
- How stable is MySQL ?
- Selective inserts or something?!?
- iterating over fetched tablenames ?
- concatonating 2 SELECTS into the same result set?
- Query optimization
- return min between 2 fields
- grouping results
- Re: Do i need to install mysql-Enterprise to use monitoring?
- Normalization
- Index Join without temporary tables
- How do I create a new user?
- function both exists and doesn't exist
- subquery fails, i don't think an outer join will work
- Accessing Database on another PC
- Help Me
- bussiness logic - how to develop in mysql
- Adding 10 hours to specific time
- Data from 2 columns
- How to count number of distinct rows
- top3 with or without "having" in query
- Question about Warning (Code 1262): (number of input rows & @dummy)
- How to find out the current version of the MySQL installation ?
- how does view work??
- How to list all existing databases and their size ?
- mysql connections vs threads
- I need help optimizing this query
- Trying to wrap my brain around a normalization issue. Assistance please?
- Case sensitivity
- double insert
- Multiple Count in 1 Query
- Is it possible to QUERY and insert result into another table?
- How to create Read Only Table
- using fulltext like 'like'
- return result set from cursor
- Query with WHERE ... IN () AND ... NOT IN ()
- please help with searching in mysql database
- MySQL error log becomes zero bytes
- Basic MySQL MERGE table question
- Installing MySQL 5.0 (Windows 2000)
- Select Top 1 * problem
- Query which uses more than one value from the same column?
- Regular Expression to Update a field
- Child and parent rows
- MYSQL with VB
- How do I find out exactly why a query is taking so long?
- INSERT works in phpMyAdmin but not in PHP
- SELECT has different effect in a view
- Query /Stored proc issue..Help please
- activating slow query log
- converting mysql 4 statements to mysql 5
- how to monitor dynamic performance
- MySQL ignores datatdir on Vista
- Is it possible to combine a SELECT and UPDATE in a single query
- migrating data from 3.23 to 4.1
- Rows Positions problems while performing several operations
- week numbers doesnt correspond with the official ones
- Apex Systems - Excellent Senior DBA Opportunity!
- Join vs ...
- Full Text Search - characters limit
- How do I save connections
- Is there any way to tell if a thread has an advisory lock set?
- Timestamp conversion problem
- mysqld dies every hour
- INSERT rows in Reverse Order
- Connecting MYSQL to IIS v5
- how to relate tables with two primary keys
- SELECT all records that occurred in the last five minutes or less
- Weird Scenario
- Parameters for table names
- order by not working
- email trigger in MySQL
- Variable in Select statement?
- Problems with insert...select
- design question - storing questions and answers for various question types
- ** Regexp Help **
- Insert categories with new row
- InnoDB tables silently created as MyISAM
- GURU: conception help needed
- count(*)
- mysql-test-run Test Cases
- how to create insert from select
- Simple MySQL issue
- SELECT not working???
- MySQL .NET Connector and AutoIncrement
- recherche table SQL et élement qui se suivent
- Find next available slot in Calendar
- Performance issue
- subquery, alias and derived tables
- Help needed on query syntax - easy question!
- Select AND IF
- Weighting results of subqueries
- advice on rewriting a query
- Schema Relationship Question
- [OT] Allegati cli/for
- Status and meaning of opens: parameter
- ERROR 1064 (42000)
- something like a trigger!
- Speeding up large query
- SELECT MAX vs. SELECT / ORDER BYDESC / LIMIT
- VARCHAR and size
- Capturing a Schema
- Copy rows from one table into another table.
- Foreign Key for PHP serialized data - possible?
- MySQL uses %25 of 2GB RAM
- Fatal error: Call to undefined function mysql_connect()
- cannot delete from table [MYSQL 5]
- BINARY
- subquery
- selecting the BIT number "n" of a BITfield (BIN?!)
- searching on a datetime column, how?
- Query Producing Unbounded Set?
- Parameters for column names
- Help with Combination Query
- simple query question
- search purchase price
- [ANN] WebSQL - web based database administrator tool
- migrating MSSQL databases to MYSQL
- Mysql for a Oracle DBA
- Normalizing db, some probs.....
- Why this query works?
- Help for MySQL 5.x DBs for demo
- A sort order column?
- How to determine shape of data from mysql Stored Procs
- Help making a join.
- upgrade Mysql to 5.0.45
- Getting master status position programmatically
- How to capture mysql queries or view them in real time
- howto numerically order a char value
- join question
- LIKE & indexes
- Nodes and Trees... probiably
- Ignore a column when using mysqldump?
- [SQL] Matching One to many relationship, difficult.
- How to write this UPDATE statement?
- mySQL Many-to-Many Relationship.....Nested Select??
- Missing the obvious?
- Finding a category or a default alternative
- Cardinality
- Replication problem: max_allowed_packet
- Duplicating rows (newbie)
- Creating a transaction
- error handler
- big problem in database
- collation problem
- Reusing subqueries
- Nested subquery loses rows in dynamic table
- How to include some empty answers in a query?
- combine two queries and compute from values
- Add text to a field and keep the old text?
- is full text search slow?
- mysql on partition FAT32
- is full text search slow?
- Is there a quick way to copy database information?
- LIMIT and TEXT types.
- Newbie sql question
- Query help
- Import sql datatbase into MySQL on Red Hat v. 4
- Are these 3 hosts not the same thing?
- Newbie needs help with UNION query - easy question!
- Watch NFL Games Online
- How to got Mysql prompt at Linux
- free access to MySQL source code repository and BitKeeper?
- connector 4.1
- BLOB/TEXT columns can't have default values?
- Regular Expressions problem
- Help with a simple SQL query