Transactions in MySQL.

Hi All, How transactions and locking are handled in MYSQL? Is it a part of configuration? Or a query (lock tables, Unlock tables) for each set of queries? Regards, Ravi K The information contained in this electronic message and any attachments to this message are intended

adding columns to a large table

I have a table with about 3million rows and I'm having trouble altering it to add 4 more columns. I'm using the MySQL Administrator and I've left it more than 24hours and its still not finished. I was going to try using a login to the console next, but is there a better way? Any advice much

Re: SUM in WHERE

Ahh... I think I understand what you are trying to do now. The query will keep the cumulative total of the "Total" column... so, your data is 22, 41, 10, 40, 30, 20... After the 22 the cumulative total is 22 After the 41 the cumulative total is 22+41 or 63 After the 10 the cumulative total is

Re: Rapid application development

Hi Ahmad: I use CodeCharge Studio to develope aplications in PHP and MySQL. I haven't had to much complains, and you can make a whole app in a couple of days. Is not too expensive as well. Is very useful specially to create the forms. When I have to hand code, I use Eclipse. OpenSource and Free.

Re: SUM in WHERE

Hi I need the result to be 100 not to more or less than 100 here is my query : mysql> select version() ; ++ | version() | ++ | 4.1.21-log | ++ 1 row in set (0.00 sec) my table : CREATE TABLE `tbl_name` ( `ID` int(11) NOT NULL auto_increment, `Total` int(

Re: SUM in WHERE

Hi Ahmad I tested that example query with version 5.0.19. According to the manual, (http://dev.mysql.com/doc/refman/5.0/en/ansi-diff- subqueries.html) derived tables (subqueries in the "from" clause) should work in versions 4.1.x and up, so I'm not sure why it didn't work for you. In mo

Re: MySQL socket and logs locations

Russbucket wrote: I just check my install of mysql (version mysql-4.1.13-3.8 on SUSE 10.0) and the socket is in /var/lib/mysql and the mysqld log is in /var/lib/mysql. This is the mysql version that came with my 10.0 DVD. Did you use YAST to install? I don't know if these locations changed with t

Re: MySQL socket and logs locations

Peter Bradley wrote: > Hi, > > I've installed MySQL 5.0.24a-standard on my AMD 64, SuSE 10.0 box, using > the binary distribution from the MySQL downloads site. I've also > installed the GUI tools from the same location, using the SuSE 10.x rpm > packages. The intention is to use MySQL with PHP

Re: SUM in WHERE

doesn't work :( , tested with 4.1.21 On 21 Sep 2006 13:20:37 -, Felix Geerinckx <[EMAIL PROTECTED]> wrote: On 18/09/2006, "Ahmad Al-Twaijiry" wrote: > I want to run SQL query that will return to me the first records that > the SUM of Total field = 100 USE test; DROP TABLE IF EXISTS foo; CR

Re: SUM in WHERE

doesn't work :( , tested with 4.1.21 On 9/20/06, Douglas Sims <[EMAIL PROTECTED]> wrote: Following is one way of doing what you want. mysql> show create table t; +--- +--- --

MySQL socket and logs locations

Hi, I've installed MySQL 5.0.24a-standard on my AMD 64, SuSE 10.0 box, using the binary distribution from the MySQL downloads site. I've also installed the GUI tools from the same location, using the SuSE 10.x rpm packages. The intention is to use MySQL with PHP5 and Apache. Both these lat

Rapid application development

Hi Everyone, I know this isn't the right mail list, but I need your feedback as mysql users What is the best RAD (Rapid application development) do you use with MySQL to develop software or a web-based program ? and in which language is it ? (PHP, Perl, Java, ...etc). I like programming but one