View Full Version : MySQL
- Speculative attempt to access PhpMyAdmin
- SELECT WHERE ColumnA+ColumnB LIKE '$q%'
- pagination page code error
- PHP MySQL Form Data not actually posting
- Advice Please : Speed up this query
- Stumped on an SQL error...
- Sorting into categories
- Using joined table question
- Disallow users to chagne their MySQL Password
- MD5 encryption
- trigger question
- Trying to insert multiple rows from array
- Bash script for multi-db backup
- what am i doing wrong
- how to make a cell a default NULL again?
- Resolved Query For Summing Values For Each Day
- How do you sort Alphabetically but put 'Other' last?
- Query comes up empty but...
- Resolved Do Queries speed depend on size of table or on the number of rows to be selected
- Get the highest ID from a table
- banner script
- Grab Table Name When Using A Union
- Can I do something different - Displaying records
- Help with some small mysql questions
- mySQL query problem
- thread and processes - difference?
- Displaying from mysql table accoring to id and another column
- Help: How to automatic optimize table db
- Can you take part of a mysql table name and use it in a link?
- Bad Data Import, Invisible Characters, Can't Select Data Specifically
- Msql Search form loses values on next page
- html tags changed to < and > when saved to database...
- Resolved Get data from DB using WHERE
- Deleting a mysql row - proper syntax?
- Automatic database updation based on files in a directory?
- Resolved Migrating data- collation/charset issues...
- Foreign Keys, PHPMyadmin, Innodb, establishing relationship
- Creating VIEW in MySQL Version prior to 5.x
- Sort ASC where UPPERCASE = lowercase
- Insert Into command help
- Deleting Duplicate Rows
- Migrating MySQL Database from Local to Remote Server
- to divide into defined number
- Select a row, check if a column has the value, count the checks.
- restart fetching array
- Mysql REGEXP with range
- Is it possible to put IF/ELSE in SELECT query
- Comment Box System: How To
- Resolved Any way to combine these simple queries?
- is there an error log
- Resolved cursor reuse
- Displaying latest entries only for all categories
- Selecting 2 fields in a query, but one must be distinct?
- MySql View 'SELECT contains a subquery'
- MYSQL Select statment Where something equals a or b?
- Resolved Delete row based on two fields
- DataBase profiler
- Resolved Get 2 database tables assign to one output
- Update database script
- utf "\ufffd\ufffd"
- call stored proc from function - sql err
- Mysql error
- Verifying blog comments
- mysql using .asp "I'm a newbie...be gentle"
- Unserializing Issue in MySQL
- Problem with copying one field to anouther
- +1 Every Second
- mySQL Query using a result as a variable.....help plz!
- Need help to make random videos from db
- Copying a row, but changing a value
- Any Wordpress pros around here?
- Getting distinct column values into multiple separate columns
- Is it possible to have sub-tables?
- group by and order by
- really silly newbie question!
- Storing sensitive information
- While using fetchrow_array()
- sql query question
- Multiple joins
- Create a dynamic exact search query in a stored procedure
- insert column in mysql table
- MYSQL Min by Group and Distinct
- how to make a qraphical format of a database so i can see all tables on one page
- Curdate problem
- Insert into error
- im totally confused
- if statement, fetch rows
- More Duplication
- find all entries starting with 'userid:' from a table
- list entries in reverse order not by field content
- SQL query help
- Resolved Delete duplicates from a table
- sleep ?
- Need to get hostname (NOT LOCALHOST)
- Got a question
- how to copy entries to and from the same table
- Delete Row from list.
- Adding column to table
- Delete member from databse
- Displaying number of times an entry repeats in a column
- Trouble forming MYSQL query properly
- count all member posts for each member
- stuck on a case statement internally providing the order by command
- Can someone explain the purpose of the relational database model?
- on duplicate key update, no ''
- Help with query
- Update one table from two others
- mysql update from another table
- Auto MySQL database backup
- Script not inserting into DB
- Displaying DB Results Vertical
- key dead end
- MYSQL bug ?
- Multiple $_POST won't INSERT INTO Database
- condition inside where
- Populating Database using GZipped File present on Web Server
- Uh Oh.. - PhypMyAdmin Backup Issue?
- Move to Linux server, now getting errors
- Query using loop: Subtract value between 2 lines
- PHP variables inside mySQL stmt
- MySQL Full-Text Searching on an Encoded Field
- Delete duplicates from a row
- Ordered Relevant FullText Search Results Using Boolean Mode
- First, Second, and Third Normal
- <h2> if mysql value is 1 problem
- MYSQL average
- Object tabs in mysql
- how to design a database?
- Please help with deleting "every other row" in mysql table
- [Request] Make a database to a game [mafiagame]
- how do i remotely access mysql ?
- two variables with same value bind_param mysqli statement
- List of values -- db design
- not a valid MySQL result
- A problem with md5
- How to call user defined function of mysql through PHP
- how to make this database?
- does this table fit the 1nf
- how to make this table fit 1nF
- best practice addslashes? column length
- headache multiple tables
- problem with desc limit 1") got me baffled
- Problem sending "selected" to database
- sql datetime
- MySQL IF Help!
- Uploading a CSV file via a webpage
- A question about the multi pages
- Resolved operators for 9<=x<=20
- Mysql data retrieving...How to?
- Line Breaks in Mysql
- Sql query help
- mySQL syntax error but can't see how
- Column count doesn't match value count at row 1
- How can I make an entry unique across tables?
- How to alter content of a field based on date
- How to store a youtube embed in mysql?
- why am I only getting a one time insert into my table?
- Send +1 to database only once per day
- Database Design
- While WHERE clause slows down GROUP BY?
- Timestamp
- password function
- Advice Needed - Displaying Members Table
- Paypal then update mysql db problem
- Record not more that 10 entries per user id
- Adding up dates between a range
- Rearrange in SQL
- How To Search By Date Where Date Format: 01-01-2001
- problem with binary data field
- Stored procedures or functions or...
- Fancy default value for datetime column
- return entiries only if the value of the field is more than '"2009-08-19"
- mysql query help
- show records based on date?
- how to ensure that fields do NOT belong to indexes?
- How To Count Rows In DB Where Cell Value = Duplicate?
- Case Sensitive
- Will Oracle discontinue MySQL?
- Trouble with a Join
- Advanced Searching
- Check if Column is set to 1 for a User
- Update, insert into statements don't work properly
- SQL Genius needed!
- vUsing LAST_INSERT_ID, mysql_insert_id() to create foreign keys
- Figuring out order
- Best Match Search on Foreign Keys
- What Would Be The Best SQL For A Referral Site?
- Creating New or Updating Table
- Would like help figuring out a query/if MySQL can/is supposed to do this
- Query to select last 3 records that meet a given condition..
- SELECT query misses something
- TRIGGER holding up a transaction
- how to find correct syntax
- Extracting Records Based on Date (Equal to or Greater then current date)
- Problem with inserting data if it contains “ symbol
- Access to MySQL help
- Read Data in HTML
- Solving MySQL Error 2006: MySQL Server Gone Away
- Numeric -25 + 25 = $7.1054273576E-15 when result should be 0?
- A question how to do
- MySQL equivalent to Oracle's "set echo on"
- how to delete the odd ids please???
- Database structure for blog
- how to delete rows by the id units number please ?
- Check if exists in another table
- Two different users one table
- Allow HTML into Database field
- Shipping Type Count
- Mysql Error When Trying After Ajax Load
- Resolved Deleting by IDs?
- very newbie question
- Working with timezones and DST
- Error in syntax
- How can i modify this query?
- Calculating ages from date of birth?
- Need a popup search in a form that gets submitted
- Order by matches
- JOIN problem; JOIN on NULL values...
- Getting non distinct rows based on enum value
- Complex query, maybe with REPLACE and REGEX functions?
- MySql SUM and GROUP query help
- Resolved Error: Column count doesn't match value count at row 1
- Display select option data fails
- Insert failing
- Resolved Cannot Connect to DB
- MySQL error (Microsoft VBScript runtime (0x800A01A8)
- wrong sorting order with UTF-8
- How safe is this?
- Resolved Constructing an equivalent query after normalization
- System cannot find the path specified
- Secure this code
- proper syntax to update || insert and then return current value
- Finding a most occuring value (HELP)
- Same datetime giving two different timestamps
- Adding contents to a field automatically
- Running Two Query Commands at Once?
- Showing SELECT results from newest to oldest
- User Registration
- Compare 2 columns, where one column is made of a substring of the other one
- How to limit the precision of computation results
- INSERT Help
- Export mysql to access (mdb) with php
- Greater Than or Equal To Doesnt Work
- what is the best way to search every column in a table for the same value
- Designing a Normalized Database
- how to create a syndication feed from other sites
- Help with PHP/MySQL Booking System
- How to empty a table?
- Fantasy football stats - Weird result when joining tables for
- Replace user ID with Name
vBulletin® v3.8.2, Copyright ©2000-2012, Jelsoft Enterprises Ltd.