2,570 Topics
 | |
 | Hi all, I am trying to select single record from each year of last ten year. Given below is the code what I am using now. But its taking too much time to get the result. Is there any way to make it fast? $sql_cond ="SELECT Close_Price FROM (SELECT Close_price … |
 | Greetings, I read about database normalization and I knew that there are 8 normal forms to follow. I understand the 3 first normal forms, however, I did not understand the other 5 normal forms and they are: 1- BCNF - Boyce-Codd Normal Form 2- 4NF 3- 5NF 4- ONF - … |
| | developed an admin panel in which users can add products from there and I put fields over there as size and color for the dresses dresses sizes and color would be more then 1 so I made 2 more tables in the database named prod_size and prod_color here is the … |
| | Hello All, I have been working on a registration form for opencart for a while now. I think I am nearly there in how I have coded it. However I just do not know where I am going wrong with it. It is a standard form with text input fields … |
| | Hi all, Just wanted to start a discussion on a database issue that I am presented with; the issue is that I am trying to insert seed data into around 90 tables without having to worry about manipulating/disabling the foreign key constraints. The most logical solution would be to do … |
 | I'm trying to load dxf files CAD into a database for searching. Some of these files are huge with hundreds of thousand of separate entites. I've separated the file into the following tables: * drawings * layers * style * entities * points * flags * floats * text The …  |
| | Following is my code effort.... I want to read first line of file(comma separated) & then create table in JavaDB but stuck here... Please someone help me how to do next???? public class DatabaseDAO { public void FileRead(String st) throws ClassNotFoundException, SQLException, IOException{ String []tokens=null; try{ try (FileReader fr = … |
| | Please i need help in writing a code showing online friends on a chatting site |
| | Hy there! I have prestashop 1.4.4.1 and i want to export database clients in CSV through Mysql. I want all the fields possible. Is possible to export their passwords also?I mean MD5. Can you please help me? Best regards, Florea Uwe  |
| | Hi, Can you guys reccomend me some good oracle sql journals? Thanks |
| | Hello, What are the different areas of databases I can focus on for my project? Thanks, |
| | Hi all, If I have two table of cod-desc, T1 and T2, and I need to create all possible combination, other than using cartesian product, is there another way more optimal to do that? Suppose every table has 1M rows. RDBMS= Oracle 11G. Thanks sandro |
| | WAMP 2.5 server on my windows 10 machine was working completely fine, until I accidentally installed a software which silently installed Win MySQLAdmin on the same machine. That day since, Wamp server icon remains in orange color (never turns green). **Issues:** 1. localhot/ phpmyadmin displays 'access denied' error. following is … |
| | Please Can Any one tell me How do I Greet a user with his name after he submited His form into my Data base /please i need your help.  |
| | I have a quick question, I am hoping it is an easy answer but if I wanted a query like the following: SELECT * FROM items ORDER BY date ASC Is there anyway to replace the order by information with prepared statement attributes? would either of the following work? SELECT … |
| | I need some help writing a sql query. I have below 2 queries and I want to combine them together. Now I already tried union but it doesn't work. I first want to print all result of query1 than I want to print all results for query2. Ex: --Query#1 results: …  |
| | Hi guys, I really need your help. I am Programming an app where a teacher logs in with a username and password. After the login a new Fragment in the app opens where the Teacher see all his students in a ListView. To Login I only type the username and … |
 | I am writing a custom MembershipProvider for ASP.NET and would like to record certain events in a table when they happen. I have the methods to do it, but I would like to get the value of the "ID" column of the row I insert into the table. I have … |
| | Hi all! I have a simple procedure which should return an 'id' field if parameter is passed. The problem is that if I provide the single letter parameter it returns no records although there are matches. But if i provide the whole word as it's written in a table, I … |
| | Hi guys, am trying to populate textboxes with data from sql server database. below is the code I am trying to use in Visual studio 2012, Vb.net. Private Sub btnSave_Click(sender As Object, e As EventArgs) Handles btnSearch.Click Dim query As String Dim MyConnection As SqlConnection = New SqlConnection("Initial Catalog=PayRoll;" & …  |
| | Hi all, I am trying to insert 1000 above data into a table but after inserting 500 something data its showing an "Internal Server Error". I tried after changing max_execution_time in php.ini and some other methods but no use. But this works fine in localhost. Given below is my code. … |
| | Howdy All, I'm creating a database for UFO sightings and would appreciate some feedback or suggestions. Yes I know, strange topic. Some background info so that the problem is understood: I'm extracting data from several large UFO database catalogs, news articles, and other miscellaneous sources, so that the data can … |
| | I'm working on a personal movie database project to help keep track of my movie collection, but I'm having issues and I was wondering if it was even possible and if so how to go about doing this in the first place. I want a way to get an overall …  |
| | [code=php]// display records page wise code starts: $adjacents = 3; $tbl_name="feedback"; // $display = "SELECT COUNT(*) as num FROM $tbl_name"; $display = "SELECT COUNT(*) as num FROM $tbl_name"; $total_pages = mysql_fetch_array(mysql_query($display)); $total_pages = $total_pages[num]; /* Setup vars for query. */ $targetpage = "dispfeed.php"; //your file name (the name of this … |
 | Hi to all! I have to install sql server first time. But I have a confusion that what is difference between sql server and sql server management studio? secondly is sql server management studio embeded in sql server or will it installed separately? If it will installed separartely then which … |
| | |
| | Hiiii,Good Evening I have a code that search for data in the database but I can search for only 1 keyword in a time,which is working fine for single keyword. if I type 2 keywords separated by a space or comma's which return blank page. I would like to modify … |
| | Hello All, I need a bit of advice regarding my final year project. I dont want any help with code but just on what path I should take. My project based on using triggers to solve business problems. I am not sure, on how I should approach this really. if … |
| | **Bold Text Here**Hi there I'm just wondering what the best or a good table layout would be for a little project I'm trying to do at work. I work at a temp to perm agency where companies use us for the probationary peroid of employement and then hire the workers … |
 | hello A newbie in database constuction, need help in adding automated sms functionality in mysql database. A user needs to sent a certain sms with certain keywords like 'location' to the system. the system refines a search according to the location content then sents back the data back to the …  |
The End.