7,494 Archived Topics
Remove Filter  | |
| | Hi there, I have 3 tables to extract data from. My query thus far is: SELECT `ministry`.`pm_name` AS 'Name', DATE_FORMAT(`ministry`.`min_begin`, '%Y') AS 'Election Year', `ministry`.`party` AS 'Party Led', `deputy_name` AS 'Deputy PM', COUNT(DISTINCT `ministry`.`min_begin`) AS 'Times Elected PM', `GG_name` as 'GG Name', `gg_title` as 'GG Title' FROM `ministry` JOIN `deputy_pm` … Databases mysql |
| | Hi, I am starting my final year project and was looking for some advice on what more experienced coders think the best database for me to use would be? On placement I was using visual studio to code and sql server for stored procs, is this the best way for … Databases visual-studio  |
| | hello everyone i am designing a database system for a college i would really appreciate if someone can check my ERD design and advise me if it correct please check attachment thank you Databases database-design  |
| | hi all i want to insert 110 million record in oracle database but i am using java application to insert the data but it takes 4 days to complete i check the program to see if there is a problem but what i found that the insert to the database … Databases oracle |
 | Hello friends, I am using sql server 2005 as a backend. I want to filter the datagrid based on fromdate,todate,companyname,employee name. I have done the date filter's.... The problem is with the other two filters. The actual problem is.. The application has to filter based on company only if the … |
 | i'm trying to alter a table's column name but i keep getting an error. alter table GelderlandDist change inauguration 'inauguration date'; but i keep getting an error: ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the … Databases mysql  |
 | Hie everyone I have the below code on my console to import data from an excel sheet to a mySql database but unfortunately I am having an error which reads: NO CONNECTION TRYING TO RECONNECT.... ERROR 2005 (HY000): UNKNOWN MYSQL SERVER HOST '(ID,NAME):' (11001) ERROR: Can't connect to the server … Databases microsoft-office mysql |
 | hello friend i just wanna learn if a way exist to generate AUTO_INCREMENT i have my datble and the colum ID is an AUTO_INCREMENT and the id is from 1, 2, 3 .... i would like to diferent id for exemple : CC13445356 i want 2 letter at begin or … Databases mysql |
| | So I 1. downloaded the odbc drive from the oracle site, "Connector ODBC 5.2" 2. created a user datasource that tested successfully in ODBC Datasources Administrator 3. created a new db in access 4. External Data->More->odbc database->Link ..., selected the datasource i created and got "ODBC - call failed" Data … |
| | whenever i open phpmyadmin it showing that access denied and #1045 - Access denied for user 'root'@'localhost' (using password: YES) phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they …  |
| | Hi need some help. Some time ago I created a database and tables doing a tutorial. After I deleted the tables(don't remember why)and now all I have is a database with no tables. Trying to clean up my db I wanted to drop the DB but get this error: ERROR … Databases |
| | I have an assignment where I'm supposed to normalize up to three normalizations for a table but the teacher didn't explain it well. Empno Pro# Hours Pro_name Pro_loc Ename Job Job# Pay_rate 56789 1100 32.5 x Apex Smith, John Database Deisgner 100 90 45555 1100 52.5 x Apex May, Joyce … Databases data-structure database-design mysql |
 | getting recepient based on login support id 5 login i need recepitent as 3 and name vimal. |
| | Hi, Please advise which database should choose for developer and dba profile  |
| | I didn't expect to find this so difficult, but I'm trying to set a user variable in MySQL to contain an array of values. I have no clue how to do this so tried doing some research and was quite suprised to find no answer. |
| | I have this search method that doesn't seem to work, and I am not sure why. I need an extra pair of eyes to see why my search query brings back false results. Thanks in advance. public function search($data) { $person = $data['person']; $bind = [ ":person" => "%$person%" ]; … |
| | Hello, I am dealing with SQL server 2005 and i have data from a system where i am tracking an application at each stage in the system. i have data in a tabular form as follows and the dates are derived from an sql statement. how best can i write … |
| | HI I'm building a little learn app. It bases on the principle of cards. You can learn vocables, graphs, formulas etc. So you have different types of content/cards. Basically, I divide them into 2 types: Vocable Cards => The front and back of the card can have several words (synonyms). … Databases database-design json |
| | I have just a user form in access 2007 with a text box and a Save command. MY code: Private Sub Save_Click() If School.Value = "" Then MsgBox ("Text Box is empty") else Msgbox(" Not Empty") End If End Sub When the Save is clicked, and the text box is … Databases microsoft-access  |
| | Say I have 2 tables: Table 1 Name - Toys - broken - recurrence Jack 6 4 0 John 8 3 1 Mark 8 2 2 Jack 4 2 1 John 3 3 1 Mark 6 0 2 Table 2: Name - Toys - recurrence COlumn Name: name Column Toys: … Databases mysql |
| | hi everyone...im looking for a complete uptodate list of people by race, i have country name lists, but im looking for "english, irish, indian, australian etc". i cannot seem to find a list anywhere. I did manage to find a pdf, but it went too detailed and contained about 800 … Databases pdf |
| | Hi, I am currently creating 'Routines' to speed up the analysis of the quiz data my database stores. One of the queries I have been using which I would like to turn into a Routine looks like this. SELECT Candidate, QuizName, PercentageScore, PassFail FROM Results WHERE Candidate ='Joe Bloggs' This … Databases mysql  |
| | Hello, I have Error Like this when i open the table in phpmyadmin.. why this is happening with table ? please any solution for that... #145 - Table is marked as crashed and should be repaired Thanks |
| | If I have a table like this: Table1 ID - sequence - value 1 1 6 1 2 4 2 1 3 2 2 2 3 2 6 4 1 5 5... Table2: ID - Firstname 1 Jack 2 John 3 Mark 4 Mary Querry Result I hope for: ID … Databases mysql |
 | Hello, Someone told me that with sharepoint portal I can design database easily. Is that true? What is sharepoint portal actually? Is it possible to integrate sharepoint portal with other webbased application? I wonder if my understanding about sharepoint portal is correct? Thanks before. Databases database-design sharepoint  |
 | want to update my database via email, for exm i have 3 fields in db, 1-Id, 2-Name, 3-Marks i wants to update this records by sending a email, how can i update it, |
 | PFA...!! **Please look at the table data carefully.** I need to delete the rows. I need urgent help..!! Table: CREATE TABLE IF NOT EXISTS `version` ( `nidt` varchar(11) NOT NULL, `noeud` tinyint(3) NOT NULL, `VERSION` float NOT NULL, `ETAT_FONCT` varchar(20) default NULL, `idnap` varchar(25) NOT NULL, `nidtint` bigint(20) NOT NULL … |
| | |
| | |
| | Does anyone know if there is a way in which I can install my own Encryption Algorithm into a MySQL database? Databases algorithm encryption mysql |
 | Group, I've got 1000 questions regarding this "Rocket" (Unidata) database, but I digress. To give you some background, I do have some experience with SQL, but nothing with Unidata. But given what I've read, I can't believe it is that much different from SQL, aside from the command syntax (I … Databases windows-server  |
 | I am completely new to Triggers but I hear they can help me with a specific problem. I have a table: picid picture recordListingID 1 danny.jpg 0 2 jane.jpg 0 3 ralph.jpg 0 In the recordListingID column (int) i would like to generate numbers sequentially upon an INSERT. Is it … Databases mysql |
| | I'd like to find out what's the best route to take. I want to build a website for a small company that allows online bookings on vehicles. What's the best database to use and what storage medium may i use as backup? Databases storage |
| | |
| | I have a mysql database that includes the fields first_name, last_name, email. I have an input form to enter in the above information. If the e-mail address already exists, then I have a message page that lets the user know this and display the first and last name that already … Databases mysql |
| | select e.employee_id from employees e where (select count(*) from employees f where f.employee_id < e.employee_id) < 5; The above query gives me first five employee id's. I want to know about the output produced by the sub query and explain. Thanks in advance. Databases sql |
| | Hi Guys, I have a requirements to backtrack 2 days if the date fall as Monday. Why? We dont have any transaction from Sunday to Monday at 6:00AM that's why need to backtrack 2 days. i want to share with you my query. if you have any additional idea to …  |
| | Hello all, I need help with part of an assignment that is due Sunday. This is my first week learning mySQL so clear and simple descriptions will be well liked. Here are the instructions. a)When adding a customer, add the customer's balance times the sales rep's commission rate to the … Databases mysql  |
| | Im working through sprocs with MySQL and I came across something that made me quite uncertain... I learned sprocs with MSSQL and I am used to declaring as such: create ... myProc (@var type, @var2 type(xxx)) as .... and for declares, we declare vars as declare @var3 type(xxx), @var 4 … |
| | |
 | Hi all , I am trying to build a function in Access Query database which gives results of a 1 month expire invoices from the current month.Therefore when I run the query, the results will be all the invoices which will expire next month. I have tried the Data Add … Databases microsoft-access |
| | |
| | Hi, I'm confused right now about mysql statement I have four tables : form1 | form2 | form3 | form4 | ----------------------------------------------------- k8regNo | form2_ID| k9regNo | form4_ID | consignee | goods | out_date| k9regNo | moveDt | k8regNo | | form2_ID | can i join this four tables..? Databases mysql |
| | For each of the following sets of functional dependencies on a schema r(A, B, C, D, E) AB --> C, D --> E, B --> E A --> CD, B --> DE AB --> C, C --> D For each of the above set of functional dependencies, decompose relation r … Databases |
 | Hello guys!! I have a database and I store public tweets inside. I have lots of columns, including timestamp with timezone column. For example: timestamp | tweet_id "2013-07-30 11:14:07.404+03" 6598dsf4466a "2013-07-30 11:14:08.028+03" 87f9dss99s97 ... "2013-08-04 17:36:37.924+03" 646s4f64a64 "2013-08-04 17:36:38.891+03" 654asd9f654a So, I want to make clusters (time clusters) with these … Databases postgresql |
 | just installed SQL Developer 4 and I'm using Oracle Database 11g. I want to execute multiple insert into statements in the worksheet at once. That works fine if I copy paste via command line of SQL but in Develop 4, only one row is being inserted at a time. Is … |
 | Hi to all, I like to start a new discussion after a long gap..Now i have a Question in Sql,I need to Take a difference in Current Month and Previous month,from get the diference i use the trigger to send a sms.. SELECT datepart(mm, dateadd(mm,-1,'2011/1/1') ) or SELECT DATEADD(MONTH,-1,GETDATE()).i need … Databases mssql |
 | I have a table that looks like this room date price 128 02-09-2013 15 128 03-09-2013 17 128 04-09-2013 19 If I want to update the field price depending on the dates, First I have the form with the data: while($rows=mysql_fetch_array($listprices)) <? $date[]=$rows[date]; ?> <p style="width:100px;float:left;text-align:center;"><input name="price[]" type="text" value="<? echo … Databases mysql |
| | Hi, I'm having some issues trying to figure out the way to find the percentage of parents with children inside my database. There is a table where all the parents are stored called XY and there is a table where all the children are listed called table Children. How would … |
| | Hello everyone! Is it possible to write a query which does the following : UPDATE db.table SET col1 = 1 WHERE col2='something' AND col3 IN ('a','b','c') ELSE SET col1 = 0 Meaning that the rows that don't match the where conditions will also be updated to another value. Note that … Databases mysql |
The End.