How would I create a core-data application that syncs with a MySQL database? Should I implement a SQL-Lite layer and try to sync with MySQL that way? Or would running web services be better? I want to take advantage of Core Data modeling though. Is there any way to use Linq? I love linq. ...
Is there a free solution for using Linq and MySQL? Can one use Visual Studio Express, Linq, and MySQL together? ...
hi i was trying to do a query in drupal which selects every row in table, i was having an issue with the no of rows i was able to query for the query is working for 300row limit but if i increase it 400 it is going blank page. $total_terms = 300; $query = "SELECT N.nid ,N.tid FROM term_node N "; $query_result = db_query_range($query, $...
Hello, I realize that the exact question has been asked before on stack overflow with only a vaguely conclusive answer: link So here it is again. Table A: Has an integer column which is nullable, along with an index. Query: SELECT * from table WHERE column IS null LIMIT 10; Will an index be used, or will mysql do a full table scan un...
I have a two tables for ex: cities - id_city, city_name properties - id_property, id_city, property_name I want to display cities.city_name and next to it [properties.count(id_city)] How do I make a query that still return ZERO if no records founds istead on NULL so I get results like London [123] New York [0] Berlin [11] and NEW...
And another one would be do I really need to have a license? I mean Bing Maps is running just fine. ...
Hi everyone, I'm coding a website in PHP/MySQL and I'd like to implement a similar to stackoverflow tagging engine. I have 3 relevant tables in DB: 1. Items 2. Tags 3. ItemTagMap (maps tags to items, n:n mapping) Now, on search page I'd like to show distinct list of all tags for entire search result (not just the current page), so that...
Can I reset the auto-increment index of a MySQL table so that it starts counting from zero again? I deleted all the rows in the table--how can I reset that counter as well? ...
With MySQL I often overlook some options like 'signed/unsigned' ints and 'allow null' but I'm wondering if these details could slow a web application down. Are there any notable performance differences in these situations? using a low/high range of Integer primary key 5000 rows with ids from 1 to 5000 5000 rows with ids from 20001 to...
setup: mysql> create table product_stock( product_id integer, qty integer); Query OK, 0 rows affected (0.17 sec) mysql> create table product( product_id integer, product_name varchar(255)); Query OK, 0 rows affected (0.11 sec) mysql> insert into product(product_id, product_name) values(1, 'Apsana White DX Pencil...
Hi guys I'm in a bit of a pickle here now. Well to start with I built a simple CMS in PHP with an admin panel the directory structure is like this: root/ ->admin/ ->images/ It worked fine as is however the client requirements changed and they wanted that instead of having to access the admin folder as a folder within the root ...
I've been using pear packages in php for years. I'm in the process of upgrading/moving a sites that uses the MDB2 pear package and it has not been updated for PHP 5.3.X. In 5.3, MDB2 is returning those new annoying errors. Unknown: Assigning the return value of new by reference is deprecated in /usr/local/lib/php/MDB2.php on line 390 ...
Platform: Windows XP, Qt Creator Ide 4.5.2 MySql is setup here as well. I want to establish database connection with Qt and mysql. The line QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL"); generates error like below: QSqlDatabase: QMYSQL driver not loaded QSqlDatabase: available drivers: QSQLITE QODBC3 QODBC It seems QMYSQL ...
Hi, is there a way to delete a relation only if it exists in the table? If not, Whats the best approach when deleting a relation in a table: Check if the relation exists. If it does then delete. (2 operations) Delete and catch the error if it didnt exist. (1 operation) Thanks ...
setup: create table product_stock(product_id integer, qty integer, branch_id integer); create table product(product_id integer, product_name varchar(255)); insert into product(product_id, product_name) values(1, 'Apsana White DX Pencil'); insert into product(product_id, product_name) values(2, 'Diamond Glass Marking ...
setup: mysql> create table product_stock( product_id integer, qty integer, branch_id integer); Query OK, 0 rows affected (0.17 sec) mysql> create table product( product_id integer, product_name varchar(255)); Query OK, 0 rows affected (0.11 sec) mysql> insert into product(product_id, product_name) values(1, 'Aps...
I have three tables with a one to many relationship as shown below. What I would like to do is select all the data from "tblOne" based on their relationship to "tblThree". So without having a query to get all tblTwoIDs I would like to select from tblOne where tblThreeID equals an "Inputed Value" Hope this makes sense, Thanks Ben tblO...
Short Version I'm currently looking into an issue with MySQL collations and how they affect a Set of values (which is mapped using Hibernate, but that shouldn't matter for now). I want to have a Set of Strings using the same collation as MySQL uses. E.g. I want "foobar" and "fööbar" considered equal but "foo bar" and "foobar" considered...
Say I have this two-column table id | column_test 1 | NULL 2 | NULL 3 | NULL ... as you see, the column_test column now all have value 'NULL'. Now I want to do an update to this table and the final status should look like : id | column_test 1 | a 2 | b 3 | c ... I know little about compound SQL state...
HI , I am stuck with a little thing, I need to allow muplite users to be able to login my php code works with one member how can I make it so mulitple users can login, If there is a better way using MySql please let me know $upload_username = "username"; $upload_password = "password"; Thanks ...