MySQL Database Answers - Page 19

SQL Query question
SQL Query question
lower_case_table_names not working for SELECT
lower_case_table_names not working for SELECT
Cannot get MySQL Query to work in .asp
Cannot get MySQL Query to work in .asp
Copying a row
Copying a row
Cannot get MySQL Query to work in .asp
Copying a row
Guenther Trauner/L3A/EAGA/EAG/AT ist außer Haus.
SHOW VARIABLES LIKE '%dir%'; (basedir and datadir)
Guenther Trauner/L3A/EAGA/EAG/AT ist außer Haus.
SHOW VARIABLES LIKE '%dir%'; (basedir and datadir)
MySQL 4.0.13 Memory Problem on heavy load
SHOW VARIABLES LIKE '%dir%'; (basedir and datadir)
MySQL 4.0.13 Memory Problem on heavy load
Optimizing a query
MySQL 4.0.13 Memory Problem on heavy load
Optimizing a query
Optimizing a query
MySQL Query help
mysqlbinlog question
MySQL Query help
mysqlbinlog question
mysqlbinlog question
join tables on a large database 200 meg
SourceForge.net mySQL Server Connection Failure
join tables on a large database 200 meg
[users@httpd] apache/mysql errors....
SourceForge.net mySQL Server Connection Failure
[users@httpd] apache/mysql errors....
Grown defects in a RAID array
moving MySQl database
Grown defects in a RAID array
MySQL 4.0.13 Memory problem under heavy load
Doing Differential backup
Raw partition with InnoDB on Windows 2000
moving MySQl database
apache/mysql errors....
MySQL 4.0.13 Memory problem under heavy load
Doing Differential backup
Doing Differential backup
Raw partition with InnoDB on Windows 2000
Raw partition with InnoDB on Windows 2000
Will a SIGTERM shutdown while using LinuxThreads?
apache/mysql errors....
Raw partition with InnoDB on Windows 2000
Will a SIGTERM shutdown while using LinuxThreads?
DIFFERENTIAL BACKUPS
Differential backup
Access denied for user
DIFFERENTIAL BACKUPS
Report to Sender
Differential backup
SELECT SPEEDS......
Access denied for user
Difference between mysql-3.23.56-Max and non-max version
CREATE TABLE with CHAR but get VARCHAR
Report to Sender
SELECT SPEEDS......
Difference between mysql-3.23.56-Max and non-max version
CREATE TABLE with CHAR but get VARCHAR
Problem connection to MySQL using .net
problems with @ symbol in varchar field
Problems??
runlevel setting on default rpm is wrong (in my opinion)
Problem connection to MySQL using .net
problems with @ symbol in varchar field
Replication Problem - Sorry
moving MySQL
Problems??
Problems??
runlevel setting on default rpm is wrong (in my opinion)
runlevel setting on default rpm is wrong (in my opinion)
Replication Problem - Sorry
moving MySQL
moving MySQL
Delete questions and speed/safety issues
Request
Fw: mysql 4.0.14 + replication + windows XP PROF
problem to run setup under windows xp sp1
mySQL error
Returned mail: see transcript for details
Delete questions and speed/safety issues
Question with GROUP BY command
Request
Fw: mysql 4.0.14 + replication + windows XP PROF
convert the clipper.dbf files and .ntx
problem to run setup under windows xp sp1
URGENT ATTENTION.
mySQL error
punctuation limitation in fulltext search
month by month count
Returned mail: see transcript for details
database reverted to 18hr old state after power outage
Question with GROUP BY command
marking all records based on a text file
convert the clipper.dbf files and .ntx
Difference between keys and indexes
URGENT ATTENTION.
punctuation limitation in fulltext search
month by month count
Message ("The distribution of your message dated Tue, 19...")
database reverted to 18hr old state after power outage
Real-time compression for mysql udf_lzo
marking all records based on a text file
PROBLEM when installing mysql!
Difference between keys and indexes
Message ("The distribution of your message dated Tue, 19...")
Real-time compression for mysql udf_lzo
Message ("The distribution of your message dated Tue, 19...")
Simple error ... Im sure
PHP mysql_connect randomly failing
Real-time compression for mysql udf_lzo
Got error 127 from table handler
PROBLEM when installing mysql!
PROBLEM when installing mysql!
Mast-Master Replication
Specifying INNODB without configuration
Simple error ... Im sure
PHP mysql_connect randomly failing
Simple error ... Im sure
PHP mysql_connect randomly failing
Got error 127 from table handler
Got error 127 from table handler
Mast-Master Replication
MySQL and shared storage
Specifying INNODB without configuration
Mast-Master Replication
Specifying INNODB without configuration
"hard" sort table order
JOINs
MySQL and shared storage
MySQL and shared storage
"hard" sort table order
JOINs
"hard" sort table order
Another Replication Problem
Another Replication Problem
JOINs
memory leaks
Another Replication Problem
memory leaks
memory leaks
indexs, primary and such
indexs, primary and such
indexs, primary and such
Out of Office AutoReply: Your details
Out of Office AutoReply: Your details
shouldn't mysql_pconnect force reuse of mysql connections?
Need help optimizing query, awfully slow on only 20000 records
Out of Office AutoReply: Your details
shouldn't mysql_pconnect force reuse of mysql connections?
Need help optimizing query, awfully slow on only 20000 records
shouldn't mysql_pconnect force reuse of mysql connections?
Import from Excel to MySQL
Need help optimizing query, awfully slow on only 20000 records
Logical OR on Columns? (Merging two or more columns into one column)
Import from Excel to MySQL
Cache problem in 4.1
Import from Excel to MySQL
SHOW DATABASES works in 4.0.14
Windoz service problem
What's the meaning of: "InnoDB: Warning: using a partial-field key prefix in search"
Logical OR on Columns? (Merging two or more columns into one column)
myisamchk question (important)
Cache problem in 4.1
Moving MySQL data to RAMDisk
SHOW DATABASES works in 4.0.14
Replication Binlog Corruption - REPOST
SHOW DATABASES works in 4.0.14
Replication question
Windoz service problem
What's the meaning of: "InnoDB: Warning: using a partial-field key prefix in search"
Windoz service problem
myisamchk question (important)
What's the meaning of: "InnoDB: Warning: using a partial-field key prefix in search"
Replication Binlog Corruption - REPOST
myisamchk question (important)
Help with SELECT statement for date range
Moving MySQL data to RAMDisk
Replication Binlog Corruption - REPOST
Replication question
Moving MySQL data to RAMDisk
Replication question
Help with SELECT statement for date range
Help with SELECT statement for date range
SELECT with 1,000,000 ROWS
compiling mysql for arm on i386-linux
mysql-standard-4.1.0-alpha-pc-linux-i686.tar.gz changed since April 12 2003?
scroll problem
blob update in Perl DBI gives syntax error
SELECT with 1,000,000 ROWS
compiling mysql for arm on i386-linux
scroll problem
mysql-standard-4.1.0-alpha-pc-linux-i686.tar.gz changed since April 12 2003?
scroll problem
SQL, Count and subqueries
blob update in Perl DBI gives syntax error
automating data entry
SQL, Count and subqueries
SQL, Count and subqueries
mysql_install_db on Mysql 4.1.0 seg-faults
Oracle DBA here looking for advice on MySQL ....
automating data entry
automating data entry
Replication Problem
mysql_install_db on Mysql 4.1.0 seg-faults
Oracle DBA here looking for advice on MySQL ....
Need advice on speeding up a query
mysqlbinlog wrong output
Replication Problem
Need advice on speeding up a query
Need advice on speeding up a query
MySQL processes not showing.
mysqlbinlog wrong output
MySQL processes not showing.
Table locking...
Problem to use mysql
Table locking...
MS Excel /myodbc drops column aliases (with joined tables)
Problem to use mysql
MS Excel /myodbc drops column aliases (with joined tables)
Running MySQL in RAMDisk
bad data in mysql tables in replication server
Relationship in Mysql
mysqldump of DB vs. individual tables
MySQL Installation problem
Running MySQL in RAMDisk
bad data in mysql tables in replication server
mysql 4.0.14 + replication + windows XP PROF
Relationship in Mysql
mysqldump of DB vs. individual tables
mysqldump of DB vs. individual tables
how to sort and display multi-byte charsets?
Auto Incrementing Problem
MySQL Installation problem
mysql 4.x week function fails
position of a certain record in the result set?
Database name
mysql 4.0.14 + replication + windows XP PROF
Mixed table types in transactions?
how to sort and display multi-byte charsets?
Fulltext for InnoDB?
How to make Database access fast
Auto Incrementing Problem
mysql 4.x week function fails
MD5 digest length 16 bytes or not?
position of a certain record in the result set?
Database name
Mixed table types in transactions?
Fulltext for InnoDB?
set up question
How to make Database access fast
MD5 digest length 16 bytes or not?
set up question
Problem installing MySQL v4.0.14b
Primary keys
An MS-windows front end interface ?
Mysql: check Innodb autoextend
Problem installing MySQL v4.0.14b
Delete row
Primary keys
An MS-windows front end interface ?
mysqldump w/o password
Mysql: check Innodb autoextend
Slow performance after falling back to MySQL 3
Delete row
ezmlm warning
mysqldump w/o password
[MYSQL] Confused about DATETIME compare/subtraction
Slow performance after falling back to MySQL 3
ezmlm warning
ezmlm warning
64-Bit and INNODB
[MYSQL] Confused about DATETIME compare/subtraction
Storing images in mySQL
"table is read only" after copying table files to new server
64-Bit and INNODB
64-Bit and INNODB
Storing images in mySQL
Storing images in mySQL
"table is read only" after copying table files to new server
"table is read only" after copying table files to new server
Double entries
AW: How many join do I need for a query on 3 table?
images on database
Double entries
ranking student grade ? with subquery/subselect?
Double entries
AW: How many join do I need for a query on 3 table?
images on database
AW: How many join do I need for a query on 3 table?
User Permission and ODBC
images on database
ranking student grade ? with subquery/subselect?
ranking student grade ? with subquery/subselect?
big big integer
big big integer
User Permission and ODBC
User Permission and ODBC
big big integer
Windows 98 shutdown problem
Windows 98 shutdown problem
Can I change the date format...
Can I change the date format...
How many join do I need for a query on 3 table?
How many join do I need for a query on 3 table?
compile mysql meet problem
compile mysql meet problem
compile mysql meet problem
compile mysql meet problem
PHP or Perl?
Trying to install MySQL on Win98
PHP or Perl?
Trying to install MySQL on Win98
URGENT ASSISTANCE.
PHP or Perl?
URGENT ASSISTANCE.
replication and internals
replication and internals
Optimizing imports
querie assitance
MySQL embedded server example bug
Secure Database Design Part II
MySQL embedded server example bug
Secure Database Design Part II
About Embedded MySQL server
About Embedded MySQL server
Bi-directional Replication
SQL lertter Exclude ... like 'd%'
Bi-directional Replication
SQL lertter Exclude ... like 'd%'
MySQL to syslog
MYSQL & ASP.NET
Better query method?
AW: I simply can't compile this
AW: I simply can't compile this
Character case conversion problem
I simply can't compile this
AW: Query with inner join (Help!)
Query with inner join (Help!)
log-bin not created
Benchmark
Transactions tutorial
Q: Delete subselect
My UDF for Snort/ACID
Suggestion
Defining Datew Format in Import
what are some good options for reiserfs and mysql
compiler used to successfully compile mysql on solaris 8 machine
ssl support in MAX binaries?
Subquery IN+SELECT blues
Table to csv file ?
MySQL -- Java vs PHP
Best practices
table rows inserted by embeddded MySQL cannot be retrieved by MySQL tcp client
mysqld_multi don't starts groups on Linux RedHat 9
how to display a text in a SELECT ?
how to display a text in a SELECT ?
Does mysql cache results?
no return value from empty table
Does mysql cache results?
myODBC command syntax for SELECT statement...
no return value from empty table
myODBC command syntax for SELECT statement...
BLOB / TEXT question
FW: A final Windows MySQL PHP plea
BLOB / TEXT question
FW: A final Windows MySQL PHP plea
MYSQL with .NET
AW: mutual declarations produce Error 1005 (errno: 150)
MYSQL with .NET
AW: mutual declarations produce Error 1005 (errno: 150)
CREATE TABLE, INSERT INTO with SELECT in parentheses
AW: mutual declarations produce Error 1064
String Comparison Implementation
unable to run mysql_install_db please help
CREATE TABLE, INSERT INTO with SELECT in parentheses
AW: mutual declarations produce Error 1064
String Comparison Implementation
unable to run mysql_install_db please help
Users and hosts-Newbe ?
Problem renaming table
Users and hosts-Newbe ?
Problem renaming table
performance question: resultset's vs sql
Problem renaming table
SQL Server 2000 to mySQL Server
SQL - Join How?
can't create this table with datetime column, why?
performance question: resultset's vs sql
performance question: resultset's vs sql
SQL Server 2000 to mySQL Server
SQL Server 2000 to mySQL Server
SQL - Join How?
SQL - Join How?
can't create this table with datetime column, why?
can't create this table with datetime column, why?
InnoDB & multiple mysqld's on 1 server
Trouble with Query using DWMX
FULLTEXT crashing mysql 4.0.14
InnoDB & multiple mysqld's on 1 server
Trouble with Query using DWMX
InnoDB & multiple mysqld's on 1 server
TEXT to MEDIUMTEXT conversion error
Trouble with Query using DWMX
FULLTEXT crashing mysql 4.0.14
INSERT .... SELECT
FULLTEXT crashing mysql 4.0.14
TEXT to MEDIUMTEXT conversion error
TEXT to MEDIUMTEXT conversion error
INSERT .... SELECT
`mysql_config --...` does not work
USE database prompt
INSERT .... SELECT
relay-bin on master?
Formula to caluclate date automatically
INSERT .... SELECT
`mysql_config --...` does not work
`mysql_config --...` does not work
USE database prompt
USE database prompt
relay-bin on master?
How to ship mysql connector java JAR
Formula to caluclate date automatically
relay-bin on master?
Formula to caluclate date automatically
Matching escaped strings
MySQL Installation Challenges
How to ship mysql connector java JAR
How to ship mysql connector java JAR
mysql build problem (fwd)
Is this legal sql code ?
How to get the total number of rows with a query "limit" ?
Matching escaped strings
Matching escaped strings
MySQL Installation Challenges
MySQL Installation Challenges
AW: mutual declarations produce Error 1064
mysql build problem (fwd)
Is this legal sql code ?
How to get the total number of rows with a query "limit" ?
How to get the total number of rows with a query "limit" ?
AW: mutual declarations produce Error 1064
fulltext searching
fulltext searching
Accessing Mysql after fresh installation
Import Database from MySQL3.x to MySQL 4.x
Import Database from MySQL3.x to MySQL 4.x
sub queries in mysql?
sub queries in mysql?
Performance MySQL with ADO VB
Performance MySQL with ADO VB
non-standard characters shown wrong in generated emails but not on the web
non-standard characters shown wrong in generated emails but not on the web
Sppeding up on ORed coloumns query
Reading table structure and data from sql file.
Reading table structure and data from sql file.
efficient placement of fields
Fwd: Dynamic enabling of log files
Fixing autoincrement
Running Total of a column on a SELECT
Multiple items in an ALTER TABLE statement
Joins and Unions
Tricky INSERT
alter table froze entire machine!
symlinking tables to a new db
Difference of GROUP BY + ORDER BY
Foreign Key Constraints
Designing a secure database?
backups of raw db files - indexes needed?
backups of raw db files - indexes needed?
Problem with indexes ?
Problem with indexes ?
How to optimize this query ?
A final Windows MySQL PHP plea
table corruption problem on 4.0.14
table corruption problem on 4.0.14
mySQL & ADO?
InnoDB - mysqldump
Replication Problem...
replication blues
Meaning of Column time in Show Processlist
Multiple field updates
Transferring database from one PC to other
mysql insert records in the middle of database table
Connect via VB
order by rand()
MySQL routing issue
Converting Sequel to MYSQL
optimisation of a code
optimisation of a code
access denied on individual table
Reset Primary Field Counter..
mysql build problem (fwd)
Foreign Keys
Foreign Keys
mysqlbug
mysqlbug
q re apostraphes that are escaped...
mysqld_multi don't starts groups on Linux RedHat 9
mysqld_multi don't starts groups on Linux RedHat 9
How to do a subquery with MySQL 4.0 ?
Form values are truncated
How to do a subquery with MySQL 4.0 ?
Form values are truncated
Form values are truncated
Select match from a stored delimitated string?
Select match from a stored delimitated string?
Tomcat+MySQL. Intermitent DbcpException: Server configuration denies access to data source
Tomcat+MySQL. Intermitent DbcpException: Server configuration denies access to data source
Random Errors in Replication Binlog
Random Errors in Replication Binlog
Password formats 3.23-4.x
Password formats 3.23-4.x
Help debugging this Query?
Help debugging this Query?
MySQL Replication
MySQL Replication
Quick ones to speed up acces!
Quick ones to speed up acces!
libmysqlclient.so.10 is needed by (installed) mod_auth_mysql-1.11-12
libmysqlclient.so.10 is needed by (installed) mod_auth_mysql-1.11-12
the logic of full text search
ERROR 1045: Access denied
Text File
the logic of full text search
Text File
Error 127, some questions
ERROR 1045: Access denied
Error 127, some questions
Fw: Mysqld dead subsys locked
Mysqld dead subsys locked
Fw: Mysqld dead subsys locked
Please Help
Mysqld dead subsys locked
Checking the mysql status
Help with count(*)
Please Help
Checking the mysql status
Help with count(*)
Problem with date query
Int fields...
Whats wrong.
Problem with date query
Int fields...
Searching for rows that depend on other rows in some fashion...
Whats wrong.