2,403 Solved Topics
Remove Filter  | |
| | i have a table fieldname like companyname and Created Date shown in below image. in that i want to display data's date wise ASC or DESC, like that if i click companyname the data's will show ASC and again if click will show DESC order format. and here i added … Databases mysql |
| | Hi i have installed prestashop 1.4.8.2, i want report from mysql, Number of orders per customer with customer name & customer id plus i want total amount of order customer wise. can you help me with SQL query so i can generate this report from phpmyadmin. thanks, regards, Ritesh Databases mysql |
| | Hi i have issue in stored procedure converting data type Destination table dbo.Z_tbl_CirculationCopy_TEMP has numeric data type But source table Z_tbl_Import_temp have VarChar Type If I export data from source, I have error message Msg 8114, Level 16, State 5, Procedure Z_usp_IMPORT_EXCEL_UNPIVOT_1, Line 10 Error converting data type varchar to … Databases mssql  |
| | hi. how can i convert string format to datetime: the string is formatted like : December 01, 2010 (which is another table) tblTransactions and the datetime column format is : 2010-12-01 (another table) tblBilling how can i search my string format to my table which matches the column (datetime field). … Databases |
| | I need to create a table to track page visits to landing pages on a website based on the page name / the member ID / the Year / the Month and maintain the count of visits based on each unique combination Basically, I think I can create a table … Databases mysql  |
| | I need to copy only some selected rows from a table and insert these rows into another table (having the same structure) in another database. Is it possible? Databases mysql |
 | Hy i have this sql query.. how can i combine with the next one ?... this $sql = "select id,date,category,sum(q1) Total,sum(q2) Total2,sum(q3) Total3,sum(q4) Total4,sum(q5) Total5,sum(q6) Total6 from articles group by category order by id"; with $sql = "SELECT * FROM articles WHERE from_date >= '".mysql_real_escape_string($_REQUEST["from"])."' AND to_date <= '".mysql_real_escape_string($_REQUEST["to"])."'".$search_string.$search_city; as … Databases |
| | I use the following code to generate a uuid concat with CMRC it works fine uuid is generated in lower case i.e. CMRC+someString in lower case I could not find anything to resolve this i had to post this on here for help how can I convert this generated uuid … Databases mysql |
 | i made union to two mysql tables select cashid, sum(amt) as ramt, NULL AS pamt from receipt where cashid in ('17', '23') GROUP BY cashid union all select cashid, NULL AS ramt, sum(amt) as pamt from payment where cashid in ('17', '23') GROUP BY cashid and now i want to … Databases mysql |
| | 1. What exactly is a surrogate primary key? 2. Is a surrogate primary key just a made up attribute inserted into a table by the database administrator? All I know is that you use a surrogate key when there is no primary key or the natural key may not be … |
 | so.. Im having trouble wrapping my noodle around this... my initial thought: -- events create table Events ( id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, Title VARCHAR(512) NOT NULL, Description TEXT NULL, StartDate DATETIME NOT NULL, EndDate DATETIME NULL ); create index StartDate_OnEvents On Events (StartDate); create table EventFrequency ( … Databases client-server mysql sql |
| | hey guys, so i'm trying to insert data from one table to another. table 1: |event_id|event_name|start|end|event_venue| table 2: |guest_id|guest_name|event_id|event_name| $event = mysql_query("INSERT INTO event VALUES('','$name','$dstart $tstart','$dend $tend','$venue')"); $insertg = mysql_query("INSERT INTO guest(event_id, event_name) SELECT event_id, event_name, FROM `event` WHERE `event_name` = `$name` "); i get : > Column count doesn't … |
 | Hi, i'm having some trouble with my MySQL server where i can't log in or connect to it from the terminal , phpmyadmin or my server control panel. the password is correct , i have reset it a number of times but still get the same message: ERROR 1045 (28000): … Databases client-server file-system microsoft-access mysql  |
 | Hi, I have a data, employee attendance record with following format > 01-0002,I,4/21/2014,07:34:00 01-0002,O,4/21/2014,18:09:00 01-0002,I,4/22/2014,07:47:00 01-0002,O,4/22/2014,18:09:00 01-0002,I,4/23/2014,07:54:00 01-0002,O,4/23/2014,18:07:00 where I is in and O is out The table contains lots of records for this saves records from the start how can i search a record with no In or no … |
| | I have 3 tables --Ticket_Lines (parent), Labour_Items (child), Part_Items (child). Table Ticket_Lines has 2 primary keys (ticket_number & ticket_line_number) I know that you cant have two seperate primary keys in one table so would this mean that ticket_number and ticket_line_number is a composite primary key? if that is correct, is … |
| | i need a simple project of microsoft access for beginner bacause i am beginner in database plz help me and give me a simple project Databases microsoft-access |
 | Hi all, I'm looking into the management of duplicate records in MySQL, but this case is a little bit more specific. A record is only duplicated if column A and column B have the same value. So a record is only a duplicate if two specific columns have the same … Databases mysql |
 | Hi ! I need to have a single mysql query which should get COUNT of two different values in a single field, suppose i have a field in a table 'approved', and there are only two values ie. approved=0 or approved=1, and have suppose 100 rows for them,so how to … |
| | i want to display first priority wise after that remaining data if no priority will display all data by select DISTINCT s.Companyname,s.id as companyid,s.LogoImage,s.LogoPath,s.Url,ck.MainCatagory,c.city,st.state,sub.Subcatagory,sub.MainCatid,p.priority,rc.RelatedCatagory from spa s left join relatedcatagories rc on rc.spaid=s.id left join catagorykeywords ck on ck.id=rc.mainCatagoryid left join subcatagorykeywords sub on sub.id=rc.RelatedCatagory left join city_place cp on … Databases sql |
| | I'm testing out wdcalendar, a jquery based calendar for a wesbite. Some info on it: [url]http://www.webappers.com/2010/06/08/wdcalendar-jquery-based-google-calendar-clone/[/url] The installation instructions are simple, but not detailed so maybe im screwing up somewhere. They go as follows: Copy the unzipped directory into the apache www directory/sub-directory. For a database: Create a database, execute … Databases file-system javascript-jquery mysql sql |
| | I am trying to connect a Crystal report to my database.mdf i.e SQL Server database. When using the wizard At the [I]Database Expert[/I] window after choosing the [I]OLE DB (ADO) [/I]i can not find any server and a database in the drop down menu. how to get that? i have … Databases mysql sql window-manager |
| | Anyone will help me to solve this? this is about ER diagram and some other stuff about database. This is the exercise: ----------------- "Project a DataBase to support a architectural studio which offers its customers proposals refurbishment. Each component of furniture ( table , chairs , ... ) is characterized … Databases sql |
 | hello So i have problem in connecting to my oracle database on the server it threw an exception like this "The type initializer for 'Oracle.DataAccess.Client.OracleParameter' threw an exception". my supervisor told me that it might be a referencing problem in this library Oracle.DataAccess.Client.OracleParameter,but i think that the library doesnt fing … Databases oracle |
| | So I'm really new to the whole database thing. Now I have a website running here. http://fcsit-trackandtrace.comuv.com/ You don't need to register, as the member's area is empty right now. Now what I want to do is, when someone logs in, he will get this sort of service where he … Databases  |
 | Hi all I need some advice making my query work properly. I already played around it a dozen of times and still can't get it work. So as my last option im here:) . what im trying to achieve is sum all amount of a particular rows and display the … |
| | i have 3 tables and i want to display companyname,maincategory,city,place 1.SELECT `id`,Companyname from spa 2.SELECT `id`, `mainCatagoryid`, `RelatedCatagory`, `spaid` FROM `relatedcatagories` SELECT `id`, `MainCatagory`, `name`, `size`, `path` FROM `catagorykeywords` SELECT `id`, `Subcatagory`, `MainCatid` FROM `subcatagorykeywords` 3.SELECT `id`, `city_id`, `state_id`, `spaid` FROM `city_place` SELECT `city_id`, `city`, `state_id` FROM `cities` SELECT `state_id`, … Databases sql |
| | I wish to implement a tag system for a gallery,I have a huge number of images and all of them are to be associated with one or more tags. The number of tags is also large,but not exceeding say 500,isn't constant.Tag texts may also be large in certain cases. What … Databases |
| | Im trying to delete from multiple tables using full outer join like this: $del_id = (int) $del_id DELETE contact, child, spouse FROM contact FULL OUTER JOIN child ON child_name = c_name FULL OUTER JOIN spouse ON s_name = name WHERE contact_id = $del_id I get warning/notice: unknown table contact in … Databases mysql |
 | I am trying a query in mysql. I have 3 tables which are linked by the same foriegn key ... Table 1 = students (PKey - stdnt_rfid_tag) Table 2 = student_attendance ( FKey - s_id for stdnt_rfid_tag ) Table 3 = users ( Fkey - s_id for stdnt_rfid_tag) In the … Databases linked-list mysql |
 | I cant log in to wamp server although i get in the phpmyadmin. When i try to open my project i get access denied for user 'root'@'localhost' (using password yes) Databases client-server mysql |
| | I was wondering if there is any way to do a single mysql query to do a count of filled positions in a multi-level structure to an indefinite depth. That sounds a bit cryptic, but this is what I would like to do if it is at all possible. we … Databases matrix-multiplication mysql sql  |
 | Simple timediff: SELECT time_format(timediff('2014-04-24 09:11:37','2014-04-24 09:09:37'),'%H:%m:%s') as dif Returns 00:00:00 . Im problably missing something stupid, my apoligies... Databases mysql |
| | Hi Everyone, I'm trying to import a ever changing CSV into MySQL on the fly, there is constant data being aded to the file and don't to everything every time. Is there a way to add new data only? Kind Regards Databases mysql |
| | Hi, I have two tables called header user, inbox. The table structures mentioned below, User: NUM_USER VCH_NAME VCH_PHONE_NO VCH_STATUS 1 XXXX 123 Y 2 YYYY 321 Y 3 ZZZZ 456 Y INBOX NUM_ID(P.K) NUM_CUST_ID NUM_SEND_CALL_ID NUM_REC_CAL_ID DTT_DATE 1 10 2 1 4/11/2014 2 10 3 2 4/11/2014 3 10 3 … Databases oracle |
| | I have this table: Time_Stamp Time_Stamp_ms '2014-04-11 13:33:24', '879', '5555', '4444', '3333', '2222', '1111', '123', '1', 'text' '2014-04-11 13:33:24', '899', '5555', '4444', '3333', '2222', '1111', '123', '2', 'text' '2014-04-11 13:33:24', '919', '5555', '4444', '3333', '2222', '1111', '123', '3', 'text' '2014-04-11 13:33:24', '939', '5555', '4444', '3333', '2222', '1111', '123', '4', 'text' … Databases mysql |
| | Good afternoon, I'm trying to formulate what should be a simple query that will create a result set of ALL records from a table that have a date that is in the previous month... Basically something like this one that I use that gets any records prior to the current … Databases sql |
| | Hi, How to use in select statement with where condition comparing a Null value and with value? I have this Statement `Select Col1, Col2, Col3 From Table where DateDeleted` 'Here comes the problem The condition is something like if DateDeleted (which is actually a date) is Null then get records … Databases sql |
| | Good Morning All, I'm about to write a script that will actually be run in a CRON job weekly. I created an overview of the process so you would understand what I'm doing but I have questions with 2 of the MySql queries that will be required, and wondered if … |
 | 1. For all the accounts that have authority="admin", set permision to modify all of the files (attribute changes is datatype YES/NO),,, so basically a user can set yes or no depends on his will. 3. For each directory, print out his name, in which directory it is located, and how … Databases file-system sql |
| | Hi All, My MySQL experience is fair but when it comes to doing some of the more complex queries I get stupid fast. That said, in the past, I have written queries that INSERT data to the DB based on clicks. In this case I want to use the same … |
| | I'm working on a Database assigment but I'm kind of stuck. It seems to be the Double value that's causing the issue because when I use the Varchar data type I can create my table. Is there any way I can use Double without using Varchar. Any help is much … Databases ide java java-netbeans sql  |
 | Hi all, I've made a query that gathers info from several tables, after it was working, there was the need to integrate yet another table, however I can't seem to put it to work. I've seen some of this "witchcraft" before, but can't seem to find a tutorial, basically because … |
| | I am tring to perform a calculation in my query. I've been working on it for hours, so I need another pair of eyes to see what I am missing. Everything in the query is working except for the g.courseFee part. The course fee is not being added to the … Databases mysql |
 | Hey guys, I am having some difficulties regarding a select query logic. Then I have a table with products and it has a column -> submodel with all kind of data in it.  What I want to achieve is to **STRIP** (with REGEXP?) all the strings starting with … Databases mysql |
 | Hallo, I get stuck when installing SQL Server 2012 : Services Account Name Password SQL Server Agent SQL Server Database Enginee SQL Server Analysis Services SQL Server Browser This Sharepoint Server connected to DCSHARE1 (Domain Controller) The problem is I do not know what to fill for Account Name & … Databases mssql sharepoint sql |
| | Hallo, This is funny. I export mysql codes to the webserver. Yet, I cannot run the codes correctly, there are some errors when I run the codes: Error SQL query: -- -- Database: `project_infracom` -- -- -------------------------------------------------------- -- -- Table structure for table `infracom_admin` -- CREATE TABLE IF NOT EXISTS … |
| | I'm hoping that another set of eyes will see something that I'm not. I'm having an issue with a script that I just added a little routine to, so I know the issue is in the routine, because the sript as a whole was working before adding this... the routine … Databases mysql |
| | This is what I have: create table Employee_T (EmployeeID varchar2(10) NOT NULL, EmployeeFirstName varchar2(10) NOT NULL, EmployeeLastName varchar2(15) NOT NULL, EmployeeAddress varchar2(20), EmployeeCity varchar2(10), EmployeeState char(2), EmployeeZip number(5), EmployeeDateHired date default sysdate, EmployeeBirthDate date, EmployeeSupervisorID varchar2(10), Constraint employee_PK primary key (EmployeeID), Constraint employee_FK foreign key (EmployeeSupervisorID)REFERENCES Employee_T(EmployeeID) ); create table … |
 | Hello everyone. I'm quiet new here and trying to get som helpå from you guys. My main problem is that I have made a form which I want to use to post data to my database. But it seem to never work. Firsta problem was; everytime the page loads the … Databases mysql |
| | Hi all I Have 3 Queries in access 2 of them are being used as a calculator we willcalled them Cal1 and cal2. The third query The Order query displays the Customer , the orders and totals which consistes of cal1+cal2 (there is a possibilyty of some cells for cal1 … Databases |
The End.