Bytes - MySQL Database answers - Page 8

Please Help : upgrade to MySQL 5.0
compacting / data size
Executing Java methods from database
error importing old mysql db
new instance / installation problems
Why is this a SQL syntax error?
Subquery in Join Statement
Indexed single-col search capability from multi-col index
how to delete content of column?
Updating a JOINed recordset
Subquery returns more than 1 row - help
Need to combine 2 tables into 1 uniquely-rowed table - help
MySQL with utf-8 charset - problem with 'LOAD DATA'
MySQL & SQLDatasource
ASP.Net, MySQL, and dates
String Comparison (ORDER BY) with _ (underscore)
Load file errors
LOAD FILE access problem
mysql freezes on startup
Advice
mySQL and SSL on FreeBSD
Strange character ...
Using INSERT to write to a directory
problem in inserting unicode data in forms6i
Questions on replication?
MySQLdb slow on MySQL 5
Entering NULL from a form
Using OLEDB with MySQL
Cannot connect to MySQL using VB.NET 1.1
can't create new user in 4.1.18
city state database
The best DB strategy in my case
mysql tables
MySQL equivalent for MSSQL's DATENAME
Radio button help!
Touch a table
database file size
Inserting a list of names in a table using stored procedure
authentication to MySQL
query in a query
mysql will not start with LDAP
How-to multiple select
copying a mysql database
MySQL table intersections
Correct form to quote strings with (intentional) wildcards?
Trying to build mysql from source
Max of a column where ...
Dates Differences from Strings
MySQL and VS.NET
ASPNET user and MySQL
Problem accessing data with \ in it
Error 11 (can't unlock file) in different places for sp vs script
Java code or Pseudo Code for "Outer Join"
Same day last year problem
Any and All MySQL questions here?
Mysql basic help
checking "return type of sprintf"
Percent of Males and Females and Age distribution
mysql eating too much cpu
Why does GROUP_CONCAT() function fail in MySQL 4.1.12 in this query?
Distributed MySQL Clustering/Replication
cannot edit tables..user-del
incorrect SELECT results
Connect MySQL to SQL
Checking a field for NULL
MysqlDataTruncation and jdbcCompliantTruncation
mysql++ memory leak
Logparser 2.2 and mysql
how do I reset user "root" password ?
Loading a file into a TABLE
Record Size Calculation
upgrade probs to 5.0.18 - queries fail
Full update query
CONCAT all columns
mysql 5 functions
Basic Update query
regarding making connection to mysql from a C program on windows
MySql Cluster transaction Performance
Insert row
No Subject
InnoDB Weekly Backups
Excel -> MySQL ODBC data format problem
Creating an A to Z list from query
I want to make transfer data between MySQL Server to MySQL Local .
Alternate values
ORDER BY clause fails to do descending order on this field column
Linux Korn Shell 93 Connecting to a networked MySQL database.
Cannot connect to MySql server on Fedora linux
mod_auth_mysql or mysql usernames and passwords?
Help! Large table performance problem with MYSQL performance with ASP.NET
INSERT ... SELECT ... ON DUPLICATE KEY UPDATE not working for me.
Multiple queries in one script
Problems with getting the right data ?
Truncating all Tables in a particular Database.
Using Windows Authentication
MaxDB substring_index
Large table performance problem with MYSQL performance with ASP.NET
Is version 5.0.18 stable
Remote table in a database
Subquery help
Update problem
Error 1067 when starting as service, no problem in standalone
ODBC not connection to database
How to configure mySQL 5
MySQL Server stopping
Sort (ORDER BY) by a comma-separated adjoined string of related separated fields in MySQL 4.1?
bad query??
Code examples
Got error 134 when reading table
mhjh
"select into outfile " issue
Restoration from Tarball
how to get records from stored procedure using ASP
Access denied for user 'ODBC'@'localhost' (using password: NO)
SELECT statement with date expression
Developers needed for healthcare software
Offset to geometry field
unable to connect to mysql
MySQL 4.1.16 compile failure under Linux 2.6.12.2
Repeating replication error
Can you help with 'MySQL Query Browser'?
effects of innodb_locks_unsafe_for_binlog parameter
Many to many cross reference query
Date format
restoring data into mysql
UNION ALL GROUP BY
LIKE and IS NOT NULL
Select problem
Importing MySQL in MS Access
Display all databases
A simple thing!
MySQL consuming lots of memory during transactions w/ many statements
new db setup
Please Help - urgent request Pt II
Please help - urgent request - I need a query like below ASAP
Data recovery with just the MYD file
Escaping strings
Copying a table from one schema to another
DBDesigner 4 question
List of MySQL datatypes?
I am new to sql and stuck
New to SQL
Mysql RPM install on FC4
How to view catalog in MySQL
I need to move column field values from one database table to another database table
Strange JOIN query problem
MySql Replication and network speed
Accessing MySQL on Linux from Window
multi-column index, is it slow ?
Using TOP in mySQL v4.1
Search for entries starting with a non-letter?
update [table] select - but I only need part of the column field value to select
Can you import/export using MySQL Administrator?
Concatenating multiple rows to one field?
Getting Success or Failure Detection in Stored Procedure
moving mysql backup from Version 4.1.12 to 5.0.3
Packing needed for MySQL?
Really going crazy with NOT NULL
not null not taking
This is a reall simple SQL question
Plural Search
Where to start
help with SQL coding question - 3 tables with outer join needed
The ultimate migration nightmare - need help
unix_timestamp() & retrieving historical rate data
SHOW TABLES & SQL_CALC_FOUND_ROWS
Update query needed - on a "group by" query - Possible / How???
creating foreign fields
mySQL 5.0.18 and stored procedures
how to check for date/time ranges within record (check for schedule conflicts)
Best Topics Rating Using MySQL
Full text search min word length
What's Wrong
A begineer
Issue 5.0.18 and trigger
newbe ORDER BY question
Recovering deleted rows
Dumb Q about command line
PHP Script stores data in wrong MySQL columns
Fastest Way to Create a Replica
Problem installing mysql-administrator on Redhat
Debugging Stored Procedures
Update a table with values in another
Load Data Infile - edit a field
upgrading MySQL column type has no effect
Change access settings?
Optimizing query that spends a lot of time in 'statistics'
Returning most recent records?
i suck, but would like to do something complicated with 4.1
Ignoring query to other database
LIKE % Operator
new test server, is there ANY reason NOT to use 5.x?
Append a string to all the values in a column SQL
Append a string to all the values in a column SQL
BLOB Update failing on SQLParamData
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'
How do I do this query?
"Duplicate column name" error when adding column
can't install / uninstall MySQL
Full text not returning any results
enum type, sort, restrict, use
MySQL Databases
GURUS - VB6 - stored procedures
Navicat Frontend: Possible to accept keyboard input to set user variable?
Why does this insert fail?
MYSQL version differences
Order by and Count
Pls recommend one C++ wrapper for unixODBC/MyODBC api
Foreign key problem
selecting 3 images
Indexes
mysql and cron
Creating a hyperlink to a specific record
User Admin in mysql-administrator slow on Linux
transfer rows between servers.
MySQL Experts
MySQL Experts
MySQL Experts
MySQL Experts
MySQL Experts
MySQL Experts
MySQL Experts
stored procedure calling from perl
help needed with select statement from multiple tables
stored procedures
stored procedure calling from perl
Properly Re-starting replication process
problem with update using join
Stored procedures in MySql 5
problems with FILE priv granting
Replacing every £ with &pound?
Google style search
Replication using ssl rather than (telnet?)
database diagram program...
Search Term Not Passing to Output Form
TIMESTAMP : created & modified fields ?
problem with installation of mysql-administrator
Mysql syntax problem...
Connector/net causing 'Connection unexpectedly terminated'
update syntax for version 3.23.58
Syntax Problem?
view changes in mysql database
confused about certifications - site says nothing about 5.0 certificaiton but there's a book for it ??
Table design for school registration system
help with a select clause
Select one row from MySQL table
auto column
HELP! Crash at: in my_strcasecmp_8bit () from /usr/lib/libmyodbc3.so
ERROR 1044 and 1045
conditional join
mysql server web interface tools link
Updates invisible - windows only (Linux OK)
PHP MySql 4 table query
searching rows containig a substring fast
problem with 'mysql.sock' file
create a c++ based program using mysql odbc.
MySQLdb Python API: Unable to connect
Are some single character aliases not compatible with MySQL 5.0?
Avoiding the need to repeat clauses in MySQL
odd persistent view in tables ??
how to get data out of mysql
greatest value bounded above?
Creating ordered lists that ignore the word 'The' at the start of phrases
Slow query
ORDER BY - mix two fields
[Virus Found - Message Cleaned]
statement
join problem
How to make a select statement FROM A TABLE that has two INDEXES?
hosted mysql user access problem
Query is really slow
putting linux & MySQL on 6 year old box - hwo much RAM, Hard drive space do I need?
Need to automate adding a file to MySQL as it uploads to webserver!
varchar and unique
Where does mysql_config get its defaults from?
mysql back-up question - *.sql files?
i know this isn't the place for feature requests, but...
New to MySQL
I just want to know the differences :0)
Updating Column Descriptions (Comments)
Admin Error
upgrading from 4.1.12 to 5.0.1
SUM(DISTINCT) OF INNER JOIN
having count() trouble in a GROUP BY clause
The best Mysql report generator
Creating queries for one-to-many tables
Help me with group by query in MYSQL 3.x
MySql: does a database exist?
Thousands of academic software titles, 80% off, Instant Download
Non-stop queries coming from ??? XP, MySQL 5.0.15
Sounds like search for string in the database
problem with nested select...
Changing Tables from MyISAM to InnoDB... Cautions?
TIMESTAMP issues...
Query log parsing utility
"ERROR 1216: Cannot add or update a child row" but parent record exists
MySQL Client Side.
restoring a MySQL db
MySQL and ADO
Simply query of joined tables
update from select in same table
MySQL and MS Windows
Why does 'SELECT * FROM countries' truncate characters and 'SELECT country FROM countries' does not ?
How can I get MySQL data from an external hard drive
Problems trying to get MySQL to work from PHP script
URGENT FUND TRANSFER
Get A real College Degree Today!
database replication help needed
Software Compatibility
sales
About combining data in different mysql database
Which index to hit first?
Linux Server v/s Windows Server ( WebServer - LAMP v/s WAMP)
Optimistic locking?
Database design question
MySql Connector/NET Pooling
cannot restore 3.23.58 db to MySQL 4.0.22-debug
utf8_general_ci versus utf8_unicode_ci character set.
Account privilege requirements to execute CREATE DATABASE.
solutions for more connections to db
MySQL v5.0.3 -- Does this indicate v5.0.30 or v5.0.03 ?
MySQL Error Number 1064
accounting apps, use Decimal, Int, or Double ?
Using SELECT * truncates first characters.
PHP alternative for MySQL
Cyrillic web pages with Perl and MySQL
How to admin user in MySQL 5.0
Alternate Name / Nickname Table
Best Practice Mysql Tables
can not connect mysql from php
Help with SQL
order by and group by problem..
stupid order by and group by problem..
Database schema ideas
stop optimize table`?
MySQL queue/messaging
SET SQL_BIG_SELECTS=1
SET SQL_BIG_SELECTS=1
mysql in a startup/shutdown loop at 30 sec intervals
View with special effects for underlying table
Caching results for large multi-table select
Can not connect mysql from php
CREATE TABLE SELECT, ON DUPLICATE KEY UPDATE, and UNION
packing database
Optimizing help
Unixtime SQL Help
How to get rid of the buffer
dates and index cardinality
does "LOAD DATA" EVER work?!? I've tried EVERYTHING!
Speed comparison of SELECT statements
setting database pw
Strange error when trying to delete a row from MySQL via ODBC
Writing large chunks of binary data to MySQL with ODBC
permissions
DISTINCT with multiple columns?
finding if a table exists
LNK2001 Error Compiling MySQL++ library
install of v5, table types, features
Once a day MS SQL -> My SQL
Altering table structure in live database?
What looks like a basic SQL query still not resolved
bdb api
Tuning
(Message Subject)
How to add new collation for a utf-8?
new Error 1146 error and behavior with mysqlcc + mysql-5.0.15
Thinking of Access/jet to SQLServer or MySQL
CONCAT with IF
memory size exhausted error - Too much info back from query - what to do?
Help With Database Design: Multiple Vendor Data Submitting
count fields over multiple rows
I need help with selecting from 2 identical tables in 2 separate databases
database path
Is it normal for a query on a 90k record table to take 1+ seconds?
mySQL command questing.
Controlling output of mysqldump 10.9
Switching from Ms Access to MySql
trigger to run an external program
Adding GROUP BY empties the result set?
records from linked tables
syntax error - uggh
Going for a LARGE Table: Any Tips?
importing sql statements
mysql on linux-gui interface
Win XP software for 80 % 0ff
selecting distinct
Procedures to promote slave to master server?
Load Data - Succuess/Error information
Selecting a subset...
select statement with multiple value where
Adserver with mysql+apache
encrypted password problem
Interesting SQL query requirement for <SELECT> menu
Restricting Access to Tables
Keeping data sorted in a table
Atomicity problem / question
Large record count
Query Cache Not Working: MySQL 5 / Windows XP
Major diff between varchar of 70 against varchar of 100?
What args does WHERE take (wildcard question)?
How does a MySQL "AND" work? (sub-searches)?
Searching in mysql
replication error after promoting slave to master
TurboDbAdmin beta released, an AJAX solution for database administration
Error 4001????
Why Should I Create A Foreign Key?
Date Format
Query help
Subquery help
Deleting multiple rows that have the same field value.
mySQL NEWSGROUPS
distributing MySQL
Redundancy ?
Selecting from more than two tables
What is the fastest way to restore a mysqldumped table?
Privileges on specific fields in a DB
Saving storage space on blank entries in DB
converting field type in active database
How to get the number of each unique items?
Is KEY and INDEX the same thing?
Question on PhP, MySQL
Memory error
Replacing all entries with "Re:"
Problem with MySQL Big Database
Returning unique records
Copy data from other database prog to mysql. Is that posible???
Thousands of academic software titles, 80% off, Instant Download
Using BLOB for storing data
I want to create something like AMAZON: those who liked page A also liked page B
Self join to multiple references...
automatically filter records based on a userlogin name??
left join an sum
Pre-approved Application Tue, 25 Oct 2005 08:24:51 -0600
loading date strings as dates
Failed to Install & Starting MySQL-5.0.15 on RHEL3-U5.
NEED CONVERSION FOR "14:10:01.000 GMT Sat Oct 22 2005"
UTF8, ASP and MySQL Querybuilder stangeness
UPPER not doing anything inside stored proc
Get your degree without going to school
Getting Count(*) when using pseudo pivot tables...
Got passed up again?
Should I upgrade to Mysql 5?
You've Seen Them On TV...!
MYSQL Join help
Multiple LIKE comparison using IN operator
Help needed with slow query
RDBMS usage survey
Having problem getting group by to work with order by
UNIVERSITY
Beginner help with SELECT query
Mysql C prepared statement API sending incorrect data
over has no properties
User ID and Password for querying TextLink database
exporting tables with password fields
How to determine the size of a set of rows based on a where clause
0nline software, Download MS 2003, Systemworks & others Instantly
Multiple statements in single query batch
Best way to structure a table?
Getting around a restricted connection from an external computer
Query from multiple tables
query question
Sorting correctly...
group by and other columns
Running 4.1 and 5.0 simultaneously on linux
Inner Join sub select query help
Best way to delete data from operating db?
Is there any way i can improve upon the performance of this query
Mysql How to sum min max and get the date/time of the min max????
Difference in SQL Syntax between Access and MySQL (from VB6 project using ADO)
Server Log not logging all queries
Error Upgrading MySQL from 4 to 5
Bulk Insert of new records in sequence
Problem connecting to remote MySQL DB from VB6
Long queries priority
SELECT duplicates without looping
making a table with unique entries
Query Across DBs in MySQL
Update Notification
New AntiFraud System has been added to your account - Please update infos.
What back-end database should I use for this project ?
Creating an unique record id ??
Shell and Mysql
Combining two select queries into one ?!?
Complex select
MySQL variables, modifying Microsoft SQL sequence insert for use in mysql
index clarification
Help: Join Performance, Not Recognizing Index
Problem with the unicode signs
"Warnings" count when using mysqlimport
Behilfliche Teilzeitposition. (Ref:075)
Connection problem
insert ignore
How to UPDATE from a linked table
Mysql optimization
Counting rows assigned to index value?
Restrict selecting from a table
Partially updating records based on pattern match
Error Connection MySql
Alternatives to MySQL CC and Query Browser?
How to log specific queries
Junction Tables - Necessary, Useful, or Neither?
OPENINGS IN MUMBAI
how to run mysql 5.0 and mysql 4.0 together
segmentation fault when loading mysql
trigger question.
Database statistics / cardinality - NULL problem
Sort by non "" characters first, alphabetically?
Re-setting mysql as a service
Showing disk usage of innodb tables?
LEFT JOIN? Or create another table?
Joining tables on unknown table name
start...error
Extra-Time pills!-It Works.
LOAD DATA INFILE Syntax Error
Reading Variables available in shell program into MySQL
ON DUPLICATE KEY UPDATE with an old version of MySQL
workaround for outer join using filtering subquery
two tables selecting fields
Problem with 100% CPU utilization
MySQL db - data not saved (Using Frontpage ASP)
Frontend help
replication issue
mysql with openssl
Restoring a database from shell and sql dump
Compression of data
Parsing XML from a stored procedure
datetime and timestamp as default
Embedded BerkeleyDB vs. Embedded MySQL
Installation of mysql++ with SuSE 9.3
Subtracting dates gives me what?
INSERT WHERE NOT EXISTS
Can NOT Create or Drop a Database :o(
Installation of mysql++ with SuSE 9.3
Connecting to mysql
problem with foreign keys to datetime field
Efficient Storage of IP Address
total noob help with sql script
MySQL Database Administration HELP!
Perl DBI / SQL Question
web server ram
Inclusive AND with an exclusive OR search
Querying dates in mysql
Advanced Select Problem - Please Help
Ole objects
Create database using variable name
Store data for alot of records
mysql -e I get \t and \n!!! Help :confused:
Blank Date Field
Migrating MySQL DB to MySQL DB
FullText index performance issue