Forum: MySQL

Hello, I have a website hosted on Windows using asp pages to display ads. The database server is a MySQL server (4.1.15) on an other server...

Hi to everybody, I have upgrade to mysql 5.0.18 my linux box and when I'm trying to make any command in this table: select * from PROGETTO;...

let's say I did a simple query on a database like show tables; in java, i get a ResultSet how can I get the total number of rows in the ResultSet?...

Hello, i need to insert chinese signs in a table. but if i insert them, in the database there is only shown some weird values. do u know how i...

Hi, I made a form where visitors can introduce data. I use this: strsql="INSERT INTO mytable (field1,field2 ...) values('" & lol & "',#" & dat...

Dear all, could someone help me in such problem: in a loop a make a lot of (ca.1500) inserts to table1. I the some time I make select query on...

PHP has a function - gmdate - whereby one can get the GMT time from a timestamp. How might I do something like what this function does in MySQL? ...

Hi, if I try to install mediawiki, I get following mysql-error, during running config/index.php: "Specified key was too long; max key length is...

I have been asked to compose a query to return the metadata of a function or procedure (MySQL 5.0): argument names and types, IN or OUT, return...

I tried to create a temporary memory table using the following: CREATE TEMPORARY TABLE mytable_tmp LIKE mytable ENGINE=MEMORY; However, I...

I have a stored proceduren with a prepared statement inside, I would like to put the result fields into variables but I don´t know how, Should I...

Hey all, I want to give the user a dialog where they can find pairs of duplicate entries in the database and resolve these down to a single...

Consider two tables: Table_1 (id, data_1, data_2) Table_2 (id, data_2) How to load the `data_2` field from Table_2 to Table_1, which is...

I seem to have dug my way into a hole that's a bit over my head. I have a db laid out as shown here and I can query it with some very basic joins...

I have a number of scripts that generate queries where the number of rows I need is dynamic ( LIMIT 0,$rows ). Using MySQL 4.0 I can get all the...

I am in the process of writting a program, in my language of choice, (ooRexx) to perform the following conversion from BTrieve databases to MySQL...

I have a query I want to run using DBQwiksite siftware, which produces the syntax error (missing operator) in query expression error when...

I've built a page in Dreamweaver (php) pulling records from mysql with rand() order, displaying 1 record at a time with a navigation pane, it...

Probably not making myself clear with that subject. Here is what I want to do. I want to basically implement a FIFO (FirstInFirstOut) queue in...

Hi, I use a simple Master-Slave-Replication with one Master and one Slave.( MySQL 5.1.11-beta-log) If I crash's the slave (Power off) while...