Search Results

Search found 23821 results on 953 pages for 'mysql group by'.

Page 249/953 | < Previous Page | 245 246 247 248 249 250 251 252 253 254 255 256  | Next Page >

• 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

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

• 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

• reclaim space after moving indexes to file group

  - by Titan2782

  I have an extremely large database and most of the space is the index size. I moved several indexes to a different file group (just to experiment) but no matter what I do I cannot reduce the size of the MDF. I tried shrink database, shrink files, rebuilding clustered index. What can I do to reclaim that space in the MDF? I've moved 15GB worth of indexes to a different file group. Is it even possible to reduce my mdf by that same 15gb (or close to it)? SQL Server 2008 Enterprise

  Read the article

• My Java regex isn't capturing the group

  - by Geo

  I'm trying to match the username with a regex. Please don't suggest a split. USERNAME=geo Here's my code: String input = "USERNAME=geo"; Pattern pat = Pattern.compile("USERNAME=(\\w+)"); Matcher mat = pat.matcher(input); if(mat.find()) { System.out.println(mat.group()); } why doesn't it find geo in the group? I noticed that if I use the .group(1), it finds the username. However the group method contains USERNAME=geo. Why?

  Read the article

• Which is more efficient in mysql, a big join or multiple queries of single table?

  - by Tom Greenpoint

  I have a mysql database like this Post – 500,000 rows (Postid,Userid) Photo – 200,000 rows (Photoid,Postid) About 50,000 posts have photos, average 4 each, most posts do not have photos. I need to get a feed of all posts with photos for a userid, average 50 posts each. Which approach would be more efficient? 1: Big Join select * from post left join photo on post.postid=photo.postid where post.userid=123 2: Multiple queries select * from post where userid=123 while (loop through rows) { select * from photo where postid=row[postid] }

  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

• 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

• 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

• 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

• PHP - get MySQL query results as their native data type?

  - by redidas

  I've tried fetching MySQL query results using mysql_fetch_row() mysql_result() and numeric values are being returned as strings. Is there any way to fetch the data as its datatype stored in the table? The application will be querying many different queries so I will be unable to cast the values as the intended datatype on a 1 by 1 basis.

  Read the article

• Magento - Change Customer Group on purchase of specific product

  - by Gaurav

  Hi, I am developing a purchasable video website having different videos in different categories. It needs membership functionality in which if customer purchase membership then he/she will have all videos free for one year. For that I can create a membership product and if any customer purchase this membership product he/she will fall/switch into ‘Members Customer Group’ and then I can give 100% discount for all products for customers that are in group ‘Members Customer Group’. But I have no idea how I can achieve this? Can anyone please guide me how I can change the customer group on purchase of membership product? Thanks

  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 do I restore from a drop database command using a mysql binary log?

  - by azl

  How can I restore a mysql database that was dropped using a "drop database" command? I have access to binary logs which should make this type of rollback possible.

  Read the article

• mysql: how do i get a list of databases available?

  - by every_answer_gets_a_point

  i am using wampserver i opened the mysql prompt i would like to know which databases i am able to connect to/view. how do i do this?

  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

• Can I restore a single table from a full mysql mysqldump file?

  - by Mobius

  I have a mysqldump backup of my mysql database consisting of all of our tables which is about 440 megs. I want to restore the contents of just one of the tables form the mysqldump. Is this possible? Theoretically, I could just cut out the section that rebuilds the table I want but I don't even know how to effectively edit a text document that size.

  Read the article

• Can I use ALTER DATABASE to rename a mysql database?

  - by thearchitect

  I am using PDO with PHP to create a new database and then a new user with privileges on that database. In case one of them fails, I want to rename the database and user so that they can be deleted later and the names are available. Is it possible to rename a mysql database using the ALTER DATABASE?

  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

• Retrive all data from mysql table using fluent nhibernate step by step process..

  - by chandru_cp

  As i am a newbie to fluent nhibernate i would like to get step by step tutorial that explains configuring mysql with fluent nhibernate and retriving a table data from it... Any suggestion....

  Read the article

• How do I escape reserved words used as column names? MySQL/Create Table

  - by acidzombie24

  I am generating tables from classes in .NET and one problem is a class may have a field name key which is a reserved MySQL keyword. How do I escape it in a create table statement? (Note: The other problem below is text must be a fixed size to be indexed/unique) create table if not exists misc_info ( id INTEGER PRIMARY KEY AUTO_INCREMENT NOT NULL, key TEXT UNIQUE NOT NULL, value TEXT NOT NULL)ENGINE=INNODB;

  Read the article

• ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using Password:YES) [duplicate]

  - by sivashanmugam

  This question already has an answer here: MySQL command appends '@localhost' to username 1 answer Mysql - Access denied for user 'root'@'x.x.x.x' [duplicate] 7 answers root@test-2:/usr/local# mysql -u root -H 192.168.x.xxx -p Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

  Read the article

• COCOA Objective-c : How can connect to mysql database?

  - by kalps1982

  I am creating application for MAC using cocoa framework, I would like to know how and what are the ways i can connect to MySql database using cocoa framework.

  Read the article

• [Win32/MFC] Making group-boxes contain things

  - by John

  As I understand it, a group-box is just another control. Controls inside it are not owned by it, so unlike in Winforms, if you move a group-box the contained controls stay put. What would be the nicest way to address this? Just create your own data-structure mapping controls to 'container' group-boxes so that when the container is moved the children are automatically moved?

  Read the article

< Previous Page | 245 246 247 248 249 250 251 252 253 254 255 256  | Next Page >