1,079 Recommended Topics
Remove Filter  | |
| | Hi.. I'm trying to extract the day, month, and year from a datetime to use it within a 'WHERE' statement. Table: workshops workshopid - int(10) workshopgroupcoursecode - text title - varchar(255) description - text Table: workshops workshopscheduleid - int(10) workshopid - int(10) startdatetime - datetime enddatetime - datetime timedescription - … Databases mysql |
| | 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 |
 | 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 |
 | Hello, I wonder what is mysql table name requirements? I have tried creating mysql table with these names: group_mgt --> squprime.group_mgt table does not exist file_uploads_log --> squprime.file_uploads_log table does not exist In order to make the table creation works I have turn group_mgt to group AND turn file_uploads_log to … Databases mysql |
 | i got complete details in html table and willing to update 2 values |
| | |
 | I am using My SQL Database. I have two databases of My SQL which are used in a appplication simultaneaously as backend and log databases. So i need to stop services of log database only to view some results relating to my application. Is there any way to stop the … Databases mysql |
| | Hi guys. I wanted to create a quiz for my website. I have found some code from a website called (getcode.org) (prev world of webcraft). The quiz now works as it should and I'm very happy it does. There is one problem I have adapited it to the needs of … Databases sql  |
| | I have a specialization hierarchiy with one parent table and two children. I am in a situation where one column in the child table is a pk, fk, fk and unique. TICKET_NUMBER = pk, fk1, fk2, u1 This is how I have currently tried to create this table but im … Databases |
 | In true Microsoft fashion they have made the download process so counterintuitive that your chances of getting what you want is near impossible. Fortunately someone has created a "simple" [12 step process](http://www.istartedsomething.com/20140616/the-12-step-process-to-download-microsoft-sql-server-express-2014/). For yuks, see also [here](http://www.istartedsomething.com/20121216/downloading-sql-express-2012-from-microsoft-com/). And to see how little things have improved see [Bill Gates Chews Out … Databases client-server microsoft mssql sql |
| | Hi, Not sure what exactly is happening here as I'm used to dealing with Microsoft SQL server rather than Oracle but here goes: I have a C# project that connects to an Oracle database using the OracleCommand Object to bring back records but I've been noticing some strange behaviour. Here … |
 | Hi, I am using MS ACCESS. I want to validate a particular field. To check whether if its a valid email address with a @ So anyone have tutorials or website to reccomend or even reply off hand with the expression to check for @ in a string? Thanks alot. Databases email microsoft-access |
| | This code was to create a simple database with a table and add records with the following. toIm having trouble with the 'id' auto_increment. <?php $con=mysqli_connect("localhost","root","distortion","my_databs"); // Check connection if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); } // Create table $sql="CREATE TABLE empl(ID INT NOT … Databases cybersecurity mysql sql  |
| | I have two tables with column name price I want to order by price from both columns so if is in first table 100eur and in second is 200eur I want to order results like this: 200, 100 SELECT a.price, b.price FROM table1 AS a INNER JOIN table2 AS b … Databases mysql |
| | Hi, I want to display the department no. and the no. of employee in each department from EMP Table.(in a Single Row). Pls help me how to write the query for that. I had one query which display the result in 3 rows. select deptno, count(*) from emp group by … |
| | hi i need to show employee attendance based on device logins with employess various information like department,designation,device_person_id,person_id,logid etc..... joining 3 tables i.e dbo.tempdevicelogs,dbo.employee_settings,dbo.persons_profile i tried this one Select Device_Person_id,personal_id,Date1,( cASE WHEN eXISTS( SELECT Device_Person_id FROM tempDeviceLogs AT WHERE T.personal_id=AT.Device_Person_id AND T.date1=AT.logDateTime ) then 'P' Else 'A' End )as Status FROM …  |
| | hello. my MySQL database corrupts the database when ever i start, stop, or restart the service. i am on a laptop.. and this is for testing.. so, i have to stop the server to be able to do other kinds of work and take my laptop to school, work, and … Databases mysql |
| | use people; SELECT 'first' UNION SELECT first from e where skills regexp "javapl" INTO OUTFILE '/home/ankit/csv/tablename.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n'; this runs without problem to /var/tmp folder but other folders gave error:13 can't write please help Databases mysql |
| | A warning: I'm very new to databases! Hopefully this will be a pretty simple question. To simplfy my problem, I have a tree of 'meters' that collect data (Let's say electricity meters). I'd normally structure this with objects in a tree, each with a list or some kind of array … Databases web-design |
| | 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 … |
 | 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 |
| | How would I go about learning about data bases and how to create them? What is the best programming language to create them with? Databases  |
| | pls help me creat database for computer hardware shop by letting me knw the attributes Databases |
| | 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 … Databases mssql |
| | I have a php/mysql project. When the admin deletes a customer or product from the database on the form I need an confirm box to show and ask the admin if they are sure they want to delete and have the customer row show in the confirm also. Here is …  |
 | 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 … |
 | Hello i have a textarea on a form when i submit it it returns [object HTMLTextAreaElement] so does on the field of the table. WHat can i do to fix it? Databases html-css |
 | 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 one table in sql Date Day Start Time End Time Subject Teacher 2014-06-02 Monday 2:30 PM 04:30 PM Maths Mr.Smith 2014-06-10 Tuesday 2:30 PM 04:30 PM Science Mr.Ayar 2014-06-16 Monday 2:30 PM 04:30 PM Maths Mr.Smith 2014-06-02 Monday 3:30 PM 04:30 PM Maths Mr.Smith I want to make … |
| | Hi,im trying to insert into table student_acedamic_history but I get this error.Heres my code. CREATE TABLE Student_Acedamic_History( S_id INT, Degree_Title VARCHAR(30), Institue VARCHAR(30), Year_Of_Comp INT, Total_Marks INT, Obtained_Marks INT, PercentAge FLOAT, CONSTRAINT fk_S_id_students FOREIGN KEY student_acedamic_history(S_id)REFERENCES students (S_id)ON UPDATE CASCADE ON DELETE CASCADE ); And the data: INSERT INTO student_acedamic_history … Databases mysql |
| | Database: id name 1 Supriya 2 Himanshu 3 Deepika 4 Himanshu 5 sonu 6 Sonu I am using name field to fetch the datas and my **OUTPUT** should be as id name 2 Himanshu 4 Himanshu 1 Supriya 3 Deepika what query should i use Databases sql |
| | 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 |
| | 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 |
 | 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 … |
| | Hi I have the following code that uploads images and other files to an SQL Server DB on GoDaddy via a FileUpload Control on an aspx page. Public Function InsertData(ByVal cmd As SqlCommand) As Boolean Dim strConnString As String = System.Configuration.ConfigurationManager.ConnectionStrings("ConnectionString").ConnectionString Dim con As New SqlConnection(strConnString) cmd.CommandType = CommandType.Text cmd.Connection … Databases client-server file-system image mssql 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 … |
| | i want to copy data from an access database to a sql database 2008 through coding in vb.net any help ? NB : I WANT ALSO TO CHECK FOR DUPLICATES EACH I SELECT FROM ACCESS TO COPY IN SQL Databases microsoft-access mssql sql |
| | hai everyone... i m doing hospital sys,here i have channel form here one field is channel ID,that is auto no, nw i want to do that auto no change with date i.e every day channel ID start from 1.... please help me friends....i have to complete the project shathee Databases |
| | Hello, I am trying to fix that error, yet I cannot find mysqld in the registry. I am afraid that I accidently delete it. [mysql error](http://en.kioskea.net/faq/1718-mysqld-exe-encountered-an-error-and-needs-to-close) What should I do now to fix that error? Do I need to reinstall windows? Thanks in advance. Databases mysql  |
| | # Heading Here # how to store the coordinates (points) of a line as x0,y0 ,x1,y1 .....xn,yn in database MS SQL. coding is in c# using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; namespace WindowsFormsApplication6 { { List<Point> points = new List<Point>(); … Databases mssql |
| | hello all; <!DOCTYPE html> <!-- To change this license header, choose License Headers in Project Properties. To change this template file, choose Tools | Templates and open the template in the editor. --> <html> <head> <meta charset="UTF-8"> <title>Our Local site</title> </head> <body> <form action="welcome.php" method="post"> <input id="t1" name="t1"type="text" placeholder="table name"><br> … Databases mysql programming-construct python |
| | 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 |
| | hello can i search a field for different words simultaneously??? we have a |or opertor in mysql regex but not and operator...please help |
 | I need a connector to connect from a application running on Windows CE machine to a MySQL Server. Is there anything like this for both ARM and x86? Thank you Databases client-server microsoft mysql |
| | 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 |
| | I have a bunch of insert querys running and some of them fail with a duplciate entry. I want to see a log where it says "Error: Duplicate key" and that tells me the EXACT INSERT query that fails so I can see what keys are duplicated. Thanks  |
The End.