View Full Version : MySQL
- a question about the "EXPLAIN" functionality
- multiple fields AS one field...
- MYSQL and php coding for designing a combo box or list box
- Problem with OES/Linux environment
- Asynchronous write of transaction log to disk
- Sort/Grouping question
- Need help with: COUNT() two columns from two tables in one query
- selecting records from one table that aren't in another
- first day of the week
- easy backup from 10 servers
- I can connect through MySQL-Front Direct Connection. But Not through PHP scripts
- FORCE INDEX in a DELETE statement
- Weird Date BETWEEN problem
- Multiple WHERE conditions. Can I simplify/optimize this?
- mysql-devel
- Need to find a way to use loops to run a query by increasing data variable by 7 days.
- Mysql Outfile ^M Characters
- return one row with topics concatenated (was "Newbee needs sql help")
- Starting MySQL
- LDAP services my MySQL Database
- Help setup!
- How to store a link in a table
- Storing huge amount of binary data
- table creation problems
- Database Installation (mysql)
- Database Installation (mysql)
- ERROR 1030: Got error 28 from table handler
- Why does this return 0 rows?
- I need help with joins
- HOw to update a table from another table
- Making schema with different roles
- Date Casting from concatted values
- Empty column name on a simple request
- How much data can mysql hold?
- How to search part of a name from two fields?
- MySql Scalability
- Are there hosted MySql ?
- Default today's date syntax
- use mysql for lock all tables and restore database???
- BETWEEN not returning results (was "Query not working in mySQL")
- Turning off referential integrirty while inserting
- Which Columns do I Index?
- Designing a tiered document management solution
- Database Record Expiry
- Converting Excel to Mysql Tutorial
- A table design problem...
- Display all that is not Null
- fulltext index problem
- help on join table in search engine
- Formatting an average number
- Storing Coordinates XYZ
- MySQL 4.1.12a-nt buggy?
- tr character problem
- Conditional SELECT?
- timed batch query that writes text file.. where to start looking for info?
- find minimum value in a row
- Get the last date
- Call procedure with parameters
- Query help for shoutbox script. 3 tables and need 40 rows?
- Automatically remove singe quotes?
- get the oldest person's id from group 2 (was "Sql HELP")
- hotel reservation database
- String Format (lower/upper)
- Full-text search! Returns all rows! Why?
- server instance issue
- is mySQL server running, or a service running? (was "new to mysql")
- FoxPro to MySQL
- How to determine position/rank in sorted result without full result?
- Need Help Optimizing A Query
- Unknown column in where clause
- artists that have all genre criteria (was "Query help")
- service keeps stopping
- upload a text file (was "Please help me in this i am sort of newbie")
- Multi-language transalations
- Composite primary-key
- MySQL foreign keys
- MySQL 5 for production
- many to many table nightmare
- MySQL Query Browser Very Buggy?
- months within a selected period
- problem connecting to mysql server via php
- prepared statements had been removed?
- NVL with Count
- Does order of columns in multi-column index matter (was "Probably a stupid question")
- problem in usin COUNT(*) & GROUP BY
- Remote login (plz help the newbie)
- mysqldump HELP!!!!
- SQL: EXISTS Condition
- Connecting to a remote server
- group by [..] order by [...]
- unique SurveyKey with a comma seperated list of sRefs (was "SQL query help needed.")
- SQL Order by INT
- Read/Write Error
- Mysql date query
- Displaying designated record first in a SELECT result
- Index for faster SELECT queries
- MySQL use of aliases
- Multiple Tables?
- structuring similiar data with multiple formats...
- Records Database
- Import data
- Backing up MySQL from an application
- Batch File problem
- How can I store Asian characters in MySQL?
- FullText Search Doesn't Work
- import stored procedure
- Odd mytop enteries make server crash
- countin rows without changing main statement
- Using ORDER BY to alternate rows from UNION query
- Alaternative to inforamtion_Schema
- STR_TO_DATE in mysql 4
- SQL connection Windows or Linux
- charecter problem | help please
- Problems w/ Case Statement
- Can't connect from remote host
- Cant create a user
- CLOSE! One last question about the CASE statement
- Total number of queries doesn't add up
- Export
- Help needed with this schema
- Converting and Loading MS-SQL data to MySQL
- Alternative to OUTER JOIN ON? Issue with very slow query.
- Lock wait timeout exceeded
- MySQL won't connect...
- You have not established a connection to MySQL 4.x.
- Can't create table '.\erpdb\test.frm' (errno: 121)
- Problem accessing 2 tables
- error when using password in dbconnect
- SELECT * + format some fields
- problems with MySqlAdministrator
- Is this possible with MySQL 4.1 (Summary Rows)
- Is Primary Key index?
- Categories and Sub Categories Table
- Date Compare
- question about MAX( )
- translation
- converting 4.1 to 4.0
- Problems upgrading from 3 to 4
- information import
- How do I start Logging on Windows MySQL Production Server?
- is it possible? help for select statement..
- display_size - What does it actually mean?
- Multiple-step operation generated error
- Dynamic Order By help
- SUM of 'n' columns in every row
- OrderID's as Integer (zerofill) yymm0000 (was "Query help")
- move INNODB Tables between dbase instances
- How to convert MySQL database to ORACLE
- GROUP BY, ORDER BY and JOIN...
- MaxDB ODBC driver failed
- mysqldump program
- cannot connect to database (was "very very new to MySQL")
- How to get the number of rows processed
- Viewing log files with mysqlbinlog
- swapping rows and columns
- Joining three tables
- 3 years in 3 columns (was "Pulling my hair out with this query")
- <option value="$var" $SELECT/$noSELECT>
- Veritas Cluster for Sun Training
- See if data in one table doesn't exist in other
- error message in guestbook
- Reset auto increment column
- table1 rows not in table2 with condition (was "where am i going wrong...")
- ib_logfile0 is of different size
- JOIN vs WHERE (joining tables)
- CREATE TABLE error in sql syntax...
- start ansi_mode, redhat 8.0 linux
- case sensitive table names
- Help needed - Identical input field value
- insert unicode data (japanese string) into table
- Exectute multiple statements from PHP
- SELECT...FOR UPDATE question
- MySQL & Dreamweaver MX
- mysql says im inputting something im not
- password problem on a windows machine
- Query Help
- live Two Tables Update
- How to get the row number which has warning
- dropping indexes on a MRG table
- Importing a CSV File
- Getting rid of the session-id
- replication over SSL errors
- [NOOB] Foreign Key Constraints (errno: 150)
- Export Problems
- multiple-database query with mySQl?
- what is wrong with this record
- Show warnings
- Update MySQL Server
- ADO Connection and Delphi
- Inner Join question
- Repeating entry in general log
- Transcoding problems
- data provider for ADO(OLEDB?)
- could not connect to mysql from php fedora core 3
- MySQL Cert and Release 5
- Count and Divide
- hotel room reservation
- return result set in SPs
- What is my problem with Unique Index?
- Bad Query Performance
- error near 'ENGINE=MyISAM DEFAULT CHARSET=latin1' ( was "Why the syntax error?")
- Name of Mysql Server Machine
- Updating a table from another table with like
- Having a hard time with a select within a select.. or whatever this needs.
- Change the DB, MS sql to Mysql
- MySQL - Multiple Instances
- replication missing data recovery help
- Convert DB's: PostGre -> MySQL
- How do I compress a read-only table on a remote server?
- SELECT to return rows for each date within a range
- standings calculation query
- How To Create Data Source Name Through Code - Delphi
- Resource for Memory Usage
- Need To IMPROVE MySQL Database Search
- DSN is Not Creating
- Recursive statement
- MySQL Full-Text search with pleurals
- -bash: mysql: command not found (was "Easy question...")
- Database design question
- update a column from a data file
- COUNT: counting 2 different things?
- Error 1193: Unkown system variable
- how to do a MINUS or EXCEPT in mysql
- find season depends on date input
- MySQL Performance Issues
- mysql download pls help
- MySQL Query Help Please
- MySQL and PHP, socket issues, please help!
- DB not keeping order
- Any database design expert here?
- Please, help with Hurricane website!!!
- pls help to install the myssql
- Cyrilic in MySQL Browser
- Custom Order By
- Problem with 4.1 (mysql-standard VS source install)
- Help with LEFT JOIN
- Persistent Fatal error: Call to undefined function: mysql_connect() in ...
- Help, Integrating VB 6, Mysql ODBC 5 and Mysql 4.1.14
- should only be retrived once
- Access denied for user 'root' @'localhost' (was "pls help the newbie")
- HELP, with VB6+ODBC+MYSQL
- Query Syntax with LIMIT and ORDER question
- execute procedure got error 1418 (was "plz help me.")
- Foreign Key in another Database
- Moving vBulletin DB from 3.23.58 to 4.0.25
- Need Smart MySQL Query
- set up on xp home
- how to get the result set inside procedure
- housekeeping table; table of tables and fields
- Error in replication
vBulletin v3.5.3, Copyright ©2000-2008, Jelsoft Enterprises Ltd.