7,494 Archived Topics
Remove Filter  | |
| | [code=sql] alter table pets_like_boys drop constraint pets_like; alter table boys_like_girls drop constraint boys_like; alter table girls_like_pets drop constraint girls_like; drop table pets_like_boys; drop table boys_like_girls; drop table girls_like_pets; create table pets_like_boys (pets_name varchar(32), boys_name varchar(32),primary key (pets_name)) ; create table boys_like_girls (boys_name varchar(32), girls_name varchar(32),primary key (boys_name)) ; create table …  |
 | File under FAIL: social network widget maker RockYou has fallen victim to a SQL injection flaw and as a result some 32.6 million users are being urged to change their passwords as a matter of urgency. Security specialists Imperva discovered the problem at social networking development site Rockyou.com and issued … Databases cybersecurity mssql sql  |
| | Hi everyone, I sat down to create a what I thought was simple SQL query but once I got thinking about it I realised I'm not sure where to start. The objective is to return two resorts from a Resorts table for each country code in that table. Countries table … |
| | At the risk of coming off like TV's "[url=http://www.amctv.com/originals/madmen/]Mad Men[/url]," Amazon Web Services really are New and Improved. The company today announced the addition of [url=http://aws.amazon.com/rds/]Amazon Relational Database Service[/url], giving users of Amazon's Elastic Compute Cloud (EC2) access to a virtual instance of MySQL. That's the New part. Improvements include … Databases amazon-web-services api mysql storage |
| | I'm trying to find out what the legal laws for the internet are on storing text via e-mail/chat. I am not sure if there is such a law but than again it's better to ask than to find out the hard way. Does DaniWeb keep history of Private messages for …  |
 | This is a very important issue to consider when you're using form/url variables in databases. A user can cleverly put in SQL statements and manipulate your db server as he sees fit if you don't take the necessary precautions. I get the feeling that there are several people that aren't … Databases google sql user-interface  |
| | Hi, I have 2 questions regarding the auto increment datatype in mysql. Q1) Since we all know that if we create an auto increment column, it will start from the number '1' but is there a way we can force it to start with the number '300' and it should … Databases mysql |
| | Well, Buying a collection is always useful and result is fruitful. I have made 3 test collections for oracle and got total of 20% discounts at all. I know the real exam is so much difficult. you should have the knowledge about whole exam topics. Although ucertify simulation test give … |
| | I am supposed to write an query which will add new attribute to my already existing table So I written this [I][B]ALTER TABLE member ADD e_mail CHAR(20)[/B][/I] which is fine, however when I try insert required data for each row I get stuck [I][B]INSERT INTO member(e_mail) VALUES('johnwhite@msn.com');[/B][/I] Can anyone help … Databases |
| | Hello guys Actually I am new to the world of datawarehousing. In fact today is my third day. Actually I am working in an organization where I have been given the responsibility of designing a datawarehouse. The operational database is already being created and I have to post the past … Databases first-post |
 | How can I identify and delete unused MySQL indexes? I have a large table that has somehow accumulated way too many indexes over the years, and I'd now like to identify and delete indexes that are no longer used by the application. Databases mysql |
| | I ran into a bit of a snag in my code, and I'm trying to make heads or tails as to whether this will work. From within my PHP script, can I write to a database using a MySQL connection in the middle of a transaction with a different connection? … |
| | Okay, so I'm in need of some career advice, because honestly I'm at a point where I don't really know how to proceed in the future. Databases career data-science engineering |
| | What are some ways to improve MySQL performance on queries against large tables that include the HAVING BY clause. It's my understanding that anything in there doesn't benefit from table indexes. Databases mysql |
| | My textbox datatype is DateTime. Using the click event of a button, this code is placed following MyTableBindingSourceAddNew() Dim CurrentDateTime As DateTime = DateTime.Now.ToString("dd.MM.yy hh:mm:ss") Me.SaleDateTextBox.Text = CurrentDateTime I then update table with TableAdapter. On my form I have a dropdown combobox in a toolbar, display member being "SaleDate" This … Databases visual-basic  |
| | An equipment company wishes to create a database to support the hiring of tools and machinery to clients. The company has three types of equipment: power tools, such as drills and vacuum cleaners, plants such as excavators and scaffolding. Each piece of equipment is identified by a number. Power tools … Databases database-design sql |
| | What is best way to get one row from a mysql table (with many columns) so I can use several several fields from that row for calculations in a C program? After executing a succesful SELECT command using mysql_query, is there an alternative to using mysql_store_result? Databases mysql |
| | Hey Peeps, Hope all are doing well. Happy to be a part of this community. So am fairly new in the programming world and exploring a few job opportunities in this field. Coming to my query, So was going through this list of questions, although concepts seem easy to understand … Databases |
| | So, I have made a table called `supplies_table` and inside the table is `id`, `name`, and `files`. And I also made an upload button where it can upload a pdf BLOB file into the `files` column. Yes, it can upload a pdf file in the `files` column but the problem …  |
| | I’m working on a blog post about this topic. I’d love to hear your suggestions! * What book(s) should someone read to come up to speed? * Why do you recommend that one? Note that the books don’t have to be peculiar to Redis. For example, someone suggested *Designing Data-Intensive … |
| | Good day every body. I want to develop a database program that will be used in school to input information about students and all the staff of the school. I want the program to be able to retrieve any required information and also display the total number of students in … Databases microsoft-access vb.net  |
 | Hello all, I would like to set a time after 2 requests that someone can make a request again does anyone have an example for this. thanks in advance |
 | Hi, I want to write a program whose input is the names of the companies and when adding the name of each company, it will take various information from that company of different types, 1- TextBox (daily production rate), 2- CheckBox (select product features), 3- OptionButton (the gender of the … Databases gui microsoft-office sql  |
| | Hello , i am using vb6.0 can some one help me with my problem. I want to summarize a database with multiple name and display it into one data where the date is same today. thank you for any one would response. for example. below is a table where multiple … Databases listview |
| | Hello I am building a database (i prefer MongoDB) that i will store over 100 mil ipv4 and ipv6 records for logging purposes. Data sample : 1.1.1.1 -> 0x1010101 1.2.3.4 -> 0x1020304 34.53.63.25 -> 0x22353f19 255.255.255.255 -> 0xffffffff 0001:0001:0001:0001:0001:0001:0001:0001 -> 0x10001000100010001000100010001 1111:1111:1111:1111:1111:1111:1111:1111 -> 0x11111111111111111111111111111111 2345:0425:2CA1:0000:0000:0567:5673:23b5 -> 0x234504252ca1000000000567567323b5 2345:0425:2CA1::0567:5673:23b5 -> 0x234504252ca1000000000567567323b5 … Databases mongodb |
 | I need to get a set of results from the db (server) but at times I would get the same result back and I would like to cache the result instead of making the same call to the db. Any ideas? |
| | I am building a ipv4/ipv6 geo ip **MongoDB** database and i will have millions (100+) of ips Structure will of the database will be [ { _id: 58fdbf5c0ef8a50b4cdd9a8e , ip: '34.53.63.25', ip_hex: '0x22353f19' , type: "ipv4", data : [ { country : "CA", region : "region1" city : "city1", blacklisted … Databases client-server data-structure mongodb |
| | I am new here. I passionately need the help of python gurus here to help solve this my statistics analytics problem. I want to write a python code that prompts for an imput. Then saves the new input data into a table of numbers at the last position while it … Databases python |
| | hello, i hope someone can help me i have a table ip in my database if there is 5 times in it he has to forward it in php to another page. thanks in advance |
| | import net.proteanit.sql.DbUtils; import javax.swing.*; import javax.xml.transform.Result; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.sql.*; public class EmployeeRegistriation { private JPanel Main; private JTextField txtName; private JTextField txtSalary; private JTextField txtMobile; private JButton saveButton; private JTable table1; private JButton updateButton; private JButton deleteButton; private JButton searchButton; private JTextField txtId; private JScrollPane tabla_1; public … Databases java java-swing mysql |
 | Hello, I am fairly new to VBA development trying to upgrade my employee training database in VBA from a single listbox with single line select/add/edit capability to one that pulls employee data from listbox1, searches training available by job title in listbox2, and combines the data into listbox3 also adding … Databases microsoft microsoft-office |
 | so we were trying to make a simple log in form and our professor simply told us to copy the codes he wrote:  i copied it but i got a red line under line 20 and 21 . I dont know what to do, no one is responding to … Databases |
| | The web application will have a database that consists of millions (over 20mil ... maybe 100mil or more) of hosts (ipv4,ipv6 and domains) and additional data to each host like blacklist, uptime, history, geo data (country, region, city, isp). I could, of course, use other RMDBS system like MySQL, Oracle, … Databases mongodb oracle postgresql |
| | hii how can i make self join and sum data in other table by username i have table like this members (id, username, referral) ref_bonus (id, username, bonus) members id | username | referral ---------------------- 1 id1 id2 2 id2 null 3 id3 id2 ref_bonus id | username | bonus … Databases  |
| | Hello all, We have just launched a startup. Now, we are looking for a simple web-based relational database system where we can easily add tables and connect them to one another through foreign keys. For example, we would want to create a suppliers database in which we could perform a … Databases |
| | HELP! We are a volunteer-driven not-for-profit offering motorcycle safety training and skill development with a huge database issue as described below. We cannot identify any of our volunteers that can tackle our database issue...here it is, can you volunteer your time to help us? We would be glad to hear … |
| | I am a newbie and i am working with php and i have got the following error Parse error: syntax error, unexpected 'INSERT' (T_STRING), expecting ',' or ')' in verify.php on line 9 CODE SNIPPET:    |
| | package sadbinproject; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.SQLException; import java.util.logging.Level; import java.util.logging.Logger; import javax.swing.JOptionPane; /** * * @author Notebook */ public final class admission_panel extends javax.swing.JFrame { /** * Creates new form admission_panel */ public admission_panel() { initComponents(); Connect(); } Connection con; PreparedStatement pst; public void Connect() { … Databases java java-swing oracle  |
| | Hello friends, I am new to this site, this is my first post, My question is.. How to calculate the one rows value for next row value? [code=sql]select @rownum:=@rownum+1 "sl.no", b.bus_activity_desc "Type",r.trn_no, o.Office_name,o.Address,o.Address2,o.Address3, DATE_FORMAT(r.trn_date,GET_FORMAT(DATE,'EUR')) as trn_date, l.Account_id , if(r.trn_type=6,r.total_trn_value,0) "Credit", if(r.trn_type=7,r.total_trn_value,0) "Debit", if(r.trn_type=6 ,@cbal:=(r.total_trn_value+@cbal),@cbal:=(@cbal-r.total_trn_value)) "Closing Balance" from(select @rownum:=0) s, office_master … Databases mysql  |
| | |
 | Hello. I am trying to check if a table definition (the default value on a constraint) is equal to UTC Time by using the following query: IF NOT EXISTS((SELECT object_definition(default_object_id) AS definition FROM sys.columns WHERE name = 'ModifiedDate' AND object_id = object_id('dbo.WorkflowAudit')) == GETUTCDATE()) However, you can not compare a … |
| | Illustrate a database for the video club using a recent video club entities Databases microsoft-access mysql sql |
| | I have an access Database with Chinese and German words. How can I had their audio prononciation wich I get from Forvo or Google translate? Databases audio microsoft-access sql |
| | I have managed to get blog posts displayed from each blog category but I want to limit it to 1 article from each blog category but unsure how to do it in the sql query I have, below is what I have so far (SELECT BP.postID,postTitle,postSlug,postDesc,postDate,postImage FROM blog_posts BP, blog_post_cats … Databases mysql  |
| | Create a table with following rules and regulations ma 1)Id should b identity 2)Name should allow only starting Letter with a to p 3)city should not allow Chennai,cbe, Salem 4) department should allo only cse,it,ece, 5) college default should b anna university 6) per should above only 70% 7) year … Databases sql |
| | I have a SQLite database that for some insane reason stores dates as the number of days since 1899-12-31. I want to create a view that will display the date as an actual date. I can calculate a specific date from a specific day number as select date('1899-12-31','Localtime','+44386 day') as … Databases sqlite |
| | Find product who hasn't had any sales in first three months of the year?  |
| | Hi Guys, Im not sure how to word the title of this question, but i have a table called "daily_recyclables". Inside this table, i have multiple columns of recyclable materials (example copper, stainless steel, brass etc etc) In my PHP application, i have a statistic card (like below) that is … |
| | I have three tables: First table is 'user': user_id | Name | ---------------------- 1234354 | Abu Bakar | 2543353 | Ali | 3342342 | Aliza | 4234243 | Ali | 5234324 | Mike | Second table is 'meeting': meeting_id | meeting_name | meeting_startDate | meeting_endDate | room_name | ---------------------------------------------------------------------------------- 1 … Databases sql |
 | Our database is running into problems, as many transactions are waiting for locks held by other transactions. Here is what each transaction is waiting for: · T1 is waiting on T4 · T5 is waiting on T8 · T2 is waiting on T7 · T6 is waiting on T2 · … Databases  |
The End.