• In Access 2000 When i open a form, that has 9000 records, it will only load the first ten, how do I make it load all records in?
• How would I create the syntax for this query? select foobar like '%brown, charley%', If you actually search "charley brown"? When the db is reversed?
• How can I show values in a varchar which are greater than or = ?
• mysql server is down each time i use ORDER BY in a query - an idea ? Thank You
• what is the best way for n-way replication?
• How can I load binary data as a blob using Perl
• I'm new to MySQL, where should I start?
• Is Select Case Implemented for the Win32 Shareware version?
• How can I direct the results of a query to a user's computer not the server (outfile)?
• How can I use a shell script to make sure Mysql server is alive and restart it if it is not running?
• How can a many-to-many relation be realized; what are the data supply sql-syntaxes (especially for the connection-table)?
• How do I store a variable number of values in a field? Let's say I have "clubs" and between 1 and 500 unique member ID's per "club"?
• How do I allow a user to create his/her own databases?
• What connection string should be used for connecting to MySQL on Win32 without a DSN?
• How do I create a relationship between two tables?
• how to move/copy huge MySql DB to another server? Thanx all
• How can I make MySQL user friendly, what program can I use as an Interface?
• how can i select the records where the First Letter is 'D' from the database?
• How can i List all the Records that begin with 'D'?
• Imagine 2 tables:t1(id int autoinc)(data:1,2,3...),t2(id int)(1,2,2,1,1...) Need query to get t1.id & count(t2.id)where t1.id=t2.id. t2.id CAN BE NUL!
• How to Recover deleted records?
• What is a Knowledge base
• Does MySQL support "SELECT...INTERSECT..." statement? If not, what are my other options in order to implement the same function?
• I had to re-install mysql, how do I restore a large myswl databse so that mysql recognizes it?
• How to copy the contents of one database to another database(locally)
• What do you mean by - Warning: Supplied argument is not a valid MySQL result resource and how do you solve it?
• How to change the password of an user xyz if I have the MySQL root access?
• How does table relationships work exactly? I need to use more than one table but they must be joined.
• How do I populate a pulldown menu with data from a mysql table? I'm using Perl & javascript (no PHP
• How do i set up foreign key constraints in MySQL?
• How can I check if a table in MySQL database already exists?
• How do I converyt MS Access databases to work with mySQL
• How do I copy a record to another record while only incrementing the id # with php and mysql?
• how can I transfer data from MS Access tio a mySQL database
• How do I delete a table from a database?
• How can i make mysql send a copy of all data to a backup database in realtime?
• calculating vaules in rows ...
• how do i join 3 tables where one of them a map table the other 2 contain actoual data?
• How can i transfer a database from my computer at home to the one at work ?
• how can i select random rows from a table?
• When using UPDATE where var = case , how can I make Mysql INSERT this row if it does not exist yet?
• I'd like to run a text file that contains sql commans after I'm already inside mysql
• Select statement to join tables?
• Q: May i know the short comings of MySQL over MSSQL.
• Q: Can i use stored procedures, foreign keys and triggers.
• Does mysql have a rowid that is similar to oracle's rowid
• How can I UPDATE table set field=value where field2 in (select field3 from other_table)?
• Redhat Linux 7.2 error "can't connect to local mysql server through socket '/var/lib/mysql/mysql.soc
• I need to match the max (date) value in the first table to the same date in the second table
• How do I find out the username and password of a database?
• Formatting SQL queries
• How to change the password of an user xyz if I have the MySQL root access?
• How can I update more than one record at a time? i.e record 1, 5, 9 Thanks
• Storing HTML tags in MySQL data
• Maybe there are ways to create MS Access applications with direct access to MySQL server? (no odbc)
• I am new to MYSQL where can I learn more ?thanks
• how can i search a desired data in MYSql database using PHP and HTML form? Give an example please.
• I want to delete a record from the database which is not been processed from last 48 hours. URGENT
• How can I display entries from two tables on one page
• what are the differences between GROUP BY and ORDER BY...the manual is not clear on this
• What is wrong with this: "SELECT * FROM mytable WHERE p_price BETWEEN '$MxPrice' AND '$MnPrice'" ??
• mySQL Service fails to start on .NetServer
• How to programmatically (PHP) import a delimited text file into a MySQL database?
• does mysql support foreign keys
• how to connect mysql through javascript
• Merge MySQL's data into Acrobat forms, no programming required?
• Auto-email/fax MySQL's data, including html-based emails
• Listing Databases
• How can I do a parameterized query in mySQL?
• Where can you get most recent and complete conversion of MySQL manual to HTML Help (.chm)?
• Is there something to convert Oracle sql code to MySQL sql code?
• does connection.rollback work even after setting auto commit as false
• How to calculate the running total of a table
• How can I get a running total from three columns in a table? The sum of price - mycost * units_sold
• How do I limit the amount of text that comes out of my 'Description' column to 440 characters?
• link:, so that when a database error happens I can display the error within a std layout
• I need to update field2 data with information from field1. How would I structure a statement.
• Is there some way to find a certain value that could be in any column in a table ?
• how to insert more than one item with INSERT INTO
• How to create customer database/invoice system (rookie). Any templates?
• Database: Relational: MySql: Configuration: Which are the configuration files of MySql?
• Database: MySql: Backup: How to backup your MySql databases on Microsoft Windows? [mysqldump.exe]
• Database: Relational: MySql: Link: Overview: Can you give an overview of links?
• Database: MySql: Microsoft Windows How to stop MySql server from the command line? [mysqld-nt.exe]
• How do I find the last insert id for an autoincrement field?
• How can display only limited records in a pge ,where the result from a select query?
• Database: MySql: Command: File: Source: Read: How to: How to read commands from a file? [batch]
• Database: MySql: Operation: Replace: How to replace a MySql database with other MySql database?
• Database: MySql: Table: Split: How possibly divide 1 large table in smaller subtables? [foreign key]
• Database: MySql: Database: Copy: Microsoft: Windows: How to quickly copy a MySql database?
• Database: MySql: Command: Multiple: Execute: How to: How to run commands by copy/paste in MySql?
• Database: MySql: Command: Multiple: Execute: How to: How to run pipe commands in MySql?
• Database: MySql: Command: Multiple: Execute: How to execute multiple commands at once in MySql?
• Database: Relational: MySql: Error 1136 (21S01): Column count doesn't match value count at row 1
• Database: MySql: Error: 1216: (23000): Cannot add or update fails: a foreign key constraint fails
• How to handle the Continue Varaible --Problem Of Cursor inside a Cursor
• Database: MySql: Microsoft Windows How to start MySql server from the command line? [mysqld-nt.exe]
• Database: MySql: Operation: Check: Test: How to test your MySql server (locally)?

Unanswered Questions

• Has anyone seen a median aggregate function for MySQL (specifically for Win32 port)?
• How should I kept the mysql data results in a bash ?
• not compile mysql
• unable to create table or amend fields
• How do I mirror a MySQL database?
• How can I add a new column with data to a table with an indexed column?
• when I run my sql script I get "1163 the used table type doesn't support BLOB/TEXT columns, what do I do?
• I want to allow MySQL to accept an article into its database using Korean characters, how can I do this? All I'm getting is jibberish!
• How can I increase the speed of MySQL on a Sun E250 with 2 400mHz procs and 2 gigs of memory? What's the best configuration/memory settings and tweak
• Newbe sorry: How to get my ISP's MySQL to create databases for my site?or ftp upload my .sql files?
• How do I connect to two databases at the same time?
• How do I detect a change in the modified times in an image and then automatically update my databas
• How do I Mirror my Mysql database ?
• If I want to export data and table how replication can do it for me?
• what are the files called "server_name-bin.XXX" found in the database directory ?
• Does mysql have a rowid that is similar to oracle's rowid
• How could i make a web submission form to submit an image to a mysql BLOB cell?
• When the MySQL Server starts on my laptop, the CPU usage stays at >90%. Any thoughts on lowering it
• MySQLgui cant connect to server, Then Again Nothing can. Any Help?
• How do you back up a DB that has binary data in a blob?
• Forms help??
• What can you do about write replication in mysql when the master goes down?
• Can anyone tell me how to store HTML tags in MySQL data and then use this formatting on JSPs?
• I cannot start mysqld. Have got Suse Linux 8. Have run mysql_install_db. Tried safe_mysqld --user=
• Maybe there are ways to create MS Access applications with direct access to MySQL server? (no odbc)
• Double insert isue
• error 2003
• can't get table to INSERT from PHP script. mysql> INSERT works fine
• Host 'x' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts'...
• Why do negative integers (BIGINT) sometimes show up positive through ODBC?
• when importing the table structure info dqlphi 5 (ado) from mysql,I have wrong types. String<-->Memo
• How do I calculate a field with data from two tables? Update code please. Tnx
• At present i am having Ms-Access Database i want to transfer my data from Access to MySql . how can
• syntax for UPDATE table1 Set ... IN (select Table2 where xxx) does someone know how,?
• How can I use hyperlinks in my db?? (How do they appear in my browser?)
• How do I fix this error: Warning: Supplied argument is not a valid MySQL result resource
• What is the best way to copy Table1 from database1 to Table2 in database2
• how to define a relation in a super/subtype relationship
• im new to mysql. i want to set up a db driven website on "angelfire"'s web server. examples please..
• Why after I start MySQL server in my PC running win98 my internet explorer stops working?
• Auto Increment / Access 2000 verse mySQL
• How to set numbers of field in a table (I want to set 30 fileds in one table)
• mysqld listen on 3306 / mysqladmin <ip> status works / mysqladmin <ip>:3306 works not - why?
• How do I make it so a user that logs into phpmyadmin cannot see other DB's on the sql server?
• Have you tried merging MySQL's data directly into Acrobat forms?
• Exists any programm, which can generate forms like forms from access for mysql??
• Can you configure a field for milliseconds? eg. hh:mm:ss:xxx
• How do I update production tables from development tables without trashing the table data?
• How do I get a list of all of the user databases in a multi-user mysql environment?
• Autofill Acrobat forms with mySQL data, auto-email/fax, use PF-Merge before?
• How can you auto fill a new primary key with data using mysql syntax?
• Is there something to convert Oracle sql code to MySQL sql code?
• Is there something to convert the syntax between Oracle and MySQL code?
• how can i get a mysql database table on to my pc through ftp in linux environment
• How do I change or create an new location(path) to a MySQL database?
• When i rename the record, Errcode:13 will display on screen. How to solve it on MySQL+Windows 2000
• ./configure not found,While instaling on sco unixware7.1.3
• What are some tips if i'm replicating db's and the master and slave connect but don't exchange data
• How do I limit the amount of text that comes out of my 'Description' column to 440 characters?
• How can I get mysql to 'refresh' the database list?
• Is there any method of converting sqlserver databases to Mysql database
• In mysql-4.0; create view test_image(image_id) as select image_id from image; gives error syntax???
• I need to submit unique multiple updates in one statement. What is the best way to do this?
• In MySQLadmin, the notice "not found, driver version 3.51" - what are the implications?
• In MySQLadmin, the notice "not found, myodbc3.dll" - what are the implications?
• i have mysql error host 10.0.0.22
• how can mysql server inform my client application that update or insert are made on table?
• Fix for "Error message file has too few error messages"?
• Can MySQL use an Apache servlet instead of its own server? If so, how?
• Due to a shortage of space, is it possible to 'repair' a table onto a different drive?
• I want to build a lyrics website using php and mysql . So i want to know how to update the site and
• Can I use 2 not between clauses using AND operator ? If yes how?
• How can I transfer Mysql databases(using PHP) in Linux to Microsoft Excel
• How do I regularly exchange data from an Access database to a MySQL database at a remote location?
• how to make a english - polish dictionary database and a search form in perl
• i have table with answers and a table with question how to link them
• Can I use multiple tablespaces with mysql if table type is innodb
• How can I select from one table based on a field in another table
• How can I add a MYSYL-Userfolder programmatically??
• How to add a mysqlUserFolder with a dtml-method?
• How do I get a list of all db's through the shell commands?
• Can we use stored procedures and triggers qith MySQL? Any issue with that?
• Can we use stored procedures and triggers in MySQL? Any issue with that?
• how to understand the current working database in MYSQL?
• How to query MySQL data dictionary tables, to get full definition of tables, columns, and constraint
• how to join 2 tables so when query 1 table extracts data from other table?
• mysql server self restart question
• what difference between sqlserver & oracle?
• Is it possible to connect two different databases in single program?
• have 3 tables 1 table i need the min - 2nd i need the MAX and 3rd everything all have jobnum field
• help plz! How can format columns overlapping?
• how do I change the server banner
• How to delete the binary logs pertaining to a particular database?
• Is there an alternative to query "reset master" to be able to delete logs of only one database
• Two tables a & b has same field 'x'. when 'x' is updatd in 'a' ,then field 'x' should updte in 'b'
• how can i copy table from one database to other locally
• i know to use tables from mutliple database at differnt location in acess but tell me how in mysql
• Storing images in database
• Want to store pictures away from the database
• Want to store pictures away from the database but rename them after the primary key. How?
• i want to display the record of past 3 months from database
• How we can find the load on mysql server?
• how can i make between nubers in sql . say i have these two numbers ( 12) - (18)
• How do I make sure that duplicate information doesn't get entered into a specific table in a databas
• I got a database with 1000+ links. Is there a script/code to check the links of my database ?
• How to write a query that will sum column but higher lvl?
• I need a record count of text (various single words) from 1 field, then displayed as a number
• how I can handle parameterized cursor in MySQL like oracle parameterized cursor ?
• how to use mysql 5.0 store procedures with vb
• error "IPB WARNING result set not freed"
• How can I get mysql to 'refresh' the database list?
• Can I get a field to automatically run a procedure or function, to hold a running total?
• Is it possible to transfer data from one table to other whenever the server restarts in mysql.
• Which command allows you to view all procedures and functions in MySql 5 +
• How to move specific data in col1 into another table
• How to move specific data in col1 into another table
• How to move specific data in col1 into another table
• How can I take the Backup of whole databse that is kept on Remote location at a time using PHP?
• Connecting to more Database
• Connecting to more Database
• Help with internal structure of .MYD file ??
• Insert query in the aspx page is not working in remote databases
• how to convert a sql script to a database
• how to convert a sql script to a database
• how to delete the same set of records from the database
• i want to output the fieldvalues of a cursor query to indexed php variables, could not google a samp
• How do I update a field in a record with the sum of 2 other fields in the same record.
• How do I update a field in a record with the sum of 2 other fields in the same record.
• How do I update a field in a record with the sum of 2 other fields in the same record.
• how to write the php script to enter dropdown,radio(in html) to enter the data in mysql table??????
• How can I embed MySQL Server into my C#.NET Applications?