Questions tagged as 'mysql'

Tagged questions
1
answer

What to do when this happens?

I'm working on a system in which I must register various data from a form in different tables using mysql. It works like this: The person does a registration and in the same form requests a special attention, I save his data normally and with hi...
asked by 24.05.2017 / 21:06
2
answers

Sql auction script [closed]

I need to make an application for a used things auction company, so I need to create an interface where n clients can bid a minimum and a maximum bid for a X product and the system returns the winner, but making a rule for the customer to pay...
asked by 07.02.2017 / 00:53
2
answers

Error fetching MySQL data with PHP [closed]

I can not get information to the database using php. Here's the code I've implemented to fetch this information: // Create connection $conn = new mysqli($servername, $username, $password, $dbname); // Check connection if ($conn->connect_err...
asked by 02.02.2017 / 12:34
1
answer

How is Java related to MySQL? [closed]

I want to develop expense control software and want to use JavaSwing with MySQL. So I have a question regarding the database. I know it stays on a server, but when I compile the program and want to distribute the software will I have to install...
asked by 01.08.2018 / 23:24
1
answer

Is it possible to use MySQL with Entity Framework 6 and get good performance of CRUD? [closed]

Is it feasible to use MySQL with Entity Framework 6 and get good performance from CRUD?     
asked by 13.04.2015 / 23:29
1
answer

How to insert timestamp value into a MySQL table?

I'm getting a timestamp value from a request, and I'd like to store this value in my database, however I want the column to interpret it correctly. The value is 1416178487. And using PHP's date('d/m/y',1416178487); function, it returns...
asked by 17.11.2014 / 00:06
1
answer

How to fetch all records in the database?

   Help me out! $BuscaProdutosAtivos = $pdo->prepare("SELECT * FROM tbl_produtos p INNER JOIN tbl_categorias c ON c.cat_id = p.prod_categoria INNER JOIN tbl_vari...
asked by 26.11.2014 / 01:27
2
answers

Search in related table

I have a search script that scans up to three fields of a table named products, I now need to do a search on a table named tag, the product table has the tag id that relates to the tag table, but I am not able to implement. The search looks l...
asked by 15.01.2015 / 22:10
1
answer

Property HasRows in C #

I'm doing SELECT mysql with inner join within my C # application MySqlCommand _comandoDados = new MySqlCommand(String.Format( "select EMGroot.id, EMGroot.lbs_net, EMGroot.lbs_gross_aai, EMGroot.price_brazi...
asked by 20.07.2018 / 20:20
1
answer

Alternative to PHPMyAdmin [closed]

Does anyone know how to tell me a database manager where I can assemble more complex queries without having to type the query? Just by clicking where I want to do a SELECT for example? I need to make multiple queries that involve a SELECT in...
asked by 23.07.2018 / 13:33