Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you may not be able to execute some actions.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

There's no MySql sample.

K
kalena last edited by
Created. cms ♪ php♪ Used PDO To work with the base. It's super work on the denver. As soon as I moved to the hostel, it stopped working. Once the violin tries to get something from the base, it makes a mistake. 500♪ Where she's going, I figured out. For example, before works:
```
$user = DB::selectThis("users", "login, password", "WHERE login='{$login}'");
```
Not anymore. No mistakes in the magazines, absolutely nothing. Files...htaccess watched everything, nothing like that.
It works through it. __autoload♪
Tell the expensive pros, what else is the problem?
Reply Quote 0
1 Reply Last reply
R
rielyn last edited by
Disclosure helped to include all the mistakes, instead of a prefaced page with a mistake of 500.
```
ini_set('display_errors', 'On'); 
error_reporting(E_ALL);
$pdo->setAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION);
```
Reply Quote 0
1 Reply Last reply

2
Posts

0
Views

Suggested Topics

D

Group SQL data PHP with sum of records
Software Programming • php codeigniter • • derk

2

0
Votes

2
Posts

0
Views

J

Simply enter the sum at the beginning of your select by grouping by the product code. See:SELECT `tbl_order_details`.`product_name`, sum(`tbl_order_details`.`product_quantity`) as unidades, # soma de quantidades sum(`tbl_order_details`.`subtotal`) as total # soma de valores FROM `tbl_order_details` JOIN `tbl_supplier` ON `tbl_supplier`.`supplier_id`=`tbl_order_details`.`supplier_id` WHERE `tbl_order_details`.`order_id` = '6' GROUP BY `tbl_order_details`.`product_code`; # agrupar por código do produto See working on http://www.sqlfiddle.com/#!9/1f281f/1 In Codeigniter: $this->db->select( // somas 'tbl_order_details.product_name, sum(tbl_order_details.product_quantity), sum(tbl_order_details.subtotal)' ); $this->db->join("tbl_supplier", "tbl_supplier.supplier_id=tbl_order_details.supplier_id"); $this->db->where('tbl_order_details.order_id', $id); $this->db->group_by('tbl_order_details.product_code'); // agrupamento $this->db->get('tbl_order_details')->result();
S

"java.lang.IllegalArgumentException" This happens when I use the JDateChoser library
Software Programming • java mysql jc languagealendar jdatec languagehooser • • simrah

2

0
Votes

2
Posts

0
Views

S

You've probably called the JDateChooser and he's having trouble. In the event that this has worked, it is possible that the String that receives new java.util.Date is in an incorrect format.I'd say you change the name to Date that's ambiguous with the java.util class. These documentations can be useful to you. https://docs.oracle.com/javase/8/docs/api/java/util/Date.html http://javadox.com/com.toedter/jcalendar/1.4/doc/api/com/toedter/calendar/JDateChooser.html https://docs.oracle.com/javase/7/docs/api/java/sql/ResultSet.html
E

getting the total of amount of money of each user between two dates even if no record is found
SQL, Database Testing • mysql performance query performance performanc languagee tuni • • emerson

2

0
Votes

2
Posts

0
Views

S

Because you want to see every single user, table guest_t should be the main table. You can then LEFT JOIN shopping_t to it for existing shopping records. This query use the period from 01-01-2016 to 01-04-2016. It seems to be what has been used for your desired output. I remove the calendar query because it does not seem required in your desired output. Query: SELECT gt.name, gt.id, coalesce(sum(st.money), 0) FROM guest_t AS gt LEFT JOIN shopping_t AS st ON gt.id = st.guest_id AND st.shopping_date >= '2016-01-01' AND st.shopping_date < '2016-04-01' GROUP By gt.id, gt.name; Coalesce replace NULL by 0. Output is similar to your desired output: name | id | coalesce(sum(st.money), 0) george | 0 | 220000 Lisa | 1 | 0 Anne | 2 | 10000 Mike | 3 | 0 If you want data for the past 3 months starting NOW(), the calendar subquery is not needed. You only need to check the boundaries (NOW and NOW - 3 months) in the ON clause: SELECT gt.name, gt.id, coalesce(sum(st.money), 0) FROM guest_t AS gt LEFT JOIN shopping_t AS st ON gt.id = st.guest_id AND st.shopping_date >= (CURDATE () - INTERVAL 3 MONTH) AND st.shopping_date < CURDATE () GROUP By gt.id, gt.name; This query gives the same output. Both query are in this SQL Fiddle. Your query with dates in the WHERE clause didn't work because a LEFT JOIN returns NULL for rows with no match in the shopping table. NULL cannot be compared to the dates and the result of the condition is false. Therefore the whole row (guest+shooping) is discarded by the WHERE clause: | id | name | city | address | tel | point | etc | guest_id | money | shopping_date | 0 | george | Summerwind | | 042968084 | -100 | | 0 | 150000 | March, 02 2016 00:00:00 | 0 | george | Summerwind | | 042968084 | -100 | | 0 | 50000 | January, 03 2016 00:00:00 | 0 | george | Summerwind | | 042968084 | -100 | | 0 | 20000 | February, 16 2016 00:00:00 | 2 | Anne | Windhill | | 042968084 | -100 | | 2 | 9000 | January, 02 2016 00:00:00 | 2 | Anne | Windhill | | 042968084 | -100 | | 2 | 1000 | January, 03 2016 00:00:00 | 1 | Lisa | Laplace | | 042968084 | 0 | | (null) | (null) | (null) | 3 | Mike | Fairview | | 042168084 | 0 | | (null) | (null) | (null) From this output, the last 2 row are discarded. When the date condition is move to the ON clause, shopping_t is checked before the LEFT JOIN. If the condition is not true, they are not used in the JOIN and replaced by NULL. However because a LEFT JOIN guest_t data stay in place whether shopping_t returns nothing (NULL). If you want to see each days whether there is data or not, you have to CROSS JOIN the calendar subquery with guest_t and then use a LEFT JOIN: select guest_id, t.days coalesce(sum(money), 0) from ( SELECT ADDDATE... ) as t CROSS JOIN guest_t gt left join shopping_t on gt.id = st.guest_id AND shopping_date = t.days group by guest_id, t.days; I remove the final WHERE clause with is similar to ON clause.
MySql.Data version. Entity compatible with MySql 5.6
Software Programming • mysql asp.net mvc entity framework c languageode first • • Mystic

2

0
Votes

2
Posts

0
Views

T

I found the following table in http://dev.mysql.com/doc/connector-net/en/connector-net-visual-studio-install.html . It shows which version of MySQL for Visual Studio is required according to the server version, Connector and Visual Studio: MySQL for Visual Studio Connector/Net Visual Studio MySQL Server Observações 1.2 6.9,6.8 2008, 2010, 2012, 2013 5.7, 5.6, 5.5, 5.1, 5.0 Requer algumas funções do C/Net 6.9 1.1 6.8 2008, 2010, 2012, 2013 5.7, 5.6, 5.5, 5.1, 5.0 1.0 6.7 2008, 2010, 2012 5.7, 5.6, 5.5, 5.1, 5.0
D

MYSQL
Software Programming • mysql • • derk

2

0
Votes

2
Posts

0
Views

B

You should use CTE.WITH testCTE (country, av, yeardoc) as (SELECT country, SUM(Prstoim)/COUNT(*) as av, Yeardoc FROM table.dbf Where country IN ('Россия', 'Германия', 'Италия', 'Нидерланды', 'Япония') Group BY yeardoc, country) SELECT SUM(av) FROM testCTE First, in the CTE, you get a set of data that counts for each country and year. SUM(Prstoim)/COUNT(*)and then receive the total amount, summarizing the data from the pre-set.
B

I'm writing a snake in IntellijIdea at java. Please indicate why neither repaint(s), update(g), nor updateUI(s) may work.
Software Programming • java swing timer awt play • • Burma

2

0
Votes

2
Posts

0
Views

You presented an incomplete example, and you don't understand how you launch it.What I did to make your example work. No timers.:- He made your class Snake public.- Created Jframe for which the Componette was placed - Snake Extended from JPanel.- Initiated Snake class in Window designer- I just wrote from Main. new Window();public Snake(int Width, int Heigth) { // Делаем конструктор публичным // Добавляем Jframe JFrame jf = new JFrame(); jf.setSize(500,500); jf.add(this); //this - это Jpanel которым расширяется Snake jf.setVisible(true); // Дальше все по старому food = new Food();field = Field.getField(); Point start = new Point((int)Width/2, (int)Heigth/2); //размеры поля, а не окна parts = new ArrayList<>();parts.add(start); Point p1 = new Point((int)start.getX(), ((int)start.getY())-1);parts.add(p1); Point p2 = new Point((int)start.getX(), ((int)p1.getY())-1); parts.add(p2);length = 3; } Window classpublic class Window extends JPanel { private Graphics g; // ? Зачем это здесь private Snake snake; // тут был null, где происходит иниц. ? public Window() { super(true); snake = new Snake(20,20); Thread snakeThread = new Thread(snake); snakeThread.start(); } @Override public void paint(Graphics g) { super.paint(g); snake.paint(g); } } Launch:public class Main { public static void main(String[] args) { new Window(); } } I didn't change anything in your code anymore, and he works without "punctures." Started a regular debag and watched the status of your class and variables.I will not be able to provide you with an expanded and literate response, since the problem was probably in architecture and composing/investigation. You literally have every class coming from Jpanel. ♪ ♪
J

Restriction for repeated records
Software Programming • php html mysql mysqli • • jules

2

0
Votes

2
Posts

0
Views

A

You can create a Compound primary that you will have the 4 fields you need to evaluate (idctg_turno, idctg_dia, hr_entrada and hr_salida) to just fulfill your task. Here I leave you a link with an example that has some fields quite similar to yours and in which the composite primary key is created: http://www.tutorialesprogramacionya.com/mysqlya/temarios/descripcion.php?cod=38&punto=39&inicio= Here are more examples that solve the problem of repeated records as you have raised it with composite primary key: http://jjmojicamysql.blogspot.com/2012/05/39-clave-primaria-compuesta.html So your board ctg_horn should have a primary key composed of this style:create table ctg_horario( idctg_turno tipodedato not null, idctg_dia tidpodedato not null, hr_entrada tipodedato not null hr_salida tipodedato not null, primary key(idctg_turno,idctg_dia,hr_entrada,hr_salida) ); I hope it's helpful. A Greeting!
auto-incrementing key in self-referencing table, performance
SQL, Database Testing • mysql database design auto inc languagerement • • briley

2

0
Votes

2
Posts

0
Views

F

In indexes, DESC is ignored. (This will be rectified in version 8.0.) MySQL is happy to use an ASC index (that is, any index) but scan it in descending order. So DROP that redundant UNIQUE index. That said, I don't see that anything you have described so far could be cause "excruciatingly slow" inserts. To further elaborate. You have 2 BTrees: One with all the columns, and ordered (ASC) by ID One with just ID and ordered (ASC) by it. When inserting a new row (without explicitly specifying ID), the server is optimized to insert it into the "last" block of the BTree and bumping the A_I value. Meanwhile, the UNIQUE index is acting much the same. But it is doubling the amount of work to do, with no benefit. On the other hand, if you have multiple connections doing the inserts, this may be worth noting -- How the inset works: Get a new A_I value (well optimized) Check all UNIQUE indexes for duplicates. This may be slow, since another connection may be locking the adjacent ID. Insert the row Throw info into the "Change buffer" for later updating of non-unique indexes. (This does not apply.) Also worth noting in InnoDB: Each transaction has some overhead -- writing to the undo log, writing the "double write" buffer, etc. Hence, batched insert run much faster because they spread out this overhead over multiple rows. Can you insert, say, 100 rows in a single INSERT? That may literally run 10 times as fast. Do you really need BIGINT? It takes 8 bytes. INT UNSIGNED takes only 4 bytes, and allows 4 billion values.
MySQL
Software Programming • php mysql • • Analeea

2

0
Votes

2
Posts

0
Views

T

If it's a stupid text file, it's easy to open if it's, like, a php script and it's written in it. ♪ ♪[sarkazm] go into the hosting control panel and open the Pound[/sarkazm]By the way, what's the injection?
R

Regular expressions in MySQL that accept "Ñ"
Software Programming • mysql regex • • Rossere

2

0
Votes

2
Posts

0
Views

E

Option 1. Add Ñ to the character class.Inside the https://dev.mysql.com/doc/refman/5.7/en/pattern-matching.html you can add any features you want to allow to match:select columna from Tabla where columna regexp '^[A-Za-zÑñ]+$'; Option 2. Match with alphaWithin the character class, you can utlize the https://dev.mysql.com/doc/refman/5.7/en/regexp.html alphaThat matches ñ and many other diacritics, such as tilds, diéresis, etc. Thus, the regular expression coincides with alphabetical characters, although it also accepts many other characters from different languages.select columna from Tabla where columna regexp '^[[:alpha:]]+$'; TestsExample to test both expressions:CREATE TABLE Tabla (`columna` varchar(7)); INSERT INTO Tabla (columna) VALUES ('abcd'), ('abcñ'), ('ABCD'), ('ABCÑ'), ('ábcdé'), ('ÁBCDÉ'), ('áòçñüïô'), ('AB DE'), ('123abcd'); select columna, case when columna regexp '^[A-Za-zÑñ]+$' then 'Sí' else 'No' end as '^[A-Za-zÑñ]+$', case when columna regexp '^[[:alpha:]]+$' then 'Sí' else 'No' end as '^[[:alpha:]]+$' from Tabla; Outcome: columna ^[A-Za-zÑñ]+$ ^[[:alpha:]]+$ 1 abcd Sí Sí 2 abcñ Sí Sí 3 ABCD Sí Sí 4 ABCÑ Sí Sí 5 ábcdé No Sí 6 ÁBCDÉ No Sí 7 áòçñüïô No Sí 8 AB DE No No 9 123abcd No No http://rextester.com/NTU31828
E

- MySQL.
Software Programming • mysql • • emran

2

0
Votes

2
Posts

0
Views

A

User table to create a column last_activity(last activity) with the type of data stored, e.g. timestampand in any action the user changes its meaning to NOW()♪Afterwards, who can be identified online using this column.For example, online people can be considered online. last_activity-time()<5♪
J

MySQL replace selected data in sample select
Software Programming • mysql select if • • Jolied

2

0
Votes

2
Posts

0
Views

J

Either it's true to use the case, or it's still starting another field in the table.First option:SELECT CASE `id` WHEN 55123213 THEN 'Вася Пупкин' WHEN 53244351 THEN 'Невася Пупкин' WHEN 55100000 THEN 'Вася Непупкин' END as `user_name`, `dat` FROM `table1` Second option♪You do it once:ALTER TABLE `table1` ADD COLUMN `user_name` VARCHAR(100) DEFAULT '' NOT NULL; Then you do the request like that:SELECT `user_name`, `dat` FROM `table1`
MySQL
Software Programming • mysql • • Analeea

2

0
Votes

2
Posts

0
Views

R

I should have changed the bases that were default wrong.character_set_database latin1 --> utf8 collation_database latin1_swedish_ci --> utf8_general_ci
Mysql Left Join doesn't make a sample the second table.
Software Programming • mysql join • • Laycee

2

0
Votes

2
Posts

0
Views

J

LEFT JOIN products pp ON p.sn LIKE '%pp.sn%' SQL doesn't work that way, you can't expect the row to be magically dissociated from the reference to the column in any table.If that's what you're doing, write it like that, clearly moving the reference to the meaning and gluing the line:LEFT JOIN products pp ON p.sn LIKE '%' + pp.sn + '%'
C

Select... LIMIT... Slow work on big samples. MYSQL
Software Programming • mysql • • chanisef

2

0
Votes

2
Posts

0
Views

E

Filesort, and on these things, you can't do it fast. And given that the sorting goes to the field of the sub-request, i.e. the non-indicated data set, I do not see the trend of optimizing this request in principle.I suggest that consideration be given to transforming the request into a procedure. It contains a sample of the sub-request in TEMPORARY TABLE ENGINE=Memory, index, and then receive a final sample. The greater the number of records that falls under demand after contacting other tables, the greater the chance to catch profil... yes, the request itself (interim selection) should be booked, or at least try to do so.

There's no MySql sample.

Suggested Topics

Group SQL data PHP with sum of records Software Programming • php codeigniter • • derk

"java.lang.IllegalArgumentException" This happens when I use the JDateChoser library Software Programming • java mysql jc languagealendar jdatec languagehooser • • simrah

getting the total of amount of money of each user between two dates even if no record is found SQL, Database Testing • mysql performance query performance performanc languagee tuni • • emerson

MySql.Data version. Entity compatible with MySql 5.6 Software Programming • mysql asp.net mvc entity framework c languageode first • • Mystic

MYSQL Software Programming • mysql • • derk

I'm writing a snake in IntellijIdea at java. Please indicate why neither repaint(s), update(g), nor updateUI(s) may work. Software Programming • java swing timer awt play • • Burma

Restriction for repeated records Software Programming • php html mysql mysqli • • jules

auto-incrementing key in self-referencing table, performance SQL, Database Testing • mysql database design auto inc languagerement • • briley

MySQL Software Programming • php mysql • • Analeea

Regular expressions in MySQL that accept "Ñ" Software Programming • mysql regex • • Rossere

- MySQL. Software Programming • mysql • • emran

MySQL replace selected data in sample select Software Programming • mysql select if • • Jolied

MySQL Software Programming • mysql • • Analeea

Mysql Left Join doesn't make a sample the second table. Software Programming • mysql join • • Laycee

Select... LIMIT... Slow work on big samples. MYSQL Software Programming • mysql • • chanisef

Group SQL data PHP with sum of records
Software Programming • php codeigniter • • derk

"java.lang.IllegalArgumentException" This happens when I use the JDateChoser library
Software Programming • java mysql jc languagealendar jdatec languagehooser • • simrah

getting the total of amount of money of each user between two dates even if no record is found
SQL, Database Testing • mysql performance query performance performanc languagee tuni • • emerson

MySql.Data version. Entity compatible with MySql 5.6
Software Programming • mysql asp.net mvc entity framework c languageode first • • Mystic

MYSQL
Software Programming • mysql • • derk

I'm writing a snake in IntellijIdea at java. Please indicate why neither repaint(s), update(g), nor updateUI(s) may work.
Software Programming • java swing timer awt play • • Burma

Restriction for repeated records
Software Programming • php html mysql mysqli • • jules

auto-incrementing key in self-referencing table, performance
SQL, Database Testing • mysql database design auto inc languagerement • • briley

MySQL
Software Programming • php mysql • • Analeea

Regular expressions in MySQL that accept "Ñ"
Software Programming • mysql regex • • Rossere

- MySQL.
Software Programming • mysql • • emran

MySQL replace selected data in sample select
Software Programming • mysql select if • • Jolied

MySQL
Software Programming • mysql • • Analeea

Mysql Left Join doesn't make a sample the second table.
Software Programming • mysql join • • Laycee

Select... LIMIT... Slow work on big samples. MYSQL
Software Programming • mysql • • chanisef