Databases Forum

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

here i have 3 tables. i want to display OfferDescription,OfferImage,offerPath based on spaid.becaz offerimage and offerdescription are added by using array.so its in different table. if i add companyname and 2 offerimage and 2 offerdescription its added in this 3 tables.after i have to display based on spaid value.i tried …

hello So i have problem in connecting to my oracle database on the server it threw an exception like this "The type initializer for 'Oracle.DataAccess.Client.OracleParameter' threw an exception". my supervisor told me that it might be a referencing problem in this library Oracle.DataAccess.Client.OracleParameter,but i think that the library doesnt fing …

for pagination i need to display number of data.here is my query but am getting error like You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'st.state)as num from spa s left join relatedcatagories …

Hello, I need to run a report against a database, and I am having a difficult time thinking of a way to run a particular report. What I need to do is run a report which selects students that have no course registrations for three consecutive semesters. The semester table …

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

I'm working on an application for a joint-stock company. A joint-stock company is a business entity which is owned by shareholders. Each shareholder owns the portion of the company in proportion to his or her ownership of the company's shares (certificates of ownership). This allows for the unequal ownership of …

So I'm really new to the whole database thing. Now I have a website running here. http://fcsit-trackandtrace.comuv.com/ You don't need to register, as the member's area is empty right now. Now what I want to do is, when someone logs in, he will get this sort of service where he …

Hi all I need some advice making my query work properly. I already played around it a dozen of times and still can't get it work. So as my last option im here:) . what im trying to achieve is sum all amount of a particular rows and display the …

Hello Below is the schema with sample data of table es_preadmission  I am trying to get the number of male and female students from each categories (GEN, SC,ST,OBC), bpl, sgc, handi,ser_cat class wise. Example class 1 => GEN => Male = 3, class 1 => GEN => Female …

i have 3 tables and i want to display companyname,maincategory,city,place 1.SELECT `id`,Companyname from spa 2.SELECT `id`, `mainCatagoryid`, `RelatedCatagory`, `spaid` FROM `relatedcatagories` SELECT `id`, `MainCatagory`, `name`, `size`, `path` FROM `catagorykeywords` SELECT `id`, `Subcatagory`, `MainCatid` FROM `subcatagorykeywords` 3.SELECT `id`, `city_id`, `state_id`, `spaid` FROM `city_place` SELECT `city_id`, `city`, `state_id` FROM `cities` SELECT `state_id`, …

I have a table called "mytable". The columns are Time_Stamp (datetime) PK Time_stamp_ms (int) PK data1 (int) data2 (int) data3 (int) data4 (int) data5 (int) data6 (int) cycle (int) name (varstring) I want to order by Time_Stamp and Time_stamp_ms and then each time cycle reaches 1, I want to get …

I wish to implement a tag system for a gallery,I have a huge number of images and all of them are to be associated with one or more tags. The number of tags is also large,but not exceeding say 500,isn't constant.Tag texts may also be large in certain cases. What …

Hi, My instructor has given me a project as: Car Maintenance System Data Entry Forms Setup: a) Vehicle b) Maintenance Types c) Parts d) Labor Transaction: a) Work Order Reports a) Printed Output: i) Work Order b) Information Outputs: i) Vehicle Maintenance History, ii) Labor wise work orders Its vague …

hi there, i am getting this error while activity monitoring on sql server 2008 R2(SP2) and at the same time all the users application (i.e arround 200 users window user application) connected to the database in this server gets Hang and again starts functioning properly after 1 or 2 mins …

here i have to store comapnyname,contactperson,city,place,maincategory,subcategory values.but i have 4 tables with data's like maincategory,subcategory,city,place. so how can i store the below data's in table.in spa table i added maincategoryid and cityid is enough or else these city and category i have to store in another table. please give some …

Hi Folks, I am having problem with my web design. I am making a query that involves two table but it doesnt do anything when i click submit. do i make mistake in the query ? my code is like this, <?php if ($_POST['action'] == 'show'){ $requestCompSql = "SELECT REQUEST_COMPONENT_CUTTING.PROJECT_NAME, …

Im trying to delete from multiple tables using full outer join like this: $del_id = (int) $del_id DELETE contact, child, spouse FROM contact FULL OUTER JOIN child ON child_name = c_name FULL OUTER JOIN spouse ON s_name = name WHERE contact_id = $del_id I get warning/notice: unknown table contact in …

Is there any syntax error in this code or query because i am not getting the required report? I have created a JFrame with JDatechoosr. When i select the dates and click view report, it gives me empty report while i know there is data within the specified date range. …

I am trying a query in mysql. I have 3 tables which are linked by the same foriegn key ... Table 1 = students (PKey - stdnt_rfid_tag) Table 2 = student_attendance ( FKey - s_id for stdnt_rfid_tag ) Table 3 = users ( Fkey - s_id for stdnt_rfid_tag) In the …

I cant log in to wamp server although i get in the phpmyadmin. When i try to open my project i get access denied for user 'root'@'localhost' (using password yes)

Hello to everyone. I have this table: CREATE TABLE `documents_category` ( `id` int(11) NOT NULL AUTO_INCREMENT, `parent_id` int(11) NOT NULL, `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `description` text COLLATE utf8_unicode_ci NOT NULL, `active` varchar(255) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; I am trying …

I was wondering if there is any way to do a single mysql query to do a count of filled positions in a multi-level structure to an indefinite depth. That sounds a bit cryptic, but this is what I would like to do if it is at all possible. we …

Hi guys i want to make database for payroll only but i dont know how to make structure for this suppose i want to calculate payroll every month for employees as following basic salary bonus overtime absence deduction meaning salary = basic salary +bonus+overtime-absence-deduction How i make database (ERD)Diagram for …

I need some help with this project. I've gone as far as I can go, with no results, The inquiry form works, but I need to populate it with my sql table. I could only screen shot my sql and I have no idea of how to put it on …

Hi, I have this list : CompanyID CompanyName Involved Party Involvement C 10001 GRAF LIMITED GRETA PACE BONELLO Director C 10001 GRAF LIMITED GORDON PACE BONELLO Director C 10001 GRAF LIMITED DAVID PACE BONELLO Director C 10024 J.P.F. TRADING COMPANY LIMITED PATRICIA FERRIGGI Director C 10024 J.P.F. TRADING COMPANY LIMITED …

Im doing a query and Im getting this: Error Code: 3. Error writing file '/tmp/MYYQVeZr' (Errcode: 28) Its not a space issue or a permission issue either:  Whats wrong?

Simple timediff: SELECT time_format(timediff('2014-04-24 09:11:37','2014-04-24 09:09:37'),'%H:%m:%s') as dif Returns 00:00:00 . Im problably missing something stupid, my apoligies...

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

COMBINATION_ACIL contains column: id (primary) prodcode [group] alias lastupdate updateby and here is the steps when i import xml to sql DECLARE @COMBINATION_ACIL AS xml SET @COMBINATION_ACIL = ' <Product> <product> <PRODCODE>CADB</PRODCODE> <GROUP>CADB</GROUP> <ALIAS>ADB</ALIAS> </product> <product> <PRODCODE>CI50</PRODCODE> <GROUP>CI50</GROUP> <ALIAS>I50</ALIAS> </product> <product> <PRODCODE>CI80</PRODCODE> <GROUP>CI80</GROUP> <ALIAS>I80</ALIAS> </product> <product> <PRODCODE>HOSBA</PRODCODE> <GROUP>HOSB</GROUP> <ALIAS>HOSBA</ALIAS> </product> …

I'm trying to create a table but I keep getting errors: Here are the errors: mysql> source Tables3.sql; Database changed ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at …

I have a table that will have several fields, such as counties, age_groups, gender, sports, etc.. on countries I will be storing data with this format["US","CA","DK","FI","RU","SE"] on age groups I will be storing data with this format["2000","1999","1998"] on age groups I will be storing data with this format["M","F"] on age …

I insert something simple like insert into table(pri1,pri2,value) values (1,1,1); insert into table(pri1,pri2,value) values (1,2,1); And in MySQL 5.6 they show up as: pri1 pri2 value 1 1 1 1 2 1 BUT In MySQL 5.1 I do the same thing and they show up as: pri1 pri2 value 1 …

Hello Sometimes I get a duplicate key which I want to ignore or discard. This is a example and has nothing to do with the actual query. I simple want to state columns/values insert into table(Time_Stamp,Time_Stamp_ms,p1) values (time,timems,'1') Where the first two are my PK. I see that insert into …

Hi Everyone, I'm trying to import a ever changing CSV into MySQL on the fly, there is constant data being aded to the file and don't to everything every time. Is there a way to add new data only? Kind Regards

I usually use wp clone wordpress plugin which basiclaly zipped the database and folder of wordpress to upload to a new install of wordpress. I can't use it however on a bridal woocommerce website. It tries then eventually gives me a 404 page not found error. The is has about …

i have a works to create table report like in attached image.  i don't know how to arrange the days and grouping as Time, thank you for help...

I am trying to write a querry to pull just one playername out of a database by random, can anyone see what I am missing please ? open base< $sql="select playername from tablejollys where (ID % 1000) = floor(rand() * 1000) order by rand() limit 1"; $result=mysql_query($sql); echo ['playername'] ; …

Hi, I have two tables called header user, inbox. The table structures mentioned below, User: NUM_USER VCH_NAME VCH_PHONE_NO VCH_STATUS 1 XXXX 123 Y 2 YYYY 321 Y 3 ZZZZ 456 Y INBOX NUM_ID(P.K) NUM_CUST_ID NUM_SEND_CALL_ID NUM_REC_CAL_ID DTT_DATE 1 10 2 1 4/11/2014 2 10 3 2 4/11/2014 3 10 3 …

We're learning pl sql in class, and I was just wondering if anyone noticed any glaringly obvious errors in my code? --Gets the phone number of a specific member set SERVEROUTPUT on DECLARE phone_number Member_T.Phone%TYPE; BEGIN SELECT Phone INTO phone_number FROM Member_T WHERE MemberCardNumber= 2436322287; DBMS_OUTPUT.put_line (phone_number); END; --Uses a …

I have huge csv file that i need to load into database using sql loader. In the file, there are columns enclosed by ", but some of them is not and in these columns there are single quotes and I would like to know how to deal with them (I …

Hi, Hi I only want to select 5 rows. Can you please tell me how to do it in sql? Thank you. example: ratee rater apple banana apple orange apple peach apple sunkist apple mango apple grapes grapes orange I want to see random selected of 5 ratee orange with …

I have this table: Time_Stamp Time_Stamp_ms '2014-04-11 13:33:24', '879', '5555', '4444', '3333', '2222', '1111', '123', '1', 'text' '2014-04-11 13:33:24', '899', '5555', '4444', '3333', '2222', '1111', '123', '2', 'text' '2014-04-11 13:33:24', '919', '5555', '4444', '3333', '2222', '1111', '123', '3', 'text' '2014-04-11 13:33:24', '939', '5555', '4444', '3333', '2222', '1111', '123', '4', 'text' …

I would like to be able to store data in various files instead of one huge one to make remote backups easier on MySQL. How can I set this up? Thank you

Good afternoon, I'm trying to formulate what should be a simple query that will create a result set of ALL records from a table that have a date that is in the previous month... Basically something like this one that I use that gets any records prior to the current …

I have set up a data base called assignment with a table called 'Parts' in it. But when i run the follwoing code on my local host i get the following error "Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in /Applications/XAMPP/xamppfiles/htdocs/lab9.php on line 8". Can anyone help …

We have various databases on several offsite locations and we want to do a backup to here. Problem is that database is problably going to weigh GBs of data so it would be better to split it into several "files" so we can only get the updates in small amounts. …

Hi, How to use in select statement with where condition comparing a Null value and with value? I have this Statement `Select Col1, Col2, Col3 From Table where DateDeleted` 'Here comes the problem The condition is something like if DateDeleted (which is actually a date) is Null then get records …

Here's how I'm thinking about inserting values into two tables. Each `reservation` will have a set of `services` the amount of which can vary, so I need to setup the query dynamically, here's my first sketch, although not tested yet. function saveBooking($fullBook) { $mysqli = new mysqli(HOST, USER, PASSWORD, DB_PRICE); …

I' ve converted mssql database to mysql database (locally). I ve created a free subdomain and found a free webhoster on 000webhost.com. I m trying to import my mysql database onto the server using phpmyadmin interface but am unable to do this. I get the following error-->#1044 - Access denied …