Search Results

Search found 14310 results on 573 pages for 'mysql sock'.

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

• 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

• 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

• Easiest way to choose a percentage of an amount of rows from a MySQL table?

  - by Rob

  I have a script that has a GET variable: $_GET['percentage'] I have a MySQL table of data. Now lets say that there are 100 rows of data in this table. In pseudo-code: SELECT data FROM table Now would it be possible to select $_GET['percentage'] of random data from table? For example (again in pseudo-code): $_GET['percentage'] = 10; SELECT 10% of data from table order by rand() If this IS possible, how could I do it?

  Read the article

• Sorting mysql array value after string chars swapped from fetched DB data.

  - by Shail Patel

  I want to sort one column fetched from mysql DB, and stored in an array. After fetching I am doing below steps. 1- DB Fetching fields array in row format. ->Field1, Field2, Field3, Field4, Field5 2- From that fields array One columns data [Field3], swapping string keywords. eg. AB013, DB131, RS001 to->013AB, 131DB, 001RS Now I want to sort above value in new string format like-> 001RS, 013AB, 131DB

  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

• 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

• 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 many millions records can Mysql reasonably deal with with .NET ?

  - by asksuperuser

  Anybody can tell his experience with MySQL and .NET dealing with millions of records ? Need to be able to cope with 50 to 100 Millions records.

  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

• 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

• 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

• 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

• 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

• Is there a way to delete the most recent entry in MySQL using PHP?

  - by user300371

  I want to delete the most recent entry in MySQL using PHP, is there a function that allows me to do that? $query2 = "DELETE FROM test WHERE ___";

  Read 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 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 can we re-use the deleted id from any MySQL-DB table?

  - by Parth

  How can we re-use the deleted id from any MySQL-DB table? If I want to rollback the deleted ID , can we do it anyhow?

  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

• 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

• 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

• 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/Cky1va3K

  Read the article

• How should i store availability calendar information in mysql? for [id] [date] [available/unavailab

  - by Haroldo

  I'm building a simple calendar for holiday cottages to show when they are booked or available. What would be the fastest mysql table design for this, bearing in mind when users mark dates as available/booked they will do so via a start date and an end date. i can see 2 obvious options Store 'booked' data for every day [more rows] or, store 'booked' data with 2 columns a start_date and end_date [more processing?] Which is best or is there another method i'm missing?

  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

• Best way to build a SMART mySQL & PHP search engine?

  - by Kyle R

  What is the best way to build a mySQL & PHP search? I am currently using things like %term% I want it to be able to find the result even if they spell it slightly wrong, for example: Field value = "One: Stop Shop: They search: One Shop Stop OR One Stop Shop Etc.. I want a really smart search so they find the information even if they don't search the exact thing. What is the best way to build a smart search like this?

  Read the article

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