View Full Version : MySQL
- 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
- New Row Insertion
- how to dynamically build select statements in a stored procedure?
- Schema Desig for Private Message System
- Which design should I use - depth or breadth?
- Com_select differance
- how to set a time to repeat a trigger in mysql
- How should i design a database?
- best structure for DB
- Selecting split period of date and time
- GUI tool to create relationship between tables
- Prepared statement error help.
- sort dynamically using a link to add SortBy=Code etc to a URL.
- How to split string with delimiter ?
- how to combine two or more remote databases in one system database
- Problem with Left outer join among tables in hibernate
- all 3 fields as one primary key...
- float decimal problem
- Store Proc return no value
- Complicated SELECT from multiple tables
- Query too slow on select with order on large table
- or problem
- Query with DateTime, "empty" time-values
- How to do this SELECT statement
- Truncated incorrect INTEGER value
- long table or many tables?
- detect if db table exists by php
- Deleting records matching a list in another table
- Cannot shutdown MySql even with SHUTDOWN privilege
- Problem with querying many-to-many tables; possible subquery issue
- different between NO ACTION i RESTRICT
- Using "load data infile" command with network drive
- error in retriving data from the database
- How to backup and restore MySql database
- Text file SQL DB to csv format
- search from field seperate with comma
- import a csv file into multiple mysql tables
- Performance problem with "in" operator
- Transaction isolation
- dates problem
- Select/Update selection problem
- Share data between two tables ?
- Update problem
- semi monthly
- date range -60 to the future
- check and repair all tables
- Tricky query
- Synchronizing DBs
- How to get the .ddl file of an open source?
- modify or change primary key??
- error 2003 cant connect to mysql server
- Mysql 4: Invalid database name
- Database structure / userdata with attributes
- Refer to the view field from another table
- "SHOW KEYS FROM" - can I get the source table name?
- have_innodb=NO
- Problem while restoring Backup files
- Selecting "date before" multiple dates
- why mysql is free
- Help with syntax is MySQL
- about trasactions and stored procedures in MySql
- ( 3000 - 3300 ) = large numbers
- MySQL Time Difference BUG
- Nested Set model - Get child node with parent
- Updating connection string
- Database Design
- question on replication
vBulletin® v3.8.6, Copyright ©2000-2012, Jelsoft Enterprises Ltd.