Ruby, MySQL: Connection pool that is outside of the rails framework?
- by Zombies
Is there a ruby gem or such for MySQL connection pooling that isn't part of rails? I simply have a ruby script (again, I don't do anything with rails).
Search Results
Search found 20838 results on 834 pages for 'mysql num rows'.
Page 234/834 | < Previous Page | 230 231 232 233 234 235 236 237 238 239 240 241 | Next Page >
-
-
How do I select a random record efficiently in MySQL?
- by user198729
mysql> EXPLAIN SELECT * FROM urls ORDER BY RAND() LIMIT 1; +----+-------------+-------+------+---------------+------+---------+------+-------+---------------------------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +----+-------------+-------+------+---------------+------+---------+------+-------+---------------------------------+ | 1 | SIMPLE | urls | ALL | NULL | NULL | NULL | NULL | 62228 | Using temporary; Using filesort | +----+-------------+-------+------+---------------+------+---------+------+-------+---------------------------------+ The above doesn't qualify as efficient,how should I do it properly?Read the article
-
Can MySQL do row level security or what Oracle calls virtual private databases?
- by JavaRocky
Does MySQL have any equivalent feature to Oracle's virtual private databases in 10g. It is also known as row level security. I prefer not to implement anything like columns and triggers. I am looking for a solution similar to Oracle's.Read the article
-
How to keep backup of our database in MySql.
- by Sanjeev
I want to keep backup of my database and import it into different System? and how to make .dmp or store file in MySql?Read the article
-
How can I employ "if exists" for creating or dropping an index in MySQL?
- by Paul
I was wondering if there's a way to check if an index exists before creating it or destroying it on MySQL. It appears that there was a feature request for this a few years back, but I can't find any documentation for a solution. This needs to be done in a PHP app using MDB2.Read the article
-
How can I connect to a mysql db from a different server ?
- by HJ-INCPP
Hello, I have, let's say, a root website with mysql db on a remote server. I want to connect to that particular database (to make queries), from many other little websites (with lower priviledges). Can this be done? Language: jsp,java,php Thank youRead the article
-
Sum of distinc rows after a 1-many table join
- by Lock
I have 2 tables that I am joining. Table 1 has 1-many relationship with table 2. That is, table 2 can return multiple rows for a single row of table 1. Because of this, the records of table 1 is duplicated for as many rows as are on table 2.. which is expected. Now, I have a sum on one of the columns from table 1, but because of the multiple rows that get returned on the join, the sum is obviously multiplying. Is there a way to get this number back to its original number? I tried dividing by the count of rows from table 2 but this didnt quite give me the expected result. Are there any analytical functions that could do this? I almost want something like "if this row has not yet been counted in the sum, add it to the sum"Read the article
-
Zend framework : how to extract a column from mysql result set?
- by understack
What would be the best way to extract a column out of mysql results set? My result set is like: [0] = ('id'=>1, 'name'=>a), [1] = ('id'=>2, 'name'=>b), [2] = ('id'=>3, 'name'=>c) How can I extract 'name' column as an array from this? I can do it using for loop. But wondering if there are any better reusable solution?Read the article
-
How to use Triggers for Logging History of database change in MySQL?
- by Parth
How to use Triggers for Logging History of database change in MySQL? If yes, then is it possible to create a sepearte db for trigger tables for tracking history of other Db tables??Read the article
-
Delete record in MySQL with php targeting auto_incremented int?
- by Chris_45
Why doesnt this delete work to delete the whole record: $query = 'DELETE FROM tblEvents WHERE index = $_GET["id"]'; $result = mysql_query($query, $db) or die(mysql_error($db)); Where index is variable of type int, auto_incremented in MySQL?Read the article
-
Is it possible to apply the Replication mechanism on single MySQL server?
- by Parth
Is it possible to apply the Replication mechanism on single MySQL server? I want to replicate the changes done in test db to Main db in the same server, so can i use this Replication mechanism on same server?Read the article
-
is there any way to catch ROLLUP (mysql) figures as values in php?
- by JPro
Hi, I am using group by ID WITH ROLLUP in my mysql query. The thing is I want to store these totals in a variable in php. Is there any way to do that? Thanks.Read the article
-
HOw do I show number of fetching of a data in a MySQL data base??
- by mathew
HI I would like to show to user how many time a data has been accessed. I am using MySQl and PHP...Read the article
-
How to get structed result using nested set in MySQL and PHP?
- by user198729
There is no limitation on the depth. How to get the structed branch or even entire tree? The definition is from here: http://dev.mysql.com/tech-resources/articles/hierarchical-data.htmlRead the article
-
Merged rows in column, bottom row fixed height
- by Styxxy
I've been struggling some time now with a specific problem using Tables in MS Word (2010). I have a table with 2 rows and 2 columns and the last column, the rows are merged. Now it can happen that this last cell will expand, and I would like to have the last row in the first column to be of a fixed height and the first row has to expand. What happens now is that the last row expands and the first row has a "fixed" height. A picture of the behaviour at this moment: And this is how I would like it to behave: I have been looking through all properties and settings, but I don't seem to find any option. Neither can I found anything by searching online (probably not using the exact right keywords). Any help is appreciated.Read the article
-
Migrating server, don't wanna lose MySQL data. Is Master-Master setup viable?
- by royh
I am moving to a new server and thinking about how to keep my 2 MySQL server data consistent is causing me to lose both sleep and hair. I was thinking about using a Master-Master setup to ensure that I lose nothing in the process. How viable is that. Any potential gotchas?Read the article
-
How to restrict user from modifying data in mysql data base?
- by Paul
We need to deploy application(developed by Java) WAR file in client place which make use of MySql 5.0. But we would like to restrict the user from modifying any data in the database. Is there any way to protect data. The client can make use of the application but they should not be able to change any value in database. How to do that?Read the article
-
How to select multiple rows by primary key in MySQL?
- by estourodepilha.com
SELECT * FROM `TABLE` WHERE (`PRIMARY_KEY`= `VALUE1`) OR (`PRIMARY_KEY`= `VALUE2`) OR (`PRIMARY_KEY`= `VALUE3`) OR (`PRIMARY_KEY`= `VALUE4`) OR (`PRIMARY_KEY`= `VALUE5`) OR ... This works. But is there a faster way?Read the article
-
How to parse a "Mysql result JSON String" in Javascript?
- by user330429
Is there a way to convert it into object form? So that each field of the result can be accessed results[i].field where i is the number of records in the mysql result.. This is my JSON String http://pastebin.com/Cky1va3KRead the article
-
How do I identify which MySQL slave has responded?
- by Kynth
I have a MySql Master server replicating to three Slaves. A legacy website is performing load-balanced Reads from the Slaves. Is there a method of identifying from the website which of the Slaves is serving a Read request? I'd prefer a function that I can use to return a server name or ip address as part of the SELECT, but any reasonable method will do. Thank you in advance.Read the article
-
How to save Excel date time cell into MySQL using VBA?
- by mysqlizor
The mysql table has a DATETIME field. I want to INSERT a new row into this field using the cell data from the Excel worksheet. But I cannot use the datetime formatted cell value in a INSERT INTO query. How can I implement this?Read the article
-
The least amount of code possible for this MySQL query?
- by ddan
I have a MySQL query that: gets data from three tables linked by unique id's. counts the number of games played in each category, from each user and counts the number of games each user has played that fall under the "fps" category It seems to me that this code could be a lot smaller. How would I go about making this query smaller. http://sqlfiddle.com/#!2/6d211/1 Any help is appreciated even if you just give me links to check out.Read the article
-
how do i delete all non filtered rows in Excel
- by oo
if i have an excel sheet and i filter by a certain column, how do i then delete all non visible rows?Read the article
-
ASP.Net (C#) & MSQL -or- PHP & MySQL for Performance?
- by Mike Curry
Money, Staff, Skill and preference to open source or commercial is neutral. Lets take the best of the best programmers (for arguments sake) and think about this: What will perform better overall: PHP & MySQL or ASP.Net & Microsoft SQL (I don't want biased answers, just looking for Performance, and Speed).Read the article
-
Whats the best way to backup a MySQL table without file privileges and command line access?
- by asdasd
Im on a not so great shared hosting plan. I cant get file privileges for mysql so i cant do SELECT INTO outfile, and i dont have command line access so I cant use mysqldump. What can I do to get a decent table backup?Read the article
