Databases Forum

My current connection and echo code is as follwed: <?php $myServer = "Server_Name"; $myUser = "User"; $myPass = "Pass"; $myDB = "DB_Name"; //connection to the database $dbhandle = sqlsrv_connect($myServer, $myUser, $myPass) or die("Couldn't connect to SQL Server on $myServer"); //select a database to work with $selected = mssql_select_db($myDB, $dbhandle) or …

HI I am a part of database testing team. I have imported a tables.csv file which contains two fields 1. table name- all the tables of a database 2. Primary column- primary column name of the respective tables. I am trying to write a sql query for getting the table …

Hello, I am in my 3rd year and would be required to submit about 5 project proposals next month. I am really interested in doing a project involving database but as many topics as i have seen look like i would get hooked mid way. So please if you have …

some how mysql database in wamp server 2 got replaced by older database and i am unable to restore the database to the location (before being replaced by old data) from the latest backup i have . is there any way i can restore the data to my required position. …

Hi, I am trying to open some dbf files and two of the three I am trying to open does so just fine, but the third one gives this error: "The Microsoft jet database engine could not find the object 'NewStructures'. Make sure the object exists and that you spell …

Hello, I have my old Mail file on one computer and no longer have access to the same notes db. I need to move my files to another computer and access them. Also read me, that file doesn't work correct

I'm working on a small web project (MariaDB LAMP stack) on my desktop but I'd like to be able to continue working on the project when I am away from home computer. I think I can sync my /var/www/html/ directory without a problem but does how can I export my …

**Bold Text Here**hi,Everyone ,please guide me that how i can install MySQL with window 8,problem is that my RAM is of 20 GB and Window8 consume 17GB on RAM .When i install MySQL my pc becomes heavier and slow ,please tell me how i can solve this problem .Thanks

We have a WCF web service hosted on Windows 2008 SP2/IIS 7 accessing an Oracle database. Usually data access works fine but during load testing, it often times out and logs an exception saying: Error occurred when processing XXXXXXXX Web Service Oracle.DataAccess.Client.OracleException Connection request timed out at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection …

Hi there, I created a new table and forgot to set the primary key with an auto_increment. I went back and use: `ALTER TABLE table ADD PRIMARY KEY AUTO_INCREMENT (column);` However, now whenever I try to insert a new row of data, I get the error message "Duplicate entry '0' …

Hi.. I have a big problem, hope that you can help... I have windows 2003 server with CA brightstor 11.0 (Build 2670) and is making backup to all my SQL Servers. so I need to restore a database where the MDF file is 4 GB and the LDF file 111 …

I want to show the total qty of these query (total qty from datagridview where ActualQty value will update the values of Used Column) `SELECT COUNT(Software) AS ActualQty FROM tblswlogs WHERE Software='MS EXCEL'` and (**Total** will appear in textbox) `SELECT MAX(used + initialqty) As Total FROM tblswlist WHERE Software = …

Hello to all! I am facing problems in feartures of sql sever 2008. I installed it but i could not find management studio in it. then i installed managemenet studio2008 separately. but when i opened management studio then there was no interface for making database but only interface was for …

I'm working with MariaDB through PHPMyAdmin and I have a question about how I need to set up my database. For eash person in the table I am currently building I'll also need an array of date values. I don't think there is a way for me to setup a …

I need to update my records normal password into Md5 passwords.my query was like that UPDATE testing SET password = MD5('Manojano234') This query was working fine but i need to add plain text also

Hi, I am trying to get same field name from different tables. And i am using like the below query to get the field name. I am expecting some other queries to get distinct 'function_name' column from 'N' of tables. SELECT function_name FROM base_table UNION SELECT function_name FROM firstcall_table UNION …

For loop error problem Method: for($i =0;$i<count('$std_id);$i++) { for($j=0;$jcount('$sub_id;$j++) { mysql_query("INSERT INTO mmst_tbl(std_id,sub_id,mark)VALUES('$std_id[$i]','$sub_id[$j]','$mark[$j]')"); } } How to solve this? instead of 138 rows it goes 2000+ lines

Here I have this error java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES) if I execute this thing GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'root' WITH GRANT OPTION; then I have this error. ERROR 1045 (28000): Access denied for user ''@'localhost' (using password: NO)

I'm struggling with my hosting company and have had to move to a new one fairly quickly. I've transferred the pages and the databases over quite easily, but have run into an unexpected problem in the form of the error message below. > Warning: mysqli_connect(): (HY000/2000): mysqlnd cannot connect to …

i want to clear all data in databse automatically for everymonth.iam using xampp.

Hi Guys I am trying to select and display on the RadGrid. i am using sqlDataSource. i have 2 Tables (Users and DealerShip). User table i have attributes (UserID(pk),UserName,Email,Phoneand DealerShipID(fk)) on DealerShip table i have attributes (DealerShipID(pk),DealerShipName) and now here is what i want to do. on my grid i …

Can someone please help to advise below question? I need to do a SUM of the amount column based on the CreateDate date range From 10th of previous month to 10th of this month Below is the database table Amount CreateDate 151.00 5 July 2015 567.50 19 July 2015 558.00 …

Hello i want to put more than one values in a table's row

I have an old sqlite database that I am no longer going to be using but I want to transfer all of my data to my new mySQL database. I have everyone imported and it all looks good but the problem is when I order my one of my columns …

I am trying to update several rows in the database using mysql statement. My code is as follows. <?php $query = mysql_connect("localhost","root","toor"); mysql_select_db("busticket",$query); $result=mysql_query("Select * from ticket_reservation WHERE validate_status='No'") or die(mysql_error()); while($row=mysql_fetch_array($result)) { echo "<tr><td><input type='checkbox' id='name' name='name[]' value=".$row['id']."</td><td>".$row['userid']."</td><td>".$row['busid']."</td><td>".$row['numberofseats']."</td></tr>"; } echo"<tr><td><input type='submit' name='submit' Value='Validate Tickets'></td></tr>"; if(isset($_POST['submit'])) { if(is_array($_POST['name'])) { $qry …

Hi, thanks in advance foy your time. I have in the past made a inventory site where a user selects from a dropdown what he or she has and saves it but this is a little different... What I'm attempting to do is this... User creates an account (have the …

this is my first time of creating trigger..I tried to create trigger using mysql to count how many 2007 data in the table when inserting new record but it not working....... My table have more than 50 data... CREATE TRIGGER No_of_Publisher_year Before Insert ON Book FOR EACH ROW SET @Count_No=New.Copyright; …

Hello, It would be great if someone tell me what is the exact difference between DDL and DML? Thank you

Hi everyone, I have about 20 simple queries running seperately on loading a php page with mysql querying. On my localhost the page takes about 3 seconds to load but on the live server this is over 30 seconds. I'm trying to shave some time off but I'm having trouble …

Please help me.... I want to upload up to 5 photos and save in database. I want by selecting photo it will upload automatically and then the selected photo will appear in the page. It will occure with one by one photo, up to 5 photos and the photos can …

Hi! I am facing problems with sql server 2008. I installed sql server 2008 and it was installed successfully. But when i went to start menu then only following features were displaying 1- sql server configuration manager 2- send errors and reports 3- sql server installation center. But other features …

When I try to create a database with a non root user of MySQL I get this error. -> MariaDB [(none)]> create database cl_db; -> ERROR 1044 (42000): Access denied for user 'garrett'@'localhost' to database 'cl_db' How do I allow my recular username to create databases? Thanks.

The following SQL query would return 1 record with a min(unit_cm): select id, name, category, min(unit_cm), unit_Cost, unit_price, unit_costPerc from ( SELECT a.id, b.name, e.name as 'category', (d.unit_price - d.unit_cost) as 'unit_cm', d.unit_cost, d.unit_price, ((d.unit_cost/d.unit_price)*100) as 'unit_costPerc' FROM menu_items a, item b, menu c, price d, categories e where a.item_id_fk …

How can i design a simple php site with a database like facebook

SELECT subject,GROUP_CONTACT(description)FROM assignment WHERE standard_id='1' AND section_id='61' AND assignment_date='2015-06-30' GROUP BY subject; For above query , I am facing this error , what is the mistake, Error:#1305 - FUNCTION ssv.GROUP_CONTACT does not exist.

hi guys, I have a question regarding databases which made me stuck in my recent interview. How we can identify unique records in any table without using any primary key or unique key ? Plz share your ideas... thanks

Imports MySql.Data.MySqlClient Public Class EmployeeInfo Dim con As MySqlConnection = _ New MySqlConnection("server=127.0.0.1;user id=root;database=bsit3d") Dim cmd As New MySqlCommand Dim da As New MySqlDataAdapter Dim dt As New DataTable Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click End Sub Private Sub display_Click _ (ByVal sender As …

I dont know how to connect C# to MySQL can someone help me?

Hello, Please as at this morning everything was fine, but all of a sudden all data record wiped off from 3tables in my database, now my client can't find records. Am using MYSQL, Visual Basic. Thanks.

Hello Everyone, So I've begun a new project, in an attempt to show off my progress with Javascript. I'm making a little text-based RPG. However, I would like for it to permanently save your character and their progress. Thus, I need a MySQL database. I won't lie, I've only used …

hello daniwebers... I am really stuck with this design of tables for calendar. Here is the thing...there are employees in a specific company. Each employee accepts customers of the company per day. The number of customers is limited by the doctor on a day by day basis. So for e.g. …

I have an Access 2007 file that I was working on at my office. I left for the day and the database was still open. When I came back the next day the system had shut off so I rebooted (no issues). I tried to open the database and am …

Hi all! I have developed my application in VB.NET that uses a mysql database. From my application, I can make mysql backups and restore them. When i take a backup, the result is a .sql file which is saved somewhere. But as usual, one can open that sql file with …

Restaurant | restaurant_id | names | Date | date_id | date | Time_slots | time_slots_id | start_time | end_time | restaurant_id | date_id | Reservations | reservation_id | No.of.people | time_slots_id| Relations between tables: Relation between time slots and restaurants = Many to Many Relation between time slots and date …

In the work I came up against a situation when the working database at the end of day went to the Suspect Mode. And the archive was in many hours before. To transfer it in normal mode, until isn't made repaired base it was impossible. DBCC checkdb also refused to …

I have a table of names that have done something on a certain date, now this could be over and over again yet of course on different dates but never the same. I need to update a field called last_time that corresponds to the previous date that they occur and …

Hi, I am new in pl/sql programming and I need your help. I would like to make a procedure. To be more specific, I have tables like the folowing TABLE1 ================================================ |COL1 | COL2 | COL3 | COL4 | COL5 | COL6 |COL7| =============================================== |600 | 140 | 2 | …

My problem Im almost certian is a permissions issue but im still very new to this so bare with me. I have a server running the latest mysql with mysql workbench installed and im tryign to modify the users and privilieges for either my one table or all my tables, …

registration table broker_id , email , affiliate_id.....etc 40 abc@gmail.com 9999 62 xyz@gmail.com 8888 affiliate_Stats table status_id , affiliate_id , banner_id , campaign_id , clicks impressioins , ctr , sale , sale_price, total_earned...etc 27 9999 3 0 0 1 0 29 9999 3 0 1 0 0 affiliate_chain id name recruitedby …