Questions tagged as 'mysql'

Tagged questions
1
answer

Import CSV files to MySQL workbench

I have a .csv file that contains columns (vertically): Product.1 (line1) Product.2 (line2) But when I do this query : use test; LOAD DATA LOCAL INFILE 'local' INTO TABLE tabela1; It always gives me a warning to say that the att...
asked by 12.06.2015 / 21:29
1
answer

Weekly Booking

I'm developing a scheduling system and it's almost all right though a question arose I need to create an option for weekly scheduling if the user clicks on the weekly schedule he schedules all week at the time chosen by the client something like...
asked by 15.06.2015 / 16:40
1
answer

Can you do a SELECT by returning the quantity and name of each color?

I am making these two queries to download the colors and the quantity of each color in the bike table: SELECT DISTINCT color FROM bike ORDER BY color ASC SELECT COUNT(color) FROM bike GROUP BY color ORDER BY color ASC How do I make t...
asked by 05.06.2015 / 15:13
1
answer

Compare varchar in procedure

I'm trying to use the procedure and trigger below in mysql so that when inserting a record into a table the trigger is triggered for subtraction of the given value in another table, but it happens that it is applying to all records of the target...
asked by 15.07.2015 / 19:58
0
answers

Populating Cities / Neighborhoods in jQuery with fields in Array

I have the following JS. <script type="text/javascript" src="https://code.jquery.com/jquery-1.11.3.js"></script><scripttype="text/javascript"> $(document).ready(function(){ $("select[name=cidade]").change(fun...
asked by 23.06.2015 / 18:35
2
answers

While incrementing datetime field in MYSQL

I need to do a while between a start date and an end date, that is, as long as the start date is less than the end date, it will return a query, how can I increment this while to make it run?     
asked by 23.06.2015 / 01:08
0
answers

Problem with PDO INSERT

Hello friends I am very lay in PDO and would like the help of friends to try to create an INSERT that would register a font name in the BD font table. Next, I created this code below, based on the UPDATE code that is working: <form name...
asked by 13.05.2015 / 14:42
1
answer

Label Indefinida Graphic with Flot and PHP

Using Flot to generate pie charts, the graph is generated with the values in percent, but the labels are displayed with 'undefined'. $(document).ready(function () { var chartError = function(req, status, err) { console.log('An erro...
asked by 12.06.2015 / 02:40
0
answers

Save ArrayIterator in MySQL

I'm having trouble saving a list of items in ArrayInterator , where I need to save this data in the table when I click a save button. Array code: <?php ... $p = new ArrayIterator($_SESSION['PEDIDO']); while ($p->val...
asked by 12.06.2015 / 04:17
1
answer

Problem with & quote when generating txt via PHP

Dear, I have a routine that creates a txt file with some information of a query in mysql, but when the query returns some text with quotation marks, the problem starts. When you display the data on the screen, information that has double quotati...
asked by 10.06.2015 / 15:36