1,079 Recommended Topics

Remove Filter
Member Avatar for
Member Avatar for Ziggynet

Hi there here is a stupid question. I have created an update statement that updates a table that has null user id using a name as the identifier: [CODE] UPDATE dembel SET userid = 8908 WHERE [Name] = 'o'reily' [/CODE] However the the name already contains an apostrophe which causes …

Databases mssql sql
Member Avatar for Sherin Mathew
0
427
Member Avatar for divyang_patel

[MYSQL] my query is:- SELECT * FROM (SELECT 'attendence' AS 'type',userAS 'username', STR_TO_DATE(in_time, '%d-%m-%Y %H:%i:%s') AS 'time_in', 'in_address' AS 'address_in', STR_TO_DATE(out_time, '%d-%m-%Y %H:%i:%s') AS 'time_out', 'out_address' AS 'address_out' FROM attendence UNION ALL SELECT 'visit', username, STR_TO_DATE(visit_time_in, '%d-%m-%Y %H:%i:%s'), location_in, STR_TO_DATE(visit_time_out, '%d-%m-%Y %H:%i:%s'), location_out FROM visits) t WHERE t.username = 'MCCuser0036' …

Databases mysql
Member Avatar for AndrisP
0
338
Member Avatar for Papa_Don

Hi group, I've just installed Visual Studio 2019 and have started my first app using this. Within the program I created a database using the tools provided in Visual Studio. I now want to begin writing to the tables I've created. But I'm stumped on how to do this. Hopefully …

Databases vb.net visual-studio
Member Avatar for Papa_Don
0
3K
Member Avatar for Menzk

I have a sp which has multiple resultset.I need to create another procedure which should execute the second resultset of 1st sp for ex SP1 gives two resultset I need to write sp2 which uses only the second resulset

Databases sql
0
332
Member Avatar for Menzk

I have a sp which has multiple resultset.I need to create another procedure which should execute the second resultset of 1st sp for ex SP1 gives two resultset I need to write sp2 which uses only the second resulset

Databases sql
0
295
Member Avatar for Menzk

can we able to count how many number of resultset is returned by a stored procedure? i have a sp which will result in multipe resultset. more then 6.sometime 4 sometime 6 based on the parameters. so i need to count how many resultsets are returned by the sp

Databases sql
0
292
Member Avatar for Kraso

I have a table where I want to update "time 2" row, in the user's last "time 1" entry. I was try this, but not function. UPDATE `temp` SET `time2`=NOW() WHERE user = 'kraso' (SELECT max(time1) FROM 'temp')

Databases sql
Member Avatar for Sherin Mathew
0
718
Member Avatar for prochotap

In mysql database i created "leave" table: CREATE TABLE `leave` ( `ID_LEAVE` int(11) NOT NULL, `ID_WORKER` int(11) NOT NULL, `BEGIN_DATE` datetime DEFAULT NULL, `END_DATE` datetime DEFAULT NULL ) INSERT INTO `leave` (`ID_LEAVE`, `ID_WORKER`, `BEGIN_DATE`, `END_DATE`) VALUES (3, 26, '2019-03-20 07:00:00', '2019-03-21 15:00:00'), (4, 22, '2019-03-20 07:00:00', '2019-03-20 15:00:00'); "Workers" table: …

Databases mysql
0
235
Member Avatar for SimonIoa

Hello i have a problem with a Sql script `SELECT col1_id, col1_name, col2 FROM table GROUP BY ?????` col1_id col1_name col2 A john bear A john dog A john cat A john bear A john dog A john cat A john dog A john cat A john bear A john …

Databases mysql php
Member Avatar for jamesdave
0
3K
Member Avatar for k_7

Hi, How can i make query for this: Table1 Column1 Column2 LS11111 0 LS22222 100 LS33333 10 LS44444 0 LS55555 25 Table2 Column1 Column3 LS11111 100 LS22222 80 LS33333 25 Result i need is Column1 Column2 LS11111 100 LS22222 100 LS33333 25 LS44444 0 LS55555 25 Column1 is same on …

Member Avatar for Sherin Mathew
0
546
Member Avatar for dongtrien

In Access I want to group and assign data according to conditions with 2 values 0 and 1 (true or false) and with the condition NGAYGIAO>= #01/01/2019# and NGAYGIAO <=# 31/01/2019# me How to write commands ? The data I put in the excel file consists of two sheets: Original …

Databases sql
0
301
Member Avatar for azegurb

Hi there, recently I have created stored procedure in **Postgres Sql** which deals about with hashing passwords. When used via **pgAdmin** tool it works like a charm as stated below. SELECT horeca_user.update_token( 1, //user_id 1, //type 'sdsfsdfs' //token ) I have also installed extension **pgcrypto**. It works when called via …

Databases php postgresql
0
250
Member Avatar for Mike Bishop

Can anyone help me with a SQL string ? or point me in the right direction? I have a colum called ctn_node_path which has results like PARTS & ACCESSORIES > PSJOHNSON - SEDDON JOHNSON PARTS > JN - JOHNSON PARTS I am trying to split the string into three PARTS …

Databases mssql
Member Avatar for rbjolly
0
393
Member Avatar for SimonIoa

Hello i want to UNION three tables from the same database. SELECT DISTINCT * FROM (SELECT uid as id, name as name, username as username,bio as aboutme, '' as text, 'user' as type, profile_pic as profile_pic, '' as media_pic, '' as group_pic, 'U' as mediatype, '' as image_path FROM users …

Databases mysql php sql
Member Avatar for SimonIoa
0
2K
Member Avatar for Peter_77

So I am attempting to do an ER diagram over a login, with just login data, and the base data of the person loggin in, and the connection between login_ID and Basedata/Stamdata_ID. Is this correct, or how would you guys do it? ![53117831_816749895338489_2535073724562931712_n.jpg](/attachments/large/4/592e2722cc6c966e769126c23313ec2e.jpg) http://prntscr.com/mskpli

Databases
Member Avatar for Alexander_17
0
619
Member Avatar for dongtrien

I want to calculate the total conditional in the month but remove the records that are not the same month and not the same year, the condition that eliminates the view on the sql access because the result is true or false in the excel file http://www.mediafire.com/file/kq2mr2v6px1uxan/exercise.rar DOANHTHU2: Sum(IIf(Not IsNull([DONGIA]),[SOLUONG]*([DONGIA]/1000000),[SOLUONG]*([DONGIATT]/1000000))) …

0
336
Member Avatar for macusberts

Please I'm trying a simple connetivity with VB.Net to Microsoft Access Database and it keeps giving this erro message.... Please i need help Thisis the error it gives The 'Microsft,ACE.OLEBD.12.0' provider is not registered on the local host

Databases microsoft-access
Member Avatar for spiderxman
1
2K
Member Avatar for open2join

Hi Pobably it is going to be repeated question but I wasnt able to find such thread. I just would like to do sql through C++ and I have 2008 ms database. What are free libraries available for doing such job? Thanks

Databases c c# c++ sql
Member Avatar for rproffitt
0
349
Member Avatar for Magic8Computing

A long shot I know but a colleague has left, leaving behind a couple of access databases that query each other and a sql database, unfortunately one of the databases querys now takes a long time to run to the point that the excel report calling the query timeouts. is …

Databases microsoft-access sql
Member Avatar for rproffitt
0
392
Member Avatar for phphp

Sir I have this data ![Untitledg_jygukg.png](/attachments/large/4/e33bd064d12c1ff9b76646dc9376d4de.png) Group by hours Or First value of every hour Please help

Databases sql
Member Avatar for AndrisP
0
289
Member Avatar for bprosic

Hi, I want to design DB for posts with multiple subcategories and categories. Example: Category has information: C#, PHP, JS, Python. Subcategory can contain: Logger, String, While Loop. A post table contain posts about "while loop" in PHP language and posts about "while" loop in C#. So, this is a …

Databases first-post mysql php
Member Avatar for AndrisP
0
669
Member Avatar for John88pogi

i need help on this project it really makes me crazy... imnising access 2007 and vb6 together in my code im trying to make a report using sql query inner join on access database with aggregate function so sad the result is really bad.... the many to many relation ship …

Member Avatar for le5691
0
395
Member Avatar for narendra_jntu

plz... some give me the answer for this . this was asked in an interview.

Databases oracle
Member Avatar for Mandava PavanKumar
0
8K
Member Avatar for SimonIoa

Hello i have a database which users make groups or send messages to other registered, in our project, users. So you have messages as M,users as U, groups as G. So you want to show all updates that happen in these tables WHERE (uid - thats the user id column …

Databases display mysql
Member Avatar for SeanDevoy
0
2K
Member Avatar for mksaeed

Hi guys, This is my first post and so glad to start sharing the knowledge. I am using Mysql database with VB.NET and I have this code : Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click Dim str As String = "Server=localhost;Port=3306;Database=testdb;Uid=root;Pwd=password" Using con As New MySqlConnection(str) Dim …

Databases mysql sql vb.net
Member Avatar for Santanu.Das
1
3K
Member Avatar for Dani

What's the difference between LCASE() and LOWER() in MySQL? I found places on the web that said they're similar but not a synonym for each other, so I'm not sure what the differences are?

Databases mysql
Member Avatar for pty
0
4K
Member Avatar for dongtrien

Previously used winXP operating system running normally (very good) when switching to win7 operating system, this error, read errors from the SQL Server data, what is the error ? http://www.mediafire.com/view/4q5ux6e66ds4avb/ErrorOpenSQL.jpg/file

Member Avatar for rproffitt
0
474
Member Avatar for Dani

I need help with implementing MySQL transactions with PHP. Specifically, I'm confused between the flags `WITH CONSISTENT SNAPSHOT`, `READ WRITE`, and `READ ONLY`, what their differences are, and how they relate to table locking. I already read the MySQL reference manual but I'm still confused.

Databases mysql
Member Avatar for Dani
1
2K
Member Avatar for Dani

If a bulk MySQL insert takes 5 minutes to complete, and one of the columns in the table is a TIMESTAMP column with a default value of CURRENT TIMESTAMP, will the timestamps of the rows that were inserted be reflective of the entire 5 minutes, or will they all default …

Databases mysql
Member Avatar for pty
0
3K
Member Avatar for VenusCrystal

Hi, I have installed Oracle 11g (latest version 11.2.0.1.0) on my system. During the installation it didnt ask me to set username or any password. I'm unable to start sql plus because i dont have the username and password. Can anyone tell me what is the default username and password …

Databases oracle
Member Avatar for Shiwam_1
0
65K
Member Avatar for Eric_28

I want to create a php function that i can use to get a particular user details and display the info gotten in my ProfileActivity when a user profile is been clicked in my app. so i wrote this php code to get user details from my database but when …

Databases java mysql php
Member Avatar for AndrisP
0
502
Member Avatar for Precious_7

hello everyone im taking database course this year and it's my first time to take it so i need help how to draw a ERD for following busniess case AND IF there many to many relation how i can establish a new relation ! Entity (Artist ) Attribute : death …

Databases database-design
Member Avatar for rproffitt
0
376
Member Avatar for Thodoris_1

Hello! I have a problem with a MySQL database that I haven’t been able to solve no matter how much I tried, either with internet guides or with free tools. I really don’t want to pay hundreds of dollars to a company so please, if anyone knows of a solution, …

Databases mysql
0
326
Member Avatar for aldeene

Hi to all! I'm fairly new to using High availability group and i've been having issues with storage space from my Logs drive from my primary server.. I just want to know why is my Log file not shrinking after I do backups(Full) on the primary server.. also, another question.. …

Databases sql storage
Member Avatar for aldeene
0
750
Member Avatar for Hoang_7

I read several forums questions related to SQL database corruption. As we all know, backup is the best way to repair SQL database. What a user will do when backup copy is also corrupted or updated bacjup is not available? Is DBCC CHECKDB Repair option (Repair_Allow_Data_Loss) safe?

Databases sql
Member Avatar for Claire_3
0
320
Member Avatar for Jessica_16

Hi Guys! I have a website but we don't host in GoDaddy or any hosting website, because we use SQL database. And we have a large database that we are using , the website is for productions. We store a lot of data. We use the IP address because we …

Databases asp sql
Member Avatar for Jessica_16
0
564
Member Avatar for SimonIoa

Hello i have a project that uses firebase but i want to make connect to my MySql database on xampp. Any idea what to do?

Databases firebase mysql
Member Avatar for pty
0
597
Member Avatar for Mo_1

Hi there, i'm trying to create a class schedule for subjects where students can view what's available and later on book a position in a class. Here are the images of what i'm trying to achieve: https://imgur.com/a/Ie4XO I want to retrieve the table name and ID of students that have …

Databases sql
Member Avatar for alan.davies
0
2K
Member Avatar for Mike Bishop

When i run the statement below i am getting a number of xxx.xxxx can anyone help me change this to two DP? (SELECT sum(oht_net) FROM order_header_total JOIN order_header ON oh_id = oht_oh_id WHERE oh_cd_id = cd_id AND oh_sot_id = 1 AND DATEPART(yyyy, oh_datetime) = (SELECT DATEPART(yyyy, GETDATE()) -1))

Databases sql
Member Avatar for Vijay_32
0
260
Member Avatar for Carlos_18

I am trying to select all rows from all tables in the database when a column equal a given name. I have like many tables with same structure and columns. I have written this piece of code but it throws an error. SELECT GROUP_CONCAT(qry SEPARATOR ' UNION ') INTO @sql …

Databases mysql sql
Member Avatar for White_4
0
12K
Member Avatar for Lucky_8

Hey , am currently doing my school project of coming up with school reports of learners but when I tried to connect my database with the ms vb it gave me an insert into error whil I was trying to register learners .Please help.

Databases
Member Avatar for Reverend Jim
0
476
Member Avatar for falak_1

I use codeigniter3.0.0 version, when i run the project i get this error plz tell me how i fix this error. Error Number: 1048 Column 'no_of_people' cannot be null INSERT INTO reservation (no_of_people) VALUES (NULL) Filename: C:/xampp/htdocs/book/application/models/Books_model.php Line Number: 26 My model code is class Books_model extends CI_Model{ public function …

Databases
Member Avatar for happygeek
0
432
Member Avatar for progtick

I am using a code similar to the one below inside my stored procedure: [CODE]declare @tempVar decimal select @tempVar = amount from tempTable where <<conditions>> IF (CONDITIONAL STATEMENT) BEGIN select @tempVar END [/CODE] now I am supposed to be getting 4.25 something and I get 4, when I can clearly …

Databases client-server mssql sql
Member Avatar for happygeek
0
649
Member Avatar for Amaina

I have been cracking my head on this mater in the past couple of days. I am faced with a situaton where i need to write a MySQL equivalent of PHP code to loop through sql select results. The Php code looks like this $query = "SELECT pubid, author FROM …

Databases mysql php python sql
Member Avatar for flashx4u
0
19K
Member Avatar for mirapsm

How to display an available room using date range? below is a code, where is display all the room on that date. its should display a room that had not been booked between two dates. my input : $datein = 31-12-2014 $dateout = 01-01-2015 below is database : ---------- room …

Databases mysql
Member Avatar for Jun_7
0
4K
Member Avatar for Dave_20

Hey guys. So this should be a pretty simple question (but doesn't appear to be) that I'm hoping some of the database wizards out there can help me with. I'm not too long outta university with a BSC in Computing, I didn't get a full classification due to the fact …

Databases mysql php
Member Avatar for overwraith
0
626
Member Avatar for anitg

I have two tables like below tb1 Date Cr Dr 2018-04-29 100 50 2018-04-30 0 150 2018-05-01 250 100 2018-05-02 150 100 2018-06-10 300 250 2018-06-11 0 50 tb2 Date Cr 2018-05-01 350 2018-05-02 250 2018-06-10 300 2018-06-11 100 2018-06-15 200 2018-06-18 100 I need the following Result Apr May …

Databases php sql
Member Avatar for flashx4u
0
567
Member Avatar for anitg

I am trying to get access toke from FB through Developer App. But I am not able to json_decode the call back response. If I use the token_url call from browser, it returns the access token. But from within the script it does work. I searched online and foun that …

Databases json php session
0
283
Member Avatar for savedlema

Greetings! I got a mysql database "backup" that someone made and I have to use it, trying to get a website back online. Its a Joomla web database. The person gave me a file "database.txt" (not database.sql) which opens with Notepad. Trying to "import" in phpmyadmin does not work and …

Databases mysql sql
Member Avatar for Daniel_87
0
762
Member Avatar for Dazy

I read several forums questions related to SQL database corruption. As we all know, backup is the best way to repair SQL database. What a user will do when backup copy is also corrupted or updated bacjup is not available? Is DBCC CHECKDB Repair option (Repair_Allow_Data_Loss) safe?

Databases sql
Member Avatar for Dazy
0
349

The End.