MySQL Database Forum

I'd like to replace a field value but don't know the proper syntax. The record currently has a NULL in the datetime field and I'd like to enter a real value from the command line. (I'm just getting started with MySQL) Thanks for any input... -- joe /*------- A new survey of online daters found that 47% of people believe that their...

I've got a table t with rows a,b,c,d,e,f and a single index i on a,b,c,d,e,f The query is: SELECT * FROM t WHERE a="something" AND b="something" AND c="something" ORDER BY d, e, f LIMIT 100; now, table t may have millions of rows.

I share a folder on an XP Pro computer across our peer to peer network. I have add users to the XP Pro computer for network login. If users on our network edit the MS Access 2000 file no problems occur. But if I edit the MS Access 2000 file on the XP Pro computer itself all users are removed from the security tab on the MS Access file except...

I have two tables, both containing an 'authors' column. Is there a way to get a unique list of authors from the two tables? I tried SELECT DISTINCT `authors` from `table1`, `table2`; but I got an "Column 'authors' in field list is ambiguous" error. Is there also a query to return only the count of distinct authors from the two tables? ...

----TKMBBI543513992CWTFAAHDK Content-Type: text/plain; Content-Transfer-Encoding: 7Bit The new craze is finnally here - one of the bast sites that can give you the things you've allways wanted to get - watchees, repliccas to be correct, of the bast brand s in the world! Impress you're lady/man with roleex (inc. vip roleex), carttier, tag...

I'm writing an application that displays a list of transactions from a mysql database. The problem I am having is I need the user to be able to view the last x transactions but there needs to be an initial row with the "balance forward" from the previous transactions. Is there any mysql statement for this or class for this type of feature...

Hello, I have TWO tables. TABLE1 ----------- ID ProgramID 01 Program1 02 Program2 03 Program3 04 Program4 ....

Hi! I am trying to get my C++ connecting and communicating with a mySQL server on my developer PC. I did a next-next-finish installation of mySQL and installed the developer libraries as well. I started programming in MS VC++ and can communicate with my server. However, every time I connect with a user that has no password (blank) I am...

Here's the breakdown: MySQL 4.0.12 Table: Assignment (indexes are created on proper fields) 419,234 records Table: Finders (indexes are created on proper fields) 5,345,657 records My user wants to be able to do a wild card search on lastname in the finders table. So, I wrote the following query. SELECT Finders.Lastname,...

Hello all I have a field (called active) of type DATE and I want to add a default value. The default value must be the current date. Is this possible to do this in the table create statement? CREATE TABLE mytable ( id INTEGER NOT NULL AUTO_INCREMENT, active DATE DEFAULT ?????,

I have about 20 databases in a single MySQL instance running 4.0.21 on RHEL3. I have a healthy mix of MyISAM and InnoDB tables. Howerver these two types do not mix within a single database. A read/write master MySQL server replicates to five read-only database servers for load distribution of the web traffic. I need to come up with a backup...

Can phpMyAdmin be used to manage databases that are not local?

Hi everyone, I'm using the command mysqlcheck --all-databases --auto-repair --silent and I see these warnings (listed below) on a daily occurrence. Is mysqlcheck causing these warnings? I can't see how a table can close inappropriately. How can I prevent this. Hoping to here from MySQL users who have came across this. I'm using MySQL...

Hi everyone, I'm using the command "mysqlcheck --all-databases --auto-repair --silent" and I see these warnings and errors (listed below) on a daily occurrence. What could cause these indexes to be out of order? Another thing I don't understand is why an increase in the number rows constitutes a warning? Hoping to here from MySQL users...

does anybelly know why the following happens? i am using macosx 10.4 and ./configure --prefix=/usr/local/mysql --with-unix-socket-path=/usr/local/mysql/run/mysql_socket --with-mysqld-user=mysql --with-comment --with-debug sql_list.h: At global scope: sql_list.h:401: warning: inline function `base_ilist::~base_ilist()'

I've just applied an index to my mysql 4.0.21 database/tables and it really helped with speed. I was wondering if this index I added is automatically adjusted by mysql over time or do I have to go back say every week and remake the index? Mysql 4.0.21 Linux 2.4.30 Thanks.

I have a C++ Builder APP that uses the Advantage database. I want to export data from the Advantage tables to a MySQL database on my website. What is the best way to get my data into the MySQL table ? I am only looking at 10-15 records, but I would be updating every 10 seconds or so. I could create a text file and upload it via FTP, and...

How do I to move data on an external server (over the Internet) in mySql to MS Access on my office computer. I would like to remove the data from the Net and store it on my computer. Thanks. Ken

Hi all, I got a quite strange problem when I tried to setup a database backup shell. I put it this way: "bin/mysqldump --opt --user=xxx --password=xxx DB > DB.bak" However, error 1045 came to me to say "Access denied for user 'xxx'@'localhost' (using password: YES) when trying to connect". None the less, I'm absolutely full of confidence...

----FIXMLI5221120PQJD Content-Type: text/plain; Content-Transfer-Encoding: 7Bit Now presenting: You know you've allways wanted it - watchees: elegent, fancy, impressive repliccas! You can impress you're lady/man with: roleex (including vip roleex), carttier, braitling, bulgari and much much more... The bast brand s in the world! Just...

Joe's Collection Agency is what is stored in one of my fields when a user types in Joe's Collection Agency on one of my web forms. How can I train my LAMP application to know that when user's type in a single quote (') - a character with ASCII value 39 that the user really DOES mean a friggin' single quote?

I'm having trouble copying a database to another machine. Here are the two table's in ths database and the sql commands: DROP TABLE IF EXISTS `clients`; CREATE TABLE `clients` ( `client_id` int(10) unsigned NOT NULL auto_increment, `lastname` char(15) NOT NULL default '', `firstname` char(15) NOT NULL default '', `birthdate` date NOT...

Can someone explain to me why this simple query will not use an index on the field confirm_date? select * from comments where confirm_date != 0 confirm_date is an integer, and I have a regular index on it. When I use EXPLAIN it shows all 1233 rows being searched with NULL for the possible keys. Thanks for your help.

Hi, I am about migrate from an old program database to MySql (Running under RH LINUX)and I'm wondering which is the best option to do : I currently have one file for each of my modules, (I'm using filepro plus) , so like CUSTOMER, WARRANTY, ZIPCODES, INV, etc... like 2,000 files each with their own fields. 1) Should I create multiple...

Any reason to suspect that ROLLBACK is not working for MySQL v4.1.10a? Have reduced code to a very simple test, START TRANSACTION followed by INSERT followed by ROLLBACK, but the INSERT remains. Tried substituting SET AUTOCOMMIT=0 for START TRANSACTION, no effect, no error. Thanks.