View Full Version : MySQL
- hacker getting on to my stuff
- New to databases, do I even need a relational database?
- Sql query browser
- Fifo?
- Statement for inserting image as blob into Sql query browser
- A database with a memory
- I'm looking for the best way to join two tables based on the matching of the words in a varchar field in one table against a varchar field on another table
- Invalid use of group function
- DBI connect failed: Access denied for user
- Right outer join syntax for Hibernate with My Sql 5.1
- Comparing Time in conditional statement
- MYSQL Create Table Syntax
- reg: music file upload into db
- MYSQL + WP woes help appreciated.
- Self Referencing Foreign Key Struggle
- Problem with long insert/update query
- selective sum?
- SchemaQuwery dilemma (help!)
- Partition Question - 2 tables with one-to-many
- whats wrong with this?
- Multiple tag search
- compare 2 columns with wildcard
- Problem during migration from MS SQL to MySQL
- Complex Sum
- How to join many to many tables
- update a number -- can't figure it
- Joining two tables
- to maximum how much size we can use myisam tables
- How to set database variables in mysql++
- Fetch rows with timestamp within a week range
- How To Attain Sample Databases
- question about speed the process of displaying data in an application
- Case, Subquery, Greater than Comparison
- Help Writing "Friend Requests" Query
- sorting using html forms?
- MYSQL Create Table Syntax
- Partitioning - drop large partition
- backup works from command line but not from script
- Return zero if query returns nothing?
- mysql host with 3306 opened
- Newbie Question link from one record to another
- Using Inner join and Outer Join at a time
- selecting all the records that aren't a FK somewhere
- Update Stmt - Update same record multiple times
- rollback committed transactions
- Stored Procedure issue
- Join three tables
- Basics: how to create and access an embedded db with C#?
- Encrypting a column?
- ask ask the cost of license MySQL per server?
- how to select a unique couple from data???
- Connect to somones Database
- sql help needed
- Need help from MySql experts, UTF8 and gibberish problem.
- What is your opinion of ID keys created based on time/date/random numbers?
- A complicated query
- Default How to get Table schema information ?
- host says there is a fragmentation issue
- Parameter information of table.
- Replication topology
- Searching for User's Location
- Help Please. Trying to add 1 Year onto a Date.
- slow queries precisely every 30 seconds!
- Legacy data CD for SQL Reporting
- Using Distinct and SUM in query problem
- Complex time slot management
- Access Database from behind Firewall
- Trouble using sysdate in BETWEEN clause
- get the record position in query result
- question about query speed
- Out of Memory issue
- "SIN"tatic Prodecure
- How to insert the date and time into a data base while doing routine inserts.
- Remote connection to MySQL
- Using Sprocs all the time
- help with db
- Auto-populate text box in Form2 once data is pulled down from Form1
- tips to write good sql queries
- Update using OR InnoDB slow
- Options table JOIN
- Can Crystal Reports be used with MySQL?
- Table Crashed
- Allowing users/visitors to insert records into MySQL
- Recommended starting point?
- On Duplicate Key Delete
- copy, and insert row
- sql query question
- Installing MySQL
- Ordering with NULL values in a column
- linkin img with db
- How to query about all entries which occur less than n times
- Problem with DB Design
- Joining a table to itself, in reverse
- unlimited sub category levels
- Returning first row from a join
- Print data on mysql_table
- Need Assistance
- Default escape character in MySQL
- MySQL mass insert
- How to tune Mysql queries
- Connectivity Issue.
- Connectivity Issue.
- Group by date
- Response in same order as array?
- SQLPrimarykey in 64 bit gives wrong values in linux
- How do I make my db more relational?
- UPDATE post with limit of 15 in wordpress
- Can I combine these two update statements?
- Database backup script
- many to many, how far can I go with 1 query?
- help with full-text search
- IS there any MySQL Default tables like DUAL in ORACLE.
- Returning Top N elements
- 2 tables interacting with each other
- Significant Performance Difference Between Comparable Boxes
- Date formating
- stored procedure to entry the count of table
- Select problem - I am a newbie
- Tricky trigger question
- Question on changing an item
- getting to grips with UNION
- Display required records from same table
- Are queries queued?
- MySQL 5.0 or 6.0 ?
- inverting the recordset
- Query optimization + functions/procedure
- Instantly selecting then updating fields before other queries can query them
- Chage detection in MySQL.
- MySQL query analyzer
- umm.. a sort of anti-join?
- Query Select Like and replace/update
- Update from Select Count
- COUNT and SUM in the same query?
- List of records with count(*) in child table
- Complex Insert problems.
- Looking for a reliable MYSQL blog/news script for a review website
- Grouping inside sub-queary
- Split Values 12|3|43
- mysql: keyname and cardinality issues
- Large Table and Complex Query
- MySQL Heavy Uploads
- tricky duplicates
- Create index fails on existing table
- Pleses somebody help me...
- returning columns that don't have null/blank values?
- MySQL Cluster on Windows Server 2008 Enterprise
- MySQL/PHP Query and 'sprintf' issue
- help with phpmyadmin and mysql
- Problem connecting tables
- Average in query
- #1030 error
- Triggers Newbie
- Math in query
- Syntax incorrect
- How to install MySQL 5.1.34 to Windows 2008 Server ?
- linked server from MYSQL to SQL SERVER
- ...so ROLLBACK executes , this [the ROLLBACK] do NOT work...
- Select Into Query
- Multiple rows returned in OR query due to cartesian product
- Link to remote mySQL table from MS Access
- Error on case query
- Mysql version 3.23.58 supports the inner joined query and union query?
- Help with retrieving data...
- What does MySQL stand for?
- table in use
- SQL Date Query Problem
- select query to find the particular column in the database
- Seperating Groups - almost there
- Update tbl SET Case When Condition1 THEN Col1=1 When
- negative integer result = 18,446,744,073,709,549,568
- please help with query!
- how to query for words appearing in ONLY one doc
- Maintenance of Partitions in mysql5.1 table partitioning
- no result for 27 columns
- Selective Group By?
- retrieving document details with highest version among the documents of same name
- 2D Interaction storage
- mysql connection timed out
- Best Method for storing lots of user data?
- This year only
- Help with Uppercase query
- Clip data in query??
- How to get matching experience in all categegory with min query...
- Trigger Creation in MYSQL
- 3 seconds to run a select that returns empty set??
- Querying 3 tables at once..!
- MYSQL REGEXP REPLACE - Proving very difficult...
- select by rand()
- php mysql installation process
- Condition of display
- time going fast
- Condition of entry
- transaction in stored procedure
- Need a trigger for this scenerio
- mysql odbc connection not showing in utf-8
- May an .sql file viewed in excel ? restore a database from .sql file can be done ?
- Can Anybody speed this query up?
- A recordset that returns two columns as one
- MySQL Stored Procedure Resources for Newbie
- .frm files or .sql files??
- How to change MySQL root password
- could not start window service MySQL5.error:0
- Hi There Can You Tell Me
- could not start service.error:0
- RAM requirements
- Problem with user name
- one-to-one table
- constraint naming schemes
- errno 121 problems
- Do we need to index foreign keys?
- changing foreign key name
- While Loop Within A Stored Procedure
- more than 1 to many relationship
- can't make count(*) work :(
- Trying to Learn it RIGHT
- Synchronize tables utility
- Cursor Related Issue
- Why my application got slow when operates over the network?
- order of tables in DDL statement
- Help me! big problem with dynamic SQL
- Sorting results, starting at 2 or 3, then loop until finished. =\
- less than or equal to (<=) query problem
- Select/Grouping Question: Select where the recent of a group of rows equals xx
- auto_increment syntax
- looking for recommendation on character set
- Suggestion for Query Optimization
- n00b install question (mysqld or -debug)
- MySQL foreign key info
- Working time between two datetimes
- Partitioning - stable...?
- Web based data viewer?
- mysql if statement evaluating int data type 0 to false?
- could this code make a load??
- New to Databases (Wanting to learn)
- Error from error_log
- Incorrect information in file './testdb/testemp.frm'
- syntax question on creating index
- Triggers stop update and insert
- Data Type Conversion
- n00b questions on basic DDL
- sql migration problems
- Unable to create user after MySQL 5 upgrade
- UNIQUE KEY vs KEY
- Looping through distinct records...
- Date stored in Char(11)
- Problem With Null Values Using Least Statement
- How do I move the records of a column of Table1 to Table2 by creating the column
- mysql - table updation
- join 2 results but not in rows
- Database Design
vBulletin® v3.8.6, Copyright ©2000-2012, Jelsoft Enterprises Ltd.