postgressql nextval not working after transfer data from maria db

SELECT setval('yourtable_id_seq', (SELECT max(id) FROM yourtable));

Komentar

Posting Komentar

Postingan populer dari blog ini

React js make submit form not reload page

import React , { useState } from 'react' export default function Home (){ const [ keyword , setKeyword ] = useState ( '' ) const handleSubmit = ( e ) => { e . preventDefault (); // hanlde form not reload page console . log ( keyword ) } return ( < form onSubmit = { handleSubmit } > < input type = "text" value = { keyword } onChange = { ( e ) => e . setKeyword ( e . target . value ) } /> </ form > ) }
Baca selengkapnya