[mysql] Forum Topics

I have 2 tables: an IP Address table, and an IP Ranges table. I want to retrieve a list of ranges in the ranges table for which one or more of the IP addresses in the IP address table fall within that range. The IP addresses are represented as integers, …

hi all, how can we have a select satement in an SP?(i want to return a result set from the SP). i want to migrate from SQL Server to MySQL and i don't know what to do with these SPs. it can be done in MySQL client, but it gives …

Hi friends, I think the MySql is not case sensitive for selecting values. for example I am having a table called dept, Id | Depart 1 | BTECH 11 | it 12 | ibt 2 | BE 21 | cse 22 | ece Now i want to select the capital …

I have just started using DB2 and have been re-introduced to SQL. I want to make sure I post in the right forum with some questions regarding SQL and some basic scripts I have been given - please, let me know if this is not the place. Also, anyone have …

I am using MySQL 3.23.58 on FC2 I ran PhpMyAdmin >> Runtime Information and it said that "Created_tmp_disk_tables is big, you may want to increase the tmp_table_size value to cause temporary tables to be memory-based instead of disk-based. " My existing my.cnf looks like this: [CODE] [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock set-variable …

Hello all, I am wanting to structure a database that will allow for multiple prices per products. I also want to be able to upload an image and enter details about the product. My initial thought would be to have a product_db and have a price table, a product table, …

I'm sorry but I'm totally new on Web Development, I'd like to make a registration form for everyone that downloads a file I have on a Website. The ideal thing would be to send a confirmation email where the link to file is attatched. So basically when a person wants …

[B]Hi All[/B] 2 db servers replication interval in every 60 secs right now needs to have length interval ncreased is this o.k. to do - pro's and cons of this Thanks for ur time and help..............

hi I want to fetch data from four tables using a single query.please tell me how to do that. thanks in advance

Hi guys, Im working on a bit of MySQL and was wondering if there is a way (without using php arrays or other) to search a table for a value (say 1) and return the rows which '1' wasnt found in. != wont work because the table contains more than …

hi, i have two entities products and categories. both have many-to-many relation. how can i get the products that are not related with the categories. i mean the ones which not not mapped in junction table. thank you! daniyal nawaz

I'm looking for some guidance on how to develop a msql query that loops through elemenets in a php array. The array is constructed from a multiple line list box.

Hi I have two databases ...1st is server database which is in MySql and 2nd is local database which i will create in oracle. I want to have some of fields of 1st database to be populate in in my local database which should be refreshed automaically ... plz let …

i need some help i wana talk about security in mysql 5.2.5 plz send me links (i searched mysql.com site and still i'm not able to get anything about mysql 5.2.5 , no informations were found) 10x

Hi. I know this is MySQl forum, but maybe some one help me through the below issue: I don't know which file I should download to install postgreSQL, could nayone please guide me which I should download ??? [URL="http://www.postgresql.org/ftp/source/v8.3.1/"]http://www.postgresql.org/ftp/source/v8.3.1/[/URL] I am using Windows OS.

Hi. I want to know how it is possible to write your own function "UDF" in MySQL? and how use that UDF in MySQL?

Is someone farmiliar with the travel database that installs with the netbeans installation? I can finally connect to the db and it shows folders to hold tables etc yet there is no tables in the folder. Is there a way to obtain the scrip for the travel db so I …

is it possible to add a number to a number that is stored in mysql db without extracting the stored number first. i have a count and i am updating the count periodically but i would like to know if i can update the count while it is in side …

after i have run my query on a mysql db how can i set the result to equal a variable that i will use later on in the page. i have set the query up like this [CODE] <?php $rand = rand (0, 100); $query = "SELECT broad1 FROM images_broad"; …

i have created a table to store the number of a count which i need for some subtraction at a later date. when i try to get the information out of the table instead of getting the number 5 i am getting resource id # 5. the table has been …

Hey guys, Is there any way that I can just simply get the length of a row in a table? Thanks

Hi, I wan to know where the MySQL variables stored? when I execute the [CODE]show variables; show status; [/CODE] I see many more variables, so I want to know the place they are stored in? and the file name too?

I am running a MySQL cluster test on 3 nodes. 1 management node 2 storage nodes. I can't seem to get mysql to start successfully. All 3 nodes are running Ubuntu Server 8.04 with MySQL 5.1 ... I know this is totally new, however, we are trying to test out …

Hi, I need to match rows from one table to another table that may or may not have a match on one common column.... the problem begins with bringing back the most recent row in the other table. So, the query I'm starting with is: [code]SELECT * FROM data LEFT …

Hello Is there a way i can have a MYSQL query to run automatically at a certain time without me running it myself?

Hi. I want to GRANT privileges on two tables, but I dont know why error, but on one table it is ok. what is wrong? [CODE]GRANT SELECT ON mysql.db, mysql.user TO 'user'@'localhost' IDENTIFIED BY 'password';[/CODE] I dont know why it is not working on two tables???

I am using adodb to import a CSV file into a MySQL database. One of the fields is lastname. One of the contacts being imported has a last name of 'null' (yes, that is really his last name). It always gets valued as a NULL value, not null the string …

I currently have a database that is just one table with products and is using the myisam engine for the fulltext capabilities on two columns. The question I have is that this database has about 390,000 rows with a lot of duplicate entries namely manufacturer, price. I have been searching …

Hi all, I wonder if it is possible that someone can drop me a code or something on this particular problem which I am currently dealing with. in_date out_date 18/03 30/04 20/04 So how am i supposed to pair up 30/04 and 20/04 as 1 pair and show it up …

Hi people. This is my first thread, i hope you can help me. I'm a newbie and my english is so bad, but, i hope you can understand me. this is my question: I've a table TURN with this field IDTURN (int) SEASON (string) SORT (string) another table GROUP IDGROUP …