Search Results

Search found 42428 results on 1698 pages for 'database query'.

Page 9/1698 | < Previous Page | 5 6 7 8 9 10 11 12 13 14 15 16  | Next Page >

• Create MySQL user and database from PHP

  - by snaken

  Hi, Is there a way to create a new MySQL database, a new MySQL user and give the new user priviledges on the new database all using PHP? I've seen examples where mysql_query is used like this: mysql_query("CREATE DATABASE ".$dbname)or die(mysql_error()); but i don't see how this would work as there's no database connection. Help please!

  Read the article

• EF query to fluent nhibernate query

  - by Shlomi Levi

  I have EF Query: IEnumerable<Account> accounts = (from a in dc.Accounts join m in dc.GroupMembers on a.AccountID equals m.AccountID where m.GroupID == GroupID && m.IsApproved select…

  Read the article

• Webcast - Oracle Database In-Memory Option

  - by Thanos Terentes Printzios

  Next to the recent announcement by Larry Ellison on the Future of the Database, we are happy to share this exclusive series of live webcasts from Oracle Database Product Management, where you can learn more about the brand new Oracle Database 12c In-Memory option. Oracle Database In-Memory is Oracle’s new…

  Read the article

• SQL SERVER – Copy Data from One Table to Another Table – SQL in Sixty Seconds #031 – Video

  - by pinaldave

  Copy data from one table to another table is one of the most requested questions on forums, Facebook and Twitter. The question has come in many formats and there are places I have seen developers are using cursor instead of this direct method. Earlier I have written the similar article a few years ago…

  Read the article

• SQL SERVER – Guest Post – Architecting Data Warehouse – Niraj Bhatt

  - by pinaldave

  Niraj Bhatt works as an Enterprise Architect for a Fortune 500 company and has an innate passion for building / studying software systems. He is a top rated speaker at various technical forums including Tech·Ed, MCT Summit, Developer Summit, and Virtual Tech Days, among others. Having run a…

  Read the article

• Should I comment Tables or Columns in my database?

  - by jako

  I like to comment my code with various information, and I think most people nowadays do so while writing some code. But when it comes to database tables or columns, I have never seen anyone setting some comments, and, to be honest, I don't even think of looking for comments there. So I am…

  Read the article

• ASP.NET Website Administration Tool: Unable to connect to SQL Server database

  - by MedicineMan

  I am trying to get authentication and authorization working with my ASP MVC project. I've run the aspnet_regsql.exe tool without any problem and see the aspnetdb database on my server (using the Management Studio tool). my connection string in my web.config is: …

  Read the article

• Firebird database corruption causes

  - by Rytis

  I am running several different Firebird versions (2.0, 2.1) on multiple entry level Windows-based servers with wildly varying hardware. The only matching thing between them is that they are running same home built application with the same database structure. …

  Read the article

• What is the best way to do testing database (MYSQL spesific)

  - by justjoe

  Right now i'm on testing something in a database. It's a wordpress database. i have to write and delete and do other operation on it. As you know it, it has indexing mechanism that will always make every new post inherit the next highest possible ID. Please…

  Read the article

• Need help choosing database server

  - by The Pretender

  Good day everyone. Recently I was given a task to develop an application to automate some aspects of stocks trading. While working on initial architecture, the database dilemma emerged. What I need is a fast database engine which can process huge amounts of…

  Read the article

• Optimize GROUP BY&ORDER BY query

  - by Jan Hancic

  I have a web page where users upload&watch videos. Last week I asked what is the best way to track video views so that I could display the most viewed videos this week (videos from all dates). Now I need some help optimizing a query with which I get the…

  Read the article

• A typical mysql query( how to use subquery column into main query)

  - by I Like PHP

  I HAVE TWO TABLES shown below table_joining id join_id(PK) transfer_id(FK) unit_id transfer_date joining_date 1 j_1 t_1 u_1 2010-06-05 2010-03-05 2 j_2 t_2 u_3 2010-05-10 …

  Read the article

• Help with SQL query (Calculate a ratio between two entitiess)

  - by Mestika

  Hi, I’m going to calculate a ratio between two entities but are having some trouble with the query. The principal is the same to, say a forum, where you say: A user gets points for every new thread. Then, calculate the ratio of points for the number of…

  Read the article

• Curing the Database-Application mismatch

  - by Phil Factor

  If an application requires access to a database, then you have to be able to deploy it so as to be version-compatible with the database, in phase. If you can deploy both together, then the application and database must normally be deployed at the same…

  Read the article

• What is the best database design and/or software to model a thesaurus?

  - by Miles O'Keefe

  I would like to design a web app that functions as a simple thesaurus : a long list of words with attributes, all of which are linked to each other. Wikipedia defines it as: In Information Science, Library Science, and Information Technology,…

  Read the article

• SQL SERVER – Powershell – Importing CSV File Into Database – Video

  - by pinaldave

  Laerte Junior is my very dear friend and Powershell Expert. On my request he has agreed to share Powershell knowledge with us. Laerte Junior is a SQL Server MVP and, through his technology blog and simple-talk articles, an active…

  Read the article

• Has anyone used these database publish tools in Visual Studio 2012/2013 ?

  - by punkouter

  I am trying to figure out if they are actually useful... I have a DBProject and it would be nice if when I publish from my DEV to my TEST it what automatically copy the schema and data from DEV to TEST.. is that what this tab in visual studio…

  Read the article

• 2 Servers 1 Database - Can I use Redis?

  - by Aust

  Ok I have a couple of questions here. First let me give you some background information. I'm starting a project where I have a node.js server running my application and my website running on another normal server. My application will allow…

  Read the article

• SQL SERVER T-SQL Script to Take Database Offline Take Database Online

  Blog reader Joyesh Mitra recently left a comment to one of my very old posts about SQL SERVER 2005 Take Off Line or Detach Database, which I have written focusing on taking the database offline. However, I did not include how to bring the…

  Read the article

• SQL, moving million records from a database to other database [migrated]

  - by Ryoma

  I am a C# developer, I am not really good with SQL. I have a simple questions here. I need to move more than 50 millions records from a database to other database. I tried to use the import function in ms SQL, however it got stuck because…

  Read the article

• Should each app have its own database, or should small apps be merged into one?

  - by King

  We have a bunch of small to medium sized apps, each of which has its own database (MSSQL Server). There was a suggestion that we consoldate the 'related' databases into a smaller set amount of larger databases. They don't particularly…

  Read the article

• How should I make searching a relational database more efficient?

  - by Travis J

  This is in the scope of a web application. I have a database which has a few nested relations. There is a feature which depicts the history of a large chain of relations. It is essentially a data analysis feature. The issue is that in…

  Read the article

• Best design for a memory resident tool

  - by Andrew S.

  I apologize if this tends more toward design that programming, but here goes. What design would you recommend for a database that is Memory resident Must run on windows, linux and (at a stretch) the mac Accept multiple queries…

  Read the article

• Prolog - How do you distinguish between just a string, and a variable? [closed]

  - by Mr Prolog

  When you are querying a Prolog database, often you will use terms that start with an uppercase letter as your variables. However, let's say that one of the constraints on your query is that a person's location must be "Dallas",…

  Read the article

• 3?????????????(Database??)

  - by rika.tokumichi

  ???????????OTN????????? ????GW????????????????????????????????????????????????????????? ???????????????????????????????????? ???Database??????????????3?????????????????????????????????? ??????????? 1?:Oracle SQL Developer…

  Read the article

< Previous Page | 5 6 7 8 9 10 11 12 13 14 15 16  | Next Page >