View Full Version : MySQL
- insert data for every friday
- Changing field names
- Query for a specific amount of time...
- Criteria in left join
- foreign key clarification plz.
- Sleeping processes
- Joining NON-Related Tables
- Calculate votes and ORDER BY DESC
- Please explain Inner Join, Left Join and Right Join
- JOIN Broken
- Using LIKE to search
- Boosting SQL
- varchar
- Convert Access DB to MySQL DB, is it possible?
- How to overwrite table data?
- Table Join Invalid Query
- Select from not working...
- JOIN - 3 tables
- Storing and using images
- Calculating and displating voting results
- Encoding MySQL Database
- Select all and some
- Decrypt a total table
- Trouble creating table
- collation when creating new table.
- editing and amendment of DB or its tables.
- Stored Quieries / Procedures and relationships
- Releasing resources
- Display Random Urls on Web page
- does PK field type have to be same as FK filed type?
- Selecting unique values from a table (NOT DISTINCT!)
- Quick Query Fix.
- Selecting record from multiple computers
- join 4 tables in query
- Starting and stopping MySQL
- Query Multiple Levels Deep
- "Unable to save result set" Error
- table structure question
- How to find duplicates in two columns and count for each row found
- I'm new to MySql......how do I?
- MySQL query
- I am trying to enter the program mysql but I keep getting the error
- My query is throwing an error
- MYSQL Sorting
- instert multiple records
- Tricky Join
- Return a count of number of rows before desired row.
- Several Queires on A Single Page
- help with complex query
- Field consolidation [ was: Row Consolidation]
- import an excel sheet in mysql
- Can't get SQL right
- Creating a simple form that displays field output
- Can anyone tell me what I have done wrong in the short MySQL command?
- Optimizing MySQL for a new server setup
- Ordering with GROUP BY
- Populate DB from a PHP script
- Relationships
- Changing data in a table
- MYSQL Sum() Join Group By
- Inner Join help
- displaying result by querying first 3 letters
- Group By and Order by Help
- query problems
- Confused about tinyint,medint,bigint...
- datestamp on records?
- query vs logic speed
- how to create relationship between tables whwn unvoidable redundancy is there?
- Displaying picture from a mysql table
- Database Design Question
- need help in update query
- InnoDB vs MYISAM for mysqli functions
- Whats wrong with this query?
- Get Next and Previous Records
- i... uh... deleted the root user...
- SELECT WHERE any field is blank?
- INSERT not working...
- sustaining tables relationships
- execute an SQL doc
- Alter Table!
- Calling a variable from a different php file
- Quick Question, how to make ON DUPLICATE KEY ---DO Nothing---?
- WAMP server settings changed
- ERROR 1364 (HY000): Field 'DateIn' doesn't have a default value
- MySQL server has gone away
- Error trying to grab a news post from phpBB
- PHP MySQL Statistics Algorithm
- Sql problem
- MySQL Quit with PHP 5
- Syntax Error????
- question about querying in two tables.
- help please, returing data from two tables
- automatic updates
- sum() in SQL
- PHP Upload MySQL server has gone away
- query from 3 table in one (3 in 1) ?
- innoDb -v- MyISAM question
- how to use a dictionary table twice as a ref for 2 diff columns in a join?
- Linking HTML to a mysql data source
- multiple SUM queries - nested?
- Help in refining the sql query
- How many queries script used?
- num_rows issue
- Listing results by first creating category header, then displaying subcat results.
- How bad is it for a script that uses lots of queries?
- mysql_connect is failing
- flat files....
- select * from
- Nested query?
- SQL archive news statement
- Quick Question : Checking against multiple columns
- Mysql Query help
- phpbb with mysql
- UPDATE record & upload image
- printing table from mysql to lpd on linux box
- Need help in qriting mysql query
- Multiple COUNTs Against A Single Table
- Poorly performing update queries
- measuring query times
- help with left join query
- SQL errors
- table structure question
- Need help optimizing FIND_IN_SET()
- MySQL database structure?
- mysql/php help with form [was: Noob question =(]
- query not working if nil results
- Not sure to use filer or sort
- Questions regarding Primary Key/Design
- could multiple calling of mysql_fetch_array possible?
- Connect to MySQL
- Creation of a CMS with PHP & mySQL
- Detecting high CPU usage queries
- PMA Colossal Blunder
- data from two tables
- stored PROCEDURE problem
- importing txt file to table
- Ordering SQL Query Results
- Help in Truncating string column in Sql
- Retrieving last auto-increment
- MySQL in PHP Dreamweaver
- Help in displaying records in Single row.
- PHP/MYSQL problem!
- Dedicated MySQL Server... Very Slow
- How Much Load Can MySQL Handle?
- select all fields of specific row in multirow result
- MySQL JOIN - List Items Under Categories
- MySQL column value as percentage
- Fulltext searches
- How to design a movie-cinemas database?
- mysql error and not quite sure why
- Alternative to tons of selects from diff tables to populate many <SELECT> elements?
- Difference between ascii_bin and ascii_general_ci
- insert new rows with qty values from existing rows
- To make an advanced search...
- Incorrect Integer Value Error
- Change table type to MyISAM
- Ignoring blank fields
- The art of printing Mysql columns
- Really slow UPDATE IGNORE with innodb
- complex query - joining to self
- Joining 2 tables
- Connector for Microsoft Access?
- Conducting a search with MySQL
- how to best connect the data
- how to use nested query to get different names
- COUNT warning error I can't understand
- stumped by a JOIN...plz assist.
- Change date/time stamp in mysql
- Getting Error on Date_Add using Variables
- MYSQL - Removing Duplicated Rows
- Get strange record in Group by & order by
- Help wrapping my head around joins
- Refresher required! Easy question. How to pull information from the MySQL DB!?
- SQL Syntax question
- People Realy Simple Sql Question
- Whats wrong with my syntax?
- MYSQL - Date and Months query? And VB
- referring to count in output [was: Count ME in!!?]
- upload files
- daylight saving and CONVERT_TZ
- $user IN (table.Assigned)
- Please Help Check My Answers!. SQL Noob
- Rows and Total
- What Chars Do I have To Worry About
- error!! help me insert into
- Importing data into new tables
- Simple SQL bug
- Is there a website that offers schema for different types of tables
- Join from 2 dbs
- WHERE - 2 cases
- Problem in Sql..
- I can't seem to find my.ini anywhere in the /mysql/ directory
- mySQL question
- mysql weight
- Running a modify SQL command, When a INSERT is done on a Table
- Deleting a "test databse"
- Need more help with news system
- Import Sql file into PhpMyAdmin
- Limit Query to 1st occurrence of a value
- On what port is MySQL running?
- problem with mediumblob
- Avoiding Inline MySQL With PHP?
- Importing new data into empty fields of an existing table
- insert in 2 tables
- sorting by a column with letters and numbers
- Sum, Union and balancing accounts
- Is this a good table setup (just started)
- Help:How can I load this text file into MySQL?
- what is wrong with that line?
- next id on auto increment field
- phpMyAdmin - #1044 - Access denied for user, used GRANT ALL PRIV...
- upgrade to MySQL 5.1.7 to use RENAME DATABASE
- can not lock
- I want to design a MySQL table to hold 2 columns, News CMS
- Web-based Chat
- help with my php/mysql search
- SQL sub query and ORDER BY problem
- Is it possible to select multiple entries from one column?
- syntax error in the query
- Return longtext losing line breaks etc php html
- Can you call an sp from another sp?
- how to read composite values in tables
- New, Confused, and A couple of questions
- fill a table with dates in pure SQL
- LOCK TABLES issues
- MySQL query strange order results
- cannot create table in phpMyAdmin
- Best file type to use
- sql procedure?
- You have an error in your SQL syntax??
- blob size
- How I add to a dadabase table field [eg 1st row 4 th col] an entry [image or url] ?
- setting MYSQL rules
- How to make social network table
- How to do Bulk delete of records?
- Ordering in queries by sequence of elements in "IN"
- Insert/Update error
- Sql Synt Prob
- Can't make select statement with default value
- tools to see visual structure of a MySQL database
- Restrict # characters from field
- Need Dummies guide to mysql field structure
- Query Optimization help
- count??
- 60 Gb of mp4 files in MySQL database
- How to add X minutes, myql way
- SQL Query Random
- Order
- Constant table corruption.
- what files are need from the /mysql/data folder??
vBulletin® v3.8.2, Copyright ©2000-2009, Jelsoft Enterprises Ltd.