MySQL Database Forum

The meaning of REPLACE INTO is clear to me. IF the new record presents new key values, then it is inserted as a new record. IF the new record has key values that match a pre-existing record, then the key violation is ignored and the new record *replaces* the pre-existing record. But what about INSERT IGNORE? Is this a synonym for...

I need help on a query. There is a common titles database for several radio stations Some titles are enabled and some are not enabled for each station. Example of some tables: Titles Stations Station_Titles ------ -------- ------------- id id Station_ID Title StationName Title_ID

I am trying to install MYSQL 4.1 and I keep getting the message "Resource (messagedlg.confirmation) not found." Installation does not proceed. What does this mean and how do I correct it? Bill

I'm looking for something that would let me scroll through tables and edit rows and columns graphically in windows. Does anyone know of such a program? Jim

I want to learn somthing about mysql. I have just installed mysql 4.0.22-win and it looked to work fine. When I start winmysqladmin (version 1.4) I get the expected screen, but when I right-click on Databases, I only get flush-posibilities, not the option to create a database. Can anybody please telle me what I have done wrong, and I will be...

I'm trying to use the Windows DataLink (udl) to set up a connection to a MySQL database. I've installed the 3.51 ODBC driver from the MySQL website - however, using a DataLink, it doesn't show up as a DataSource - How can I get it recognized there?

I have a question about creating a simple database. Here are the 2 tables. They are linked by the primary/foreign key 'client_id'. I think that I understand that part. I have 'KEY birthdate(birthdate)' in the clients table definition. I'm not sure when I should have that. When is it desirable to use the 'KEY' in the definition? If I wanted...

I use phpMyAdmin. All queries there work. But when I do the same query with PHP with the same user I get: 1267 - Illegal mix of collations (latin2_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation 'like' I don't know how to solve it and how the mistake got there. All tables are set to latin2_general_ci and also all...

Hi all, I have been reading my books about this, but can't seem to find the solution. Example: Picture 3 tables: TABLE_1

Hello, I am working on designing a Web site using PHP and MySQL and I am currently figuring out how to best build my MySQL database. My Web site is going to use a MySQL database extensively throughout the Web site. It is a content management system type Web site with lots of users and written articles and other things. With my database...

Opinions appreciated! Should we consider version 5.0? How close is this version to prime time? What kind of hassles to expect with this compared with the production version 4.1? This is a production environment BUT it is new and we don't have to worry about backward compatability.

Hi, I have a site with various parts which allow users to enter info via forms which gets entered into various tables in a MySQL db (I'm using ASP, rather than PHP). I have an ecards bit, and when users send a card, their data is entered into the db via something like: INSERT vars into ecard_tbl....

Hi, Trying to restart MySQL when it is down. I have placed the following script in a file : checksql ---> #!/bin/sh /etc/rc.d/init.d/mysqld status >/dev/null 2>&1

i have zen-cart database in my computer I export into a file then when i try to import this database file to my webhost i get such error how to fix it? thx #1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1...

Hi, I have cases where I connect to the web site and MySQL is not working : Message : "Too many connection errors", Unblock with 'mysqladmin flush-hosts'. What I did is a script that check out /etc/init.d/mysqld status and if is not running, then, I restart MySQL.

Hi, Table Oelsls contains all products bought (history) table Invt contains the products to sell (Inventory) I'm trying with no success to list all products in Oelsls table (field name in both tables: part_id) that are not in the Invt table. My objective is a grid of all Special (non inventory) products. Can anyone produce the correct...

hello! First of all excuse me for this dumb question. I ve installed mysql and everything ran fine. then i installed phpmyadmin and also everything ran fine. Then i put a password to phpmyadmin and i can log on in myadmin, but all my php scripts don t work! as soon as i want to connect i get a mysql 1045 error saying cannot connect to...

Hi, We run a Linux Server Fedora AMD 1.3 Duron, 512 MB RAM, 60 GB HD. The website welcomes more and more users. Problem : we very often have max_user_connections errors and need to restart SQL server. The max_user_connections variable_name in MySQL is set to 0 and

Hello !! I have to tables (name A and B, B has a fulltext index). In need to handle this type of query: select A.* from A, B where Instr(A.field1,B.field2) and Match (B.text) Against ('foo'); because field2 on B has a substring of the A.field1. Please note that

I'm new to databases and am experimenting with mysql. I have a clients table and a sales table in a mysql database. Client_id is the primary key in clients and a secondary key in sales. The only client_id's that show up in the clients table are client_id's starting at 28 (they autoincrement from there). 1-27 were old ones that I used in...

If I do a the following using mysql_query SELECT * FROM cine_ticket_transaction WHERE performance_day='2004-10-28' AND film_name='Les miserable' If the record does not exist, I lose the connection with the mysql server. Any help appreciated. Maurice Breault

Hello, I have intalled MYSQL 5.0.1 and everything seems to work fine accept the fact that the time to establish connection to the database has increased greatly....almost to the point of not being an acceptable database solution for us. Here is whats happening...... Installed Mysql 5.0.1 on Redhat Enterprise edition V.3 in order to utilize...

I'm trying to set up an off the shelf script and keep getting an error. My host set up the mysql on my site and I changed the variables I had to in the settings.php file but I keep getting the following errors Warning: mysql_pconnect(): Access denied for user: 'ODBC@localhost' (Using password: NO) in...

or I have to be in some mlist in order to post? thanks -- Tong (remove underscore(s) to reply) *niX Power Tools Project: http://xpt.sourceforge.net/ - All free contribution & collection

Hi. Creating the below to tables give errno 150, any idea why? CREATE TABLE categories ( id int(11) unsigned NOT NULL auto_increment, name varchar(64) NOT NULL, PRIMARY KEY (id), UNIQUE KEY name (name) ) TYPE=InnoDB; CREATE TABLE types (