Search Results

Search found 14016 results on 561 pages for 'mysql like'.

Page 219/561 | < Previous Page | 215 216 217 218 219 220 221 222 223 224 225 226  | Next Page >

• 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).

  Read the article

• How to make phpMyAdmin ask for my username and password

  - by anitha

  I am using rhel 5 and php 5 with mysql 5. My server is already configured and running all applications smoothly. I am accessing mysql as root and supplying my password. However, when I access phpmyadmin through browser, it is not asking for my password. Somebody please tell me how can I set it to prompt for username and password. Since I am not familiar with php and mysql please tell me how to do it in simple way.

  Read the article

• restrict the scope of variables in a mysql query? with brackets?

  - by Haroldo

  I can't remember what the method is meant to be for ensuring the scope of a variable in a query is restricted to prevent mysql injection. where should i put brackets in the following examples? UPDATE table SET col_1 = '$var', col_2 = '$var2' WHERE col_1 = '$var3' and SELECT * FROM table WHERE WHERE col_1 >= '$var1' (Obviously looking for answers not using PDO!)

  Read the article

• In MySQL, if the movies table has a description field, how to do search on this description?

  - by Jian Lin

  Say, using MySQL, if the movies table has 20,000 records, and each record has a field that is the description of the movie, up to 2k byte long. How can we search for movies with the word "nature" in its description? If possible, it is to be fast, instead of going through all the 20,000 records. (if in some other situations, like for books, where n can be 200,000 or more).

  Read the article

• How to upload 10 Go of data to MySQL programmatically without crashing like on PHPMyAdmin?

  - by asksuperuser

  I'm very surprised that it seems impossible to upload more than a few megabytes of data to mysql database through PHPMyAdmin whereas I can upload a msaccess table easily up to 2 Gigabytes. So is there any script in php or anything that can allow to do so unlike phpmyadmin ?

  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 to connect asp.net Crystal report with mysql.

  - by Ayyappan.Anbalagan

  how to connect asp.net Crystal report with mysql database. like sql server database connection .is there any connector available to do this..

  Read the article

• Creating a mySQL query using PHP form dropdowns - If user ignores dropdown, do not filter by that pa

  - by user303043

  Hello, I am creating a simple MySQL query that will be built from the user selecting options from 2 dropdowns. The issue I am having is that I would like each drop down to default that if they do not actually choose an option, do not filter by that dropdown parameter. So, if they come in, and simply hit submit without choosing from a dropdown they should see everything. If they come in and pick from only one of the dropdowns, the query will basically ignore filtering by the other dropdown. I tried making <OPTION VALUE='any'>Choose but my query didn't know what to do with the 'any' and just shows no results. Here is my code. Thank you very much for whatever help you can provide. FORM <form method="POST" action="<?php echo $_SERVER['REQUEST_URI']; ?>"> <select name="GameType"> <OPTION VALUE='any'>Choose Game Type <option value="Game1">Option 1</option> <option value="Game2">Option 2</option> <option value="Game3">Option 3</option> </select> <select name="Instructor"> <OPTION VALUE='any'>Choose Instructor <option VALUE="InstructorA">Instructor A</option> <option value="InstructorB">Instructor B</option> <option value="InstructorC">Instructor C</option> </select> <input type='submit' value='Search Videos'> </form> MYSQL <?PHP connection stuff $db_handle = mysql_connect($server, $user_name, $password); $db_found = mysql_select_db($database, $db_handle); if ($db_found) { $SQL = "SELECT * FROM Videos WHERE GameType=\"{$_POST['GameType']}\" AND Instructor=\"{$_POST['Instructor']}\""; $result = mysql_query($SQL); while ($db_field = mysql_fetch_assoc($result)) { echo $db_field['ShortDescription'] . ", "; echo $db_field['LongDescription'] . ", "; echo $db_field['GameType'] . ", "; echo $db_field['NumberOfPlayers'] . ", "; echo $db_field['Instructor'] . ", "; echo $db_field['Stakes'] . ", "; echo $db_field['UserPermissionLevel'] . ", "; echo $db_field['DateCreated'] . "<BR>"; } mysql_close($db_handle); } else { print "Database NOT Found "; mysql_close($db_handle); } ?>

  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

• Is there a way to make Linq to Entities map unrecognized methods/functions to MySql functions?

  - by Luiscencio

  Is there a way to make Linq to Entities map unrecognized methods/functions to MySql functions? I want to add support to some functions like Convert.*

  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

• import a text file into a temporary table using 'Load data infile' in a stored procedure- MySQL

  - by Pankaj

  I need to import a text file into a temporary table and from that select portions of it to insert in different tables. I wanted to use 'LOAD DATA INFILE'. Is there any way, i can use 'Load data infile' in a stored procedure. I am using mysql. LOAD DATA LOCAL INFILE 'C:\\MyData.txt' INTO TABLE tempprod fields terminated by ',' lines terminated by '\r\n'; SELECT * FROM product p;

  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 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

• 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

• Is there a way to listen for changes in an MySQL database table using Java and JDBC?

  - by adrian7

  I have a number of users which are logged in at a time in my desktop application. They are working on the same table (create, read, update, delete data) so I have to update their views, to reflect changes, every few seconds - currently I am thinking to use a different thread to do that. I am using the MySQL database engine. Is there a way, using JDBC, to listen for changes on a specific table in the database and triggering a Java method only when changes are made?

  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 you

  Read the article

• MYSQL trigger to select from and update the same table gives error #1241 - Operand should contain 1 column(s)

  - by Bipin

  when i try to select and update the same table mysql gives error error #1241 - Operand should contain 1 column(s) The trigger is DELIMITER $$ CREATE TRIGGER visitor_validation BEFORE INSERT ON ratingsvisitors FOR EACH ROW BEGIN SET @ifexists = (SELECT * FROM ratingcounttracks WHERE userid=New.vistorid AND likedate=New.likevalidation AND countfor=New.likeordislike); IF (@ifexists = NULL) THEN INSERT INTO ratingcounttracks(userid, likedate, clickcount,countfor) values (New.vistorid, New.likevalidation ,'1',New.likeordislike); ELSE UPDATE ratingcounttracks SET clickcount=clickcount+1 WHERE userid=New.vistorid AND likedate=New.likevalidation AND countfor=New.likeordislike; END IF; END$$

  Read the article

• how do I display list of URLS say maximum 50 per web page from MySQL database??

  - by mathew

  I do have thousands of urls in my database. what I want to do is display all urls in multiple pages say number of URLS per page is 100 and alphabetically then when ever a user search for a URL info it should get updated on relevant page. for example if it is google.com then it should get updated on "G" page and no duplicate entry. how can I do this with PHP and MySQL??

  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

• How to hack MySQL GROUP_CONCAT to fetch a limited number of rows?

  - by Misier

  I somehow need this feature,but MySQL doesn't support it at this moment. I'm using GROUP_CONCAT(CONCAT(...)) to generate a xml-like stuff. But when the size exceeds the limit,the xml is just broken! So I have to somehow make it only retrieve 5 rows !

  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

• 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 send multiple row to mysql at same time(like bulk copy)?

  - by Ayyappan.Anbalagan

  I am using asp.net + Mysql. I have multiple rows in my dataset; I have to store the rows in my database table. How to do that?

  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.html

  Read the article

< Previous Page | 215 216 217 218 219 220 221 222 223 224 225 226  | Next Page >