Questions tagged as 'sql-insert'

Tagged questions
1
answer

Date insertion in PostgreSQL

I would like to know how to configure Postgre to accept date entries as follows: "12122016" . I know that with the same "spelling" it is possible with YMD but I would like to know how to configure it to accept it. Thanks in advance...
asked by 03.03.2017 / 19:14
1
answer

Insert to C # Dynamic Database? [closed]

I am making a insert and I use a model with the Getters and Setters , when I do the insert in the values I get the model as a parameter and use the following way    sql = "INSERT INTO " + Table + "...
asked by 20.03.2017 / 00:23
1
answer

Problem with Insert and PDO

I'm trying to make an insert with PDO. For this I use: controller / com_clients.add.php <?php if($action == "new_client"){ $search_cod_cliente = $pdo->prepare("SELECT MAX(cli_cod_cliente) AS cli_cod_cliente FROM clients");...
asked by 06.01.2017 / 18:40
1
answer

Error adding more than one given mysql function in javascript intel XDK with PHP

I'm using the following function: $( document ).ready(function() { var $server; $server = 'http://localhost/mobile/DatabaseXDK/database/www/'; $('#inclusao').on('click', function(){ $nome = $('#nome').val(); $.ajax...
asked by 17.01.2017 / 04:40
1
answer

Insert range of numbers into a table automatically SQL

The question is the following I want to insert in a field of a table a range of numbers that goes from 100 to 1 000 000 000 and did not want to be doing 1 to 1. How can I do this automatically? In SQL Server     
asked by 03.10.2016 / 13:15
1
answer

Not saved information in mysql when I click on one of the radioboxes of the form

I have a form with several text fields, radiobox, selectbox, and I want to save the information in the table of the bank that I use. But I'm having a problem when I click on the first two radios boxes , and I can only save when I cl...
asked by 06.09.2016 / 05:35
1
answer

Query in JPQL for insertion of Data

How can I insert data with JPQL containing values: @Query("insert into user values()") User insertUser(); Data:     username     emailUser     
asked by 16.08.2016 / 17:40
1
answer

Laravel - Save data in the database only if there is no ...

I have a person registration system and there is an area with several checkbox fields that represent the social groups that the current person represents: TABLES person id | nome 1 | João 2 | Maria 3 | Ana group id | grupo...
asked by 30.05.2016 / 18:27
2
answers

Problems with insert logic

I have a problem. I'm doing an event access control system, I created a table that records the given id, code, date, time, sit, the sit field will be 1 and 2, but I need my system to understand the following. When the last record of the bank is...
asked by 11.09.2015 / 19:54
1
answer

Inner Join, multiple Inserts with multiple conditions

Well, it's the following, I do not understand where I should start, if I must first select the clients, I'm sure I'll use inner join or some joiner since it uses other help tables. I wanted help to understand how to do this query....
asked by 10.03.2015 / 13:48