View Full Version : MySQL
- begginer question how to make raw unique
- PHP SQL Newsletter Subscribe / Unsubscribe
- mysql_real_escape_string() Question
- Resolved need help asap
- backing up MySQL database to a network drive
- Is there a database I can upload?
- mySQL Duplicate Entry Error
- Any way to improve this slow query?
- Resolved How do I interpret error message?
- begginer question about sql query
- Insert Random Words Into Column
- pulling my hair out
- Tricky query !? Merge three tables!
- COUNT(table.col) problem
- Text Area with sql format issues
- Mysql_error mail system admin
- querying table based on date
- need help on mysql statement..
- Multiple row selects with single query
- Problem with creating table which includes foreign key??? Errn150
- Problem with special characters.
- mysql :: strict string compare
- Design and query feedback please - thanks
- find out how many visitors for a website
- Resolved SQL/PHP Variable...
- creating a table on a different account
- +1 to a row
- Can't pull out last 24 hour added articles after transfer
- is n't a repeat region, why some js buttons do not work 2ND & 6TH - any criteria ?
- Problem inserting into MySQL
- how to get rows from x to y with inner join
- how to refer to a virtual table created by sub-query in other sub-query?
- Copy from Table 1 to Table 2
- need a query
- delete duplicate data
- combine help
- Searching a MySql database using 5 variables
- Resolved Frusturating: selecting all rows of 2 joined tables using * and telling results apart
- Resolved Multiple Table Query to Include Rows Missing from One Table?
- Re: help need to tweak this query...
- Date Format
- Probably an obvious question
- Update multiple rows?
- Retrieving a pdf
- pagination
- dumping query output
- How to join the 3 table?
- Get the value of the primary key?
- Resolved Adding data to a database via a PHP Form
- Adding +1 to mysql entrys.
- list entries by surname only if more than one exists in DB
- ordering query by COUNT
- Cycling through rows, smartly?
- Problem with Elgg Installation
- forum query
- Delete Multiple URLs from admin page
- Replace InTo VS Update
- subtracting two diff columns
- Finding an exact or best match
- Trying to limit date range of results
- Ignoring language accent
- Mysql query not pulling correct data
- i want to learn how to create a query where i use the IN and JOIN
- Query Help
- conditional ORDER BY?
- Remove special chars from field (calc field)
- While Looping Problem
- better way to do this in one go?
- slight tweak of my query to make it get the correct results ?
- problem with count
- change rows position in mysql
- Selecting last record for customer
- combining this into one query?
- help needed in my sql
- COUNT and GROUP BY help plz...
- Keeping databases in sync within a team
- Need help on WHERE clause
- Need help for Social Engine Script Installation
- Stumped on query
- Inefficient Table Creation / Insertion
- data to long for column/ LOAD DATA INFILE
- tweak of query, to correct a slight error in results.
- Listing mysql query
- how to create foreign key?
- upgrading mysql 4 to 5 known code differences
- data base task
- Selecting data from two tables
- Sql
- inner joints and relations ?
- what is the correct way to use AND & OR in query
- Decimal(m,d)
- Check for multiple values of a list
- count then using multiple HAVING not working
- Problem with query
- Resolved Sending $_POST variables to fuction
- creating user defined function in MySQL
- stored proc, delimites str
- which is better ?
- CONCAT_WS bug
- I have 2 problem to select this table,Please help
- Non-updateable column?
- My sql "not in" uses indexes?
- Dual Sorting Methods with MySQL
- $_POST['id'] - Help?
- Advice for multilingual site
- Full Text Search No Results
- query 3 tables
- help with creating who viewed members profile tables
- Join command question
- Removing duplicate entries in mysql table
- Adding up fields in Table
- update method not working for me
- Insert Into Problem
- 2 auto_increments? / entry ordering
- Is There A Way To Remove Similar Results From Query?
- Using multiple where cases???
- aggregate overlapping totals.
- Resolved Data Selection from 2 different tables
- 1st row, first col, 2nd row, 1st col...
- shift values
- Need help with Database Design
- Resolved How to retrieve newly-created value in auto_increment column?
- Safely updating database records
- Delete from multiple table?
- mysql concatenate error
- Retrieving duplicate names
- how to fill up the missing dates ??
- predefined values only
- Edit mysql row including blob
- like operator, '%' inside field value
- Help setting up MySQL Database
- Join Two Tables then conduct Order By
- Resolved Top 5 data from database
- stored procedure --> passing user variables to prepared statement
- Adding a time to each value entered
- SELECT statement and CONCAT
- perform SELECT, then UPDATE on same table
- Help! Access to MySql from a dedicated server
- plz help me with slight tweak to query, INNER JOIN's
- DATE format in SQL
- How to count how many days late?
- problems with LIMIT and specific row return
- Joining to the same table twice
- can not get all results using 'left join'
- Newbie - Problems connecting to Mysql
- Mysql inline query in same table(Urgent! Deadline tonight)
- Resolved opposite of DATE_FORMAT ?
- How to select value of two rows using separate PKs?
- Calculation
- is my mySQL setup correctly?!
- use results data via $results[fieldname]
- multiple small queries or a single multi-join query?
- SQL syntax error
- Get record from year XXXX
- counting categories in while loop
- database design help.
- newlines not showing up when info previously stored in DB is displayed on page
- preventing MySQL injections
- Help with a complex query
- query urgent help
- looking for free desktop sql editor
- phpmyadmin ASK
- SELECT then UPDATE in the same function
- What is the difference between these queries?
- Query Db
- question about phpmyadmin and sql
- Resolved count number of connections
- questions about creating tables
- tree data structure
- multiple sqls
- help with matching a var with a row...
- Deleting records with a datetime field value > 7 days old
- mysql_num_rows(): supplied argument is not a valid MySQL result resource
- (Easy enough) How to rename a mysql field
- MySQL and Quickbooks
- proper format for storing html
- Help with mysql insert!
- Problem with an insert
- remove query
- Is JOIN my solution?
- batch update?
- MYsql installation on windows
- Mysql Admin shows Different than PHPMYADMIN
- Help with joins?
- user id = user name
- Probably a very easy mysql question.
- Recreating a database
- check for unlinked posts in my forum tables.
- subtracting two Counts
- Problem in using LIKE clause
- is there a way to get whole numbers in mySQL?
- mysql_fetch_array problem
- Order By Field From Other Table
- list category titles for a forum
- pre prepared statements
- order by within group
- Multiple delete but value optional so not always there - Myisam
- Advanced ordering question
- How to refreshing a table every hour
- SQL help with Date please
- Selecting dates.
- Sybase and MySQL together
- About from_unixtime()
- Add up values from one table to another
- SELECT * FROM table WHERE previous_row.id = 3 ORDER BY ordering
- creating linked entries in separate tables?
- SMS to Email Query
- Resolved Trouble with LEFT JOINs for 3 tables
- does MySql have inserted or deleted
- Give error SQL syntax. Where is the problem ?
- if (record exists){tell me}else{insert} help plz
- SELECT more WHERE's
- Primary Column (Setting ID to increase automatically)
- Templates and Queues
- mysql stored procedure bug
- Resolved max_sp_recursion_depth ver 5.0.16-nt
- installed latest version --> could not start service
- mysql query browser status bar
- How to implement function for saving type, size and name for uploaded file
- SELECT contain 'this'
- Can I merge
- mb_substr similar function in mysql?
- importing to a remote host
- unable to get query to work correctly
- getting one day back mysql date
- Getting just 1 from a joined table
- dynamic sql, stored proc , latest version of MYSQL
- What can go wrong on getting data from SQL??
- User editable Profiles
- mySQL Views?
- Deleted Row
- Tracking non paying customers
- delete text from db table ?
- Resolved Date Format and Results
- trouble with mysql statement
- Trying to get my head around DB design.
- mysql administrator backup
- Uploading Image to SQL
- cant access the data from my query.
- How to get the Average time
- Get latest record from a group based on date
- MAX entrys
- adding a relation to a region:
- sql image upload?
- Select Last Record and Plus 1
- Problem in figuring out a query using subqueries
- MySql Row Select
- Checking for events based on date in mysql
- MySQL Time Difference BUG
- JOIN two tables and show results of a SUM()
vBulletin® v3.8.2, Copyright ©2000-2009, Jelsoft Enterprises Ltd.