I am new to the Visual Studio thingy. I have MS SQL Server 2005 and 2008 preinstalled in my Windows Vista computer. Are they real servers? Or just some add-on for their server and I need to buy a server version of Windows for it? If not, how to run them? How to add a database, etc.? And basically how to connect Visual Studio 2008 to M...
I have a MySQL query: SELECT DISTINCT c.id, c.company_name, cd.firstname, cd.surname, cis.description AS industry_sector FROM (clients c) JOIN clients_details cd ON c.id = cd.client_id LEFT JOIN clients_industry_sectors cis ON cd.industry_sector_id = cis.id WHER...
I need to select all email addresses from a table, but implode them by ;. Is it possible for me to do this only utilizing a single MySQL query? ...
Hello, Currently this function works : it displays for a specific game, how many jobs there are. The problem : If there is no job, the game does not appear on the list. How to display the game even if there is no job attached ? Thanks public function getWithGames() { $q = $this->createQuery('c') ->leftJoin...
I've recently developed a c# application that uses a mysql connector. I've run into some issues with other computers not having the Mysql.Data library. So my question, what is the best way to deploy a c# application that uses these Mysql.Data libraries? Install the mysql connector on every computer? Is there some way I can make c# packag...
Here's a sample table: name | picture John S. | http://servera.host.com/johns.png Linda B. | http://servera.host.com/lindab.png ... Let's say there are several hundred more records. Let's also say we moved servers from "servera" to "serverb". Would it be possible to go into this table with one query to rename the c...
UPDATE RIA.Contact SET title = REPLACE(title, 'Cheif', 'Chief') where title rlike 'Cheif'; UPDATE RIA.Contact SET title = REPLACE(title, 'Manger', 'Manager') where title rlike 'Manger'; UPDATE RIA.Contact SET title = REPLACE(title, 'Manging', 'Managing') where title rlike 'Manging'; UPDATE RIA.Contact SET title = REPLACE(title, 'Excutive...
I am in the process of building a PHP/MySql database application which could have heavy usage on certain tables. Three tables have the potential to have lots of UPDATEs executed - here is some information about these tables each user will have a maximum of 200 rows per table each row can be as large as 250k potential user base may be...
I'm trying to develop a voting system in PHP for my posts where visitors can vote them up or down and then I should be able to sort posts by highest/lowest rated. Can anyone please recommend a good script I can use for this? ...
Here's the basic layout: Table1: id 1o, blah id 11, test Table2: id 1, 10, some info id 2, 10, more info id 3, 11, more info What query using sql would allow me to display the results like so, when using php and mysql_fetch_object: 10, blah, more info, some info 11, test, more info Right now, I have: select * ...
I need to save the credit card numbers and secret codes of users in the database in plain text ( consensus behind obviously ) for automatic operation made from the server. Is there some problems ? What do I need to be aware of? ...
I am using cake php and mysql. I have several tables that all link up to a table called relates. The relates table holds the primary ids for all the other tables. example I have a table called clients its primary key is called id in the relates table its called client_id. heres my deal i created a crud application in cakephp it works...
If I have a query like this: INSERT INTO map SELECT 5, product_id FROM products WHERE price < 500 ) Say this tries to insert 300 rows into the map table. Say 20 of the inserts generate duplicate key errors. Will the other 280 rows be inserted or will the entire query fail? If so, what is the best way to write this query so that t...
How can I import an excel file into my SQL database? I have two options, MSSQL or MySQL. Thank you ...
I have a query that is grabbing the Date of a given post. I'm displaying this information in a chart that has the date and number of posts for that day. How can I display "Friday, Oct 15" instead of 2010-10-15?? Query: $oct_week = mysql_query("SELECT COUNT(*), DATE(`dPostDateTime`) AS `day` FROM `tblQA` WHERE dPostDateTime >= '2010-10-...
hi, I have a litte problem with a mysql query. I use 5 tables: user_has_data (uid, dataid); users (uid, uname); user_in_group(uid, groupid, data); groups(groupid, data, packageid); packages(packageid, name) all ids are PK. I want to build a sql query that finds a user, which belongs to a specified dataid, by its uname and checks if t...
Hey Guys, I'm looking at accepting a project that would require me to clean up an existing e-commerce website. Its been relatively successful and has over 100,000 individual products - loaded both by the client and its publishers. The site wasn't originally designed for this many products and has become fairly disorganized. SO, the cl...
The following is my query: SELECT COUNT(*), TIME_FORMAT(HOUR(`dPostTime`), '%l %p') AS `hr`, HOUR(`dPostTime`) AS 'hour' FROM `tblQA` WHERE dPostDateTime >= '$_POST[startDate]' AND dPostDateTime <= '$_POST[endDate]' AND dPostTime <> '0000-00-00 00:00:00' GROUP BY `hour`" I have the data posting to a table through a php while loop. It'...
I am developing a program in Python that accesses a MySQL database using MySQLdb. In certain situations, I have to run an INSERT or REPLACE command on many rows. I am currently doing it like this: db.execute("REPLACE INTO " + table + " (" + ",".join(cols) + ") VALUES" + ",".join(["(" + ",".join(["%s"] * len(cols)) + ")"] * len(data)...