Questions tagged as 'sql'

2
answers

How to join 4 tables in one and show text instead of INT - INNER JOIN

Hello, I know it's more or less like this in 2nd print and with the Inner join but I'm not getting it. I'm using MySQL Workbench and more when I finish this I want to move to C #. I have this question, I have already joined the 4 tables...
asked by 28.05.2018 / 17:42
1
answer

PHP Warning: PHP Startup: Unable to load dynamic library 'pdo_sqlsrv.so' - php7. +++

After completing the installation of PHP7. ++ I got the following error after performing all the steps of the SQL Server PDO Driver Configuration Tutorial for php, restart apache2: PHP Warning: PHP Startup: Unable to load dynamic library 'pdo...
asked by 05.08.2018 / 23:49
1
answer

APS.NET MVC - DB data split

I need to do a function in VB which allows you to list the data of a field in the database in a DropDown. Ihavetolistdatafromthe'EixoX'field(fromthefigureabove)inDropDown.Thequestionis:IneedtolistDBdatafromagivenID,forexampleID=1,whereIhavet...
asked by 30.07.2018 / 12:54
2
answers

Handle .sql file

I have a * .sql file. How do I transfer / use a database? Have the records in the database. (it was sent to me and I do not know how to have the data inside my database, and then use it with php)     
asked by 27.08.2017 / 17:36
2
answers

SQL Server Function - Holidays [closed]

Good afternoon! Dear, I have the following function below that is of the days not worked that is only coming Saturday and Sunday, however, I wanted this function to include the holidays. NOTE: I already have a holidays function, however, I wa...
asked by 12.09.2017 / 22:26
1
answer

Update in two MYSQL tables [duplicate]

How to do an update in two tables, Ex: first table users , would only update in senha , but in table users_info would update cos fields, cidade , nascimento , sexo e etc. I can do it in one, but I wante...
asked by 04.09.2017 / 05:22
1
answer

Delete records with various conditions

I need to exclude duplicate records in column bidding_price with the following conditions: Table: bid_account Columns to check:    id = PRIMARY KEY auction_id = ID of each product bidding_price = val...
asked by 16.04.2018 / 03:30
1
answer

How to sum the values of a column, also adding the decimals in PHP?

How can I calculate the sum of the values of a column by considering the decimal values (after points and commas) with PHP . I used in select o SUM() but the sum returned only integers. I need a way that adds the miliaries and...
asked by 03.04.2018 / 00:23
1
answer

Reordering AutoIncrement in SQL

Hey guys, I created an ID table with Auto Increment, checking the table I saw that Bugou, has any command in SQL that reorders from the value 1,2,3,4 to the last one? just for the sake of reorganization. Thank you.     
asked by 12.09.2018 / 18:24
1
answer

Object of class mysqli could not be converted to string [closed]

I'm having the following error:    Object of class mysqli could not be converted to string. PHP code: <?php include("config.php"); $query = $_GET['query']; $min_length = 3; if(strlen($query) >= $min_length){...
asked by 07.05.2017 / 00:34