[ad_1] try this one first away to get data. $check = DB::select(“select * from accounts where username = ?”,[$data[‘username’]]); second away to get data. $check = DB::select(“select * from accounts where username = :userName”,[‘userName’ => $data[‘username’]]); 1 [ad_2] solved Selecting Data from data base SQL
[ad_1] You need cross join : select t1.*, t2.category from table1 t1 cross join (select distinct category from table2) t2; However if you don’t have duplicate then you can directly express it as : select * from table1 t1 cross join table2 t2; 3 [ad_2] solved SQL Server Temp Table Insert from other temp table … Read more
[ad_1] You need to check if the area contains a hyphen. Otherwise Row.Area.Substring(0, Row.Area.IndexOf(“-“) + 1) will return an empty string, and passing the empty string to Replace is what is causing the error. So (and please excuse any invalid VB.Net) If Row.Area.Contains(“-“) Then Dim area As String = Row.Area.Substring(0, Row.Area.IndexOf(“-“) + 1) Row.Area = … Read more
[ad_1] Try code like this using System.Collections.ObjectModel; using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Text.RegularExpressions; namespace ConsoleApplication57 { class Program { static void Main(string[] args) { int employeeId = 113; List<E_JOURNAL> employee = E_JOURNAL.journals.Where(x => x.JOURNALID == employeeId).ToList(); var results = (from j in employee join s in E_ABSENCE.absenses on j.JOURNALID equals s.JOURNALID … Read more
[ad_1] You want to sort on the datetime (or if that doesn’t exist you could use the ID, but that is not how “it should be”) in descending order instead of ascending. Example query: SELECT `title`, `text` FROM `news` ORDER BY `datetime` DESC LIMIT 5 https://dev.mysql.com/doc/refman/5.7/en/sorting-rows.html [ad_2] solved How to order posts by date added … Read more
[ad_1] You can use a recursive CTE to get all the linked users: with recursive u as (select t.id, t.`Referral id`, t.Balance from yourtable t where id = 1 union select t.id, t.`Referral id`, t.Balance from u inner join yourtable t on u.id = t.`Referral id`) (select sum(Balance) from u) Fiddle 0 [ad_2] solved SQL … Read more
[ad_1] Please try this one it will give output as yours. Create table #Table (rowNo int identity(1,1), ID varchar(100)) insert into #Table values(‘32132’) insert into #Table values(‘32132,32132’) insert into #Table values(‘32132,32132,6456,654,645’) declare @TableRow int = (select count(*) from #Table),@Tableloop int = 1 while(@Tableloop <= @TableRow) begin Declare @var varchar(100) ; SET @var = (select ID … Read more
[ad_1] If you cross join your Week and Student tables to get all combinations, and then use not exists to determine where no TimeSheet record exists. select W.WeekID, S.StudentID from [Week] W cross join Student S where not exists (select 1 from TimeSheet T where T.StudentID = S.StudentID and T.WeekID = W.WeekID); 0 [ad_2] solved … Read more
[ad_1] You can group by the truck, filter on the location and check the result is 2: select truck from table where location in (1, 2) group by truck having count(distinct location) = 2 6 [ad_2] solved select only and only specific record in oracle [closed]
[ad_1] This is not the answer, but the start point for you. Here is sqlfiddle: http://sqlfiddle.com/#!9/197dd9/1 You should add more data into that fiddle. After that use my query to see some results and play with that query until you get to the closest result of what you expect to get. And once you get … Read more
[ad_1] Try to avoid posting same question in other ways, edit the same question. You asked the same question in MYSQL OR not working Hope this will really help you:- try { $keyword = trim($_GET[“keyword”]); if ($keyword <> “” ) { $sql = “SELECT * FROM tbl_contacts WHERE 1 AND ” . ” (first_name LIKE … Read more
[ad_1] CREATE DATABASE IF NOT EXISTS database_name will execute the CREATE DATABASE database_name only if the database_name does not already exist. If the database_name does not exit, both queries will do the same job, that is they create the database_name. If the database_name exits, CREATE DATABASE database_name will return an error similar to “the database … Read more
[ad_1] You have defined three columns in the INSERT INTO statement – but the SELECT only provides two. Change your code to so you’re not inserting values into your IDENTITY column: — NOT NEEDED! SET IDENTITY_INSERT #TEMPTABLE ON; INSERT INTO #TEMPTABLE(CARDNO, OFFICEPUNCH) SELECT CARDNO, OFFICEPUNCH FROM [Tempdata] — NOT NEEDED! SET IDENTITY_INSERT #TEMPTABLE OFF; 1 … Read more
[ad_1] If you want to change the date and time of the SQL GETDATE() function then you can do one of the following: Change the date and time of the server where your SQL Server instance is installed. Change the timezone setting of the server where your SQL Server instance is installed.. 5 [ad_2] solved … Read more
[ad_1] Do it on command line: mysql -u USER -p DBNAME < SQLFILE.SQL Enter password when prompted and there you go. [ad_2] solved How long should a 75mb sql file take to import in PHPMyAdmin?