Questions tagged as 'mysql'

Tagged questions
2
answers

Make CallBack in Having

In Laravel it is possible to make a callback at the time of a query. For example: $q = Model::where(function($query){ $query->where(...); }); I would like to do something like this, but with having () , since I need to check if a gi...
asked by 24.05.2016 / 16:07
2
answers

varchar parameter in Store Procedure

I have a store procedure in mysql as follows: CREATE PROCEDURE nome_procedure(campo VARCHAR(15)) BEGIN SELECT id as id, campo as value FROM tabela etc etc etc...; END $$ However, since the parameter I am passing is of type VARCH...
asked by 22.10.2014 / 14:24
1
answer

What real difference between the '=' and LIKE?

By doing another test (rs) on a database that I have in MySQL, I realized that: SELECT * From client WHERE uuid = '1kvsg4oracxq' returned the same result as: SELECT * From client WHERE uuid LIKE '1kvsg4oracxq' What exactly is the diffe...
asked by 12.06.2017 / 18:15
2
answers

Assign MySQL query result to a PHP variable

How, after telling how many records I have in a database, how do I put the value inside a PHP variable: $sql = mysql_query("SELECT COUNT(*) FROM 'users'"); $row = mysql_fetch_array($sql); $total = $row['COUNT(*)']; I managed to do what I w...
asked by 17.06.2015 / 16:07
2
answers

Get keys from an array

I am using PDO for mysql query, and I would like to get the keys from an array, tried several methods and did not succeed, ex: $arr_cars['id'] an error occurred class Cars extends DB{ static function getCars(){ $select =...
asked by 14.07.2016 / 07:30
1
answer

New row in the table every 3 columns

I have a table that has to have 3 columns per row. The data from the 3 columns I get from the bank. My problem is that when I display 3 columns, I want the next results to appear on the bottom lines, ie display 3 at 3, but I'm not getting it, be...
asked by 05.05.2015 / 02:04
2
answers

function Angular.js to calculate age

Good evening guys. In my bd, I store the date of birth of clients. I have a list that presents: name | cpf | age? How could I get the data stored in the bd and using Angular.js or php calculate the current age and fill in my list?...
asked by 18.05.2015 / 23:48
3
answers

Sum between MySQL rows

I'm having trouble performing an operation using MySQL, I do not even know if it's possible to do what I want. I have a table_control table, in this table I have all operations that are performed with products. In stock_control I have a co...
asked by 25.10.2017 / 15:56
2
answers

How to show repeated data only once?

Well, I have the following problem in MySQL: I created two tables a table of books and another table of authors. Well, I need to show the name of the book with its authors, however there are some books that have more than 1 author ie using the f...
asked by 17.10.2017 / 00:52
1
answer

Install database together with the C #

I am finalizing a meeting room agenda that will be in the company reception, so I opted for the base to be locally and not networked. I want to use MySQL or SQLite. Can I install the database together with the application? For example: when unde...
asked by 14.08.2015 / 20:22