Questions tagged as 'sql'

Tagged questions
1
answer

SQL Developer, INSERT dated: error - ORA-01843: not a valid month

I am running this to insert values in the table: CREATE TABLE SERVICIOS ( ID INTEGER PRIMARY KEY NOT NULL, FECHA DATE NOT NULL, HORA TIMESTAMP NOT NULL, DISTANCIA DECIMAL (*,2) NULL, TIEMPO_REQUERIDO INTEGER NULL, DIREC...
asked by 23.09.2018 / 07:37
0
answers

Call ajax with onclick

I am trying to count the number of clicks of a specific part of my page. I put an onClick to the element which makes a call to Ajax to store in a database for every click they make. HTML code <a id="tapaweb" href="hola.pdf" onclick="m...
asked by 23.09.2018 / 01:58
0
answers

error in mysql collation_name

I have an error in MySQL:    error code: 1267 illegal mix of   collations (latin1_swedish_ci.IMPLICIT) and   (latin1_spanish_ci.implicit) for operation '=' I have made a query to show me the tables where collation_name sea = latin1_swe...
asked by 21.09.2018 / 15:22
1
answer

Export query data to CSV format from the MySQL console

I have the following query in MySQL , with which I get the posts associated with the users who created them SELECT users.nameUser, posts.namePost FROM users JOIN posts ON users.id = posts.user_id; However, I need to work directly from...
asked by 21.09.2018 / 17:02
0
answers

integrate php search in my table

I am new to this world, I downloaded a source code to create a small project to manage a list of people with about 500 records, so far I have managed to modify it to my requirements, now in the following code I show a table where I list the reco...
asked by 20.09.2018 / 19:05
0
answers

Sql Cloud in Android Studio 3.0

I would like you to help me with a concern, I recently managed the creation of a Mysql database in Sql Cloud of Google, the truth is that I could create the base without any mishap, I can even access it from WorkBench previously giving the autho...
asked by 24.09.2018 / 23:25
0
answers

Display data of an ID from a foreign table

In this second opportunity I consulted a problem that I have when wanting to show specific data of a foreign chart for an ID. Waving more in detail, my web application is a database of entry of detainees (in Table 1 register the personal and...
asked by 25.09.2018 / 02:48
1
answer

The sql server express 2012 database is compatible with visual studio community 2017

I have installed in my computer visual studio community 2017 and I want to do some tests integrating some softwares that I have been developing for some activities of the university where I study with a database sql server express 2012, because...
asked by 25.09.2018 / 03:57
0
answers

Clear data from a SSAS CUBE

Good day forum I have a question I'm not an expert in Analysys Service I made a multidimensional data cube that is processed daily, from a data source data warehouse SQL server, in the fact table I have a partition that only took me to the cube...
asked by 03.10.2018 / 18:30
2
answers

Subtraction between two SQL fields

hello good morning I have the following problem I need to get the difference between two fields. These fields I have to add the total of all their values and then do the subtraction BUT I THROW ANY RESULT ONCE MADE THE REST SINCE I AM THANK Y...
asked by 03.10.2018 / 15:56