MySQL Database Forum

I am using a class.database.php which I found on the web, the class has the following method: function resultCount() { $this->totalrecords = mysql_num_rows($this->queryid); if(!$this->totalrecords) { $this->return_error("Unable to count the number of rows returned");

I have any users who have hosting on my server and they want a MySQL User Account for their websites. How can I do to limit the space of their database following the plan of their hosting? If I can't set a limit they can put much more datas into database. Can You Help Me?

Hallo. Habe auf einem SeSE 9.1 Server due neue MySQL 4.1.11 und den dazugehörigen client installiert. #: mysql -V mysql Ver 14.7 Distrib 4.1.11, for pc-linux-gnu (i686) Soweit so gut der Server läuft auch. Nach dem ich die Datenbanken der Vorgängerversion 4.0.x in das

I am running mysql db’s under heavy load. How do I make sure that index is never updated to disk. This is the only way I can keep my machine from running hot. I understand that if there is a sudden reset of the machine, all the indecis need to be rebuilt. I guess that is the price to pay, or other ideas around that? Thanks.

Hi all, I have a client that is obsessed (actually paranoid) with security. One requirement he has is that any data deleted from a database be physically removed. This means not only within the scope of the database itself, but at the file level itself. For example, if a row in a table has a value of "foobar", and that row is deleted,...

Here is a problem I've encountered a few times lately: Given CREATE TABLE foo( id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, some_id INT NOT NULL, ts TIMESTAMP NOT NULL );

hi I'm trying to do something like this: UPDATE newusertable B SET B.username = A.username WHERE B.userid = A.userid FROM oldusertable A But it's not happening....any ideas? I've looked at insert ..into and create etc but nothing seems to provide the cross-table check i need to perform to ensure that the right entry is updated to the...

Hey! Can anyone give me a hint, how this problem is best implemented: I have a table of users (see below), where every user has one "superior user" (= parent node), this should be a fully unambigous tree structure. The root node can have whatever value you prefer, I suppose NULL would be good for a start. What I want to do is finding the...

Hi, Where can i get the download mysql.sock file? I am unable to connect to local server because i dont have this file? thanx in advance Sridhar

hi, I have a proplem creating a new user and/or adding additional information for root user in MySQL Administrator 1.0.19. When I do I get this message: error while storing the user information. Never the less, when I close the Admin program and open it again, the changes I tryed to make are saved, (althoug the program asked me if I...

I am trying to sort my shirts by size (S,M,L,XL). I've tried the line below but I can't get it to sort the way I need. Any suggestions? Thanks. snip... GROUP BY shirt ORDER BY shirt IN ('S','M','L','XL')

Hi all of you experts, OK, here goes. I am trying to figure out how to setup an ISP. I have broadband in my shop and was thinking, I could setup the house to call into my network and connect to the Internet through my DSL. I have servers with Mandrake 10.1 for web/mail/ftp. Was wondering if this could be done and what needs to be done for it...

Hi, All I have is an MDF and LDF file from a MS SQL database & I want to load them into MYSQL, but I don't have MS SQL. Any ideas? Is this possible? Any help or feedback is appreciated!! Thanks!!

How does one enter Unicode strings into a 5.0.3 MySQL table? I tried things like INSERT INTO tablename(colname) VALUES( _utf8'€©®á§A¦n') But this doesn't work. I guess I need an escape sequence, but the MySQL manual doesn't specify Unicode escape sequences, just for quotes, newlines and such... Thanks, Paul.

Hi, We tried 2 techniques to mesure db size and both fails to return realtime size. a) under innodb, we ’show variables’, find the innodb_data_file_path variable and parse the size (works only if not autoextend) and we substract the ’InnoDB free: ??? kB’ from the Comment field of ’show table status’.

Hi, could someone explain the following please? I have a Java application (app A) which "polls" a MySQL database table for records with a certain column set to 0. It runs continuously, utilising the same commection repeatedly. The other day, I had a support call raised, whereby there were clearly suitable records in the database, but my...

I'm looking for information on how to log on and access a databases using TCP/IP. I don't want to use MyODBC or J or .NET or anything else, I don't want to telnet and use a shell... I just want to send stuff over a port and get an answer back. As far as I understand it, I'm going to have to dissect libmysql.c. Ok, but hasn't somebody...

I have a new database table which contains name and url field. When I order by name I get two groups, the first being those without an entry in the url field, the second with an entry in the url field, each grou seperately ordered correctly. In a possibly related problem with the same table displaying in a web browser through php, there...

Hi, I've got a transactions table with a tstamp field (datetime type) and I need help creating a SELECT query to retrieve only last transactions that occured within the last 5 minutes. The datetime type writes the tstamp as YYYY-MM-DD HH-MM-SS and I am using mySQL 4.1. Please help.

I'm having a bunch of tables showing up with 145 errors (145 = Table was marked as crashed and should be repaired). Repairing them is easy enough. But I have a server with dozens of databases and hundreds if not thousands of tables on it. Is there any way to do some sort of server-wide check to see how many tables are in need of repair?

Hi! I am using a web hotel which is offering access to a MySQL database. The only way to make a backup is via a web interace. What I am looking for is a way to create a classic ASP script to get all the data, and send them in an e-mail. The e-mail part is no problem for me. Hope to get some ideeas from somebody :-)

Is there a way to achieve this through SQL.....I want to be able to have my output look like this: 1/1/05 20:00 2.5 units 1/1/05 21:00 5.5 units 1/1/05 22:00 3 units 1/1/05 23:00 1 unit >From a table that looks like this:

hi Isnt it true that floating type can generate rounding errors if the values are rounded to like the 10th decimal. Since currency is rounded only to the 2nd decimal why must i worry about using float for currency calculations? decimal is slow and memory hog. is it true that mysql calculates internally using double float?

Hi, i am searching for a simple database whith a webfrontend, which could be used in our intranet for archiving of development results, as a reuse database. The tool should handle complex software cores for a reuse library with a good search and find , resp. a description platform. A compact and nice know how management tool does anyone...

I have linux RH AS 3 server with these installations: #rpm -qa | grep mysql libdbi-dbd-mysql-0.6.5-5 mysql-3.23.58-1 mysql-devel-3.23.58-1 How can I upgrade to mysql 4.1 ? Should I try uninstalling the above first with all their dependencies or should I do a FORCE upgrade over it ?