Databases Forum

I have text file (attached image) i need to loop and get the values (with ellipse shape )into sql table the text file record usually started with (----)

A Database Error Occurred Unable to connect to your database server using the provided settings. the above error am getting when i load the localhost and my database.php and db_driver codings are given below $db['default']['hostname'] = "etc.com"; $db['default']['username'] = "etc"; $db['default']['password'] = "etc@etc"; $db['default']['database'] = "visiting_link"; $db['default']['dbdriver'] = "mysql"; $db['default']['dbprefix'] …

I am trying to search a mySQL database in PhP using POST, but I get these errors: **Notice:** Undefined variable: ban1 in /Applications/XAMPP/xamppfiles/htdocs/bans.php on line 266 **Notice:** Undefined variable: banner1 in /Applications/XAMPP/xamppfiles/htdocs/bans.php on line 268 **Notice:** Undefined variable: bantl1 in /Applications/XAMPP/xamppfiles/htdocs/bans.php on line 270 **Notice:** Undefined variable: banreason1 in /Applications/XAMPP/xamppfiles/htdocs/bans.php …

I am using MYSQL and php version 5.4.16.My table structure is as given below. I want to sort the temp_id cat_id and colors based on the cat_id as given in the second table. The com_id same values should not come at once. My Table is something like this: col1 col2 …

Hey everyone, I'm looking for a free tool to administer MySQL databases. I currently use PHPMyAdmin, which is great, but I'm looking for the same functionality in a desktop software. I've actually found quite a few, but wondered if you any of you could recommend one for me. My only …

(SQL , PL/SQL) enough for searching jobs in ORACLE ? i have 2.6 years exp with oracle sql, plsql . can i get better JOB ?

Hey I want to make a backup and restore of a MySQL **SERVER** to another machine. Please note the **SERVER** part; I want to backup/restore datebases, tables, procedures, users, configuration, etc....**EVERYTHING** What is the best way to do this? Thank you

Hi Experts, I have to Pad some numbers that have decimal points and I have done it successfully as follows: SELECT case when len(myValue)=1 then RIGHT('000' + CAST(CAST(myValue AS float) AS VARCHAR(5)), 2) when len(myValue)=2 then RIGHT('000' + CAST(CAST(myValue AS float) AS VARCHAR(4)), 2) when len(myValue)=3 then RIGHT('000' + CAST(CAST(myValue …

i have wrote query to calculate TOTAL WORK TIME and Overtime of an employee based on Intime and outTime but can't figure out to put another column 'IsAbsent'. e.g. if person doesn't come on any specific date than his INtime and TimeOut would be empty then if both are empty …

Structures of my tables are as follow. Table Name : timetable [Image1](http://www.4shared.com/download/MYafV7-6ce/timetableTable.png) Table Name : slot_table [image2](http://www.4shared.com/download/9Lp_CBn2ba/slot_table.png) Table Name : instructor(this table is not required for this particular problem) I want to show the resultant data in my android app in a timetable format somewhat like this: [image3](http://www.4shared.com/download/oAGiUXVAba/random.png) **Question** : …

Successfully calculated TotalTime a person has worked and overtime he has done if total working time is greater than 08:00 but if not greater than it puts duration of time person has not worked in Overtime column BUT NOW overtime column should display that time in proper negative format e.g. …

I am creating a site and I am trying to put all the posts within a mysql database (phpmyadmin). How do i put articles/posts in the DB?

I have the following query which joins 5 related tables to get the desired result set of 10 rows, I did my best to solve the issue by adding indexes and re-writing the query in many different ways but I ended up either unexpected result or a very slow query. …

HI Hope somebody can help. My query updates a colomn in tab1 from a row in tab2 but only if a colomn in tab1 is equal to that of a row in tab2. tab 1 has 360000 rows tab 2 has 477 rows The update query runs for ages and …

i am given task to analyze and modify pre written large queries within small time, so please help me understanding it with times as ( SELECT t1.EmplID , t3.EmplName , min(t1.RecTime) AS InTime , max(t2.RecTime) AS [TimeOut] , t1.RecDate AS [DateVisited] FROM AtdRecord t1 INNER JOIN AtdRecord t2 ON t1.EmplID …

hi there, looking to get some help. i have created a view which pulls together from different product tables a review date. the thing is that a client could have review dates for the same product and i need it to only display the most recent review date. i tried …

I have a question that may be a bit complicated, so let me set it up with what I am working with first. I am dealing with a 3 x 10 matrix, which I’m sure you realize means on level 1 there are 3 potential positions, and on level 2 …

If someone can provide a link with the use of Parameters instead of concatenation

Hallo, I am trying to fix my mysql search query: $data = mysql_query("SELECT * FROM static_content WHERE upper(image) or upper(title) or upper(content) LIKE'%$find%'"); Please help me to fix it. Is it correct? I mean where column image (change to upper case) or column title (change to upper case) or column …

Hi, below queries gives two rows like category_name high_value_complaints category_name high_value_duplicate_complaints I am trying to merge both queries category_name high_value_complaints high_value_duplicate_complaints I tried to join both tables but its giving category_name high_value_complaints category_name high_value_duplicate_complaints Need suggestions select category_name, count(distinct complaint3.id ) as high_value_complaints from complaint_category,assignment3,user3,complaint3_details, complaint3,complaint_tag ct where complaint3.complaint_category_id=complaint_category.id and …

Hi, I have mysql database dump xxx.sql How can i convert xxx.sql to xxx.csv? Thanks

hello all, I want to make some simple database in access that would track student information, semesters etc... I have created basic tables like: students, professors, subjects.. now I am stuck with the most important part: semesters and subjects... here is the link [Click Here](http://prntscr.com/2jafl6)where you can see database relationship …

hi..please help.. i have 2 tables tblStudents and tblGrades. in tblStudents, all details of students and in tblGrades, grades of the students. column "StudId" is their only common column.. in tblStudents: StudId LastName FirstName in tblGrades: columns are: StudId SubjectCode Grade what i want to achieve is to query on …

please help me in this,how would i do some recursive statement in my stored procedure. here is what i want -- @requestcode will genereate some random string set @requestcode = (SELECT substring(@username,0,3)+'-'+SUBSTRING(CONVERT(varchar(255), NEWID()), 0, 9)) -- then i want to check if the string generated is existing to 'sampletable' select …

hi.please help me with mysql query. i have a table tblGrades with fields ID, Subject, Remarks. how can i create a stored procedure that will display the students that have subjects(user input) and Remarks='Passed'? the Subjects will depend on the user, therefore it may be one or two or three …

how do i stop user inserting duplicate records INSERT INTO person_tbl(person_name,person_status,creation_time,modified_time) VALUES ('$person',$status,$ctime,$mtime) WHERE person_name NOT IN(SELECT person_name FROM person_tbl WHERE city_name='$person');

Hi all, I am not sure if I am in the right place. But I don't know where to start. I had a web page that was working properly, almost at the end of a year of work (housweb.com). Last week, I tried to work in a different site, diferent …

Hi, I have a table: user uid status 1 1 2 1 3 1 4 2 5 2 6 1 7 2 8 1 9 3 10 2 I am trying to fetch data for below logic: 1) fetch top 6 rows having status=1 2) if status=1 has less then …

I have following quary example. SELECT t1.TeamID, MemberList = substring((SELECT ( ', ' + FirstName ) FROM TeamInfo t2 WHERE t1.TeamID = t2.TeamID ORDER BY TeamID, FirstName FOR XML PATH( '' ) ), 3, 1000 )FROM TeamInfo t1 GROUP BY TeamID Its giving error "Incorrect syntax near the keyword 'FOR'." …

I wrote a sample program in notepad begin dbms_output.put_line('welcome'); end; / and saved it as p1.sql i opened sql prompt and gave @p1 it didnt worked??? i tried exec p1; still not working?? how to execute a pl/sql program???pls help

I have been researching this as I am getting the distinct feeling I will have to transition my code to this soon, eventually. From your experience, can someone provide a brief overview of the benefits of MySQLi and why I should transition. Is it even necessary? I'm not sure. Any …

Hi I want to do a silent install of sql express 2008 (free edition) In my configuration file, how can I set the default language to British English and date format to "dd/MM/yyyy". Thanks for your help SQL Newbie

Guys, please suggest me, how can I set up an audit on SQL server 2008 if I need to track who, when, what and from where changed something on a database table?

Hi, I have around 4 lakhs email id data(In CSV). I want to change status of above emailids. Could i run a simple update query or do something more. Need Suggestions

Hi, I am using timestamp datatype for storing date..and value of column is like 2013-12-31 T 23:59:59.000Z For query SELECT * FROM a WHERE created_on BETWEEN '20131201' AND '20131231' SELECT * FROM a WHERE created_on >= '20131201' AND created_on <= '20131231' Which will give right result??

Hello all, I need to make some database... and lets say there is a *student* table, and the *student* table has many columns, a lot of columns.... they are all unique to the primary key, so dont worry about the normal forms... what I am in a doubt is: there …

Hi, I am trying to merge below two queries in a single query such that company_id,company_name,noOfOpenTickets,noOf PendingTickets Need suggestions?? No Of open Tickets: select c.company_id, (select company_name from company where id=company_id) as companyName,count(s.complaint_id) as noOfOpenTickets from complaint3 c ,complaint3_status s where s.id =(select max(d.id) from complaint3_status d where d.complaint_id =c.id …

I have three tables 1.course(c_id(pk),c_name,sem_no); 2.student(s_id(pk),s_name,user_name,password); 3.student_info(s_id(fk),c_id(fk)); i have logged in the student.. den i run this query select distinct sem_no from course,student_info where course.c_id=student_info.c_id and s_id='0001' order by sem_no; it shows all the semster he passed inclueding the running semster.. now i want to show the last value of …

I only have experience using pretty basic Oracle. However, I'm now in need of a better understanding of SQL. I'm trying to write a query using CASE statements (as this seems to be the best approach), but am admittedly lost at the moment. Here is what I have as a …

Hello, What's the mysql syntax to rename column in a table? I try this: ALTER TABLE static_content RENAME COLUMN title TO shorttext MySQL said: Documentation #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to …

hi im making a database for my project is it possible to have multiple foreign keys shown at the picture? i tried to alter the tables and add foreign keys but i always get a #105 error, so i deleted all of my tables and will make a new set …

I created a table in phpmyadmin and i was curious to know if it is possible to assign multiple values to one variable/field in the same table. For example here is what i have: ID | Shoe | Sizes ____________________ 1 | CK | 7 ____________________ 2 | LV | …

Hi Guys I have a "StudentNames" column in an sql table. Each student in the table has atleast two names all in one column. Assume that the following as studentNames. StudentNames ------------- John Smith Joseph Smitter Johan Smittin How can I use the LIKE statement to select students with same …

Hi, I'm getting the following error "" for the query as shown below. Any help is very much appreciated. SET SERVEROUTPUT ON; DECLARE v_CARE_COUNT NUMBER := 0; v_PHONE VARCHAr2(40) := NULL; BEGIN select count(distinct care_level) into v_CARE_COUNT from Table1 where user_id = '100'; IF(v_CARE_COUNT > 0) THEN select phone into …

hi any one with an idea on how to create user ineterface of sql oracle database.

I have a table EmpList. I want to use loop to bring result as I expected. Example, EmpNo ReportingTo ------------------- 27 14 68 14 104 27 105 27 138 27 139 68 150 8 151 8 8 5 Suppose query input is 14, I need result like this EmpNo ------ …

So I am reading a book from Pratt and it is called A Guide to MySQL. Apparently the book stinks and I am trying to answer some of the questions from the book. #fc1 show tables in the current selected database # for your current database it should be two …

I was wondering if you could help me with a current issue I am having whilst developing an ER diagram. The problem I am having is with identifying the correct Entities. Question:- students can fill registration form online (of 8th,9th and 10th only) they can give online exam. any user …

hi all.. i am having an problem during mysql installation..hopefully you all can give me advice and solution on how to solve it...below is the image of screenshot that i take.please help :)