View Full Version : MySQL
- Solved! - help with hebrew in mysql!
- mysql_fetch_array(): supplied argument is not a valid MySQL result resource
- Error 2002: Cant Connect To Local MySQL Server Through Socket
- how to subtract values from two tables
- what is the difference between ""and ''?
- mysql statment help
- formatting Localtime()
- ODBC or DDE Link help
- performance vs many records
- Need to retrieve donor information AND total donations given for date range
- my sql query do not like me!
- #1044 - Access denied for user 'cruisew'@'localhost' to database 'emailer'
- Table in My SQL
- Query puzzle...
- Incorrect time value: '' for column
- Two Questions
- How to make this efficient?
- I learned something today...
- REGEXP range of characters [a-d]
- Reset indexes?
- query help
- How query results[SELECT] appear in tabular form,using an image with source fromFIELD
- help with a query
- Newbie question - WHERE statements
- Table Structure Advice
- update 5.0 to 5.1 or 6.0 ???
- Query help for an SQL challenged designer
- Weird Error Code
- unexpected T_CONSTANT_ENCAPSED_STRING
- updating table with data
- One to Many
- Server vs Client version
- Problem with ON clause in MySQL 5
- Questions when reviewing code
- About how to use the cursor
- Music Database Design help
- Compare and get result from two tables
- what to do to copy[triple] a table['land' to 'villas' to 'apts'] in phpmyadmin
- SQL Timestamp Problem
- Few questions about MySql server login
- timestamping or alternative.
- Help finding mysql error
- Special order by
- must setup my mysql script connect to db and get prices only once[homepage] ?
- is better use a SET FIELD data type or use two records and no set field ?
- PHP md5 not same as mysql md5 password-whats wrong?
- how to make a unique key 1 again?
- Update a cell
- what does OPTIMIZE do
- regexp and greek characters
- below html/mysql syntax is correct: building links from php vars ?
- Reset column autoindex?
- I have a table at phpMyadmin and an excel file I want to upload/import the data to t
- relationship question
- Union - different values
- Problem with multiple JOINS to the same table
- PK field not null is being null
- Linux (Fedora) MySQL trouble
- What the below differ : resultset,view,...
- joining two tables to get value of unique ID
- vbulletin mysql table
- results outputs too many times
- Is this possible without subqueries?
- serialized or table
- Concat maybe?
- Php not adding to table and no error
- Relationship Databases
- MySql Administrator rules :)
- Error Poll Checking DB for IPs Finding when there ant any
- Matching data accross 5 tables
- #1216 - Cannot add or update a child row:
- is it possible to have multiple values to the same column?
- displaying certain amount of data
- search results not what they should be
- When to close sql connection
- MySQL: How I make a copy of an existing table in phpMyAdmin or SQL ?
- Security question for user permissions
- changing table set up to ONUPDATE CASCADE
- trying to read from table and merge results
- MySQL collation for text?
- is this php/mysql sub query correct ?
- Updating give unexpected math results
- Joining tables, with a condition for wich table to use
- Cron job to restart MySQL on crash?
- Problem accessing floating point data from table...
- MySQL COUNT & Return
- creating Table help please
- how to do this select sql
- How to move a thread without losing the history?
- adding/removing data to db -- new at php
- support authentication protocol upgrade
- Basic MySQL Questions..
- Blog Tagging
- Can this query be improved ?
- All my queries are like this, can you improve?
- search a field for different words, not as a phrase
- help finding dupes in MySQL 5 query
- Getting the last record
- images in database
- Multi part question about SQL Strings
- efficient SELECT from multiple tables with same formatting?
- In MySQL administrator is there a way to backup directly to my local database
- SQL Subselect
- SQL Statement in Access Syntax Error
- Insert problems..
- When a new item is added I need to make sure that the ItemID is correct in each table
- Remove or add auto_increment functionality
- how to separate first names from last names in a single column
- Is it possible to choose the position of a new column in the following statement
- site stats table structure.(silly question-deleted)
- Getting what I need out of a query...
- When I copy create statement to clipboard I get different create statment for table
- WHERE `user` = " . $user . "
- Delete using multiple table: works on 4.1.20, but not on 4.0.16
- What alter statement do I use to change the length of a smallint column?
- I am so happy about this
- MYSQL IF statement
- Dynamic queries
- Can't work out how to normalise these tables properly.
- Display only results that start with one letter
- WHERE `id` = '" . $array . "'
- ID's added in database, but nothing else
- How to convert an mdb to sql?
- Create Procedure error
- Storing numbers in 3 Digit format
- How to find out the latest 5 discussions?
- which of these two table structures would you recommend
- innoDb table count incorrect??
- Query for more that x occurrences?
- help me
- Can't find what is wrong with query
- MySql normilization help
- id number help
- PhpMyAdmin - can't find "Priveledges" pg.
- LAST_INSERT_ID question.
- Where is my password field ?
- Having difficulty opening database
- any way to find rows matching this pattern?
- MySql Auto increment
- How many children..
- trying to create a top ten members list who have posted the most.
- Simple Question about an Add Content Script
- SQL GROUP'ing entries by column but need most recent entry in GROUP displayed
- What to do with a dmp.gz file ?
- images/links do not work. URLs get from mysql database
- mysql comma issue
- can someone suggest about session
- Advice on Table Setup to Maximize Efficiency
- Fulltext indexes with min length 2
- near far
- Restoring table to table
- give a suggestion about trigger in database
- Adding up fields automatically in a mySQL database
- adding 1 year to all times
- Basic Install Script
- Incrementing table name
- stored procedure help
- SELECT problem using GROUP BY
- Retrieving Fields with a null value
- Excel -> MySql?
- MySQL Error: No database selected
- How would I handle a query with multiple rows
- Narrow Search Results by Zip Code
- mysql query fails due to a ' in data.
- does this method increase mySQL queries?
- protecting my code againsts injection?
- some questions
- Make one field always show the sum of other fields?
- Select Distinct help...
- 2 websites using 1 database question..
- Can I optimise this query?
- deleting smilar record
- Help with my query idea
- Subselects
- How to optimize this query?
- Problem updating database from form
- Command Line tool to run SQL statements?
- used mysql_real_escape_string() but now when i echo the string i get \ in the text !
- Fixing Charsets in MySQL
- MySQL/PHP script bugged - if you know the fix I will let you see the script
- Help connecting to Mysql with IIS6
- MYSQL fulltext search - searching for 3 character words
- query failure - second pair of eyes required.
- Query empty error
- I have a column that I can't seem to change:
- Can I change all databases, tables and row's collation with php?
- inserting data when it shouldn't [solved]
- Selecting rows which contain a particular string?
- insert query needs your help.[solved]
- query is not working
- SQL join help needed (again!)
- perl last insert id troubles
- Image name isn't posting to database
- trying to select values from column and count each different one
- How to display time and date properly on query
- Simple Query help?
- ASP and escaping special characters
- adodb - selecting multiple ids via IN ( ... )
- Connecting mysql tables together
- Sum 2 Fields from 2 table
- CMS help
- simple SQL question
- help me to settle this problem
- sql add at the same time delete
- PHP MYSQL form help!
- Count () sql how to use it?
- get information from sql database
- group table
- Can somebody tell me what wrong ?
- Selecting (in a sub query) the latest row
- UNION issue
- SQL Set Minus with literal list
- Cannot get a sub query to work
- Mysql PHP program not running!
- Best SQL To Use For Search
- Select all data that falls on an hour?
- how to do this with fewer queries
- need to renumber a set of rows efficiently....
- mysql search problem
- table design & query problems ??
- not quite sure where to start or go
- loop mysql query
- joins
- MySQL Join - Need help with my first join.
- insertion - value corrupting?
- problem to insert value.
- Manipulating multi table data to flat file
- Deleting Form 2 Tables
- order of fields in innoDb table.
- Search linking
- to copy content
- MS access, vb help
- SQL Injection Protection
- INSERT INTO table not working for me, not sure why...
- INSERT of variable containing ' not working
- confirmation plz, that this is how to ONUPDATE CASCADE
- Find best matches
- Synchronizing Schema changes
- DB restore problem
- Table row limit
- Get Contents of Single Cell
- Last Insert ID
- whats wrong with this query ??
- Swopping columns in the database
- Checking to see if a user exists.
- How to drop primary key on INNODB
- Accessing comments for each field
- Simple SQL error
- Weirdest ever I've ever gotten.
- performance in select query
vBulletin® v3.8.2, Copyright ©2000-2009, Jelsoft Enterprises Ltd.