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).

How do you not remove any other symbols?

E
emerson last edited by

How to remove the row from which there's a symbol '1', but there's also a line from '11', they don't have to, like and regexp don't help much, or I'm a team that suits them.
Reply Quote 0
1 Reply Last reply

Kadyn

1 option

select * from
(select * from table_name

where column like '%1%' ) a
where a.column not like '%11%'

2 Option

select * from table_name

where column like '%1%' AND column NOT like '%11%'

2
Posts

0
Views

Suggested Topics

D

Load data - fields terminated by character appearing within a field statement
SQL, Database Testing • mysql csv parse • • derk

2

0
Votes

2
Posts

0
Views

N

To answer your question yes I'm sure it is possible to employ a scheme like jkavalik suggested where you: Import the entire file into a single column/cell in a temp table Parse the malformed csv string using increasingly obtuse trickery as each edge case is discovered. I'm sure a smarter person than me could write an event driven, real-time, web-enabled, protocol buffer communicating, graphical user interface, autonomous aircraft landing system for use in hurricanes using only SQL, but why would they? You should use the best tool for the job. If you can't correct the csv exporter to properly escape the data then you should properly escape the data manually or use a programming language that will make this task easier. In my opinion, SQL is only going to make your life more difficult, and as such you should choose a different tool.
S

Generating a symbolic mass from a limited number of symbols
Software Programming • c sharp massives construction char • • Saumya

2

0
Votes

2
Posts

0
Views

E

You use the method. Random.Nextwhich only sets the upper limit. But below this border there are also unmarked symbols, so you need to put both the upper and the lower limits, that is.array[j] = Convert.ToChar(rnd.Next('1', '9' + 1)); andarray[j] = Convert.ToChar(rnd.Next('a', 'z' + 1));
Cannot Utilize Maximum CPU and Memory Usage for MySQL
SQL, Database Testing • mysql performance innodb wamp • • Bogopo

2

0
Votes

2
Posts

0
Views

A

The authors of High Performance MySQL describe part of your problem fairly succinctly (p. 234): MySQL can’t execute a single query in parallel on many CPUs. This is a feature offered by some other database servers, but not MySQL. Running a single stored procedure will use no more than 1 of your CPU cores for executing queries, with a little extra on other cores being used by various background and worker threads, such as those performing I/O. MySQL will only really use the full power of a multi-core or multi-processor system when there are multiple queries running at once. If you're seeing 30% of 1 core being used, that indicates a potential problem, but 1.2 cores out of 4 for a single query is quite normal.
A

How in jQuery to remove the probe without removing the contents?
Software Programming • jquery • • Anderson

2

0
Votes

2
Posts

0
Views

O

For example c replaceWith:var wrap = $('.block_wrapper'); $(window).on('resize', function(){ if($(this).width() >= 600){ wrap.replaceWith(function() { return this.innerHTML; }); } });.block_wrapper { background: green; }<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script> <div id="block"> <div class="block"> <div class="block_wrapper"> <div class="block_item">item</div> <div class="block_item">item</div> </div> </div> </div>
Why remove the dynamics, and what if they are not removed?
Software Programming • c++ memory indicators dynamics • • Alberto

2

0
Votes

2
Posts

0
Views

J

Imagine a city car rental system. Not so big. You always rent cars, you use and don't sell, but you don't drive anymore. All the cars will gradually be exhausted, there's nothing to ride. It's just not a memory disposal.You used it, you threw the keys and all the papers, and you don't even know where this car is now. It's a lost memory. You'd be happy to get her back to whatever you want, but you can't do it. It's if you're lost (recorded, life's time is over) all indexes for the memory. (Really, in garbage collection systems from time to time - usually when cars end - the special service is moving around town looking for abandoned vehicles and returning them to a rental.)You got your car back, but you got yourself a copy of the key. If you try to use it, it'll be a theft and the police will come. Maybe he won't come if no one notices... Undefined behaviour! This is an attempt to gain access to the emancipated memory index.You've made beautiful copies of the documents, and taking advantage of the return of the vehicle to the deposit, you want to give it back again. This is an attempt to re-freeze memory. Again, it's stealing, and the police are coming. Probably. Maybe it'll roll... Undefined behaviour you want. ♪ ♪You're trying to rent your own car. This is an attempt to free memory that has not been identified by the memory manager, such as an attempt to free memory from the variable in the glass. Again, it's stealing with all the consequences. ♪ ♪Like that. ♪ ♪P.S. Yes, cars are particularly intelligent, which themselves rent in the same system, such as wheels or trailers, and until you hand over such a car, the wheels will not be removed. This is for designers/designers of dynamically allocated facilities.P.P.S. When you leave town, it breaks up with a rental, so if you give it to the cars or don't, it doesn't matter... That is, at the end of the programme, it is not as important as to whether the memory that was not released has remained. But if you have a bad habit of not renting cars in time, you might have a problem in the new city. ♪ ♪
A

How to query mysql tables with regular expressions?
SQL, Database Testing • mysql regex • • authera

2

0
Votes

2
Posts

0
Views

T

I answer by myself. In short, sql syntax above is correct, so how to query mysql tables with regular expressions? Exactly like I did. The reason why it didn't work, is regexp syntax being too 'complex' for mysql. I found out that mysql doesn't support the full syntax possibilities of standard regular expressions. I must use simpler symbols/constructs. So for example, instead of \D{2} I can use [A-Z]{2}, and instead of \d, knowing I'll want 1 or 2, I can use [1,2]?. A syntax like the following will perfectly work in mysql to match a string like 'IT.1.12.00.00.00': [A-Z]{2}\.[1,2]?\.[1-9][0-9](\.00){3} With full regexp syntax I could have use lookahead assertions and other constructs, but anyway, for now for my needs I can use plain 'old' grammar.
S

Help with Operations of sum, difference and automatic calculation with javascript php html5
Software Programming • javascript php mysql html5 pdo • • shizuka

2

0
Votes

2
Posts

0
Views

If I understand what you're talking about, you could make everyone who changes the select performs a function that performs the calculations you need and put them in the inputs you have of total, something kind:<select name="nomb_tipoluna" id="nomb_tipoluna" class="form-control" required onchange="realizarCalculo(this)"> <option value="LUNA 1">LUNA 1</option> <option value="LUNA 2">LUNA 2</option> <option value="LUNA 3">LUNA 3</option> </select> <script> realizarCalculo(opcionElegida) { //Aquí realizas tus cálculos //Luego tomas los id de los input con getElementById o cualquier otro selector que prefieras //Imprimes los datos en los inputs modificandole su value } </script>
How to remove the knot if his name contains a key word?
Software Programming • sql server sql xml xquery • • morde

2

0
Votes

2
Posts

0
Views

J

update #t set col.modify(' delete //*[contains(local-name(.), "key")] ') Where? #t - the name of the table, col - the name of the xml columns.
K

How do we remove the extra symbols from the line?
Software Programming • java android lines • • kalyn

2

0
Votes

2
Posts

0
Views

N

Used replaceAll() It's like this:public static void main (String[] args) { String text = "[49,54545. 45,434324]"; String nexText = text.replaceAll("[\[\\]]", ""); System.out.println(nexText); } Regular expressions can be used. The line will contain all the symbols of the old one, except "[" and "]"♪public static void main (String[] args) { String text = "[49,54545. 45,434324]"; Pattern p = Pattern.compile("[^\[\\]]"); Matcher m = p.matcher(text); StringBuilder builder = new StringBuilder(); while(m.find()) { builder.append(text.substring(m.start(), m.end())); } String newText = builder.toString(); System.out.println(newText); } You can still take a cut of the line without the first and last symbols.public static void main (String[] args) { String text = "[49,54545. 45,434324]"; String newText = text.substring(1, text.length() - 1); System.out.println(newText); }
B

MySQL How to calculate checkpoint age?
SQL, Database Testing • mysql • • Burma

2

0
Votes

2
Posts

0
Views

A

Those sequence numbers are necessarily large, monotonically increasing, numbers. They are not byte offsets into the log. You may find the number in the log, of you have fun with hex dumps. (I don't.) That Percona blog, while good, is a decade old. A large log no longer delays restart as much as it once did. Consider this for judging whether to increase (or decrease) the log_file_size: Minutes between InnoDB log rotations = Uptime / 60 * innodb_log_file_size / Innodb_os_log_written 60 minutes is a good target, but it is not a precise target. Beginning with 5.6.8, this can be changed dynamically; be sure to also change my.cnf. innodb_log_files_in_group traditionally has been 2. I suggest you use 2 unless you are on a new version of MariaDB, where it is no longer needed.
Line numbering MYSQL presenting wrong sequence
Software Programming • mysql • • morde

2

0
Votes

2
Posts

0
Views

T

Try it subquery:SET @n = 0; SELECT @n := @n+1 AS linha, tab.* FROM (SELECT pergunta, resposta FROM perguntas p INNER JOIN respostas r ON r.pergunta_id=p.id) as tab; Working on https://www.db-fiddle.com/f/gva9Lt2B29HzhNisLB977v/0
F

Removal of symbols to C++
Software Programming • c++ • • fbio

2

0
Votes

2
Posts

0
Views

K

cout << "\u2554" <<endl; Alternativecout << u8"\u2554"; Windowss, to remove the arbitrary symbols into the console, despite the current codepageYou can use WriteConsoleW()Combustion with locale or SetConsoleOutputCP() It's not gonna help with Unicode. On other systems, you can just take utf-8 (proposing the terminal uses utf-8)Or another schedule https://ru.wikipedia.org/wiki/%D0%9F%D1%81%D0%B5%D0%B2%D0%B4%D0%BE%D0%B3%D1%80%D0%B0%D1%84%D0%B8%D0%BA%D0%B0
J

When ordering the arithmetic symbols the symbol "-" is not printed
Software Programming • java • • juvenalb

2

0
Votes

2
Posts

0
Views

You have an error in order you're assigning to a wrong referenceCambia s_a[j]=sa[x];For sa[x]=s_a[j];
D

Remove n symbols at the beginning of each line in the file.
Software Programming • python python 3.x • • derk

2

0
Votes

2
Posts

0
Views

C

As an option:lines = open(path, 'r').readlines() with open(path, 'w') as fp: for line in lines: line = line[n:] # вот тут можно воткнуть любую обработку, например fp.write(line)
PDO PHP error when inserting a record using $_SESSION as a parameter
Software Programming • php mysql pdo • • Alberto

2

0
Votes

2
Posts

0
Views

You can't use bookmarks for table or column names, as you do here:INSERT INTO :rama ... If the intention is to replace :rama by a dynamic name you must assign the name from the variable that contains it, not in the form of a marker.For example:public function create() { try { $rama=$_SESSION['RAMA']; $sql = "INSERT INTO $rama ( codigo_es, Nombre, Celular, Email, insignias, imagen_es, id_registro_general ) VALUES ( :codigo_es, :Nombre, :Celular, :Email, :insignias, :imagen_es, :id_registro_general )"; $data = [ ':codigo_es' => $this->_rollNo, ':Nombre' => $this->_name, ':Celular' => $this->_className, ':Email' => $this->_email, ':insignias' => $this->_Insignia, ':imagen_es' => $this->_image, ':id_registro_general' => $this->_Id_Registro, ]; $stmt = $this->db->prepare($sql); $stmt->execute($data); $status = $this->db->lastInsertId(); return $status; } catch (Exception $err) { die("Error!: ".$err); } }

How do you not remove any other symbols?

Suggested Topics

Load data - fields terminated by character appearing within a field statement SQL, Database Testing • mysql csv parse • • derk

Generating a symbolic mass from a limited number of symbols Software Programming • c sharp massives construction char • • Saumya

Cannot Utilize Maximum CPU and Memory Usage for MySQL SQL, Database Testing • mysql performance innodb wamp • • Bogopo

How in jQuery to remove the probe without removing the contents? Software Programming • jquery • • Anderson

Why remove the dynamics, and what if they are not removed? Software Programming • c++ memory indicators dynamics • • Alberto

How to query mysql tables with regular expressions? SQL, Database Testing • mysql regex • • authera

Help with Operations of sum, difference and automatic calculation with javascript php html5 Software Programming • javascript php mysql html5 pdo • • shizuka

How to remove the knot if his name contains a key word? Software Programming • sql server sql xml xquery • • morde

How do we remove the extra symbols from the line? Software Programming • java android lines • • kalyn

MySQL How to calculate checkpoint age? SQL, Database Testing • mysql • • Burma

Line numbering MYSQL presenting wrong sequence Software Programming • mysql • • morde

Removal of symbols to C++ Software Programming • c++ • • fbio

When ordering the arithmetic symbols the symbol "-" is not printed Software Programming • java • • juvenalb

Remove n symbols at the beginning of each line in the file. Software Programming • python python 3.x • • derk

PDO PHP error when inserting a record using $_SESSION as a parameter Software Programming • php mysql pdo • • Alberto

Load data - fields terminated by character appearing within a field statement
SQL, Database Testing • mysql csv parse • • derk

Generating a symbolic mass from a limited number of symbols
Software Programming • c sharp massives construction char • • Saumya

Cannot Utilize Maximum CPU and Memory Usage for MySQL
SQL, Database Testing • mysql performance innodb wamp • • Bogopo

How in jQuery to remove the probe without removing the contents?
Software Programming • jquery • • Anderson

Why remove the dynamics, and what if they are not removed?
Software Programming • c++ memory indicators dynamics • • Alberto

How to query mysql tables with regular expressions?
SQL, Database Testing • mysql regex • • authera

Help with Operations of sum, difference and automatic calculation with javascript php html5
Software Programming • javascript php mysql html5 pdo • • shizuka

How to remove the knot if his name contains a key word?
Software Programming • sql server sql xml xquery • • morde

How do we remove the extra symbols from the line?
Software Programming • java android lines • • kalyn

MySQL How to calculate checkpoint age?
SQL, Database Testing • mysql • • Burma

Line numbering MYSQL presenting wrong sequence
Software Programming • mysql • • morde

Removal of symbols to C++
Software Programming • c++ • • fbio

When ordering the arithmetic symbols the symbol "-" is not printed
Software Programming • java • • juvenalb

Remove n symbols at the beginning of each line in the file.
Software Programming • python python 3.x • • derk

PDO PHP error when inserting a record using $_SESSION as a parameter
Software Programming • php mysql pdo • • Alberto