7,494 Archived Topics
Remove Filter  | |
| | A new site that I have to work with requires me to use putty to connect to the site if I want to work remotely as opposed to logging in to their phpMyAdmin to manipulate my data.. I am unfamiliar; please read that has having no knowledge of how to … Databases mysql |
| | |
| | # Query_time: 6.081227 Lock_time: 0.000085 Rows_sent: 1 Rows_examined: 1339 SELECT COUNT(id) FROM `article` WHERE `category` = 'shkrime-te-perkthyera' Is there a way to speed it up. Should I index the category column? Or what do you suggest? I use this query to get the number of articles on that category! Databases mysql |
| | Hi all, (this is a repost from [URL="http://www.daniweb.com/forums/thread112412.html"]here[/URL]) I'm working on a relational data model in which I'd like to store boolean expressions. I'm a little rusty so I'm humbly asking for a little push. For example, let's say I have the following boolean expression: [code]((A = 8 OR A … Databases |
 | Dear all, I'm stucked with my XML problem. I have these stored procedures to save XML data into server hard disk. [CODE]CREATE PROCEDURE dbo.sp_XML_Employee(@Database varchar(10), @FileName Varchar(2000)) AS DECLARE @bcpCommand varchar(4000) SET @bcpCommand = 'bcp "SELECT EmployeeID, EmployeeName FROM ' + @Database + '.dbo.MasterEmployee ORDER BY EmployeeID FOR XML RAW(''Employee''), … |
| | Hello, I'm working on a website that will be based on user contributed data, submitted using a regular HTML form. To simplify my question, let's say that there will be two fields in the form: "User Name" and "Country" (this is just an example, not the actual site). There will … Databases database-design |
| | Hi, I am trying to set up a section on a site where the results that are shown come from a table. I want to get the number of the 'current_round' then subtract 1 from it and use that value. I have looked up MySQL dev site, and assume that … Databases mysql |
| | Hi, I am trying to display some results where one column is equal to another column in a table. End goal: display all the results where the round and current round are the same number for every team in the table. the number of teams will change as the number … Databases mysql |
| | Hi all, I need to design a database for the below requirement. SuperAdmin [Myself - Final Approval] | Admin [Client User for Approval] | User [ Client User for data Entry] How can I implement the following requirement. Kindly help. Dev. Databases database-design  |
| | hey i have two tables in a database that i will like to join in the below code, but i cant. i can only use one table at a time. $result = mysql_query("SELECT name,price from products WHERE itemid = '$id'",$cxn) or die ("Unable to retrieve information from database"); if i … |
| | Hi everyone, This is the error i am getting when i try to do SqlCommand.ExecuteNonQuery(). My application runs on multiple threads and constantly opens, executes and close connection. This error i am getting after running the application for some time. Error: System.Data.SqlClient.SqlException: A transport-level error has occurred when receiving results … |
| | hi all I'm trying to write a procedure/function in pl sql that get the user's password, encrypting it with md5 algorithm and inserting it into the USERS table. any 1 knows how to do so? i know that md5 is not a good algorithm but i dont care cuz its … |
| | Hello, I'm using Windows 7 Ultimate 64bit. I'm on admin account and all I want is to develop my ASP.NET pages on my main system - not only on virtual machine with XP istalled. The problem is that I cannot access the database on Win 7. IIS is working, ASP.NET … |
| | Hi, Hello all. I installed SQL Server 2005 on Windows 7 together with SP3. I set the surface area configuration to allow TCP/IP and named pipes. When i try to connect the machines running SQL, i fail, i cant access it. Neither can i change any settings in the surface … Databases microsoft-access mssql sql windows-server |
| | Hi, what tables shoud I put into database of online shop? I think about cart table, categories and products tables and ... - I do not know what else I can add into. How can I store for example pictures of products in my database? Is there any tutorials you … Databases |
| | Hi all ! I 'm a newbie in SQL and has just install the Oracle 10g Express Edition. When using its SQL Command in the Web-interface, I took an error with the GROUP BY, as follow : First, I create a table DEPARTMENT, here 's the code : [CODE] CREATE … |
| | Hello. Im wondering if anybody can help me out on a problem I am having for my SQL class. I have been going round in circles for the last three hours and am about ready to give up. The brief asks that I design a query that performs a division … Databases database-design oracle |
| | hello experts... i have a table employee and in it are attributes like name gender,birthdate...etc.. apart from this i want to automatically generate d employees age from d current date....how can it be done?? thankyou... Databases oracle |
| | I have a table and I want to start the select with the 20th row. How do I do this? Does conditionals work on "limit" Databases mysql |
| | For the first time, I am developing in an environment in which there is a central repository for a number of different industry standard reference data tables and many different customers who need to select records from these industry standard reference data tables to fill in foreign key information for … Databases user-interface |
| | Hey I am trying to run this in php: [code]// Retrieve data from table where row that match this passkey $sql1="SELECT * FROM $tbl_name1 WHERE confirm_code ='$passkey'"; $result1=mysql_query($sql1) or die(mysql_error())[/code] and I get this error: [code]You have an error in your SQL syntax; check the manual that corresponds to your … |
| | Hello, I've been trying to find a way, using Oracle Express, to return more than one column but have only one column be distinct. The following will make all three columns distinct. I want only the Job_ID column to be distinct. Can this be done in Oracle? [code=sql]SELECT DISTINCT Job_ID, … Databases oracle |
| | Please see this: [CODE]WARNING [1024] Error while executing query: select event_type, EventId, VenueId, Price, Schedule, ev.startDate, ev.endDate, events.name eventname, movies.name moviename from `eventvenue` ev, `events` left join (movies) on (movies.ID = ev.EventId) where events.ID = ev.EventId and VenueId = '493' and ((ev.startDate >= '2010-04-25' or ev.endDate >= '2010-04-25') or event_type … Databases mysql |
| | |
| | What is internet database system? what are the hardware and software requirement? i really need to know... urgent thanks Databases  |
| | hello, I need to have in ONE request clients who just like apple AND banana : clients id name relations_like id id_client id_like like_fruits id title a same client can have a few differents like_fruits if I made a classic SELECT FROM relations_like WHERE id_like IN (idapple, idbanana) I will … |
| | I know this may seem simple to some of you, but I really need help. I think I have part 1 correct for the most part but I really need help with the 2nd part. [B]Part 1[/B] The ABC Car Service & Repair Centers are owned by the SILENT car … Databases database-design |
| | I Have Created Following tables 1.Test_Student(Master) table which will contain StudentId(primary key), StudentName and StudentAddress as columns. 2. Test_Subject(Master) table which will contain SubjectId(primary key) and SubjectName as columns. 3. Test_StudentSubjectTrans (Transaction) table. This will be a transaction table between Test_Student and Test_Subject. This table will contain StudentId and SubjectId … |
| | Hi all. I've been having this problem and I was hoping someone could catch something I didn't. So here it goes: I have developed a registration system using PHP and mySQL, with usernames and passwords being encrypted by salt and md5 (and display names getting no encryption) on PHP's end … Databases encryption mysql |
| | Hello all. Am new to the forums and this is my first post and I am in need of a little help. I am in the planning stages of building a pretty involved web application. This question needs some background info first. This is for a direct mail company (a … Databases mysql web-design  |
| | i would really like to automate something like ... login to mysql cmd followed by creating a database following by creating tables... with one bat script here is my try: [code] mysql -u root password password; [/code] however it returned me this: [code] C:\Documents and Settings\lih>mysql -u root password root … Databases client-server mysql xml |
| | [code]<?php mysql_connect("localhost", "Master", "pword"); mysql_select_db("db"); $official2 = mysql_query("SELECT * FROM Contribute WHERE stack LIKE '%comic%' ORDER BY points DESC")or die (mysql_error()); while($row = mysql_fetch_array($official2)) { $officaluser = $row['username']; $officalpoints = $row['points']; echo "<table><tr><td align='center'><font face='Arial' size='3px' color='#D99C29'><strong><a href='ustack.php?search=$officialuser' style='text-decoration: none'>$officialuser</a></strong></font></td><td align='center'><font face='Arial' size='3px' color='#FFFFFF'><strong>$officialpoints</strong></font></td></tr></table>"; } ?>[/code] the page is coming … Databases mysql |
| | I have Column named 'Price' in a table.I want to update the 'Price' Column by adding 5 .But i have some Null values in 'Price' Column.Whenever i update the 'Price' Column.All Values Updated Except the Null Values Column.So how can i update the null Column.Pls Help Alok Databases mssql |
 | When I do `mysql> show status like '%qcache%';` it returns: mysql> show status like '%qcache%'; +-------------------------+----------+ | Variable_name | Value | +-------------------------+----------+ | Qcache_queries_in_cache | 19817 | | Qcache_inserts | 299528 | | Qcache_hits | 687127 | | Qcache_lowmem_prunes | 6702 | | Qcache_not_cached | 3171 | | Qcache_free_memory | … Databases mysql |
| | Hello everyone, I currently manage hosting for a number of customers and started created a system to manage the customers and their hosting accounts / domains. I have the following setup currently: Tables -Customers (Customer name and contact info) -Customer Accounts (An account links domains + hosting in one account) … Databases database-design |
| | Hi, I was looking for some help with how i would go about setting up my commission table. Basically i have currently: Users Table UserID Username Password Email Clients Table: ClientId Client_UserID FirstName LastName Address PostCode Tel Email Insurance Table: InsuranceID Clients_ClientID Provider Commission DatePaid CarInsurance Table: CarInsuranceID Clients_ClientID Provider … Databases mysql  |
| | I have a strange problem when making a backup of my mysql databases. In order to do so I have a 2TB external hard disk mounted when needed under /backup. Before making the backup I stop mysql (with /etc/rc.d/mysqld stop) and use rsync to copy all the data to the … Databases mysql |
| | hi, fairly new to mysql. i have been working on a site which would have say 100 + agents. basically the agents clients are their own so i thought the best way would be to get a dedicated server and create a mysql database for each agents company. the database … Databases hard-drive mysql |
| | hello all, i want to save the web page content into a database. how can i fetch data from that website and save into a sql database. im using c# as front end. need help. expecting reply soon since it needed for my project. thanks. Databases mssql |
| | Hi, I changed my table to InnoDB so one table can be used as foreign key. To do that i had to DELETE the content in my child table. I exported and saved the data on my computer. 1, Now that im trying to import all the data with phpMyAdmin … Databases mysql |
| | Hello I want to compare an inserted date against two stored dates in order to validate an entry. The date entered is being stored in a separate table from the stored dates. I am not sure how to go about this. So far I have this: [CODE]create PROCEDURE sp_GetTime @FullName … Databases mssql |
| | I've created an SSIS package where I have an FTP Task inside a ForEach Loop container. I am trying to loop through each file in the particular folder and send it to the FTP site. I am sure that I got the For Each Loop working, as the error message … Databases mssql programming-construct |
| | Hi, I am trying to understand why this statement in the book is wrong: "given a C entity, there is at most one related A entity and at most one related B entity". Is it that it doesn't apply to a specific kind of relationship?? So, if I have an … Databases |
| | i know this is about MySQL, but there is no 4GL forum, so i'm hoping one of you experts might know: we have an application that uses Progress (on a unix system) that imports data from .csv files and writes the various fields to the database. one particular type of … |
| | Question: Write commands to declare character variables named faculty_last_name, faculty_first_name, and faculty_phone. Assign the value ‘COX’ to faculty_last_name, ‘KIM’ to faculty_first_name, and 7155551234 to faculty_phone. Write program commands so that the program displays the output exactly as follows: Kim Cox’s phone number is (715) 555-1234. everyone can teach me??? |
| | I am attaching a word document I put together with screen snapshots on how to connect to MySQL on a remote server using putty. I hope it helps those of you how have questions. Databases mysql |
| | I'm re-designing a database that will facilitate registration at various events. One column in the event_person table describes the current status of the registrant. The forces that apply here are: - Various events may have different sets of status values - We may ship this as a framework to various … Databases database-design legal |
| | Hi, Fairly new to MYSQL, still learning. I have create basic web databases before but the project i am working on just now is slightly more complex than before and need some advice. i have had some help qith queries which has been great however i need some advice from … Databases mysql |
| | |
| | Our employees have an interface to enter their vacation days. The vacation dates are stored in the database as one row per day, minus the weekend days. I'm trying to create a report that will show the starting and ending dates for each employee. Note: Each employee can have muliple … Databases mssql  |
The End.