View Full Version : MySQL
- Is this valid mysql?
- Big MySQL Problem!
- Simplify Inner Join
- Is it possilbe to simplify this code?
- need help with in and not in
- Help joining queries
- PHP MySQL Guestbook
- mySQL syntax
- Generate Standings Based on Results Table in MYSQL DB
- generating scripts for MySql data tables
- Skipping ID Numbers?
- Trigger problem please help
- 0.0172 sec in phpmyadmin profiling but many slow queries with more than 2 seconds!
- Joining 2 tables and ordering by time
- Insert array values into MySQL
- Should I use an unconfirmed and a confirmed booking table
- Duplicate Entry - If Statement
- Generating INSERT Script for MySql database from exsisting tables
- from_unixtime() out of control
- Echo Query so I can See What it is saying
- Non-normalized approach for online forum DB?
- Converting .CSV to MySql database
- Creating a database of events..
- How to Reduce Table_locks_waited?
- need help with error
- Problem with Security when inserting HTML/javascript code into MYSQL table fields
- data retreiving time?
- PHP/SQL Question.
- php quary help
- Using PHP/MYSQL to generate
- Best way to handle TAGS in blog posts
- how to UPDATE correctly
- How to use explain to optimize your queries?
- PHP Where and EOF
- Getting all dates after today from existing table
- sort one column DESC and second column DESC
- Sql injection test tool
- Null = 63?
- select values before a date
- Unique Data Names Question
- Update one table from another
- Converting MyISAM to INNODB in MySql
- searching mysql with php
- mysql_real_escape_string question
- help with count() and group by
- SQL equivalent for MySQL "LIMIT"?...
- Resetting the Default Time Zone
- Getting values that a between a time
- Row from database
- How would I join two fields in one db table ?
- Sql
- Database Design Help/Suggestions
- mysql match query escape '-'
- Problem connecting mysql to localhost
- MySQL result set problem
- unique id
- MySQL speed questions...
- Uploading a table
- help building sql query to get only the next immediate result
- show results on next row
- MySQL dynamic content help
- Auto-Increment Value as a string
- Restore a Backup from .SQL file
- Worth indexing every column?
- Random Link
- TIME_FORMAT Issues
- Advanced Sorting (Procedure?)
- one table in 2 sql statements
- Mysql PHP Two Table Tree or Nested Results
- Get column names with SHOW COLUMNS
- passing column name to stored procedure
- maximum fields?
- MySQL Connector/J and JDBC Type 4 Compatibility
- How does MySQL differ from others?
- Ampersand problem
- Get you teeth into this one...Rev 2
- phpMyAdmin ignoring foreign keys?
- help for constructing query
- Days remaining
- Last Record Updated (Resolved)
- MySQL compared to PostgreSQL and others
- Cubecart linkage
- query takes too much time with inner join
- Issue with MySQL, Warning: mysql_fetch_array(): supplied argument is not a valid MySQ
- Turning I\'m hurt to I'm hurt
- adding a blank first line to select statement
- Null, Not Null and Optimization
- Assistance needed with a left join
- cant select into my db,dont know where error, help me plz
- delete record in db,help me T__T
- Logic Check
- How to insert date in table, help me please.
- Can this be improved, as its slow.
- datetime type in table, how to calculate it, help me
- Backup won't run according to the schedule
- MySQL Database Major Error, overwritten database with one entry. Help!!
- MySQL connection problem
- Finding max uninterrupted integer value
- Slow query, profiling shows nothing
- how to get innoDB in mysql ?? help me please
- finding and deleting rows query
- Newbie... Updating error
- Resolved PHP Numbers
- Resolved Id numbers
- Date between question
- Find if a table contains something
- Getting data from another table
- mySQL - if...else condition help....
- Resolved HTML inside of a mySQL Query
- Reset autoincrement field
- Extracting weekly data from table
- can not retreive data from table
- Inserting data into mysql?
- Auto increament VarChar
- getting rows from specific date
- mysql to array
- Help - Error #1064- You have an error in your SQL syntax
- get mysql column but not duplicates
- Defensive Programming
- Required Sr. MySQL DBA & Instructor, India
- Merging User Databases
- getting the number of rows based on condition
- record (unknown num) checked checkboxes values in php/mysql, how ?
- MySQL: Fetch nearest date
- getting row counts from tables
- Finding records with \ in them
- Help! Quotation mark being added after echo'd number field
- Delete ALL parents children?
- getting the number of signups per week
- could not insert data into database
- Storing prices that adjust with inflation
- Decoding MD5 and SHA1 on PHP
- Indexing of tables/fields
- Serious database error?
- mysql_fetch_array() warning
- Quick query question..
- Data too long for a column? Help?
- Query troubleshooting
- How to mysql show active products from many categories
- how long should an email column be?
- Inserting without duplicating
- Filter by month day date regardless of year
- How should I use multiple LEFT JOIN?
- how to correctly store text in MySQL
- Complex SQL Query issues
- Error
- finding the most recent auto_incremented number
- duplicate key violation
- safe injection for testing?
- Importing Access Database to MySQL
- access frontend to mysql backend
- Stuck with basic php/sql form
- split record and insert both halves to two cols
- query browser - editing join query recordset
- Renaming a column without modifying its properties?
- sql help!
- MySQL: How To use mysqldump pratically
- Auto Delete after X time
- select query problem with LIKE OPERATOR in MYSQL
- Cursor Issue
- advice required for storage of files in sql db (blobs) - 1 table or many?
- Resolved sql syntax question, selecting from multiple tables
- Read/Update table in one hosting account from another hosting account.
- ordering the results
- Resolved Having trouble with Select Where statement. Maybe data type is wrong?
- how to select a chapter of records which have keywords
- Image swap 1 large 4 small
- reading from xls sheets into Mysql DB via www
- Apache WebServer and MySQL - Not working. :'(
- selecting the last record with "where"?
- IFNULL taking time
- When in phpmyadmin a table field is type TIMESTAMP
- Help with PHP and MySQL
- use MySQL with Borland C++
- Complex MySQL Query For a Newbie
- how to replace duplicate entries without a primary key
- Weird error, can't figure it out...
- IFNULL by col
- use C++ and MySQL
- User authentication problems (PHP & MySql)
- Accessing the same column twice in a query
- MySQL + Dropdown lists -
- Duplicate structure of MySQL DB only
- Valide float numbers in MySQL
- Some general questions on saving "Group subscription"
- MySQL on my home server
- Help! extracting records meeting specific string length
- Skip Duplicate Entries
- Better to use PHP's time() or MySQL's NOW() to track user activity?
- mysql query request
- How to Export Results of a SQL querie?
- String filter in Where clause
- cant upload ~1mb ++
- To display the "date of last reply" of a set of threads
- Exporting a PDF into a MySQL?
- LEFT OUTER JOIN help
- impex problem , help please
- Create Database
- Resetting An Auto Increment ID key
- Mysql condition - replace NULL with 'NA'
- Weird Characters, Am I Doing This Right?
- help with weird query
- Can someone confirm this MySQL design please?
- How to enforce a certain constraint within a table creation?
- converting from Access to MySQL in asp pages. error messages
- Creating DDL files
- ini/conf settings for medium blobs???
- Problem with a constraint?
- mysql LIKE and _ how?
- Moving Hosts - Mysqyl
- Testing SQL Statements
- List Fields and Apply Links
- Undefined index error
- how to get rid of squares in the table
- Advice required with database
- base url problem
- mysql views and many queries(select) do the same job ?
- MySQL: NULL and ''
- Newby Question
- Images with Databases
- Use of triggers
- On duplicate key update , where
- List records in the same table if they share similar data in a field.
- schedule backup
- count number of posts of each member in mysql
- How to get the number of tables in MySQL db?
- help with mysql query
- displaying images???
- Tricky Query?
- Resolved PHP Database Manage Script
- Retrieving records that differ by one field?
- pivot table - rotate data
- Resolved Assign MySQL Field Value to Variable?
- How to check an record appears many times in a table ?
- Is Prepare statements good practice?
- Second query fails to return data
- Resolved Doing Maths in query?
- Resolved Different Table Structures
- Resolved Foreign Keys
- Reading information from one table to another
- SQL Query: Same table join?
- Simple INSERT query error... What is wrong.
- A Blog Category Table
- Insert values from Mysql to Excel
- Using Distinct help needed.
- Resolved deleting stuff
- selecting a table name based on a subquery?
- Resolved GROUP_CONCAT to more than one column?
- Crap.. what is ssh??
- How to insert into DATE fields other than default way?
vBulletin® v3.8.2, Copyright ©2000-2009, Jelsoft Enterprises Ltd.