View Full Version : MySQL
- Cross DB design
- Having Some Problem
- Having some trouble with Create Table
- Password()
- please tell me
- return transactions from supermarket
- Sync MS SQL 2005 to MySQL DB?
- Association table linking several tables
- Remove duplicate rows
- Hi There everybody
- Checking to see if date exists between two columns...
- key buffer big but key_write_request/key_write is too high
- VB.NET SQL Problem - Help please!
- MySQL newbie - help extracting data
- InnoDB: Error: page 28149 log sequence number 2 1012496415
- How to Ignore Where clause
- Need advise on how to structure a table for a certain task
- need help here
- Fetching the values using joins using 3 tables
- CREATE TABLE help (unnamed index???)
- How do I "create linked server"?
- How to use order by with group by for two tables?
- Count based on two different states for same field
- Hrms
- MySQL server date
- already have MySQL from working with tomcat server/localhost/JSP Well to install WAMP
- Setting performance options
- Trying to format data into rows so I can search it
- Where and How to Save at Mysql prompt
- Help with Group By Clause
- libmysqld and innodb
- MySQL Join Help
- Only want unique instances, but DISTINCT isn't working
- Adding row numbers help
- Forum Newbie Question
- 5 scripts accessing one table simultaneously without selecting same rows
- help with migrating data from one database to another
- Not saving current timestamp
- Empty set error
- MySQL brand newbie - replication help needed
- Urgent-help needed in choosing MySQL for hightraffic webportal
- ssh tunnel for mysql slow
- Help with designing
- Optimize MYSQL DB
- group by problem
- operator :=
- Load Data Local Infile - File not found (Errcode: 2)
- Unique index acrosss 2 tables
- Importing .csv into mysql
- SQL script failing error code 121
- Mysql Master-Master replication issue
- Question on MAX() and how it selects other fields that are returned
- looking for MySQL backup best practice
- reading a database and sorting.
- INSTEAD OF trigger
- How could i calculate the different between 2 timestamp
- group function error
- SQL Help
- filter product by attr
- Join on NULL Column values
- Help me get over this bump
- Create index
- [Mysql][ODBC 5.1 Driver]host couldn't connect to the Mysql Server
- how to generate a phantom read ??
- Logical problem with my Query
- Newbie with (prob. stupid) question.
- Help I need to create Database!!
- ACT extract
- Unique Id in mysql
- How to update column based on min value of another?
- Simple embedded database design for game
- MySQL stored procedure (PLZ solve my problem)
- Group and team leaders
- Should referenced table of FK be defined before referencing table
- Transform columns into rows
- MySQL Stored Procedure
- Calculate Working hours
- SQl data normalisaton
- Database speed
- Can't create a new thread
- Newbie help - UNION operator
- Storing content with html tags in db
- Integration of different database tables
- How to get a CSV string for column from all the rows matching a given criteria?
- Left Join not working after moving to 5.1
- TRIGGER with @variable
- no reaction to create table
- FOREIGN KEYs for starters
- Junction table & composite keys
- creating database
- Updating multiple database
- LEFT JOIN syntax error on upgrading to MySQL 5.1
- subquery result as select_expression ?
- Subquerry inside GROUP_CONCAT
- group by clause,mysql query on data
- Achieving Inheritance/super-sub classes in MySQL
- set mysql root password to password=""
- how to turn result rows from JOIN to result columns ?
- Branching between an Expression and IS NULL
- Data structure and Design help
- Rename variable in select statement?
- create table problems
- DISTINCT statement
- Newbie Problems (mostly syntax errors)
- need help with query please
- is any way execute these statements at once localhost?
- Concat inside Concat to call another procedure
- Requeriment logic with Composite Primary Keys
- About Signed/Unsigned Types
- Help needed with query
- Help with CASE
- How to pick out unique rows from query based on multiple columns.
- Query Help
- Delete last row on insertion of new row
- Deadlock for starter, simple scenario
- User defined procedures issues mysql 5.1
- Mirroring a table from one db to another
- Problem with Many-to-one relationship and Limits
- MYSQL sever
- Naming columns with numbers
- Query Months help
- Returning multiple MIN values of a field based upon different criteria
- How to make selection on a temporary created field
- return multiple rows
- Oracle to MYSQL conversion
- Help with SQL query (Calculate a ratio between two entitiess)Hi, I’m going to calcul
- re: Connecting MySQL DB to SAP DB
- Create table with partition key
- Add partition on exising table ?
- Lots of Joins: Speed Impact?
- not using mysql_real_escape_string(), problem?
- Help joining tables
- Example needed for mysql field setup
- How to create function ?
- Configure Matlab Database Toolbox, MySQL
- Charlength()
- Separating Fields
- MySQL does not see databases after upgrade
- How to install MySQL on window 7 ?
- How to select first and last row data ?
- More than one "many-to-many" relations...
- use UPDATE and SELECT statement together
- new to database
- How can you display SQL results inline?
- Sort records by Word Count
- Stored array into dropdown
- N records above/below the selected record.
- Automatic table create from text file
- Find Address containing postal code
- Geographically distributed MySQL Servers
- Sorting records in lower case
- Help me on SQL query for counting and display data
- Find values that are not in sequence
- Help finding Mixed case records
- Join/Union Two Tables (Articles and Videos)
- Reverse Operation for GROUP_CONCAT()?
- Mysql too many connection
- Query Help and finding the highest version number
- Query help with a duplicates mess
- inner join, empty set
- a very confusing query
- MySql Storage
- Group by range of hours
- Data Organization: 2 Business Cases
- performance of IN clause
- How to build mysql query for this?
- Joins need one little tweak that I can't figure out
- Anyone good with optimizing from explain?
- Foreign Key Constraint Error (inserting new field)
- Simple logic but clueless .........
- newbie question
- Related Items like Youtube's Related Videos
- Division of grouped items
- Querying Numbers from a Database
- Quick newbie question!
- How can I optimize this query to run faster?
- Cant workout this query for the life in me!
- MySql Replace
- file locations - output/dump
- could use some help on this advanced SQL.
- How do I setup proper logging in Windows
- triggered value by certain time
- Please help me on this mysql
- stored procedures
- Some questions
- Help with multi-select query
- Please help
- Online multiserver admin tool
- Optimizing a Query
- How to enable remot access to MySQL?
- the next step - more overview questions
- mysqldump import issue
- InnoDB & Foreign Key Constraints or MyISAM & Speed?
- multi level case in select failure
- Primary Key & Foreign Key Problem
- Hi everyone please i need little help
- db meshes and db
- Need to get records from first table
- Template For Articles Stored In DB - How do I get it out?
- loading comma delimited files
- using mysqldump and preserver view
- Table insertion not working...!!!
- Table diagram puzzle for user permissions
- MySQL connection issues during heavy load
- A little lost with this query
- write a right sql statement to get this job done
- What is the #1 pain point of MySQL users with database sizes of more than 200GB?
- Get count of distinct dates
- Date Time Standardisation
- database replication or backup
- which table needs to be repaired?
- Insert data into DB, return ID number
- Have I done it right
- Show only rows where there is a full match
- How to store something like Facebook Groups in DB?
- How to import/export an existing MySQL database using neatbeans?
- Why mysql creates an index for one foreign key and ignores the other?
- Writing data to 2 Databases with 1 form
- Very Basic Question
- Help with err 10055 when connecting to MySQL
- Data Integrity Issue
- Short Login Names
- query help
- Need help with sorting by MAX average!
- Newbie Question
- getting an adjacency model table selected into rows?
- How to Index and Fasten This Slow Query?
- compact framework 6.2.2.0
- Twitter style followees feed subscriptions
- Simple moving avg (SMA)
- prob:connection to database
- Could not start service MySQL - reinstall
- Resetting MySQL Password - Newbie w/a problem
- Making a car-filter - An advanced query you'll never figure out :S
- Multiple sorts... totally lost
- Search for an incomplete word
- How do I simulate 'auto_increment' on a non-primary key field
- MySQL & ASP // Password()
- Cross Join
- need to 'order by' date, but also 'order by' and integer field
- convert ms sql query to mysql
- insert is slower when DataFile size increases
- JOINing 2 colums of one table to 1 column of another
- Select 'A and B' records first, then 'A or B' records
- C++ & MySQL++ & MySQL API
- User Login, check fields from multiple tables
- Find Matches Between Partial Names
- MySQL MATCH returns no relevance score
- Execute shell script through stored procedure
- Prepared Statement with IN() Clause
vBulletin® v3.8.6, Copyright ©2000-2012, Jelsoft Enterprises Ltd.