MySQL Database Forum

I need to know how to add a column of numbers and get a total using my sql command. SELECT v.vid, title, purchdate, sum(cost) AS Total FROM Video v, Vidcopy vc WHERE vid.v = vid.vc I need to know how to add the cost column and get a total . Thanks for any and all help

I am trying to make a union query to join 4 tables. I have reduced the tables to just 5 fields and made sure that the field types and names are the same. I keep getting an error message ODBC call failed. I have tried various combinations of the tables and find that I can use any 2 of them but as soon as a third is included in the statement the...

Hi all , can anybody tell me the differance between the innidb and myisam tables types . sanjay --

Based upon an article I read in http://archives.neohapsis.com/archives/mysql/2004-q1/0337.html I am trying to retrieve an "empty row" of fields from a table that may be empty. If I have this query: This will return 1 single row whereby I have the table columns within

how can I limit the number of databases a user can create? I wish to create an account in mysql for each site on my host computer and set the max number of databases each site can create. can this be done? AndiC

HI all, I want to ask whether I can do replication in the following case. innodb (master) --replication --> myisam (slave) Rgds, Ringo --

I have installed MySQL 3.53 on two RH7.3 and one RH9.0 boxes. On one of the 7.3 and the 9.0 box, when I try to connect remotely, it takes about 45 seconds to connect, whereas the other 7.3 box connects almost immediately. The fast box has standard install of 7.3 with tomcat added. The 9.0 box is straight RH9.0 standard install. I can't...

This simple command always takes 0.30 seconds or longer: mysql> select foo from footable order by -foo limit 20; (get the 20 most recent foo's) This however, always takes 0.0 seconds: mysql> select foo from footable where foo>'2004-01-10' order by -foo limit 20;

Hello All, We are developing an application using PHP and MySQL 4.0.16, that we need to stress test. Can someone please point me to some testing tools we can use? Thanks. - Rajesh

Hello All, I'm wondering if anyone can tell me how to write an SQL statement that will select all records that are less than 10 minutes old, using a datetime column? Any help appreciated! Much warmth,

Suppose I have an innodb table in 4.0.14 and do: LOCK TABLE maggie INSERT INTO maggie values(123, 'simpson'); UNLOCK TABLES As soon as I issue LOCK TABLE, any transaction in progress is automatically committed. By what point is this INSERT guaranteed to be committed to disk

Getting the following message when I click on the MySQL shortcut on my desk top: Error Starting Program The msvcrt.dll file is linked to missing export ntdll.dll:Rtlgetntversion numbers. A device attached to the system is not functioning. Have gotten both Dll's and stuck em in the system and program directory...

I have a new DB provided by my ISP don't know details of installation, setup etc. I can log in as anybody except root. mysql -h localhost -u mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 71 to server version: 4.0.16-log mysql -h localhost -u xxxxx

I am coming across an annoying problem with a new InnoDB installation. On a 4Gig RAM box, Mysql doesn't seem to want to grab the RAM I am telling it to take. I would like for it to try and use around 3 Gigs for its innodb_buffer_pool_size, but it refuses to startup with anything greater than 512M. I bugged RedHat about it, and they had me...

Here's a SQL question a friend asked me recently...I came up with a solution, but I'm not sure it's the ideal one, so let me know what y'all think... His database has a table of actors in it, a table of movies, and an intermediate table ("casts") containing the keys from both. The tables are roughly like this: actors:...

I must learn SQL. Do you know any good book which I can found on-line? (and free of-course)

Hello, mysql, Yesterday,mysql process disappear sliently. After I check the err-log,no clues found. But the PID file still exising.I think the mysql terminate by some reason.But I still not found why. The error-log mysqld.log wouldn't provide any valueable msg.It just contains the shutdown & start up log. Any idea? Best regards.

I seem to be having a problem displaying time stored in mysql. The format stored in the database is 13:15:05. The database data type is time. I'm using asp vbscript and sql to retrieve the time store in the database. However asp recognizes the data type as date and displays the date instead of the time. If I change the data type in mysql...

I have a MySQL database and I want to cut and paste a part of it into my current MySQL database. is there a certain place that it has to be cut ? Here is a sample of the data, can someone tell me where I start the cut. # # Dumping data for table `category` # INSERT INTO `category` (`id`, `name`, `pid`, `fset`, `weight`, `image`,

Hi, I'm somewhat new to MySql. I've been using it for a while, but pretty much out of the box setup, and am starting to suffer heavily with my larger tables. I have a table with 5,000,000+ rows that I have to search and do joins on. Although I have an index set up for it, the joined select will still take some 400+ seconds to return,...

------=_NextPart_000_0000_01C34DF5.B670D500 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit I am running MySQL 4.0.12 on Windows XP. I am trying to create a library database and have a table named "cardCatalog" in the "library" database. The cardCatalog has the following fields: callNumber (varchar(60)),...

Hi, It is noted in the MySQL manual that unsigned integers bigger than 9223372036854775807 (63 bits) shouldn't be used itnarithmetic operations since signed BIGINT/DOUBLE is used in arithmetic functions. Can we somehow tell MySQL (probably during compilation) to use unsigned BIGINT/DOUBLE for arithmetic functions? (I know MySQL wouldn't...

Incident Information:- Database: d:/Lotus/Domino/Data/mail4.box Originator: <mysql@freebsd.csie.nctu.edu.tw> Recipients: <claes.bergsten@tjgroup.com> Subject: Re: That movie Date/Time: 21.08.2003 01:14:59 The file attachment your_document.pif you sent to the recipients listed above was infected with the W32/Sobig.f@MM virus. The...

I have decided to start learning MySQL, but I'm kind of a very old (long time) MS SQL programmer/designer. I'm use to using the GUI to interact with the database (Query Analyzer) and I like the Enterprise Manager too. Are there any quality freeware apps out there for doing this with MySql on a Windows XP platform? I've looked, but there are...

hi , I installed MySQL-server-4.0.14-0.i386.rpm MySQL-client-4.0.14-0.i386.rpm when I give mysqladmin -u root it is asking for password . The doc says that initially the password is empty and we just need to press enter . I read the mailing list posting but didnt find any clue i didnt set any password . mysql