View Full Version : MySQL
- Prepared Statement with IN() Clause
- NOT BETWEEN with UNIXTIME field?
- Rapidly Growing Database
- Database design help
- Inserting a File into a table
- Help me build a database
- Query Help
- Dual HAVING on AS
- Join 1 column from 1 table to another table
- MySQL SELECT distinct & group by
- create database gui
- multi user
- Major SQL Problems
- How to write the record number on a separate field
- How to join multiple results into one result
- not inserting in field properly
- duplicate unique key on same column
- Best approach to relating databases or tables?
- Data truncation?
- User in multiple categories
- Query Problem
- cannot establish a connection
- Transaction within a procedure not working
- How to Save Session UserName in a table using mysql...
- How to query the datetime field in MySQL
- Can anyone find me a data model i can use for my coursework?
- total number records
- very urgent: need help with Database
- Grant_priv
- SQL and MySQL comunication
- Need help with database structure
- Search engine help
- Ways to store audit trail
- Tricky SELECT Statement
- How to take backup of a database for a particlar time frame
- using innodb engine for my database
- Load Data
- erased data from MySQL table still populating a Google Map?
- Advanced algorithm of an existing MySQL query
- Design Question
- How can you export stored procedures to a file?
- Multiple Foreign Keys to Multiple references
- problem with using aggregate functions
- Filtering query
- Unreliable innodb transaction
- database design help
- Newbie with fresh install errors.
- Select order
- Mysql high cpu consume
- Reverse a Condition
- Many to Many Challenge
- challenging query
- How to do a JOIN with multiple tables
- Desktop App: Keep connection open or not?
- update table recursively
- How to sort the search result order by most relevancy?
- join 2 columns of a table with a column from another table
- MySQL settings for large queries
- Should i use recursion?
- xml/json returned from query/procedure
- SQL problem: updating a table's columns with other table's row's data
- Complicated select
- Date issues
- Migrate Informix database to MySQL
- NULL Problem
- Category table recurssion
- MySQL Stored Procedures : Use a variable as the database name in a cursor declaration
- Load into file \ character problem
- Index for single table query with group by/order by
- Problem adding a udf function to mysql server
- How to write the repeat of the users with same ID
- Count the number of items for a query
- Help with Sakila
- Trying to search for a word in a field
- Is it possible to write a loop to insert?
- ID update with various tables in a database
- mysql / odbc driver / excel
- Does a procedure return a boolean value?
- i want EXEC sp_xml_preparedocument same function in mysql
- I have createstore procedure in mysql i got error on convert function
- Embedded SQL Problem
- Return Dates in a Range
- Transaction wont Rollback in SP
- autoincrement column is odd numbers
- Query help. newest distinct rows.
- count of two values in a joined table?
- Select all years between two years
- How can i find last occurence of a substring in string?
- Please correct this Query
- Source command Question
- UNIQUE or PRIMARY
- Create trigger
- PHP form to query DB for ANY entry
- MySQL sets Foreign key references in lower case
- Capacity of Database?
- high load averages caused by mysql
- Setting causing browser lockups?
- REGEX Pattern
- mysql.sock problem
- Multiple Date Range Rates
- What Server/Application Do I use?
- cout() issue
- Pls help me! How to make this SQL query?
- Noobie question about NAS server
- Problems importing .csv
- How to script out all database objects?
- Dates
- Logs I should always check for health
- Needs your help, both of following sql syntax produce same result in MySql
- Mysql Order
- Count number of matching entries in separate Table with one query?
- Left Join returning a Syntax Error
- MySQL restarts few times a day
- cannot create a new database
- Count(count(count()))
- How to Write Complex Join Query
- Monitor index usage
- Using SQL Manager Lite anyone?
- Looking for books
- Structure Question/Issue
- ETL Opinions
- Performing Foreign Key Checks
- easiest way to convert Access DB into SQL?
- mysql database design question
- Can connect to database with Dreamweaver, but not with MySQL Query Browser
- select query help...
- Malformed Packet Error When Calling LOAD DATA LOCAL INFILE
- Searching for international characters
- Issue with read queries not being directed to slaves in MMM configuration
- mysqlimport
- Aggregate of a Aggregate producing strange results
- Problems in my WHERE clause :(
- Join Query
- how to setup db like facebook
- Newbie query question
- duplicate ids not returned
- $20 via paypal if you can solve this. (probably easy)
- Database inheritance - not sure if i'm doing it correctly?
- an html table field "telephone" eg 46799999666, appear it 4.678E09
- How To get Hierarchal Data like cte in MSsql server
- SELECT FOUND_ROWS() not Working
- 1064 error, please help
- select certain rows
- COUNT times 2!
- Problem with php/mysql
- Select if else
- how do i use multiple lines with SET @var =
- Triggers and Stored Procedures in MySQL
- How do we create MySQL Stored Function or Procedure from Java JDBC Library?
- Database Question
- Group supression
- code help
- Enabling Network Connections?
- Slow queries.. Cant think of a solution
- Questions!!!questions!!!questions!!!!
- Password? mysqldump?
- Help with Null Box
- Need a Query Help
- Lot of small queries or a Large 1
- Error
- Stored Procedure Caching and Performance comparison of 2 stored Procedures
- Help regarding query optimization
- InnoDB Buffer Pool Size limited by linux kernel?
- mysqldump: Got error: 1045 when run from batch file
- search text ignoring tags in it
- MySQL case sensitive?
- Get column names according to condition
- Mysql server configuration for 1 GB RAM
- Kichoos
- displaying mysql_fetch_array data in a html table
- DataBase = Web Page
- How to correctly use ON CASCADE DELETE?
- how reset autoincrement field ?
- If I reinstall MySQL for the bundle AMPP then needs reinstall and the ODBC DRIVER etc
- Internal/External DB
- Table Partitioning
- mysql and btrieve
- MySQL free or not?
- MySQL View
- LIMIT improves query performance?
- Fatel Error
- need help with a shop
- Find string occurrences
- small help in MySQL
- Help me finding a db schema or sourceforge project
- Batch Insert Issue with Mysql
- select a rounded float field
- please anyone help me to using subqueries in mysql
- How to connect to MySQL database protected by SSH
- ODBC Connection error
- Select a field if mathes to 2 or more criteria
- SQL authentication protocol
- var and varchar
- Simple Query Help
- Link mySQL db to content
- Help with complex inner join
- Help collating multiple records from multiple tables into a single record
- Error Loading Text File into Table
- Automatic Backup of SQL Database
- MAX() in WHERE clause
- Query Help
- db redesign - too many tables
- What are the other Database operations apart from CRUD?
- Database Design For Forum
- mySQL Query Probleme
- find seconds ago on multi row query
- need to select articles that share common tags & vise versa
- Foreign key contraints
- Database Desing -- Help Needed!
- Insert Query Returns False
- Alias Question
- Problems with this design?
- Baby Steps, Visual Studio 2008 connect to MySQL
- MySQL:Is any error with this query
- simple query code with if statement
- Auto Incrementing Blank Rows
- Active time.
- mySQL master Slave configuration
- referencing a lookup table twice in the same query
- Column Type for Shell Script
- query code problem.
- Stored Procedures Help please
- getting both rows in a many to many type database
- Finding a position based on SUM...
- Simple query optimization
- MySQL Transactions (RollBack,Commit) must involve particular Tables types, eg innoDB,
- Error 202 on Mac OS X 10.5.8
- Gui
- LIKE does not like!
- delete orphan records form database
- MySQL and WIndows Server 2003 Setting
- Database structure for CMS
- Export to SQL text using decimal 8,2
- Creating a Database driven site - help needed please
- Getting error when trying to execute sql script file
- Lots of questions about mysql
- Stored Procedures
- How to make a single row from many.
- Import data with different table names
- Connect to MySQL from outside of server
- mysql partitioning
- Group By Inventory
- Insert with Where Not Exists
- DBDesigner and FKindex?
- One row of table 'a' refer to many rows of table 'b'
- Error in mysql command - Cacti database
- In what Normal Form is this Table?
- Can connect to hosted mySQL, having trouble with local
- [HELP]vBulletin Config.php error[HELP]
- Silent Install and command prompt
vBulletin® v3.8.6, Copyright ©2000-2012, Jelsoft Enterprises Ltd.