Questions tagged as 'mysql'

Tagged questions
1
answer

How can I fill my tables with data, since all but 1 (tb_carrera) have foreign keys?

Create database proyectoweb; use proyectoweb; DROP TABLE IF EXISTS tb_carrera; CREATE TABLE tb_carrera ( id_carrera int not null auto_increment, Nombre nvarchar(50) not null, constraint pk_1 primary key(id_carrera) ) ENGINE = InnoDB; DROP TABLE...
asked by 05.04.2017 / 02:15
1
answer

Enter values to the database

I have my database created, in it a table with the fields, ID, VALUE, VALUE2, TIME, I have my PHP file that I enter the values (VALUE AND VALUE2), which is this: <?php $conexion = mysql_connect("localhost", "usuarioservidor", "1234");...
asked by 06.04.2017 / 18:08
1
answer

Relationship between Join tables

I'm trying to do a JOIN (it's the first time) and I have this code but it shows me the following errors.    Warning: mysqli_query () expects at least 2 parameters, 1 given in C: \ xampp \ htdocs \ inventory \ int.php on line 5       W...
asked by 06.04.2017 / 19:46
1
answer

Can I make my own web builder in this way?

My idea is to make a web application and then in the back end part to make a panel to design the layout, let's say that I'm only interested in the content, that is to say, text, icons, images, etc., but the nav bar, footer, sidebars do not touch...
asked by 10.04.2017 / 23:31
1
answer

Get how many times an ID appears in another MySQL table

I have a table "clients" that contains the data of clients and another "friends" that contains the data of friends invited by a client. I want by means of a Select to obtain the mail of the clients who have invited a multiplo of 5 friends. I...
asked by 10.04.2017 / 23:18
1
answer

MySQL: consult a date in the varchar field

I'm trying to find a date within a MySQL field that contains several dates separated by commas. Example: tabla_agenda: id (integer) fechas (text o varchar) Example of the table: registro: 1 / 2017-04-04,2017-04-06,2017-04-08 registro: 2 /...
asked by 03.04.2017 / 22:11
1
answer

add a sound when something is inserted in mysql

How can I execute a sound (beep) on the computer when I have a php web in the browser and when a data is inserted in a table in mysql, for example: I have an open php web and a new message arrives, how to do it emit some sound the web that indic...
asked by 06.04.2017 / 15:55
1
answer

Modify MYSQL query to show message in case of not finding data

How can I modify this query so that if it does not find results from a demo_id in the tags table instead of showing the demo in the answer where the tags should go, say something like no category . Inquiry SELECT 'i'.'name', 'i'.'id',...
asked by 05.04.2017 / 21:23
0
answers

Changes made directly in the bd are not seen in the front

I have a web app with angular in the front and java in the back, the database with mySQL, the thing is that when entering a record in a table, one trigger updates the field of another, it is a Boolean field. I mean, when inserting a data in t...
asked by 29.03.2017 / 15:44
0
answers

Return query as array - NodeJS

I have this query that I do in my REST API which lists the items in the following way. Inquiry SELECT 'i'.'name', 'i'.'id', 'i'.'img', 'd'.'url', GROUP_CONCAT(t.name SEPARATOR ', ') as tags FROM 'demos' i INNER JOIN 'details' d ON 'i'.'id'...
asked by 29.03.2017 / 21:55