2,403 Solved Topics
Remove Filter  | |
| | hi... im doing project for a school...and new to php and mysql..just learning.. i have to create one loginpage with 3 different users like corres,principal and the staff in the table field what type i have to give like ENUM or SET.. i want to assign 0 for corr,1 for … Databases mysql |
 | Hi Guys, I have imported a CSV file into the database and i want to write some functions to ensure that when data is loaded in that all spaces are removed from certain columns. For Example: In the Phone No column the numbers can appear as follows 07712345678 077 1234 … |
| | Hi a have 4 tables [ICODE]Table A ID | Data 1 --------------- 1 | A 2 | W [/ICODE] [ICODE]Table B ID | Data 2 ----------------- 1 | B 1 | C 2 | X [/ICODE] [ICODE]Table C ID | Data 3 ---------------- 1 | D 1 | E 1 … Databases mysql  |
| | please help me!!! im restarting the mysql server from putty: Empty pid file /var/lib/mysql/mysqld.pid for /usr/sbin/mysqld when i checked mysql status, unused running unused running what's the problem?? im using putty in configuring mysql server thanks in advance. Databases mysql |
 | Hello Every one ! i am trying to make query to show the growth of sale of the product month wise ,i have one table name Sales .having following fields , SalesID,ProductID,amt,Qty,SalesDate i use this query to show my records [CODE] select ProductID,Amt,Qty,substring (datename(month,SalesDate ),1,3)as months,DATENAME(YEAR,salesdate ) as years [/CODE] … Databases mssql |
| | Hi all........... I shud just how to use ENUM type in mysql..like shud i give any field in form in a website and how to assign a values for eg 0 for admin,1 for manager and 2 for the staff using phpmyadmin?? please help me................. Databases mysql |
| | Hi Guys , i have faced a sql command problem. That is currently i have 2 different table [ICODE]a) Select ID, Name from Table1 where ID >=1 and ID ID <=3 ID | Name 1 | Alan 2 | Amy 3 | Andrew [/ICODE] [ICODE]b) Select ID,Sum(Points) as [Total] from … Databases mssql |
 | i want to create a stored procedure that can return the initial character of two string inside the description field. ex. Computer Security -> in one data only if i use this statement select left(description) from table1 i want to return only CS when i run my script. is there … Databases mssql |
| | I have a form where a user can search for properties from a database. Everything is working except for the suburb search. I would like the user to be able to search for more then one suburb. At the moment I have the information from the textbox being separated into …  |
| | Hello Every One ! I m working on a software , i have one field name expiry_Date , now i want to make an query which subtract the current date from the expiry_date and give answer in no.of days , i use getdate() for current date , can any one … Databases mssql |
| | Hi everyone! I'm currently designing a database for an inspection body that performs controls and inspections of wiring systems. The price for the inspection depends on the power of the wiring. I'm experiencing some problem in the design of the price list for the DB. The actual price list has … Databases database-design  |
| | create table Course ( courseId char(5), subjectId char(4) not null, courseNumber integer, title varchar(50) not null, numOfCredits integer, primary key (courseId) ); create table Student ( ssn char(9), firstName varchar(25), mi char(1), lastName varchar(25), birthDate date, street varchar(25), phone char(11), zipCode char(5), deptId char(4), primary key (ssn) ); create table … Databases mysql |
| | Guys, When i run this sscript i got an error in Where clause? Where should be place this where clause? [CODE] SELECT p.ESN, p.ReturnDate,s.Receiptdate,e.Shipdate FROM USProductRecovery p with (nolock) OUTER APPLY((SELECT TOP 1 Receiptdate FROM ESNSalvReceipts s with (nolock) WHERE ESN = p.ESN AND Receiptdate > p.Returndate ORDER BY Receiptdate … Databases mssql  |
| | i want to increase the size of the column [CODE]ALTER TABLE employee ALTER COLUMN department_name VARCHAR(50)[/CODE] Databases mysql  |
| | I am a newbie looking at designing a simple database for my manufacture-based company, part of the job it does is maintaining a Purchase Order Table, a typical one and it suits all the customers we have, except for 1 particular customer which typically issues a Quantity Contract - a … Databases database-design |
| | i am starting to learn to connect a cprogram to a mysql database. i have got this elementary program to connect to server , create a database and disconnect from it. [code]#include <stdio.h> #include<windows.h> #include <mysql.h> static char *opt_host_name = NULL; /* server host (default=localhost) */ static char *opt_user_name =NULL; … Databases mysql |
 | Hi all, I haven't changed anything in the config file in phpMyAdmin folder. I don't know why the WAMP server gives me this error. Although everything was working perfectly yesterday. Does anyone know how I can fix this problem? [CODE] You don't have permission to access /phpmyadmin/ on this server. … |
| | I created a foreign key on a table just using this statement. When I wanted to drop it, phpMyAdmin didn't allow me to do so. Would anyone suggest a nice way of getting away with it? [code] ALTER TABLE `likes` ADD CONSTRAINT (fk_user_id) FOREIGN KEY REFERENCES `users` (user_id); [/code] This … Databases mysql |
 | I am getting an access denied error when I am writing to the database I am using this line [CODE] LOAD DATA INFILE 'upload.txt' REPLACE INTO TABLE Test FIELDS TERMINATED BY ',' [/CODE] I have made sure I allowed remote SQL, and I made sure to give the user all … |
| | hi! another query! i want to insert values into the table 'employee' for the 'adddress' field in such a way that the large address comes in two or three lines like this [code] empid empname address mobile grade basic Joyban1 Joy banerjee 5/67, 1234567890 2000 10000 nehru colony, kolkata 700045 … Databases mysql  |
 | I have a very simple wish, to dump all databases so I can lock up a backup of the databases, tables, users and so on. It looked like [CODE]mysqldump -v --all-databases -u root -p secret > "${directory2}""$h"_mysql_dumpall.sql[/CODE] worked, however the file contained a little error message telling me I had … Databases debian mysql postgresql ubuntu |
| | i am creating a table employee which looks like this [code]use employeemaster; drop table if exists employee; create table employee ( serial int unsigned NOT NULL auto_increment, empid tinytext NOT NULL , empname varchar(255) NOT NULL, address text NOT NULL mobile bigint unsigned NOT NULL, grade char(2) NOT NULL, basic … Databases mysql |
| | I know this sounds strange, but I messed up in a 'Manual' change to a DB table, and need to find a couple of records that I have no pathway to find... Explanation We have a member table called 'members' several different position tables, one for each level called position_1, … Databases mysql |
| | Is there anyway i can link a session to a particular table within my database, well i think this is how i need to do it. I have different tables which hold information for different shifts. The user selects the Site from one page, then selects the shift from another … |
| | Hello, My db table is this (semester result table) [B]sem1 regno(int) s1(enum) s2(enum), s3(enum), s4(enum) [/B] I want to find number of subjects in which the student with given id has gotten a particular grade. (ie no of subjects he/she has failed). Is it possible or shld i change the … Databases mysql |
| | Hello, Am new to php and I have a question that is probably very easy. I have been watching tutorials online to learn how to work with databases, but none of them speak on how to upload to server. This is my problem: am using vertrigoserv but specifically using PHPMyAdmin … Databases file-system mysql php |
| | I am trying to link fields between 2 of my tables but its not working. I have a table called assets, which consists of Asset_ID and AssetType and a table called t5_week3_shift3 which also consists of these 2 plus others. Im not sure whether to do away with the assets … Databases mysql |
| | I am trying to display the result from a query in to a table. I can do this pretty easily when doing queries from mysql, but cannot get it to work with mssql. Below is the code I used to actually make sure I could get the data (and it … |
 | Hi friends, can you guys help me to find the best way to track information changes in sql server 2000, like a free utility. The problem is that i need to track every single table because i want to figure something out. we have an ERP System and there is … |
| | I am using MySQL to store the RSS feed contents that are updated every few hours. I truncate the database once a day. But during the day, whenever same feeds are updated every few hours I get duplicate entries piled up. Is there any PHP script that I can run … Databases mysql |
| | Does anyone know the SQL statement for replacing a string in the whole of a database. My database is called DB1 and I want to remove any instance of "Table/". Many Thanks, Databases mysql |
| | what are the diffrences between CREATE INDEX [WITH IGNORE_DUPLICATE_KEY OFF] and CREATE UNIQUE INDEX it sounds the same! and if anyone knows when creating a plain INDEX just CREATE INDEX whether it creates a clustered or nonclustered index couldnt find an anshwer to that thanks in advance Databases mssql  |
| | I made a test database to store items in a database, but I keep getting an error when trying to import from a txt file. Here is my txt file [CODE] 1,Lánc 2,Fa 3,Csavar 4,Lakat [/CODE] How could I fix this problem? Also is there a reason I need to … Databases mysql |
 | hi all, I have doubt on Index,I know Index are used to increase the performance of table but my question is where to create Index whether primary key table or foreign key tables ? Databases mysql |
| | Hi, i want to write a query for employee's who's name start with "a" and end with "b". Thnks in advance :) Databases mssql |
| | I have just started using Access 2010 and am experiencing problems with it corrupting the database. To take one example I have a database with one module in it. Today when I open the module in design view Microsoft Access falls over with the error "Microsoft Access has stopped working" … Databases database-design microsoft-access |
| | Hello guys i am little bit confuse here with the code can any one help me out .. i want max customer paid in shopping and their name i dont know that i am using right way or not but guide me here [CODE]Select sum(od.unitprice * od.quantity) as Amount, (Select … Databases mssql |
| | I want to insert a record in some tables using a simple stored procedure.My question is: do i have to write several inserting procedures (one for each table) or is it possible that i can pass as a variable the name of the table in which i want to insert … Databases mysql |
| | Unable to load DLL 'OraOps9.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E). Following is my scenario: 1 - Previoulsy I had Oracle 09 in my asp.net 4.0 applicaiton working fine on Windows XP. 2 - I updated the windows to windows 7 and installed Orcale 11g. … Databases oracle |
| | I have this query, but the ordering by is not working. It should order by value, but doesn't react. you'll see what I mean in the code. [ICODE]<table class="pme-main"> <tr> <th class="pme-header">Bestemming</th> <th class="pme-header">Naam Klant</th> <th class="pme-header">Aantal Manden</th> <th class="pme-header">Aantal Duiven</th> <th class="pme-header">Naam Bestemmeling</th> </tr> <?php $con = mysql_connect("****","****","****"); if … |
| | Hi, My name is stefan and I've been trying to develop a php/mysql based CRM for private use. I've stumbled upon a problem a few days ago and I just can't figure it out, so if you could help me, I'd really appreciate it. The problem is the following: I …  |
| | In going through some homework, I was able to do some of the problems, but not others. For example, one problem was "Produce a list of employee last name, first name, job function, department name and department location. Use appropriate, user friendly column aliases." I finished this with this code: … |
| | hi all, when my codes ran at localhost, it doesnt have any error, however when it runs in a server it gives 'Column 'member_id' cannot be null' [CODE] //retrieve form data $start_date=$_POST['start_date']; $end_date=$_POST['end_date']; $project_name=$_POST['project_name']; $project_description=$_POST['project_description']; // open connection $link = mysqli_connect($host, $user, $pass, $db); $query = "INSERT INTO project(project_name,start_date,end_date,project_description,project_status)VALUES('$project_name','$start_date','$end_date','$project_description','available')"; $result … Databases mysql |
| | dear all, [CODE]$member_id = $_POST['member_id']; $delete = 'yes'; $HOST = 'localhost'; $USERNAME = 'root'; $PASSWORD = ''; $DB = 'hrs'; $link = mysqli_connect($HOST, $USERNAME, $PASSWORD, $DB); $query = "UPDATE member SET delete='$delete' WHERE member_id='$member_id'"; echo $query; $result = mysqli_query($link, $query) or die(mysqli_error($link)); [/CODE] Any error in my query? it says …  |
| | Hi , I want to copy the selected fields, eg:SELECT * FROM table1 where flag='1'; to another table ,table2 can anyone plz help me Databases mysql |
| | Hi Everyone- We are building a database that needs table(purchaser) to check table(paypal) for a matching telephone number. Table(paypal) has 'purchaser telephone' as PK and table(purchaser) has 'purchaser telephone' as FK. I can insert and see the data in both tables, but running a select query returns an empty result. … |
 | can anybody give me query of current version of my sql of [CODE]$sql = "SELECT entries.*, catagories.cat FROM entries, catagories WHERE entries.cat_id = catagories.id ORDER BY dateposted DESC LIMIT 1;";[/CODE] i will be thankful. Databases mysql |
| | Hello, I am creating a web server which lets me insert into a table. The user invokes the specific ID and its meant to append to the table with that ID, startdate and an enddate. [CODE] <WebMethod()> _ Public Function reserveVehicle1(ByVal vID As Integer) As Boolean Dim strInsert As String … Databases mssql sql web-server |
| | I am trying to combine a MySQL query with change date format so all rows display as d-m-Y (surely possible ?) in results. The datefield type is DATE. [CODE]$query="SELECT * FROM table DATE_FORMAT('datefield','%d-%m-%Y')AS datefield FROM table";[/CODE] SELECT*FROM table on its own displays datefield as YYYY-MM-DD but DATE_FORMAT does not change … Databases mysql |
| | dear all i have 2 tables, one is project table and another replies table. [ICODE]"SELECT * FROM project, replies WHERE replies.member_id=$_SESSION[member_id] AND project.project_id=replies.project_id ORDER BY project.project_id "; [/ICODE] the above code gives me all , but I need the latest updated replied in each project id I tried [CODE]SELECT * … |
The End.