View Full Version : MySQL
- How to sum and group two tables
- associative table or a directly foreign key,what is better?
- MYSQL Performance
- MySQL replication rating
- help with select query
- query to find friends of a friend
- WHERE clause question
- Problem installing driver.
- is this a driver problem or sqlyog problem
- How to check which one is the current databse?
- How to get MSSQL style relationships going?
- How to convert machine readable date format to regular date format in mysql?
- Help with database
- Performance & Indexing Question
- mysql fulltext indexing limitation
- #145 crashed and should be repaired
- database design
- MySQL &.Net Performance
- Create Trigger help required
- ERROR 1223: Can't execute the query because you have a conflicting read lock
- java.sql.SQLException: Out of memory (Needed 268435428 bytes)
- triggers inquiry
- update and function in same table
- MySQL tools and documentation
- mysql_insert_id in multi values INSERT statements
- triggers support of mySQL
- adding multiple columns in one ALTER statement
- encryption question
- Position/ranking in ordered data
- insert date
- How to Maintain and Optimize SQL Queries with Large Tables?
- Load Data Inforl question
- FULLTEXT search probs
- When do we use different databases ?
- trouble doing basic mysql insert
- Need a hand with 'count' on a UNION
- ERROR 1017 (HY000): Can't find file: 'tablename' (errno: 2)
- Derived Columns
- MyISAM Table corrupt because a simple reboot?
- database basic setup & calculation question
- global variable
- DB query
- Question about MAX function
- SQL Select Problem
- Select In Select
- community and enterprise
- Get threads sorted by most recent topic addition
- Using SET in INSERT ON DUPLICATE KEY UPDATE
- question about mysql samples or templates
- Intermittent "Can't connect to MySQL server"
- Milliseconds
- Engine wiht Transactions & Fulltext support
- DB question
- Trim spaces in the middle of a string
- how to use data in one field to change data in others
- Recovery of deleted rows in mysql
- OLEDB Provider for MySQL
- pre-4.1-style password
- setting field value based on 2 other fields
- Soring time in DB
- How to install MySQL on mac Tiger OSX 10.4
- Days between
- Storing emails on database
- Transactions/Stored Procs/InnoDB questions
- Multithreaded Application Insert Puzzle
- Need Help Finding Online Live Database
- Is this query too hard for mysql?
- Please help me optimize this query
- Keeping fields consistant within a table
- Unexpected results from a simple query, totally bizzarre...
- Creating Event to auto_update datetime field
- MySQL Transaction + ASP.NET Odbc Connection
- ODBC Connection Problem
- Major Design Concept
- Job to schedule script on MySQL database
- Storage comma instead of dot in numeric types
- Tables "in use" - How to fix?
- Can anyone convert this Oracle sql to MySQL?
- Working with stored procedures, Asp.Net with Visual Studio 2005, Connector 5.0.3
- Two tables group and Subtract results?
- Using variable in sql select
- Slow performance for fulltext queries
- Mysql5 Stored procedures editor (freeware)
- Migrating MyISAM to InnoDB
- Rookie Questions Using Tool MySQL WorkBench
- Synchronization Manager for MaxDB
- Which IP is MySql Server listening to ?
- Just installed mysql, it won't let me login.
- RegExp Pattern for a Tag Column
- a list of good business practices (was "New to this stuff...")
- A good book for MySQL?
- Connector/NET of ASP.NET & MySQL
- Enterprise Manager
- Backslashes disappearing when exporting
- Generate rows from a row
- MySQL connection was aborted by the software in your host machine
- Open mysql table in ram
- Execution plan !?
- AutoIncrement Function
- Granting Privileges
- Problem handling non-ascii characters!!
- Need Help With Query
- Error when using wizard to connect MySQL DB
- Migrating from Ingres to MySQL
- Query Shorthand
- Adding "Missing" Days
- Quick newbie design question
- Connectin Script to SQL! HOW?
- Character Set Issue UTF-8, MySQL and Arabic
- union varchar from diff tables returns blob
- knowledge of mYSQL
- database design, just one table?
- Record concat display
- Query (dont know how to title this)
- Replication - how to pick a slave...
- CSV Import Into MySQL
- MySQL charset / MySQL connection collation
- MySQL and SQL difference
- Backing up MySQL server over the internet
- turn this excel file, into a searchable database on my website (was "complete n00b")
- Query Multiple SQL databases
- Too many connections?
- Size of Table
- mysql date operation problem??
- line of code for "find & replace/delete"
- mySQL + Visual Studio.NET 2003
- DBDesigner4 and Circular Relations
- AcuODBC to MySQL connection
- Move DB from one server to another with the same encrypted passwords
- self join help
- Selecting a random record from top 100 records
- MyISAM or InnoDB?
- question on integer field length allocation
- importing mssql data (BLOB)
- ASP.NET + MySQL 4 + Transactions
- workaround for a subquery
- Field comments not showing
- End User-friendly backup and purge
- Combining 2 queries
- MySQL Administrator
- incremental or differential backup
- Easing server load for many-record queries
- Practice problems with solutions for Microsoft SQL express
- Missing index values
- New application with Visual Studio 2003 .NET
- Inserting foreign keys
- call for mysql tests
- Optimal index size on VARCHAR - tricky...
- any db master knows this ?
- Web Crawler database design
- MySql with Full text search massive use and huge database
- wat buks to read to get a gud knowledge (was "could someone help me ....beginner")
- How to optimize ORDER BY query with COUNT() and GROUP BY.
- long_query_time is 5 then after i get slow-query of 0 and 1 seconds
- Peer Review of a DB Design?
- Advanced joined query, need help
- How to retreive Data using Joins
- The equivalent of 'tablespace' in MySQL?
- Restorin script
- "too many connections"
- Case insensitive
- Combining Records
- Auto Export in MySQL
- Download sample databases used in "Learning Mysql"?
- Variable PK for specific value
- Deploying changes to database
- Simple join/query problem - I'm a newbie
- "Table xxx not exists" error
- corection needed
- converting query from select to update or delete
- Website data into db later question
- Error line
- application and database on 2 different servers
- Where's the data ?
- Can u give me some info (MySQL)?
- Changing character set
- Maximum display width on Integer types !?
- Plz Hep - query exicution is very slow
- Using multiple database is increase or decrease web site performance?
- Database design - how to?
- How to track transactional state / nested transactions
- what is the meaning of 'pnt' in SQL (was "can any1 help me please its easy...")
- Conversion Process
- Compact Table Design
- Scale out horizontally with db partitioning???
- daylight savings inquiry
- object dependencies in mysql
- FIND_IN_SET and IN not working for my situation
- backup for old mysql from new
- DB back-up SSH || forum
- Fetching text from phrase
- Help required, to complex for this newbie
- Trying to connect to MySQL using PHP
- How do I generate dynamic table names in a SELECT statement?
- Update multipe rows outside loop - need help
- MySQL query optimization article
- Complex sum and case statement(for me!)
- in search of MySQL metadata
- 1.00 ends up as 0.99 in float(2,2) field
- Guide to MySQL and UTF-8
- Error with IPB Forums
- how mysql works
- Create user password problem
- Multiple search parameters on same table field
- Auto Increment, multiple tables
- Too many left joins? - newbie stuff, help needed.
- Managing appointment conflicts
- Trying to find what's not in second table.
- LIKE and several words
- Starting MySQL problem
- Automatic FTPing of a query?
- how can i extract date from datetime
- howto get preset auto-increment number ?
- Efficient best sellers list
- new to mySQL
- Shared-nothing architecture
- Retrieving data from another table with a given ID
- Remote sql
- Access to MySql conversion
- Help with a MySQL Application
- Possible SET bug in UPDATE?
- mysql_refresh
- I used reserved words in field names– workaround?
- mysql data corruption?
- DB Design - Normalised and performance drop
- changes in hostname
- MySQL Connectivity
- Inserting binary data into MySQL
- Deferred checking
- What must foreign key reference?
- Efficiency question in 'WHERE' clause
- multiple AND with IN specs - problem syntax?
- Read from files and organized data
- MySQL Newb question
- Problem on adding foreign key
- searching for a string using hamming distance
- Error message not displaying just blank page
- Interesting query - hard to title
- Retrieving data from 2 tables separately, but in the same query.
- locking
- Age Calculations
- Escape Character Not Working
- implement logical condition on varchar
- Common Table Expression (CTE) available for MySQL?
- Doubled rows from SELECT statement??
- Subquery at Insert
- Create View question
- When coders don't see eye to eye
- Backing up MySQL in Windows
- select field starting with char
vBulletin® v3.8.6, Copyright ©2000-2012, Jelsoft Enterprises Ltd.