Our Databases forum encompasses everything related to data storage, both for the web and other uses.

13 6 5 5 4 4 3 3 3 3
Member Avatar
Can anyone give a clear,short and simple explanation about database indexes?
by Teddy112 in Databases ()
Member Avatar
my insert statement seems to be ignoring my unique index and adding duplicates what'd i mess up? thanks in advance Table CREATE TABLE `address` ( `address_id` int(11) NOT NULL AUTO_INCREMENT, `address_street1` varchar(100) NOT NULL, `address_street2` varchar(100) DEFAULT NULL, `address_street3` varchar(100) DEFAULT NULL, `address_city` varchar(45) NOT NULL, `address_state` char(2) DEFAULT NULL, …
by jstfsklh211 79 in Databases ()
Member Avatar
* <?php mysql_connect("localhost","root","") or die ("could not connect"); mysql_select_db("search_test") or die ("could not find db!"); //collect if(isset($_POST['search'])){ $searchq = $_POST['search']; $searchq = preg_replace("#[^0-9a-z]#i","",$searchq); $query = mysql_query("SELECT * FROM members WHERE firstname LIKE '%$searchq%' OR lastname LIKE '%$searchq%'") or die ("could not search!"); $count = mysql_num_rows($query); if ($count == 0 ) …
by divyasuraya in Databases ()
Member Avatar
I added "DISTINCT" in my code. but seems the output is still the same, it have duplicate records. Thank u :D (note: I changed the field names and tables here) SELECT DISTINCT b.field1, b.field2, b.field3, b.field4, c.field1, c.field2, c.field3 from tbl1 b inner join tbl2 c on b.logid = c.logid …
by bLuEmEzzy in Databases ()
Member Avatar
Hi, i have installed prestashop 1.4.8.2 & i need a report of first order date for each customers, please help me to create mysql query. i need below columns information from database. id_customer, firstname, lastname, first order date thanks, Ritesh
by riteshuae in Databases ()
Member Avatar
Hi Pls advice me the following calculation in stored Procedure my scenario is packing the magazine Example: Order = 6042 copies. 6042 have to be packed by 20 each. so 302 bundle. balance 2 copies. If I divide 6042 /20 Result is 302.10 . How can store 302 and 2 …
by Maideen in Databases ()
Member Avatar
Hii..this is mysql query $querry="SELECT CONCAT(`insert_id`, `type`) AS 'order_id' FROM orders WHERE email='$email'"; $order_id=mysql_query($querry); echo $order_id; i need to convert this into ** mysqli**. Any Help??
by shashigowda in Databases ()
Member Avatar
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 …
by shashigowda in Databases ()
Member Avatar
I dont fully understand this issue at all, it makes no sense to me for several reasons but ill liust the main ones i have code elsewhere that works just fine and is identical in function and setup i dont think the issue is a registry key issue, this i …
by berserk 60 in Databases ()
Member Avatar
FROM: ORACLE 9i Give the SQL statements that determine the following: 1. Which customers lives in New Jersey? SELECT * customer FROM customers WHERE state = 'NJ' 2.Which orders were shipped after April 1, 2003 SELECT * FROM orders WHERE shipdate to_date('01/04/2003', DD/MM/YYYY') 3. Which books are not in Fitness …
by butterflyTee in Databases ()
Member Avatar
Hi there, I created a new table and forgot to set the primary key with an auto_increment. I went back and use: `ALTER TABLE table ADD PRIMARY KEY AUTO_INCREMENT (column);` However, now whenever I try to insert a new row of data, I get the error message "Duplicate entry '0' …
by James_43 15 in Databases ()
Member Avatar
Can someone please help to advise below question? I need to do a SUM of the amount column based on the CreateDate date range From 10th of previous month to 10th of this month Below is the database table Amount CreateDate 151.00 5 July 2015 567.50 19 July 2015 558.00 …
by strRusty_gal 14 in Databases ()
Member Avatar
Hello i want to put more than one values in a table's row
by SimonIoa 39 in Databases ()
Member Avatar
Please help me.... I want to upload up to 5 photos and save in database. I want by selecting photo it will upload automatically and then the selected photo will appear in the page. It will occure with one by one photo, up to 5 photos and the photos can …
by babir in Databases ()
Member Avatar
Hello Everyone, So I've begun a new project, in an attempt to show off my progress with Javascript. I'm making a little text-based RPG. However, I would like for it to permanently save your character and their progress. Thus, I need a MySQL database. I won't lie, I've only used …
by RGStrat in Databases ()
Member Avatar
In the work I came up against a situation when the working database at the end of day went to the Suspect Mode. And the archive was in many hours before. To transfer it in normal mode, until isn't made repaired base it was impossible. DBCC checkdb also refused to …
by alain.marion85 in Databases ()
Member Avatar
I am not sure if this is possible or not, but I need help writing a query for a running balance report. I tried a few queries on my own; I've come close but not exactly what I need. For convenience, I've created an sqlfiddle: [Click Here](http://sqlfiddle.com/#!9/caa5c) The report needs …
by joshmac in Databases ()
Member Avatar
Hello All, I have a table with column_name as USERNAME where USERNAME is VARCHAR2(20) and I want to display it as **"USERNAME@email.com"**. How to write the select query for this. **QUERY**: SELECT USERNAME AS EMAIL FROM STUDENT Thank you.
by Azii in Databases ()
Member Avatar
Hello i have formatted my pc with Windows 7 and installed wamp server. My local project doesnt work. I am familiar with the difference between mysql and mysqli? Do i need to install a most recent version of Mysql than the one provided by Wamp Server?
by SimonIoa 39 in Databases ()
Member Avatar
Converting mysql to mysqli. i need help av been scratching my head how to make necessary changes but its like am making more errors. please help or give direction what to change.. <?php session_start(); include("php/class.user.php"); $msg = ""; $msg2 = ""; //$submit = $_POST['btnaddnew']; if(isset($_POST['btnaddnew'])){ if(empty($_POST['txtUserId']) || empty($_POST['txtFname']) || empty($_POST['txtMname']) …
by nitos in Databases ()
Member Avatar
Hi group, I'm getting an "single-row subquery returns more than one row" error when running my routine. Looking through the table I'm querying, it is listing a date twice for some reason. Since I'm not able to remove this one row, is there a way to return the first instance …
by doncwilson_1 16 in Databases ()
Member Avatar
Hi all, I am not able to get correct count, if col1 (percentage with respect to product) and col2 have uniq value. Below I post my sample table data and expect output and which i query I tried. Please help me to get in to right direction. CREATE TABLE mysample …
by k_manimuthu 43 in Databases ()
Member Avatar
**Hello, please help me on this. I want to select from these table,** table name: User | Register_date | --------------- | 2015-02-04 | | 2015-02-04 | | 2015-02-14 | | 2015-03-14 | | 2015-04-04 | | 2015-04-14 | table name: Reservation | Order_date | Amount | ----------- | ------ | …
by Lau_1 12 in Databases ()
Member Avatar
Hello, What seems so trivial, has been bugging me. I have a table with duplicate values on one column, while non-duplicate (date) values on the other. If I am to use DISTINCT it will only eliminate the row with the same date. But how do I use DISTINCT and only …
by amishraa in Databases ()
Member Avatar
Hi all, Below is my sample data. I am trying to get the 'product' name only if the percentage count is varying. Could you please suggest your maximum no of 'Mysql' queries to approach this. Thanks in advance. Input: ============================================== percentage product ============================================== 100.00 A 100.00 A 100.00 A 2.18 …
by k_manimuthu 43 in Databases ()
Member Avatar
Hello, I am right now having a dedicated server and when i try to execute a INSERT query in table of 2 Lakh rows it takes about 0.02 seconds. so i am having a website where i need to update all 2 Lakh rows every 15 mins. but it sims …
by sanket044 in Databases ()
Member Avatar
Group, I'm extracting some month and year values from dates. I need to ensure they are NUMBERS as I'm going to multiply, add and subtract. I'm assuming I need to DECLARE these as NUMBERs. However I'm not sure how to do this correctly as I'm getting errors preventing me to …
by doncwilson_1 16 in Databases ()
Member Avatar
Hi. Im using VS2008 and SQL Server Management Studio 2008. I want to ask, i have two different table, TableA and TableB in same database, DatabaseX. Both table have two same column, ColumnY but the data are different within this table. Example: TableA, ColumnY : A1, B2, C3, D4 TableB, …
by nimz143 in Databases ()
Member Avatar
Group, I'm using TOAD to query the Oracle database. My better expertise is in VB.net. I have very little SQL experience. My question: Can I create a variable in TOAD/SQL to prompt for a date(s)? Here is what I want to do: Question 1: Enter Beginning Date (user to enter …
by doncwilson_1 16 in Databases ()
Member Avatar
Before upgrading to EXCEL 2010, I am able to open dbf files created in Visual Foxpro 7 or 9 in Excel 2003. I am not sure why after installing EXCEL 2010 I am no longer able to open the file. I get the error message when I tried opening the …
by calebclark in Databases ()
Latest Posts