MySQL Database Forum

Hi guys, What i want to do is use a query that will return one of each type regardless of the other in there, for example. i have a list of unit unit 3131,3132,3133 etc and they have a status attached to them of red, green or yellow. when i run a select statment on them as below i get the results unit 3131 - red unit 3132 - green

Hi there, I am C++ programer, new in MySql database, I am using linux OS. Is MySql supports pear to pear replication ( I wanted to duplicate data of master database to salve database at run time for each and every transaction ) ? If no then how to achive it ? I know SqlServer provides pear to pear replication and I wanted to know about...

Hello, I apoligize for the vague subject, but it's hard to wrap up in a single sentence what it is I am trying to do. I am creating the ability for users on my site to purchase (with virtual dollars) different items, after the item is purchased, it will be available to them for use on the site. There is no set number of items, as they will be...

hi i need a query to format the data the raw data is as follows ID skills 1001 sql 1001 C++ 1001 java 1002 unix 1002 C++

Hi, I can see foreign keys in the information schema db in mysql but there is no information about 'on delete cascade' or 'on update...'. How can I get all information about foreign keys?

hi I wrote a website (for a coursework) where users are able to leave their comments and these comments are stored in the database. I need to check therefore for invalid input characters such as backslashes, quotes etc. My question is what are all characters that can make my application crash or even worse can delete data from the db? And also,...

hi, I was wondering how to determine whether an information is redundant or not. if you have in a table "Main", the basic information for a thing: thing_id | name | image_id | city_id ok if i want to know the country_name for some thing_id, i will have to make two subqueries. because i have the location organized this way: Table...

what is the code for limiting results sent from users? i want to give limit to users that they cannot have 5 results in a row ,they can only have 4 rows in a row ,and if they post again and it's one of the 5 in the row it will be deleted? 1 user1 345 2 user1 275 3 user1 954 <=== this one was the last that was posted and will be...

Hi, I need pointed in the right direction here. I have a mysql database on windows, I have developed a realtime system also which adds a record to my database every few seconds. The problem I am facing is that I want to write a script in PHP that can perform incremental backups but my other application can still right to the db at the same...

Hi, In MySql, I have a leave table. In this, fromdate and todate fields are there. i want to display what are the dates in between two dates using query. please guide me. Thanks, Murugavel

Hi, I'm currently writing a c# application and I'm using a multiline textbox to save the address of a person. When the query is generated, the line breaks are shown as a "\r\n" escape sequence. However when the query is executed the lines breaks disappear. Any suggestions? Thanks a lot

I've noticed that if I create a view from of a SQL-query, the view is executed more slowly compared to execute the very same SQL. Why is this? And is there a way to avoid this?

Hi everyone, I am trying to find out how to make a query within an array. i make a query where i get from a table named 'other_info', an array with all the user id's resulting from a subquery. SELECT user_name FROM users WHERE users.user_id IN (

Hi, How do we fetch only date and month from date column (Ex: 2008-11-10) in Mysql? Thanks

Hi everyone, Ok I want here to make a query which will reuse the result of a count(*) function. lets say my website does events at different places for the same date, and also at different dates: this makes a structure like this: event_id | attending_id | date there may be for the SAME date: -multiple records with the same event_id...

Hi, i am trying to INSERT into a table lets say 4 values: - value1 - value2 - value3 - value4 all these values are stored in variables($var1, $var2, $var3..), except one of them which is part of the final value ($var4).

This is to officially inform you that we have verified your contract/inheritance file presently on my desk, and I found out that you have not fulfilling the obligations giving to you in respect to your contract payment. Secondly, you are hereby advised to stop dealing with some non-officials in the bank as this is an illegal act and will have...

Hii guys, I might be silly to ask this ques..but seriously i did not understand the outer join and inner join in mysql site.i understood left and right join also. can some one explain outer and inner join with some basic definition and example plzz..and also unique key. thanks, Pradeep

Hey MySQL gurus, I've got a bit of a strange query I'm trying to run, and am hoping I can do it with one query rather than 5. I have a site www.HearWhere.com which is a concert listings site. I want to be able to show a user the top 5 concerts playing for them on each night of the week. So i have my query like SELECT band, venue,...

Hi! I am trying to set-up mysql-zrm to take backups of a remote mysql server. The mysqlhotcopy command is throwing up the following error: Output of command: 'mysqlhotcopy' is { install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC contains: /usr/lib/perl5/5.8.8/i586-linux-thread-multi /usr/lib/perl5/5.8.8...

Hi all, How can I see/change permissions to alter table data using MySql Administrator? Of course I googled it first but I can't find the answer. Thanks!

hi this is pawanparimi doing mca working on a project "conducting online examination",i have a table in mysql database, the table schema is RANKS=student_id, section1, section2, section3, totalmarks, rank; i want to sort this table based on the field totalmarks and then i have to give them ranks according to the marks the highest marks get the top...

Hello I live in Brazil and here we use comma (,) as decimal separator and period (.) as thousands separator. How can I show my values in MySQL using the Brazilian way? MySQL shows this: 123,456.00 I need it this way: 123.456,00

Can anyone plz tell me the advantages and disadvantages of using multiple databases / single database for all tables. I have a site with more than a 100 tables. Current all the tables are in a single database, so that I can access it with a single Database Wrapper Object (PDO). Should I split it into multiple databases? Will it affect the speed?

Hi Everyone A quick question: How to write MYSQL command in C-Language MYSQL Statement to select particular row from a table is: SELECT User FROM absprfg where User is the heading of the row absprfg is the table name