Welcome to Jonic Developer Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

Recent questions tagged mysql

0 votes
943 views
1 answer
    I have a model object where I want to have a field with a date. For now I am using ZonedDateTime as it fits our needs. Hibernate stores this field ... a sortable format? The database used is a mysql db. See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
410 views
1 answer
    I have this query and I need it to be in the CodeIgniter way (query builder). I know how to use the standard query builder class functions, but I have ... id = s.product_id ORDER BY ` Count(*) ` DESC See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
434 views
1 answer
    I am trying to insert multiple rows into MySQL DB using PHP and HTML from. I know basic PHP and searched many examples on different forums and created one script ... ; } else { echo "$row record added"; } See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
437 views
1 answer
    hello i wanted to build I get $date and $date1 from form xxx. I wanted to make leave program. now i wanted process $date with variable string with value xx- ... ['selisih']; $times = + 1; here the picture See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
484 views
1 answer
    Is there a better way (performance or syntax) to write the following mysql query: Select un.user_id from user_notifications un where un. ... pushed a notification for a certain notification_id See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
533 views
1 answer
    This is a second part of Read from file into variable - Bash Script I have a bash script that reads strings in a file parses and assigns it to a ... and a table the output should be database1.table1.* See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
304 views
1 answer
    Below is the ammount of rows for 2 tables in my mysql DB 1 is myisam the other innodb, can someone tell me why the innodb one has this ~ in ... numbers came from phpmyadmin 10,308 MyISAM ~118,011 InnoDB See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
309 views
1 answer
    I'm struggling to think of an efficient model to describe IPv4 address data. I want to be able to perform a 'whois' type lookup on a dataset ... I only have limited scope for changing/upgrading the DBMS. See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
2.4k views
1 answer
    I installed MySQL workbench 8.0 in windows 7. After the installation I just clicked server status its through the error like Could not acquire management ... variable. How can I solve this error? See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
516 views
1 answer
    I have SQL (MySQL 5.x) query like: INSERT INTO table (val1), ON DUPLICATE KEY UPDATE `val1` = VALUES(`val1`) And this works fine. Now i need to ... to sum VALUES(val1) + integer) How it could be done? See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
326 views
1 answer
    I suggested using a trigger to check a cross table integrity constraint answering this question. It has been suggested in the comments that it may cause problems: ... SET MESSAGE_TEXT = msg; END IF; END// See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
471 views
1 answer
    I'm trying to get a django site deployed from a repository. I was almost there, and then changed something (I'm not sure what!!) and ... python command line interpreter. Does anyone have any suggestions? See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
499 views
1 answer
    I'm getting a syntax error while following the MySQL guide for IF syntax. My query is: if 0=0 then select 'hello world'; end if; Logically, this should ... the right syntax to use near 'end if' at line 1 See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
465 views
1 answer
    I have a column that contains strings as: aaa_1 aaa_11 I need to query strings that ends with _1. I tried the following: select col from table where col like ... with _1 and _11. How can I correct this ? See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
302 views
1 answer
    For static pattern database(5-5-5), see this(page 290 and 283) OR there is an explanation below. For What is 15-puzzle? I am creating a static ... is practical - with or without recursion. Is it possible? See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
447 views
1 answer
    I have a PHP script that will generate a report using PHPExcel from data queried from a MySQL DB. Currently, it is linear in processing in that it gets the ... you tackle it? Also, it is PHP 5 on CentOS See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
386 views
1 answer
    membership table membership_startdate (2011-01-12) membership_dueday values like only dates (09,08,07) member_id member table member_id How can I get ... not taking into account the membership_dueday... See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
643 views
1 answer
    I have two dropdowns in jsp and have to get dropdown list from database and show it in jsp. I am using jsp for the first time . Can you ... display the values in jsp dropdown element.Thanks in advance See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.1k views
1 answer
    First off all, i've seen many others post like this, however the answer wasn't working on my particular case. Just in case i am only few ... change the PK to another place? Really appreciate any help See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
400 views
1 answer
    I have recently been informed that the use of the BETWEEN method in SQL is somewhat unreliable, and I should therefore be using DATEDIFF(). However, another ... like to know if this applies here as well See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
483 views
1 answer
    Is there a relatively secure way to store the password in the browser cookie (for remembering the login information) in the cookie without creating an extra column for hash in database? Thanks. See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
475 views
1 answer
    Updated the mysql connector. Net to version 6.6.4 provider to integrate with visual studio 2012, but now when I try to configure the ... error "Authentication method 'mysql_old_password' not supported". See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
460 views
1 answer
    I'm new to Zend Framework and I'd like to know how I can get the number of affected rows from this: $sql = "UPDATE auth SET act='', status=' ... it this way because I work with more than one databases. See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
372 views
1 answer
    According to the documentation: max_execution_time only affect the execution time of the script itself. Any time spent on activity that happens outside the ... out elsewhere, such as Apache level? See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
355 views
1 answer
    What is the difference in '%' and '%%', when used in mysql where clause with 'LIKE' ? select * from `wp_users` u where u.user_nicename like ... from `wp_users` u where u.user_nicename like "%%lastuser%%" See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
443 views
1 answer
    I am reading a TEXT file from PHP and trying to execute commands from it, like creating a DB and all the tables and procedures it has. My code creates ... works. I am trying to make a DB installer script. See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
301 views
1 answer
    In a table x, there is a column with the values u and ü. SELECT * FROM x WHERE column='u'. This returns u AND ü, although I am only ... background.) Thanks everybody for the support, especially to Pred. See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
477 views
1 answer
    SO, The problem I have an issue with rows multiplication. In SQL, there is a SUM() function which calculates sum for some field for set of rows. I ... above) - may be calculating via log will be slow? See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
Ask a question:
Welcome to Jonic Developer Community for programmer and developer-Open, Learning and Share
...