Questions tagged as 'mysql'

Tagged questions
1
answer

Adding elements from the server

Hello, I would like to know how to add values that pass me from the server. I created a system that controls the expenses / accounts, you register one of your accounts. EX: Home Name: Car Value: R $ 10,000 (per month) Times: 5 Total: $ Valu...
asked by 21.04.2017 / 18:55
1
answer

Return value generated from foreach

Basically, I have this foreach to dynamically create the selection text: foreach ($table['exists'] as $item) { switch ($i) { case 0: echo($item.' = "'.$_POST[$item].'" AND');...
asked by 21.04.2017 / 19:01
2
answers

New time schedule - Database

I have an ordering system, where the product delivery time is selected in a normal input of type='time' , and stored in the database in type time as well. Everything is working perfectly, however I will have to change and it has to be as f...
asked by 09.03.2017 / 22:40
1
answer

Check value textbox x mysql (universal app win 10) [closed]

I have a textbox where I store a value. I would like to know if this value is the same as the last id in my mysql database table. How do I do this?     
asked by 11.03.2017 / 21:37
1
answer

How to obtain data from Banco Mysql?

I have this code snippet where it takes the information from a database field and passes it to the textBlock, so now I need to populate some textblock.    EX: In the database has name = maria Rg = 123 cpf = 456 ai in the program vai   have th...
asked by 09.03.2017 / 13:10
2
answers

Column count does not match the count of values in row 1

I need guidance on how to identify the error in this message after importing a text file:    1136 - Column count does not match the count of values in row 1 The columns of the table are 10 and the data entered is also 10. SEE: INSERT IN...
asked by 05.04.2017 / 13:44
1
answer

HTTP request limit and SQL queries

I am developing a system that will have a lot of requests and would like to know the opinion based on your experience. 1) A server running apache with php and 64GB of memory, would process 50,000 requests per second? Example, an HTTP request...
asked by 05.04.2017 / 03:16
1
answer

Difficulty in adding PHP data MYSQL

Well, the title itself is already self-explanatory. Perhaps the only relevant detail I can add is the fact that when I perform the operation I do not receive any errors or warnings. Thanks in advance for the answers. <?php i...
asked by 08.05.2017 / 00:33
1
answer

Relationship 1: 1

I am having problems in the relationship of my products and stock tables. The stock table is responsible for storing the quantity of each item in the products table and the date when the product came in stock. Each item in the products table c...
asked by 08.05.2017 / 18:49
1
answer

I can not restore database in mysql

I'm trying to restore a DBS that I have on my machine, but unfortunately I'm having problems ... ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to u...
asked by 05.05.2017 / 19:55