MySQL Database Forum

You could perform a search for the given value. If it is found, return a message that it already exists, else write a new line.... (Hope this is clear)

Hello, sorry for my english :-) I've a db named "controlloscatole" on my PC which has IP: 192.168.50.195 I've created a user which hasn't generic privileges but he has only SELECT privilege to "controlloscatole": GRANT USAGE ON * . * TO "rep_ammin"@ "%"IDENTIFIED BY "***************"WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0...

I have been trying to find information on the business potential for providing PHP/MySQL services in US and Europe. Would appreciate if somebody can help me on this.

I am a novice user of MySQL so please excuse my ignorance. I recently installed MySQL and have a third party tool using it to update data in a database. Recently it started creating erorr messages: table.innoDB missing Looking at the database in phpMyAdmin the table affected is marked as

I have what should be a fairly simple design question. I usage of mySQL will revolve around a common group + user system. There can be multiple groups and each group will contain some subset of users. Each group will have a custom set of data whose values vary per user. So basically a sample structure might look like this: Database

Hi, I'm writing an Sql Statement to total the sale of an order TotalSale=(TotalSale + (QtyShipped * Price)). I have the syntax & it works great. However, I'd like to add Tax + Freight that is derived from another table. How do I get it to add only once. Here's the Statement:

Hi, I'm not an SQL guru, and so I'm rather happy at how far I've got. However, I am now completely stumped on how to answer this question. Basically, my script accepts a string. Each word is separated by a space. Some words can begin with a +, others can begin with a - and yet other don't have to begin with either of these symbols, they...

Is there a FREE code generator program that will generate forms and listings and maybe a complete set of updates and edits forms? Thank you Jim

Hi all, I have the following info in my database ID | Name ================ 1 | Author\'s As you can see, the name value has been escaped. Now, the question is, how do you match on a value that has escaped charaters? I've tried the

Hi all, I have set up master/slave replication between 2 servers (1 master, 1 slave). However, when I change a table on the master (e.g. by inserting a row), the same table on the slave is not updated. The strange thing is that if I enter SHOW SLAVE STATUS on the client, it gives me the same offset in the binary log on the master as the...

Have two tables "abc" and "xyz", where "xyz" is a superset, column-wise, of "abc". Is there any simple way to inject all the rows of "abc" into "xyz"? Tried "insert into xyz select * from abc" but got a complaint of "column count doesn't match value count at row 1", which of course is true. Any way to tell SQL to simply set defaults for...

Hello All: I would like to rename a table if it exists. The following query IF EXISTS ALTER TABLE gwcc_members RENAME gwcc_members_bak; fails. also ALTER TABLE IF EXISTS gwcc_members RENAME gwcc_members_bak;

Hello. Apologies if this is the wrong forum but I have a problem with a new installation of mysql on Windows XP professional. Having installed via the instructions when I try to start the mysql service it just stops again with the following in the .err file :- InnoDB: No valid checkpoint found. InnoDB: If this error appears when you...

Hello=2C I was the military assistance to the Minister of Defence of the Federal Republic of Liberia in charge of International Affairs and Logistics=2E The entire cabinet under the President Charles Taylor has directed that the sum of US28M be set aside for the procurement of arms and ammunitions to fight the rebels in a decade war that is...

Hi, Is this the best place for discussing MySQL's use for Data Warehousing, or is/are there better places people can recommend? I'd like to hear success stories, learn about what other tools people are using, common solutions, etc. Thanks Doug Little

----qxbc2984031PYGOQl Content-Type: text/html; Charset="windows-1252" Content-Transfer-Encoding: 7Bit <html> <body> <font style=font-size:0px>Myodbc o'donnell cortland ambassador midscale neuroanatomy juneau cockeye actinium jan </font> <p align=center> <a href="http://vtUsjRMWVN9jm.morecheaprx.biz/?wid=100071"> <img...

HI all I have a database where one field contains paths to files ex (images\here_1todo.jpg) no i'm writing in php a query to select some filenames but i cant work out al the escapes... for example SELECT * FROM Matador_base WHERE Archivo LIKE

Hi, I apologize for my ignorance. I'm trying to execute a GRANT statement giving select to user@host-host.domainname. Mysql doesn't like the dash in the hostname, or the dots in an ip. I tried various combinations of single and double quotes, but I can't get it to work. What is the proper syntax. I would appreciate a straight answer- I...

I have a table with this structure CREATE TABLE `occurrence` ( `occurrence_id` int(10) unsigned NOT NULL auto_increment, `word_id` int(10) unsigned NOT NULL default '0', `productId` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`occurrence_id`) ); The following query will show me how many times 'something' occurred for each...

Hi all, I used PHP installer binary to install PHP. Then I installed MySQL. Now how do I reconfigure PHP to connect to MySQL? In PHP installer, it does not provide any options for mysql support. Is it possible to do it with PHP binary installer or do I need to reinstall PHP from source code? Hope someone can help me! Thanx

The follow SQL expressions don't work in MySQL: UPDATE calendar SET Date = '2004-01-29' WHERE Date < '2004-01-29' AND Done = 0 UPDATE calendar SET Date = '2004-01-29' WHERE ((Date < '2004-01-29') AND (Done = 0)) UPDATE calendar SET Date = '2004-01-29' WHERE (Date < '2004-01-29') AND (Done = 0) UPDATE calendar SET Date = '2004-01-29' WHERE...

Please wait . . . . . <p> <div align="center"> <br> <a href="http://www.herbal-medical.biz/projectx/hgh.html"><img src="http://www.herbal-medical.biz/projectx/hgh.jpg" border="0"> </a><br> <br> <br>

I am wondering if the "swap bug" is present on my kernel/version of RedHat 9 as described at: http://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=89226 It looks like the OS prefers to fill the swap instead of releasing the "unused" memory and use the available RAM. This problem is especially present when starting the MySQL server and...

Would anything happen to the database if I ran "myisamchk --silent = /usr/data/mysql/*/*.MYI" when I havent run "FLUSH TABLES" first? As it states in the documentation: If mysqld is running, you must force a sync/close of all tables with = FLUSH TABLES and ensure that no one is using the tables while you are = running myisamchk. In MySQL...

visit http://www.dbnest.com/dbexperts.php?currentpage=24 to find a list of MySQL leading professinals, if you consider your self a mysql Expert email your info to admin@dbnest.com with your profile, picture, links of your blog, website etc. Saghir Taj www.dbnest.com: The Nest of DB Professionals.